Report to extract list of item which have more than one external procurement relationship for the same source and destination location but with different priority

[former_member323340]

Hi All,

Some how in our SCM system we find External Procurement Relationship having same source and destination for the same material, but with different priority.One of them is active and the other is inactive.

I want to know whether is there any report/table which can be used to check how many of such materials are there in the system.

Thanks in advance.

[Former Member]

Lakshmanamurthy,

I am not aware of a standard report.

Source of supply (which includes transportation lanes) is stored in table /SAPAPO/TRPROD.  Priority is also stored in this table.  External source of supply records are categorized as '001' in /SAPAPO/TRPROD-TRPTYPE.

Unfortunately, only the GUIDs are stored in this table for "From location", "To Location", and "Product".  You will have to map these from other tables:  /SAPAPO/LOC and /SAPAPO/MATKEY are good candidates.

Best Regards,

DB49