topic Re: loop in Application Development and Automation Discussions

loop

Former Member — Thu, 15 May 2008 07:38:27 GMT

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.

Re: loop

Former Member — Thu, 15 May 2008 07:44:21 GMT

hi,

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

Regards,

Santosh

Re: loop

Former Member — Thu, 15 May 2008 07:44:32 GMT

loop at MARA as it contains fewer records ...

Re: loop

Former Member — Thu, 15 May 2008 07:50:51 GMT

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

Re: loop

Former Member — Thu, 15 May 2008 07:51:43 GMT

Hi,

Loop at EKPO.

loop at MARA.

read from EQUI check condition using key fields(which fields u want)

Use move statement.

endloop.

Regards,

Chandu

Re: loop

Former Member — Thu, 15 May 2008 07:54:21 GMT

Hi,

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

regards,

mahantesh

Re: loop

Former Member — Thu, 15 May 2008 07:57:21 GMT

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