FIN (Finance)

SAP S/4HANA Finance Advanced Payment Management (APM) in Integration with SAP Multi-Bank Connectivity (MBC)

Advanced payment management allows you to centralize all payment activities of a corporate group. Advanced payment management supports five payment scenarios: Internal payments, payments ‘in name of’ with forwarding only, payments ‘in name of’ with routing optimization, payments ‘on behalf of’ and central incoming payments.

It integrates with other areas within SAP S/4HANA such as In- House Bank, In-House Cash, Cash Management, Bank Communication Management, Bank Account Management and General Ledger.

As organizations scale up, there is significant increase in payment volumes and hence need to automate, streamline, optimize the end-to-end payment process across the entire group. Headquarter need the centralization of the payment approval and monitoring for subsidiaries by using a single source of truth. They need the ability to handle different payment formats centrally and automate the routing of payments to different financial institutes.

The system uses Bank Account Management to determine the bank account to be used, triggers approval through Bank Communication Management and once approved creates the external medium for transmission to the bank using Multi Bank Connectivity.

SAP S/4HANA Finance for advanced payment management provides centralized payment factory to manage payments from various systems – SAP, non-SAP and manual payments.

In this blog we are majorly focusing on the scenario payments ‘in name of’ with forwarding only and its basic configuration.

In this scenario, we want to consume a file based payment instruction in advanced payment management and send it to the bank via Multi-Bank Connectivity.

In the following I will describe the available configuration which is used for this scenario as well as the master data which needs to be created to support the scenario.

Define Clearing Areas

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–>Basic Configuration–>Organization–>Define Clearing Areas

Clearing areas act as an org object under the client level. Users working in one clearing area do not have access to data in other clearing areas. One clearing Area we can make work for multiple company codes with different currencies.

Maintain Generic Number Ranges

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–>Basic Configuration–> Maintain Generic Number Ranges

The number range numbers are assigned to diverse number range objects in advanced payment management. A number range object is uniquely identified by its name, and you can assign a number range number starting with 01 and an end value of 99.

With the number range numbers defined here you can customize the number ranges for the following objects:

  • /PF1/COLL: Number Range Object for Collectors > Not used in the Project.
  • /PF1/CSTID: Customer IDs for service level agreements > Not used in the Project.
  • /PF1/FH_OL: Number Range Object List Number (Secondary Key)
  • /PF1/PO_PI: Number range for Payment Transactions (Secondary Key)
  • /PF1/PO_PO: Number range for Payment Order (Secondary Key)
  • /PF1/PO_RE: Number range Object for Recalls > not used in this Project.

Maintain Number Ranges for Payment Orders

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> Payment Processing–> Business Objects–> Payment Order–> Maintain Number Ranges for Payment Orders

A clearing area always requires a payment order number range before payment orders can be processed in that clearing area. The payment order number is then populated in the Input Manager. You create a payment order number range for payment orders and define whether or not the payment order number is assigned internally by the system.

Define Payment Order Types

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> Payment Processing–> Business Objects–> Payment Order–> Define Payment Order Types

Payment order types are defined for both incoming and outgoing payment orders. Every payment order needs exactly one payment order type.

The payment order types that are defined here are assigned to incoming & outgoing payment orders by format converters.

The payment order tells the system what checks to carry out on the payment order and its components.

While payment order categories are delivered as part of advanced payment management, payment order types can be used as incoming or outgoing order.

Maintain Number Ranges for Payment Items

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> Payment Processing–> Business Objects–> Payment Item–> Maintain Number Ranges for Payment Items

If the payment item numbers are assigned internally then they are assigned incrementally. Customizing allows you to set the lower and upper limits for a payment item number. The last number to be assigned is also visible in this activity.

Define Transaction Types

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> Payment Processing–> Business Objects–> Payment Item–> Define Transaction Types

