SAP Knowledge Base Article - Public

3688435 - How to get the first 8 digits of the bank key in the US_ACH_DD format payment file instead of the last 8 digits - SAP S/4HANA Cloud Public Edition

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

  1. Execute a payment run in Manage Automatic Payments App for US house bank (US_ACH_DD format).
  2. Check the payment file generated and notice that the last 8 digits of the bank key are included in the payment file.
  3. 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:

  1. Via MAP Format Data for Payments, copy the mapping US_ACH_DD to the customer namespace.
  2. Locate the element ‘CCD3 ReceivingDFIIdentification’.
  3. Go to the “Source” tab and change the “Structure Field” from ‘ZBNKL’ to ‘ZBNKL+0(8)’.
  4. Activate the Format Tree.
  5. 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

Product

SAP S/4HANA Cloud Public Edition all versions