2010 May 12 3:55 AM
Dear All,
Hi, i'm really new on ABAP programming. I have done to query to internal table.
itab1
no rate
1 0.2
2 0.3
3 0.5
4 0.7
itab2.
no item weight
1 10 50
1 20 60
2 10 30
2 20 90
i want it to be this
no item weight rate amount
1 10 50 0.2 10
1 20 60 0.2 12
2 10 30 0.3 9
2 20 90 0.3 27
Edited by: aishahesme on May 12, 2010 4:57 AM
Dear All,
Hi, i'm really new on ABAP programming. I have done to query to internal table.
itab1
no rate
1 0.2
2 0.3
3 0.5
4 0.7
itab2.
no item weight
1 10 50
1 20 60
2 10 30
2 20 90
i want it to be this
no item weight rate amount
1 10 50 0.2 10
1 20 60 0.2 12
2 10 30 0.3 9
2 20 90 0.3 27
Edited by: aishahesme on May 12, 2010 4:57 AM
2010 May 12 5:15 AM
You need to create another Internal table
loop at itab2 into wa2.
read table itab1 into wa1 with key no = wa2-no.
wa3-no = wa1-no.
wa3-item = wa2-itemm.
wa3-weigh = wa2-weigh.
wa3-rate = wa1-rate.
wa3-amount =
append wa3 to itab3.
endloop.
Thanks
Bala Duvvuri
2010 May 12 5:25 AM
2010 May 16 2:13 PM