Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

display of 2 internal table data in one teport

Former Member
0 Kudos
66

Hi,

I want to display 2 internal tables data in one report (one after the other ) ie, the amount net to zero records are itab1 and the amount not net to zero is itab2.

(both this itab1 and itab2 having same structure)..........please let me know how to display.

Regards,

Saleem.

5 REPLIES 5

Former Member
0 Kudos
47

Hi,

First sort the tables.

say net amount field name is NET

then

delete itab1 where NET <> 0.

delete itab2 where NET = 0.

And loop it and display it.

Reward if useful!

Former Member
0 Kudos
47

Just append one iinternal table to other and display it

APPEND LINES OF ITAB1 INTO ITAB2.

Now display itab2.

Former Member
0 Kudos
47

if u r using classical or interactive report then all u need is to output ur both internal tables one after the others.

it will be displayed accordingly.

reward points plz

0 Kudos
47

Hi,

Push the data onto another table ITAB3 like this.

DATa: ITAB3 LIKE ITAB1.

LOOP AT ITAB1.

READ TABLE ITAB2 WITH KEY ....

APPEND ITAB1 to ITAB3.

APPEND ITAB2 to ITAB3.

ENDLOOP.

Regards,

Sesh

Former Member
0 Kudos
47

Hi,

do your coding as follows..

loop at itab1.

loop at itab2 where key1 = itab1-key1 and

key2 = itab1-key2.

append itab3.

clear itab3.

endloop.

endloop.

Now, your final data is available in itab3.

Make sure you are using all the key fields in the WHERE clause of loop statement.

Reward points if it is helpful...

Regards,

Rushikesh