SRM - How to get data from tables???

[Former Member]

Hi experts -

I am new to SRM and I have a requirement to code a program that will retrieve purchase orders based on selection criteria, write an ALV report and all the user to select particular lines to close the p.o.

My question is that with the following selection criteria, I see that there are tables such as CRMD_ORDERADM_H and CRMD_ORDERADM_I as well as BBP_PDBEH and BBP_PDBEI, but not exactly sure if I should do selects on them individually or can you collect the records from a function module or BAPI?

Selection criteria:

PO Number - range

Purchasing group - range

Vendor number - range

Buyer ID - range

Cost Center - range

GL Account - range

WBS - range

Asset - range

Plant - range

Company code - range

Delivery Date - range

PO Create Date - range

How can I pull the qualifying records in the easiest manner?

Thanks in advance!

Mark

[Former Member]

I'm not certain about this, but I don't think the information you need is in the SRM frontend. I think you'll have to use an RFC enabled FM to retrieve the data from the R/3 backend to the SRM system. Or maybe there is a BAPI that does this for you.

Rob

[Former Member]

I found many views that will do the trick!