The transaction types are assigned attributes that determine the processing of payment items. They can determine whether the amount is a credit, or a debit and which validations should be carried out during posting.

  • Originator: – An item posted to the party initiating the payment order. (Company Code)
  • Recipient: – An item posted to the party receiving the payment. (Beneficiary Vendor/ Customer)
  • Clearing: – A special category of payment item used for internal posting. During the clearing process, a clearing item is generated either when a payment batch is closed or when a single payment order is forwarded. For clearing batches, the clearing item is posted on the bank clearing (nostro) account. For internal batches, the clearing item is posted on the customer account.
  • Turnover: – A special category of payment item that does not have an ordering party or recipient characteristics. Turnover items are usually generated by internal settlement systems, for example, when security transactions are handled or interest is calculated.

Assign Transaction Types to Order Types

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> Payment Processing–> Business Objects–>Payment Item–> Assign Transaction Types to Order Types

The relationship between payment order type and its allowed transaction types. The Order and Repair user interface uses this information to display allowed transaction types.

Define Rules for Bank Communication Management

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> Payment Processing–> External Interfaces–> Bank Communication Management (BCM)–> Define Rules for Bank Communication Management

Maintain the Bank Communication Management (BCM) rule IDs that are used in BCM workflow configuration for payments that are passed from advanced payment management. You can map it based on order type, Company Code, House bank & Account ID

SetUp Converter

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> Payment Processing–> External Interfaces–> File Handler–> Basic Configuration–> Set Up Converter

Maintain the format in which data is passed into and out of advanced payment management. The format describes the structure of the fields and records of the payment objects that are used in advanced payment management.

Define Media

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> Payment Processing–> External Interfaces–> File Handler–> Basic Configuration–> Define Media

You maintain the medium used to deliver data to and from advanced payment management. The medium along with the channel and the format defines a converter.

Define Channels

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> External Interfaces–> File Handler–> Basic Configuration–>Define Channels

The channel used to deliver data to advanced payment management

SPRO–>Financial Supply Chain Management–>Advanced Payment Management –>External Interfaces–> File Handler–> Basic Configuration–> Define Converter(new)

Define Inbound Converter

A converter is represented by the combination of 4 attributes. Format, medium, channel and direction are linked with a conversion program, which is responsible for interpreting the data and translating it into the required target data structure or file format.

If the file to be imported is a standard XML file, we would use the standard inbound conversion of the XML conversion framework. Its class is /PF1/CL_IPM_P_XML_FORMAT_CONV, however you do not have to enter the class, it would be derived automatically.

If Schema and tag validation was already done in your source system and if you want forward this format without any change or validation than it is recommended to use the flag ‘Forwarding’. it is recommended to use the class /PF1/CL_IPM_FORWARD_PAIN1. The partial reaction is not possible always processing happen at file level.

If you are using the Multi-Bank Connectivity (MBC) local routing functionality than it not required to configure the Directory logical file Name & Logical File ( in this scenario we are using the MBC local routing)

Note:- If you are not using the MBC local routing functionality than it is mandatory to configure the Directory logical file Name & Logical File.

For the outgoing Payments I am using the order type”000200” for Clearing area SAP001 in below screen shot which I configure.

For the outgoing Payments I am using the XML Message Identifier as “/ISO_PAIN.001.001.03” for order type “000200” in below screen shot which I configure.

PAIN.001.001.03 Message Type Inbound Handler with Help of MBC and F110 Automatic payment program

We are assigning the Incoming order type is assigned to Converter ID as per the above Screen Shot. The Order type we are assigned it to Transaction type at clearing area level.

  • Originator: – An item posted to the party initiating the payment order. (Company Code)
  • Recipient: – An item posted to the party receiving the payment. (Beneficiary Vendor/ Customer)

Define Outbound Converter

A converter is represented by the combination of 4 attributes. Format, medium, channel and direction are linked with a conversion program, which is responsible for interpreting the data and translating it into the required target data structure or file format

the converters map the data received from the source system to advanced payment management meta format in the Output Manager (OPM)

If we are using XML conversion framework Converter class for outbound file based conversion it is standard class which we use the configuration /PF1/CL_OPM_P_XML_FORMAT_CONV,

If Schema and tag validates already done in your source system and if you want forward same format without any change or validation than it is recommended to use the Class in the configuration /PF1/CL_OPM_FILE_FORWARD_CONV

