2014 Jun 24 7:45 AM
Hi All
Any body help me, i have below internal Table
( RS1- Release status1, RS2- Release status2, RC1- Release Code1, RC2 - Release Code 2 )
| Po number | RS1 | RS2 | RC1 | RC2 |
|---|---|---|---|---|
| 450000010 | X | X | 50 | 52 |
| 450000011 | X | 70 | 53 |
I want to make below internal table from above data.
How this is possible.......
( RC - Release Code , RS - Release Status )
| RC | RS | PO Number |
|---|---|---|
| 50 | X | 450000010 |
| 52 | X | 450000010 |
| 70 | X | 450000011 |
| 53 | 450000011 |
Rgds
PP
Moderator messge - Spoon feeding is not allowed in the forums. Points have been removed & thread locked.
Message was edited by: Suhas Saha
2014 Jun 24 7:53 AM
LOOP AT itab1.
CLEAR itab2.
itab2-po_number = itab1-po_number.
itab2-rc = itab1-rc1.
itab2-rs = itab1-rs1.
APPEND itab2.
CLEAR itab2.
itab2-po_number = itab1-po_number.
itab2-rc = itab1-rc2.
itab2-rs = itab1-rs2.
APPEND itab2.
ENDLOOP.
2014 Jun 24 7:54 AM
2014 Jun 24 7:58 AM
Hi Raymond
I tried to Dynamic tables......any way thanks for reply...
PP
2014 Jun 24 8:02 AM
First , loop the source internal table and just pass RS1 and RC1 values into internal table and again do the same for RS2 and RC2. Then you can easily combine those two internal tables and get desired output.
2014 Jun 24 8:15 AM
Hi Amol
Another issue i faced , in Release status showing as XXX
i need to separate XXX to 'X' 'X' 'X
Rgds
PP'
2014 Jun 24 8:23 AM
Is release status is 3 character ?
Then use,
Data: gd_status TYPE string VALUE 'XXX'
gd_c1 TYPE c,
gd_c2 TYPE c,
gd_c3 TYPE c.
gd_c1 = gd_status(1).
gd_c2 = gd_status+1(1).
gd_c3 = gd_status+2(1).
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |