loop

[Former Member]

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.

[Former Member]

hi,

Loop at EQUI table data ...and even take care of all the conditions while looping ...

Regards,

Santosh

[Former Member]

hi,

Loop at EQUI table data ...and even take care of all the conditions while looping ...

Regards,

Santosh

[Former Member]

loop at MARA as it contains fewer records ...

[Former Member]

Hi,

loop on MARA using the MATNR field you can write conditions.

regards,

mahantesh

[Former Member]

Looping EQUI table data will be useful............

[Former Member]

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

[Former Member]

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