Linking SRM PO number with invoice party number

[former_member1338362]

Hi experts,

Could someone please let me know what the tables and fields are for the SRM invoice party number and purchase order number, that are displayed in the SRM Purchase Order Display screen, as i’m trying to create a query to show these fields along with the vendor number, and PO item number and description?

I’ve tried using the tables below, and can get all the data to show, apart from the PO number from table BBP_PDHGP:

Tables used in SRM query ;

BBP_PDHGP:

CRMD_ORDERADM_I:

CRMD ORDERADM H:

BUT000

CRMD_LINK

CRMD PARTNER

Any help appreciated.

Many Thanks,