Sap Accounting: RE:[sap-acct] F110 - DME file in CSV Format

RE:[sap-acct] F110 - DME file in CSV Format

Posted by Cleofus_Brown
on Jul 28 at 11:07 AM

Hi Karthikeya,

Using transaction DMEE, you will see many example format trees. I used those examples to build my own CSV file. Start by specifying a Root node (Segment Group) and then a segment for each grouping of lines in your file (header, detail, trailer). Add fields (elements) to each segment. Specifically to make sure you get a comma between each field (Element) , the only way I have found to do this is to create a field (element) between each of your file fields with a mapping procedure = Constant and assign that constant the value of "," on the source tab.

I hope I have helped you.

---------------Original Message---------------
From: karthikeya nag
Sent: Tuesday, July 26, 2011 12:49 PM
Subject: F110 - DME file in CSV Format

I have a requirement to configure the automatic payment program. The client requirement is that the file should get generate in CSV (Comma separated values) format for country United Kingdom after running F110 program.

As per standard SAP we can generate output file only in text and xml formats. I know that this can be done through DME. But how to create file format and generate file as per the bank layout is something I would like to understand.

Can any one explain me how can we create file format in CSV?

Thanks,
Karthikeya

__.____._