Contents
Abstract
SAP Bank Communication Management typically provides an update of payment, with an end- to- end tracking. There are two types of file formats ISO20022 Payment standards, XML and text.
- XML structures are PAIN.001 formats
- Text structures are MT formats
Payment status Reports are also of two types, such as the ISO20022 Payment standards, XML and text.
- XML structures are PAIN.002 formats
- Text structures are MT900 formats
This white paper explains how to design a solution when corporate (Banks) does not send back the references which are sent on MT101 (text format) in a payment status report.
Background
Scenario
Most of the Corporate (Banks) while sending the return message Payment status Reports, for a payment format MT101, on a return message MT900, do not give the reference sent on MT101 on tag :20.
Corporate (Banks) send their own reference instead of the reference sent on MT101.
ISO 20022 Payment and Status Flow
Source :- SWIFT
Structure of Payment Status Report
Payment Status Report XML structure
| XML TAG | NOTES |
| <InitgPty><Id><OrgId><BICOrBEI> | Inclusion for proper placement of BICorBEI for sender of message |
| <InitgPty><Id><OrgId><Othr><SchmeNm><Cd> | Changed note that Bank Id should not be BIC |
| Updated Overview contents and code values | |
| <OrgnlGrpInfAndSts><GrpSts> | Updated Rule to include ACTC |
| <GrpHdr><InitgPty><OrgId><BICOrBEI> | Updated Rule |
| <GrpHdr><InitgPty><OrgId><Othr><Id> | Updated Rule |
| <OrgnlPmtInfAndSts><TxInfAndSts><OrgnlTxRef> | Updated Rule |
| Update of CGI-MP Logo and 'Data Content Principle' | |
| Approved by CGI-MP Plenary | |
| Removed Rows 174-176 which were duplicated entries | |
| Added additional Reason Status codes to 'Status Reason Codes' tab | |
| Status Reason Codes content updated to reflect current External Code List content | |
| <OrgnlPmtInfAndSts><TxInfAndSts><AcctSvcrRef> | Updated Status to BD |
| <OrgnlPmtInfAndSts><TxInfAndSts><ClrSysRef> | Updated Status to BD |
| Folder "Status Reason Codes" | Removed folder, as the copied External Code List is outdated. Relevant tags in the message refer to the External Code List, which is published on the ISO 20022 website. |
Content of the Payment Status Report
In SAP, payments batches are identified based on the reference field “RENUM” table “REGUT”. Reference of payment batch is available on MT101 payment in tag :20:
Business Requirement
The payment processed through SAP payment program (F110 or F111) and payment file (ISO 20022 XML or MT101) are to be processed, end-to-end as an automated process. Due to certain restriction from the bank side in providing the reference, sent on tag:20: on a MT101, the system should be able to process the status update in Bank Monitor.
MT900 Sample with bank reference number
{1:F01DEMOXXX3769520631}{2:O9000405190524CITIDEMO228553421291905240405N}{3:{108:90524ZRT38726LON}}{4:
:20:12345678
:21:2000000183
:25:10409030
:13D:1905240304+0000
:32A:190524USD260814,84
:52D:Test vendor Demo.
201 Test Street,Demo
Demo system
:72:/001/22.2.2018
-}{5:{CHK:93A0AE5D3637}}
SAP Solutions
New Z proxy “ZII_BNK_CPAY_ORD_NOTIFICATION’ a copy of standard proxy II_BNK_CPAY_ORD_NOTIFICATION. Following logic to be implemented
Steps
- From the MT900 file pick the value from <PaymentOrderNotification>
<ID> (please highlighted above in colour) - Go to table “BNK_BATCH_ITEM” and pass the value picked from <PaymentOrderNotification>
<ID> (payment end to end ID)
3. Pick up the value in the field “BATCH_NO”
- Go to structure “FPAYHX” field name “RENUM”
- Pass the merge date “LAUFD” and merge ID “LAUFI”
- Pick the message number from structure “FPAYHX” field name “RENUM” and update tab <ID> in <message header>collectivePaymentorderNotification>
</MessageHeader>
<CollectivePaymentOrderNotification>
<ID> 0000018716</ID>
- Updated MT900 to be processes in SPROXY “CollectivePaymentOrderNotification_In”
Conclusion
The SAP system is built intelligently and is best utilized so that the payment batches are automatically processed when the Corporate (Banks) do not send the reference sent on tag:20: of MT101 in return message MT900.
About Author
Colin Thomas
Colin Thomas has 10 years of domain experience in Financial Accounting and 14 years of SAP experience. His experience in SAP includes business process re-engineering and SAP implementation in Finance and Manufacturing processes. He holds a Master’s degree in Commerce and he is certified by the SAP S4 HANA Financials, IFRS and ITIL.
- SAP Managed Tags:
