Search for POs by vendors

[Former Member]

Hi,

Do you know the table where the relationship between vendor and PO is stored?

I want to search for POs by vendors in database tables.

Regards

Mick

[Former Member]

Why do it by hand if you can let SRM do the work for you?

Try FM BBP_PD_PO_GETLIST, in this function module you can retrieve po's based on a lot of criteria, including vendor.

Regards,

Robin

[Former Member]

Dear Atul/Robin,

Thank you very much for your help.

I found the link between the PO and the vendor in the table CRMD_LINK 05/07

CRMD_LINK-GUID_HI = CRMD_ORDERADM_H-GUID

Cheers

Mick

[Former Member]

Hi

Please look in the following Database tables using SE16 transaction ->

- BBPD_PD_INDEX_H

- BBPD_PD_INDEX_I

- CRMD_ORDERADM_H

- CRMD_ORDERADM_I

- VENMAP

Regards

- Atul