we are using the Multi-Bank Connectivity (MBC) than it not required to configure the Directory logical file Name & Logical File ( in this scenario we are using the MBC local routing)

we using the Multi-Bank Connectivity (MBC) than it is mandatory to configure the Class “/PF1/CL_OPM_OUTPUT_STREAM_MBC” or it will not create out file which we needs send it bank.

Note:- If you are not using the MBC functionality than it is mandatory to configure the Directory logical file Name & Logical File. It recommended to configure the class /PF1/CL_OPM_OUTPUT_STREAM_FILE, if you not configured also by default it will pick up the class as /PF1/CL_OPM_OUTPUT_STREAM_FILE

Maintain Routing Settings for Outbound Messages

SPRO–> Multi-Bank Connectivity Connector–> Routing and Connectivity–> Maintain Routing Settings for Outbound Messages

In case of local routing, an outgoing message is not sent to SAP Multi-Bank Connectivity. Instead, a new inbound message is created using the outgoing message. The new inbound message is handed over to the Connector for SAP Multi-Bank Connectivity for inbound processing.

Set Up XML Schema Validation

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> Payment Processing–> External Interfaces–> File Handler–> XML Framework–> Set Up XML Schema Validation

The XML schema definitions can be used in the IPM/OPM XML Format Converters.

The XML schemas could be used as follows:

  • As a basis template for an XML converter implementation. For more information, see Message Identifier for an XML Converter.
  • As a rule set for an individual schema validation of XML files. For more information, see Identifier of an XML message that defines an XML schema definition (XSD).

In the standard system, some standard XML schema definitions are available for implemented converters. If required, you can update these schemas with adjusted versions. The customizing table is protected against SAP updates. SAP is allowed to insert new entries only.

  • Choose Upload to upload a new XSD file from your local PC.
  • The following data has been entered to have the ISO_PAIN.001.003.03 in the system available:
  • Choose Upload XSD File to store this schema definition in the Customizing table.
  • Depending on the standard client transport settings, you may need to create a transport request.

The Customizing transaction enables you to display each schema definition in a detail tree view with the different types of validations (for example, patterns or digits) for each node.

Test the XML schema validation on individual XML files by choosing the Test Schema Validation button.

To replace individual invalid XML values and to control errors from the XML schema validation more flexibly, you can use the BAdI: Replacement of Invalid XML Values During Read Access.

Define XML Settings for Format Converter

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> Payment Processing–> External Interfaces–> File Handler–> XML Framework–> Define XML Settings for Format Converter

the converter implementation from the settings in this Customizing activity. You can either directly assign a specific converter implementation or specify a converter package. Converter packages can provide automatic converter implementation derivation by using the BAdIs listed at the end of this section.

You need to specify the correct converter implementation for output converters. You assign the general XML output converter /PF 1/CL_OPM_P_XML_FORMAT_CONV for your format converter regardless of the XML format. This activity enables you to inform Output Manager of the type of XML format that has to be created.

You can also use the following BAdIs to overrule the customizing settings:

  • BAdI: Derivation of Message ID for XML Input Converter
  • BAdI: Derivation of Message ID for XML Output Converter
  • /PF1/BADI_FH_XML_MSG_IDENT_OPM
  • /PF1/BADI_FH_XML_CONVERTER
  • /PF1/BADIIMPL_FH_XML_IPM_ISO
  • /PF1/BADIIMPL_FH_XML_OPM_ISO
  • /PF1/BADIIMP_FH_SWIFT_IPM
  • /PF1/BADIIMP_FH_SWIFT_OPM
  • /PF1/BADI_BNK_WF_INTEGRATION
  • /PF1/BADI_IMPL_BP_DEFAULT
  • /PF1/BADIIMPL_OPO_PROCESS_BCM
  • /PF1/BADIMPL_PO_XML_MAP_ISO

Maintain Number Ranges for Object List

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> External Interfaces–> File Handler–> Basic Configuration–>Maintain Number Ranges for Object List

A converter that converts the incoming payment order information into business objects of advanced payment management is determined based on format, medium and channel. One business object that is created is the business object “Object List”

Determine Payment Order Priorities

