I am working on a report need to move the data from 1 internal table to Dynamic internal table.
Data in Internal table 1. ( having 4 columns )
G/L account G/L text BusA Amount
1111 Customer AA 100
2222 Vendor AA 100
Expected O/p Format Internal table 2 - ( dynamic internal table )
G/L account G/L text AA BB CC DD EE FF ........
1111 Customer 100 200-
2222 Vendor 100 100 200-
where BusA will be dynamic , collecting the same from 'TGSB'
let's say as on today have 40 BusA. , after 2 months it will be 50 ...then the report should work and will have 50 BusA in column header.
Pls help how i can move the data.