Hi,
I have an internal table with the value below. I need to populate to header data line (1 record only) and detail is an internal table
When there is a change of customer, i need to copy 123 to header and 2 records of material (abc & xed), sales (100 & 200) and qty (10 & 12) to detail internal table.
for customer 567, i need to copy to header and material aqs, sales 150 and qty 5 to detail internal table.
May I know how can I achieve this?
customer material sales qty
123 abc 100 10
123 xed 200 12
567 aqs 150 5
877 abc 140 8
Thanks
Rgds