Supply Chain Management Blogs by SAP
Expand your SAP SCM knowledge and stay informed about supply chain management technology and solutions with blog posts by SAP. Follow and stay connected.
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

SAP-SNC stores the order related data in ODM tables (order data management).If you want to find out something about an order without accessing the WebUI, you can do it using the ODM tables.To acces these tables, first go to transaction SE16.

The structure of the table names:
Begins with /1OM/, this follows with the area indicator, in case of PO it is ORDR. Then comes the table category, and the client number.

The most important ones are:

/1OM/ORDR1HDR This is the header table, from this you can find out the from-to location, partnerID.

/1OM/ORDR7MP3 This is the mapping table, here you can find the items of the order, and you can find out the orderID. This can be 7mp2 to, the number at the end tells you the number of the levels, on which the mapping data is stored.

/1OM/ORDRHMSG This is the header message table, here you can find the number of the related xml message.

How to use ODM tables:

At first you have the order number, you go to se16, and go to the /1OM/ORDR7MP3 table:

From here you can find out the orderID.

You copy the ORDID, and go to the /1OM/ORDR1HDR.

Here you can get most of the needed data, but they are not reedeble. You have to go to the transaction /sca/idconverter to decode them.

You type in the encoded data and press Run.

Here you get the needed information.

You can find this article also in the wiki, under the following link:

http://wiki.sdn.sap.com/wiki/x/yoccF