SNC PO Item Table with Status

[former_member292111]

Hi Experts,

I want to know the SNC table where PO Item Status gets store. I want to extract an report having PO details with only PO open status.

How can I get this? If any table is available, Please help me on this.

Regards,

Ashwini

[Former Member · Accepted solution]

Hi Ashwini,

From table /1OM/ORDR7MP3<client number> enter the PO number in field Order Number and then copy Order ID.

Now go to table /1OM/ORDR2IT3<client number> enter Order id and press F8, here you can check item status.

If you are looking for report from backhand then go to SQVI create joint table for above tables then you will get report PO item wise.

Thanks&Regards,

Vishnu

[former_member292111]

Thanks both of you. It's very helpful.

[former_member236255]

Hello Ashwini,

You can find more information about the Purchase Order ODM on: https://scn.sap.com/blogs/snc/2013/07/10/purchase-order-odm

As informed on the article, 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 in 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.

Thanks,

Best regards,

Lucas Bozio