Skip to Content
0
Former Member
Jan 23, 2009 at 10:19 PM

SRM - How to get data from tables???

53 Views

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