SPRO–>Financial Supply Chain Management–>Advanced Payment Management –> External Interfaces–> Format Specific Configuration–> ISO20022–> Determine Payment Order Priorities

The determination of the advanced payment management internal priority of payment orders. This information controls, amongst others, the processing frequency and the frequency in which the order status is changed. The priority is determined and assigned to the payment order. In the case the priority cannot be determined for e.g. the respective message field is not filled (optional) a default priority is assigned.

Determine Payment Order Types

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> External Interfaces–> Format Specific Configuration–> ISO20022–> Determine Payment Order Types

the determination of the internal payment order type. The system uses this control information for certain validation and processing throughout advanced payment management. You define this information in the payment order. The combination of message type and original message type allows the system to distinguish uniquely between credit transfers and direct debit and between -bank-to- bank R-messages (reject/return).

Determine Item Transaction Type

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> External Interfaces–> Format Specific Configuration–> ISO20022–>Determine Item Transaction Type

the system determines the internal transaction type. You define the transaction type for the payment item in customizing (see below). This control information is used for various validation and processing steps throughout the system.

Assign Exception Handling Reaction to Bank Reject

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> External Interfaces–> File Handler–> External Status–>Assign Exception Handling Reaction to Bank Reject

he system will use the most specific (bank specific) entry. If no matching entry for the bank is available, the generic entry without bank identifier will be applied.

If no specific reaction type is defined, the ‘ Define Default Reaction Types’ or Master data configuration will be used for the standard error code ‘Bank Reject(002010)’.

Maintain Multi-Bank Connectivity Connector Inbound Settings

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–>External Interfaces–> File Handler–> Multi-Bank Connectivity Connector Integration–> Maintain Multi-Bank Connectivity Connector Inbound Settings

Maintain inbound settings for Multi-Bank Connectivity (MBC) messages received via the Multi-Bank Connectivity Connector. We can configure the Convertor ID based on Sender ID, Receiver ID, Message type and origin ID.

With the help of MBC Local Routing functionality once we ran F110, the XML will be routed with help MBC and handed over to APM

Maintain Multi-Bank Connectivity Connector Outbound Settings

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> External Interfaces–> File Handler–> Multi-Bank Connectivity Connector Integration–> Maintain Multi-Bank Connectivity Connector Outbound Settings

the outbound settings for sending messages via the Multi-Bank Connectivity Connector to Multi-Bank Connectivity (tenant).

Exception Handling

SPRO–>Financial Supply Chain Management–>Advanced Payment Management–> Exception Handling

the priorities of all existing response types. The response types, regardless of the group, are listed with their respective response type groups in number format and a short and long text description.

Only the response type priority is set in this activity. You do not create or modify any existing information regarding a response type or a response type group.

you can create response types for rejection of payment orders and/or payment items. You assign an existing return reason and a final response type to the new response types.

You can use the dropdown box in the Partial column to specify whether the payment orders are to be rejected in full, or whether only incorrect items are to be rejected, and processing is to continue. If you do not specify a value in this column, the system rejects the payment order in full. You can also specify the correspondence type required in each case.

Payments are running into erroneous situations based on various reasons. Instead of pushing these payments back to the local subsidiary systems the solution allows to fix these errors in a central place, either manually or automatically.

Service Level Agreement

SAP Menu–>Accounting–> Financial Supply Chain Management–> Advanced Payment Management–> Master Data–> Service Level Agreement

Displays options for Enrichment and Validation, Notifications and Charges for which you can define set of rules and restrictions in detail. Mark the relevant checkboxes in the Options section. The corresponding tab pages will be displayed.

Routing Objects

SAP Menu–> Accounting–> Financial Supply Chain Management–> Advanced Payment Management–> Master Data–> Routing Objects

Based on the predefined Business rules such as Incoming order type, Bank Key, Account Number and originator the Route and clearing agreement it will be identified based on clearing area .

We can use all attributes of a payment like amount, currency, country, payment type, priority and additional attributes like time, % distribution of payments

Define payment routing based on business rules (master data)

