SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

DME Files in Excel Format

Former Member

‎2015 Jun 26 6:01 PM

0 Kudos
1,330

Hello everybody,

Through the implementation of our system, after the execution of a payment run (FPY1), we require to generate a file that includes the necessary fields for updating information in an external system. Is there any way for generating a DME File in Excel format (xls, xlsx)?

Thank you beforehand for your help

Víctor.

3 REPLIES 3

AmlanBanerjee
Active Contributor

‎2015 Jun 29 5:14 PM

0 Kudos
484

Hi Victor,

Which Country DME are you using?

Thanks

Amlan

Former Member
In response to AmlanBanerjee

‎2015 Jun 29 5:23 PM

0 Kudos
484

Hi Amlan,

Thanks for your response.

Currently, we are using a custom format for Ecuador in South America.

Best regards

Victor

AmlanBanerjee
Active Contributor
In response to AmlanBanerjee

‎2015 Jul 01 12:14 PM

0 Kudos
484

Hi Victor,

Ideally, it will be in the FM (Transaction Code-FQP3) that is being assigned to the payment medium format for the assigned country.

Once you are creating the file in one of the event modules for the payment medium formats in FQP3, in there you have to mention the file extension as ".xls".

Moreover, if you are in EHP 7.0, then you can have a look at the SAP Note#2115466,which introduces a new FM, FKKID_PMW_UT_PAYMENT_GENERATE,that allows to generate payment media format output and can be implemented in event 6207

Hope it helps..

Thanks,

Amlan