writing SEPA XML file from custom report

[abo]

Customer wishes to generate SEPA mandates on a system where few (if any) of the employees are present as vendor BP, so standard FBPM is not usable. The input data comes from an Excel file and it is currently sent to the bank with an obsolete fixed format text file, which might be discontinued at any time.

In this context, would it be feasible to use the existing DMEE tree (most likely, IT_CGI_XML_CT) and feed it data from our file? Is this scenario at all possible and recommended? Honestly, by the looks of it, this is meant to be used within the standard transaction and not directly called but I might be wrong; the.wirtschaftsmann saw your blogposts today, may I ask for your take on this?

Thanks.

[former_member566586 · Accepted solution]

Hi,

It is not impossible to do a custom integration.

However, DMEE(X) accepts data in the form of data structures specified by the tree type. So if you want to base it on a PAYM tree, you would need to map your excel data to the PAYM data structures and call the DMEE engine, as DMEE cannot read from excel directly.

DMEE will just return you the file contents which you then use however you need.

There is a guide which explains everything at length:

How to create your own DMEE/X Tree Type? Part 1 of 2 | SAP Blogs

How to create your own DMEE/X Tree Type? Part 2 of 2 | SAP Blogs

And the example code can be viewed or cloned via abapgit from

Akarinfcb/CUSTOM_DMEE: Custom DMEE coding (github.com)

Although the SAP objects used are not officially released, the DMEE_START/PUT_ITEM/END function modules can be considered stable as they have been around too long to be changed incompatibly or removed.

[abo · Accepted solution]

Wonderful, thanks for the example!