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.
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
Select the format short name you created as described in step 1. Create Format Short Name.