‎2008 May 15 8:38 AM
hi all,
i am developing a small report.
the problem is i am using three tables
EKPO, "Purchasing Document Item
MARA, "General Material Data
EQUI. "Equipment master data
fetching the data based on matnr and ebeln from 3 tables
the number of records fetched for example are
EKPO -200
MARA-90
EQUI-1500
now i need to move the data to final internal table.
the problem is on which table i need to loop ie., EKPO or MARA or EQUI.
thanks in advance.
‎2008 May 15 8:44 AM
hi,
Loop at EQUI table data ...and even take care of all the conditions while looping ...
Regards,
Santosh
‎2008 May 15 8:44 AM
‎2008 May 15 8:54 AM
Hi,
loop on MARA using the MATNR field you can write conditions.
regards,
mahantesh
‎2008 May 15 8:50 AM
‎2008 May 15 8:51 AM
Hi,
Loop at EKPO.
loop at MARA.
read from EQUI check condition using key fields(which fields u want)
Use move statement.
endloop.
endloop.
Regards,
Chandu
‎2008 May 15 8:57 AM
Hi,
It depends on your requirment of the report
If you want Material wise report ie, for a material which r PO's and equipment no then loop at MARA
similarly if you want your report PO wise or equipment no wise loop accordingly.
Reward points if helpful
Regards
Bikas