Hi SAP Guru,
my client want to send the APP data to bank via DME.
I have configured all the fields and file name.
The bank has shared the format in which details are coming in different rows in one column
Reguh table shows the data
S. no Identification Run date Vendor code Amt Document number
1 test 03.04.2012 500014 5467 9876543
The output coming in my DME file is
test, 03/04/2012, 500014, 5467.00, 9876543
But Bank require data in below format
Pls suggest me , how we can convert the data currently coming in columnar format to row format
Currently we are on SAP R/3 4.7
Your help is highly appreciated
I am also attaching the sample file given by bank and my output