Route by all attributes of a payment and several special dimensions, e.g.

  • Cut-off times
  • Percentage of business
  • Beneficiary bank
  • Available liquidity
  • Adherence to due date
  • Transaction Currency
  • Payment Scheme compatibility
  • Amount limits
  • Payment Type

Perform rerouting and regrouping of payments

Link payment formats, cut-off times, bank account details, bank clearing account, etc. in one place with central governance and approval processes

End user: Run Automatic Payment – F110

Apart from the Payment run job, MBC FSN job got tiggered automatically and the Small_POP job for the APM file import.

SAP Menu–> Connector for Multi-Bank Connectivity–> /BSNAGT/MONITOR – Connector Monitor

In the below screen shots it has been observed that file has not set out it has been locally routed and handed over to APM

Loge Represents message has been locally routed

When the file is local routed it will show on incoming side

Loge Represents file has been handed over to APM

In the relation ship tab you see the both incoming and out going orders

In the Fiori Notifications you observe the APM batch approval notification which has to be approved

Got the APM (Advanced Payment Management APP’s and select the Manage Payment)

Based on the Selection it is displaying two orders which represents incoming order and Outgoing order based on the

Incoming order is getting created based on MBC Local routing based which file has been handed over to APM

For Each outgoing order it has three Segments Originator, Recipient & General Order Data

Originator: – Sending Company code information , Send bank Account Information, Service level Agreements, route, Clearing Agreements & Process flows

Recipient: – Beneficiary Bank Account details, EndtoEndID , Service level Agreements, route, Clearing Agreements & Process flows

Based on the Incoming order system is processing data and do required data validations in the APM and create the Outgoing order based on that APM batch will the created which will updated in the BNK_MONI (APP, Monitor Payment )

Note:- For Approvals We are using BCM frame work with APM information

For Each outgoing order it has three Segments Originator, Recipient & General Order Data

Originator: – Sending Company code information , Send bank Account Information, Service level Agreements, route, Clearing Agreements & Process flows

Recipient: – Beneficiary Bank Account details, EndtoEndID , Service level Agreements, route, Clearing Agreements & Process flows

Once the APM batch has been Approved with help of BCM Transaction (BNK_APP) or Fiori APP Approve Bank Payments, than an outbound file will be generated which will sent MBC Connector to tenant from their it will be sent to bank.

If you Observe in the below screen shot APM batch status is Approved

The Memo records will get created based Liquidity Management Application Activation in the Clearing area

It Below mentioned screen shot you can observe that APM Batch has been approved and file been generated which will sent MBC Connector to tenant from their it will be sent to bank.

SAP Menu–> Connector for Multi-Bank Connectivity–> /BSNAGT/MONITOR – Connector Monitor

In the below screen shots, it has been observed that file has set out with the help of MBC Connector to tenant from their it will be sent to bank.

Conclusion:

Below are take away points to be considered for this SAP S/4HANA Advanced Payment Management for scenario payments ‘in name of’ with forwarding.

  • Forward payment as is to house bank (no bank account determination – PINO Forwarding)
  • No Accounting will be generated from APM for scenario payments ‘in name of’ with forwarding.
  • Forward payment case we bring the external system payment file and process in APM and we track them centrally.
  • We payment group functionality is available based on the sending company bank key and currency we group the payments at the APM batch level which is available form S/4 HANA 2021.
  • We are able to receive the payment files from external system and able to process centrally in APM.
  • If we are not Using the MBC than for the file import directly from Physical file name directory with help transaction /PF1/FH_IPM_EXPERT – Execute Import Files.
  • If we are not Using the MBC than for the file import from file directory with help of transaction /PF1/FH_IMPORT_DIR – File Directory Import.
  • Cash Management will get updated with the help of APM
  • In APM Following tables will be used for Master data /PF1/DB_CA, /PF1/DB_ROUTE, /PF1/DB_SLA, and /PF1/DB_EOD_DT etc.,
  • In APM Following tables will be used for transaction data /PF1/DB_OLIST, /PF1/DB_ORDER, /PF1/DB_ITEM, /PF1/DB_EXT_STAT, /PF1/DB_ITEM_FI, and /PF1/DB_FH etc.,