Sales Order Data Model

[Former Member]

Hi,

We're trying to display sales orders from our ECC backend system. However we're having problems creating the data model in Netweaver Gateway, we're trying to use the BAPI salesorder/getlist, however this returns an object of sales orders. Does anyone know what BAPI we should use to create a data model which exposes sales orders.

Regards

Jing Jing Tao

[former_member231452]

Read these blogs

http://scn.sap.com/people/volker.drees/blog/2012/10/26/step-by-step-guide-to-build-an-odata-service-...

http://scn.sap.com/people/volker.drees/blog/2012/10/26/step-by-step-guide-to-build-an-odata-service-...

[christopher_glander]

I used the script entitled

"How To... Create Complex Business Entities using the Gateway OData Channel"

which is available here.  I can query orders and get some details of the line items in the orders. 

I can not get the Create to work.  It creates a Sales Order with the correct information however the Qty field is not being passed...

When you look at VBAP you see no qty, however when you Test the BAPI  BAPI_SALESORDER_GETLIST, you see a qty in the REQ_QTY field... so I am trying to figure out what is happening.

Chris

[Former Member]

Hi,

Well it really depends on the data you want to get using the service.

If you want to work with Header & Item Levels you will need to create 2 different Entity types with the corresponding association + navigation link. Then you will need the Entity Set + Entity Associations.

This is only for the data model.

In the implementation you will need to consider how to extract information.

Do you know how to call to expanded entity types?

Regards