Skip to Content

SNC PO Item Table with Status

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 13, 2016 at 02:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 13, 2016 at 06:21 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 14, 2016 at 04:41 AM

    Thanks both of you. It's very helpful.

    Add comment
    10|10000 characters needed characters exceeded