topic Re: Looping At NEW in Application Development and Automation Discussions

Looping At NEW

Former Member — Mon, 03 Dec 2012 06:21:33 GMT

Dear experts,

i have two internal tables

table 1

PONo Matnr

00001 xyz

00002 xyz

00003 abc

table 2

PONumber PRNUMB Matnr

00001 100001 XYZ

00001 100002 XYZ

00001 100003 abc

00002 555555 XYZ

00003 888888 abc

I have one final table and i need to fill that final table as below

PO Matnr PRNO

00001 xyz 100001

100002

abc 100003

00002 xyz 555555

00003 abc 888888

please give me some idea how to fill this final table . with the help of above two tables

Moderator message : Requirement dumping not allowed, show the work you have already done, discussion locked.

Message was edited by: Vinod Kumar

Re: Looping At NEW

former_member346628 — Mon, 03 Dec 2012 06:29:55 GMT

Hi,

You already have the data in your second internal table. Sort that internal table by three fields.

Thanks,

Sridhar S.

Re: Looping At NEW

Former Member — Mon, 03 Dec 2012 06:30:48 GMT

Hi..

Check the following example.

AT NEW.*If a group of lines of a particular column have same value, it can be displayed at the beginning only once using the control level statement

At New <column name>.

The columns to the left of <column name> are also considered by the 'At New' condition.

Say internal table contents are as follows:

Carrid connid

AA 0017 385 349

AA 0017 386 432

AB 0017 345 254

AB 0016 243 423

"At New Connid." Works as follows:

Carrid connid

AA 0017

385 349

386 432

AB 0017 345 254

AB 0016 243 423

Ex:

-->The output is displayed as follows:

Thanks

Sravanthi