table/bapi where i can see the guid of the sales order in SCM

[Former Member]

Hi Experts,

We have activated the APO check. when we create the sales order in ECC GATP check happens in SCM and the purchase req is generated in ECC and the number is transferred to SCM. which i can see in the RRP3 tcode in SCM. now i need to developa report in SCM where i give material,plant and sales order numbers and get the pur req numbers associated with them. i planned to use BAPI_POSRVAPS_GETLIST3. this FM actaully works if i give materail and plant details, and in the PEGGING_OUTPUT_NODES i can see the pur req number corresponding to a sales order. but the problem is over the period of time this BAPI might take more time because i am not able to use sales order data i have in any of the selection criteria for this BAPI.

but what i did was i took the ordid value for one of the sales order from the table parameter PEGGING_OUTPUT_NODES and went back to the BAPI and entered that ordid value in "ordid" field of table parameter "ORDER_GUID. Then i got a sinle entry in PEGGING_OUTPUT_NODES table parameters for that sales order. Now the question is how do i get the ordid values for a sales order number?. is there any FM or table where i can see these values?. I searched some tables but as everything is stored in live cache i am not able to see any entries in the table.

thanks.

[Former Member · Accepted solution]

Hi,

Please try the BAPI BAPI_SLSRVAPS_GETLIST2 for Sales Order / Deliveries. The FM /SAPAPO/DM_ORDKEY_SELECT_ORDNO can be used to get GUID of Order from live Cache. Please let me know if you need more information.

Regards,

Senthilrajan

[Former Member · Accepted solution]

hi

how do i use BAPI_SLSRVAPS_GETLIST2. it looks similar to the BAPI i had mentioned. can u give the selection criteria? where do i give my sales order numbers?

[Former Member · Accepted solution]

Hi,

The BAPI what you mentioned (BAPI_POSRVAPS_GETLIST3) is to read the Procurement Order (Purchase Requisition / Stock Transfer Requisition)from Livecache. The BAPI BAPI_SLSRVAPS_GETLIST2 can be used to read the Sales Order/Delivery from Livecache. I am giving an example of the selection criteria.

Import parameters Value

LOGICAL_SYSTEM CONSAPD410

START_TIME 20.071.031.000.000

END_TIME 20.071.101.000.000

EXCLUDE_EXPORT_FLAGS

MAX_NUMBER_OF_ORDERS 0

TRANSFER_MODE

PLNG_VERSION 000

IO_NODE_SELECTION I

Tables Value

PRODUCT_SELECTION 1 Entry

LOCATION_SELECTION 1 Entry

LOCTYPE_SELECTION 0 Entries

PRODUCT_LOCATION_KEYS 0 Entries

ORDER_SELECTION 0 Entries

ORDERTYPE_SELECTION 0 Entries

ORDER_GUIDS 0 Entries

ORDER_KEYS 0 Entries

ATPCAT_SELECTION 0 Entries

CUSTOMER_SELECTION 0 Entries

CFG_SELECTION 0 Entries

REQUIREMENTS 0 Entries

RECEIPTS 0 Entries

PEGGING_INPUT_NODES 0 Entries

PEGGING_OUTPUT_NODES 0 Entries

CFG_HEADERS 0 Entries

CFG_INSTANCES 0 Entries

CFG_PART_OF 0 Entries

CFG_VALUES 0 Entries

CFG_VAR_KEYS 0 Entries

CFG_BLOB 0 Entries

RETURN 0 Entries

EXTENSION_IN 0 Entries

EXTENSION_OUT 0 Entries

In case if you want to give Sales order as input you can try the fields ORDER_SELECTION, ORDER_GUIDS, ORDER_KEYS. For an sales order you can get the 22 digit GUID using the FM /SAPAPO/DM_ORDKEY_SELECT_ORDNO. The conversion of the 22 digit GUID to 16, 32 digit ORDID can be done via the FM GUID_CONVERT.

You will need to do some research on this by taking a sample sales order and using them in the FMs i mentioned above. All the best.

Regards,

Senthilrajan