topic logic required in Application Development and Automation Discussions

logic required

Former Member — Fri, 25 Jan 2008 10:16:28 GMT

Hi Experts,

I have a list of OBJNR in the Internal table ItabA.

I need to fetch maximum of Counter from the table IHPA

for all the entries in the table ItabA.

can any one pls give the logic for this without writing select statement in a loop of itabA.

Thanks in advance

Former Member — Fri, 25 Jan 2008 10:19:26 GMT

Hi Karthik,

Use FOR ALL ENTRIES IN option in select statement.

Thanks,

sunil

Former Member — Fri, 25 Jan 2008 10:20:07 GMT

Hello,

Do like this.

select * from IHPA into table itab2 for all entries in itaba

where objnr eq itaba-objnr.

sort itab2 by objnr counter descending.

delete adjacent duplicates from itab2 comparing objnr counter.

Hope this will solve ur problem..

Cheers,

Vasanth