DME Format

[Former Member]

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

for e.g.

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

~

test

03.04.2012

500014

5467

9876543

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

Regards

Ajay Gupta

my DME output.TXT.zip

Sample file by bank.txt.zip

[jainbh · Accepted solution]

Hi Ajay

The lines are controlled in DMEE based level. If you want each dataset apearing on different line, ensure you create seperate segment for each field. You need to maintain number of levels on DMEE Tree properties. In each segment ensure that you select option Define different settings for this Segment & select both options Carriage Return & Line Feed.

I tried on my system & it works.

Regards

Bhavesh

[Former Member · Accepted solution]

Hi Bhavesh,

Thanks for your input.

the setting suggested by you worked and I am getting the desired output.

I have one more doubt

the bank require certain constant value at the end of payment file

How we can define the element which will only come at the end of file

single value like "END"

Regards

Ajay Gupta

e-mail id:- ca.ajaygupta@gmail.com

[jainbh · Accepted solution]

Hi Ajay

Do you have an header for the file? If you have an header then you can add a footer (a constant). Else take help from ABAP to enter this. I did same for one of my client as there was no feader requirement on file.

Regards

Bhavesh

[Former Member · Accepted solution]

Hi Bhavesh,

Can you pls help me on how Delay output works  in DME segment node

with some e.g.

I will give you mine

we have two part to DME file

part 1 is all the info related with payment and part 2 is related with its breakup ( payment advice)

we are able to map all the fields

but the requirement is first we get the data of part 1 and then we get the data of part 2

for e.g. if we have two payment document PD 1 And PD2 and PD1 is clubbing of invoice 1 & invoice 2 while PD 2 is clubbing of invoice 3

the format bank require is

PD1

PD2

Invoice 1

Invoice 2

Invoice 3

while we are getting the data like

PD1

Invoice 1

Invoice 2

PD2

Invoice 3

someone told me with the help of DME - delay output you can achieve this but was not able to do it successfully

You can mail me your communications detail

so that I can get in touch with you

Regards

Ajay Gupta

ca.ajaygupta@gmail.com

[jainbh · Accepted solution]

HI Ajay

I cannot share my direct contact details as this would be against SCN policy.

As you mentioned, you can achieve this using delayed output.

So in your case sequence would be:

Level 1 would be Payment Document #

Level 2 would be Invoice Details

You will maintain delayed output for Level 2 & enter the node ID of same Level 1 segment Payment Document #.

This should work.

Regards

Bhavesh