Skip to Content
0

DME output file in .xls or .xlsx format

Mar 05, 2017 at 12:21 PM

160

avatar image
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..

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Ranu Eugene Mar 05, 2017 at 05:51 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 06, 2017 at 05:11 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Bastiaan Jansen Mar 06, 2017 at 10:21 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 07, 2017 at 07:12 AM
0

Thank you, Bastiaan. Will give it a try.

Regards,

Soujanya.

Share
10 |10000 characters needed characters left characters exceeded