Skip to Content
0
Jan 05, 2023 at 03:52 PM

Mapping of CAMT.054D file to SAP Payment order

156 Views Last edit Jan 05, 2023 at 03:53 PM 3 rev

Hi,

I'm working on a bank statement return file in S/4 HANA 2021 and there is something that seems a bit off to me.

  1. I'm creating a remittance file through tx F110 and the xml file has a reference to the payment order in tag <EndToEndId>
  2. When receiving the camt.054.001.02.xml from our bank, the same payment order reference exist
<NtryDtls> <TxDtls> <Refs> <MsgId>1000014208</MsgId> <AcctSvcrRef>STOESI05230105133554000001000001</AcctSvcrRef> <PmtInfId>1000014309</PmtInfId> <InstrId>04-0000000107</InstrId> <EndToEndId>000107</EndToEndId> </Refs>
  1. In transformation FIEB_CAMT054_V2_TO_FEB all this data gets concatenated into FEBRE-VWEZW (note to payee), but the EndToEndId, the payment order are also saved to FEBEP-VGREF (!)
  2. When the interpretation algoritm 029 (Payment order) are executed in include BBU10_F01 it tries to break up the string in VWEZW and tries to find a payment order from table PYORDH.

So, from a skilled abaper, but a novice in finance;

- Why doesn't the algoritm look for the payment order in VGREF?

- Based on the CGI standard both the payment order category "04" and the payment order it self is stored in <InstrId>. Since the payment order number range starts at 00000001, the algoritm will always also find the payment order 0000000004!

It looks to me that we're using a modern standard (ISO20022, CGI), but an old xml transformation and algoritm..

Any suggestions other than modifying the XML transformation or greating a custom 901 algoritm?