How is the flow of PR,PO and Material Document

[Former Member]

Hello Experts,

      As an Abaper, I got the requirement to develop a report for Purchase requisition details report. In this report the flow should be like from PR, PO get created, and from PO, Material document get created, but from one PR there may be no.of PO's createdand vice versa, and from one PO there may be no. of material documents created. and for selection screen there is MATNR, posting date and plant. So what is the exact flow of code using tables MKPF, MSEG, EKKO, EKPO, EBAN? I am confused about functional flow. So plz guide me. output should be

PR details        PO details        Material Doc Details

Please find attachment of code

Thanks in advance.

Regards,

Shubhada

[raymond_giuseppi]

• There are foreign key relations between many of the tables, so check SE11.
• Add table EKBE between EKPO and MSEG
• Use LEFT JOIN to keep records without following documents when reading data and LOOP into table in same sequence.

EBAN
↓
EKPO	→	EKKO
↓
EKBE
↓
MSEG	→	MKPF

Also don't hesitate to read 191492 - Performance: Customer developments in MM/WM

Regards,

Raymond