SUS - Table joins for PO and Invoice

[Former Member]

Hello,

I am trying to create a report in SUS and I'd like to join some tables.

I'd like to be able to pull all the SUS PO's and SUS Invoices filtered by Vendor and Date. Looking at BBP_PD all the data is already linked under "Header Links" but I'm not sure how to use those links in a query.

CRMD_ORDERADM_H seems to contain most of the PO and Invoice data I need but how can I connect a PO with the correct invoice?

Thanks,

Matt

[Former Member]

Solution:

Use the following function modules to look up this data.

BBP_PD_SUSPO_GETLIST

BBP_PD_SUSPO_GETDETAIL

This returns a lot of data so you can pick and choose what you need.

Thanks,

Matt