Skip to Content
0
Former Member
Oct 20, 2008 at 10:42 AM

Internal table data from one columns data into two columns

12 Views

hi friends,

how to split one column data to two columns.

here in one column i have docment numbers i.e material doc and invoice document nos. so i want to split as material doc into material doc columns and invoice document no into invoice columns. here transaction type event for material doc is '1' and transaction type event for invoice doc is '2' .

So here material doc's are greater than or less than the invoice doc's numbers .I what basis i can split the records from one columns to two columns from an internal table.

internal table data:

po item transaction_event document

100000 1 1 560000001

100000 1 1 560000002

100000 1 2 620000004

100000 1 2 620000006

100000 1 2 620000007

so i want these into final table : itab as

po item mat_doc inv_doc

100000 1 560000001 620000004

100000 1 560000002 620000006

100000 1 620000007