The payment medium format controls how payment orders and debit memo orders to the bank are created. The specifications (published by the banks or the central banking committees) of the formats serve as the basis for the definition of payment medium formats. To simplify communication with banks using SAP S/4HANA, we are bringing you a solution regarding payment formats in FI-CA.
We have started to redesign payment formats by introducing Data Medium Exchange Engine Extended (DMEEX). DMEEX enables you to define file formats that meet the requirements of your financial institution. You can do so by modelling externally defined format in the system.
The ability to define these formats in the system is particularly important as there is no worldwide or regional standard format. In some cases, no country standard exists, and the file must comply with bank-specific standards. Covering such numerous and varied local format requirements is difficult in standard software, but DMEEX allows you to define your specific format yourself.
Customizing of Payment Medium Formats
The initiative we run is to align communication structure between the customer and the bank defined with the payment format in
FI-CA (transaction FQP3) and the one already defined with the payment format in
SAP S/4HANA Finance (transaction OBPM1). Thanks to that, you can produce and influence the format layout for the payment file for both FI and FI-CA, which saves you time during the fine-tuning of the format structure.
In the new approach, the data collection is done in FI-CA as it was before. The data is then converted into the FI payment media workbench structures. Thanks to this conversion, the formatting from FI can be reused, saving time and costs.
To see how you can influence the structure of the payment format in practice, visit
SAP Help Portal.
Payment Medium Formats available in FI-CA
The list of available payment medium formats can be seen at
SAP Help Portal.
In order to provide transparency regarding payment medium formats that are no longer in use, we created an overview with status for each payment medium format: available, not available or obsolete. You can check the availability of the payment medium formats in
SAP Note 2943353.
Creating Customer-Specific FI-CA Payment Medium Format based on DMEEX
Although banks will follow the general standards outlined for a specific format, sometimes customers may need to change the mapping rules of the format to align with the bank-specific requirements. Examples of such changes include:
- concatenation of fields to support reconciliation
- the setting of fields from optional to mandatory
- replacing the standard mapping for customer-specific mapping
Currently, not all formats supported in FI are delivered for FI-CA, but you can create a Z-format (customer-specific format) and link it to the standard DMEEX tree delivered for the FI format. This guide describes steps to prepare customer-specific payment medium formats in FI-CA based on the DMEEX tree delivered for the FI format.
This step-by-step guide is taken from
SAP Note 2860488, where you can find additional information about customer-specific payment medium formats.
1. Create Format Name
In transaction
SM30, open the
V_TFK042FS maintenance view and enter a format short name, such as ‘
ZPTCGIXML_DD’.
2. Create Payment Medium Format
To create new Payment Medium Format, call transaction FQP3. Choose New Entries and enter the name of the format, such as ‘Z_PT_CGI_XML_DD’ in the Format field. Then, fill out other fields as shown below.
In the Dialogue Structure tree, choose the
Event Modules for Payment Formats sheet and add event function modules and a structure name for format parameters.
In the Dialogue Structure tree, choose the
Text Fields for Reference Information screen and make any necessary changes to the number and length of text fields as shown below.
3. Maintain Additional Format Data in Posting Area 1066
Call transaction
FQC0 for
Posting Area 1066 and maintain the format short name and other additional information for:
- Paying Company Code
- Payment Method
- House Bank
Select the format short name you created as described in step
1. Create Format Short Name.
4. Enhancement Implementation
Visit SAP Help Portal to read more about
DMEEX. You can also read a new blog about
Performance Acceleration in DMEE(X).
We also publish news about Payment Formats on our collective blog
Payment Formats in SAP.
Do you have any further comments regarding this topic? Do not hesitate to share them in the comment section below.