Custom xml file for bank payment in ByD

[former_member689468]

Since existing Payment Medium Format: 74 - SEPA Credit Transferformat with SEPA delivered from BYD does not cover all needs from payment transaction we need to extend file for payment. For this purpose we create our own file with avalible setup from Fine Tune - Outgoing Bank Transfers – Edit Payment File Structures

This setup give's us only output in flat file in .txt format. We need to create .xml file with differrent structure from existig SEPA. How to create costum .xml file for payment?

Is it possible to copy existing SEPA file delivered by SAP in our solution and make some change?

I have found an enhancement option called PaymentToPaymentFileConversion but I am not entierly sure if that is what I am supposed to use and how to use it so if someoen has examples or guides it would be useful.

[ragulanmurugasamy]

Thanks. Ragulan

[former_member689468 · Accepted solution]

Hey I forgot about this thread in all the mess, my bad.

What we did to solve this is we used a standard enhancement called PaymentToPaymentFileConversion. There is a PDF tutorial on SAP JAM - https://jam4.sapjam.com/groups/3odgd4UDtB1KH4dgKGmnBS/documents/ttKHBu2rnK6tkZL0zo0pIW/slide_viewer

Unfortunately it doesnt let me put it here as attachment, but I have the PDF and if you like I cant send it to you via e-mail to speed things up.

After you implement it, which can be confusing the first time around, you can code your xml structure here using ABSL. Its not ideal but it gets the job done for us. Make sure to follow the instructions exacly as they are and create a project template and edit it with a PDI user, because only PDI user will have the options you need.

In the end it looks something like this:

So its similar as if you did it by hand in the activity list, but its much easier and faster and you do get more flexibility here. One issue is that the generated file is not of type xml, but for now that wasnt too big of problem for our customers since they download it localy and save it as xml anyways. I have no idea why its not possible to make the file of different formats - or perhaps I just missed something, it wouldnt be the first time 🙂

Best of luck

[Mic_L · Accepted solution]

Hi Josip,

thank you so much, this is awesome!

I tried logging into SAP JAM following the link, but apparently you must be invited for this: "Your e-mail address registered with SAP ID has not been invited to this system. Please contact the person who sent the original group invitation and ask them to invite you with the address 'mic.lamers@unilode.com'." Would you be able to invite me or ask the person who is able to, to do so? Otherwise you at least now have my email address to send the pdf file to. Both would be very much appreciated!

And as long as we can save the file as XML to make it work, there is no issue with that. With finetuning solution currently saving files from TXT to CSV. All better than having the users retype the payments, with all the possible errors.

Kind regards,

Mic

[former_member149039 · Accepted solution]

Hi Josip,

Can you please send the pdf document to the below email address.

naveenprabhupan@gmail.com

Kind Regards,

Naveen

[Former Member · Accepted solution]

Hi josip.spajic,

Could you please send me the pdf document to the below email address?

tri.leminh773@gmail.com

Thanks.

Tri

[ragulanmurugasamy · Accepted solution]

Hi josip, Could you please send me the pdf document to the below email address? raghulan.m@gmail.com Thanks. Ragulan

[YanGerzon · Accepted solution]

Could you please send the pdf to yan@alfacloud.co.il

[YanGerzon · Accepted solution]

Could you please send the pdf to yan@alfacloud.co.il , thanks.

[solene_roques]

Hi,

I have the exact same requirement, from my understanding :

- you can not make xml through Fine Tune - Outgoing Bank Transfers – Edit Payment File Structures (it is written in SAP Docs that is flat file only)

- enhancement option called PaymentToPaymentFileConversion is the equivalent in PDI of creating a new structure in Fine Tune - Outgoing Bank Transfers (or maybe it is only for non localized country).

I am also really interested to know if we can make a copy of copy SAP existing SEPA file because it is quite long to enter and not obvious to bind to the correct data

[former_member689468]

So basically the extension gives me the same options as if I manually create the structure or can I have more options doing it trought the extension ? And I cant get an xml out of it ?

[solene_roques]

josip.spajic

Regarding flat file I am quite sure :

Regarding differences between studio and Business Configuation it seems that there can be differences for non-localized countries. It seems that some SAP member is helping you. Could you share the information please ?

Thanks

[former_member764180]

Hallo everyone,

with the Release 2211, Business By Design offers the possibility to create custom XML payment files using XSL transformations templates.

In the Business Configuration Work center, you will find the templates which can be customised according to your needs... when you need it.

The pre delivered templates can be modified with basic xml knowledge and the best part is that it can be used with or without Partner SDK.

For further details, please visit the link to the help center documentation below.

XSL Transformation

Kind regards,

Isaac

[Mic_L]

Hello all,

Did you meanwhile found some answers on this topic?

What I understood - the existing SEPA file delivered by SAP in our solution cannot be copied and adjusted. But I assume once this is setup in SAP ByD (using PDI) it can be copied and re-used?

How much work is it to setup first time, and how hard is it to do? Is that comparable to finetuning?

Anyone ever thought of sharing solutions, it that even possible?

Thank you!

Regards,

Mic