DME output file in .xls or .xlsx format

[Former Member]

Hi,

I have a requirement to generate a DME output file in .xls or .xlsx format. It is suggested in the following link 'https://archive.sap.com/discussions/thread/1885151' that output file format in .xls or .xlsx is not possible. However, as this is a business requirement - I just wanted to check if there is a function module that can convert a csv file to a .xls or .xlsx format.

Also, we are in the process of creating a DME format for India, however there is no country specific DME format available - hence would SEPA_CT be a good choice to use or is there any other generic format that I can copy and change according to the bank's format.

Thanks..

[Former Member]

Thank you, Bastiaan. Will give it a try.

Regards,

Soujanya.

[Former Member]

I believe there is an exit module (FI_PAYMEDIUM_DMEE_40) for the SEPA_CT file which should be available to all formats (or included). This exit is at the end of the creation of the file. You have the whole paymentfile available in an internal table. We use it to calculate HASHcodes. However maybe you can use it to transform the file to the XLS format.

[Former Member]

Hi Eugene,

Thank you for your time in replying to me and the blog as well. I did go through that sometime back - it was good 🙂

Pertaining to the issue of .xls format - I completely agree with you.

APP has not been configured for the client and I'm in the process of setting up one. ATM,they download the vendor payments info from SAP and manually upload the same to the bank's website in .xls format and then the bank remits the payments to the vendors on the organisation's behalf. Hence, I'm not completely positive if they would want to do away with .xls format, as there might be a Change Request between the client and their bank if they opt for H2H solution instead of manual upload. If they are alright with csv /txt fomat instead of .xls format then I'm sorted - fingers crossed.

Regards,

Soujanya.

[former_member191939]

Hi Soujanya,

I must say your requirement is very unique because almost all the banks ask for TXT or XML format, I doubt there is any FM to convert CSV file to XLS or XLXS format but let other Gurus of the group reply on the same.

Regarding generic format for the DMEE please check the below given link.

https://blogs.sap.com/2015/06/26/dmee-configurationstep-by-step-part-1/

Hope this will help you.

Regards

Eugene