Skip to Content
0
Former Member
Oct 02, 2009 at 12:04 PM

internal table merge with transpose.

75 Views

very weird stuff. I have an internal table i am supposed to make from two others, the problem is that the other two tables do not have a 1:1 mapping and I have to use the data in table 2 to make the final itab. here is an example of input and output

Table1 

POSNR           DESC         
000001          Entry 1
000002          Entry 2

Table2

POSNR       APPROVERNAME      DATE
000001          ZZZZZZ                 20090909
000001          YYYYY                 20090601
000001          XXXXXX                 20080209
000002          XXXXXX                 20070908
000002          JJJJJJJJ                 20080904
000002          ZZZZZZ                 20040303
000002         SSSSSS                   20010203


Output table

POSNR   DESC     ZZZZZZ       YYYYY       XXXXXX        JJJJJJJ               SSSSSSS
000001  Entry 1   20090909     20090601    20080209 
000002  Entry 2   20040303                  20070908       20080904            20010203

Edited by: Suker on Oct 2, 2009 2:05 PM