Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 17, 2009 at 01:47 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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