Symptom
Currently, when the standard US_ACH_DD format payment file is generated, it selects the last 8 digits of the payees' bank key. However, in some cases, it is required that the first 8 digits of the payees' bank key to be included in the payment file.
This article provides a guide on how to achieve this.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Execute a payment run in Manage Automatic Payments App for US house bank (US_ACH_DD format).
- Check the payment file generated and notice that the last 8 digits of the bank key are included in the payment file.
- The expectation is that the first 8 digits (not the last 8 digits) should be included in the US_ACH_DD format.
Resolution
It is a standard system behavior that the US_ACH_DD format selects the last 8 digits of the bank key by default.
To address the requirement of retrieving the first 8 digits of the bank key in the format file, follow the below steps:
- Via MAP Format Data for Payments, copy the mapping US_ACH_DD to the customer namespace.
- Locate the element ‘CCD3 ReceivingDFIIdentification’.
- Go to the “Source” tab and change the “Structure Field” from ‘ZBNKL’ to ‘ZBNKL+0(8)’.
- Activate the Format Tree.
- After completing the customizing in MAP Format Data App, add the custom format in the following configuration activities:
- Configuration Activity 102569 - Create payment medium format.
- Configuration Activity 101972 - Set Up Payment Methods for Each Country/Region for Payment Transactions.
See Also
KBA 3480249 - How to find the Source of Information for Structures FPAYP, FPAYH, and FPAYHX
Keywords
us_ach_dd, payment file, bank key, first 8 digits, last 8 digits, payment transfer, manage automatic payments, format tree, map format data, configuration activity, ccd3 receivingdfiidentification, zbnkl, payment medium format, payment methods configuration , KBA , FI-AP-AP-B1 , Payment transfer (w/o DE, US) , How To
SAP Knowledge Base Article - Public