SAP Knowledge Base Article - Public

3451742 - Other Outgoing Or Incoming Payment Despite Payment Method Mapping in Bank Statement Format MT940 DE

Symptom

You are adding additional External Transaction Codes for bank statement files that are based on SWIFT bank statement format MT940 DE (Germany). 

  • Business Configuration work center.
  • Activity:     Automatically Generated Bank Statements / Edit import formats for automatic generated bank statements.
  • Format:     01 - MT940 DE

Here, for example, External Transaction Code XYZ has been assigned Debit/Credit 'Decrease' and is mapped to Payment Method 'Payment Processing - Of Outgoing Bank Transfer'.

When processing the bank statement, however, the derived Payment Method shows as Other Outgoing Payments.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Liquidity Management work center.
  2. Navigate to the uploaded bank statement via Bank Statements view.
  3. Select the relevant bank statement and transaction.

Cause

The problem is not the application of a custom External Transaction Code and mapping to a designated payment method per se - but the conformity of the content of payment explanation blog :86: in format MT940 DE.

Here fields are delineated by characters ?00 ?20 ?30 and others. 

The first field is reserved for a 3-digit External Transactions Code, others for memo-text, Payer IBAN, Business Partner Names and others. 

If this is not followed and instead of ?00 any other or special character is provided - the External Transaction Code will not be interpreted and the Payment Method Mapping will not take effect. 

In the absence of a mapped payment method the only information available is the Payment Direction and Amount, hence Other Incoming/Outgoing Payment. 

For example: 

The following content will not parse External Transaction Code XYZ in format MT940 DE:

:86:XYZ^00Text 

Resolution

Adhere to pertinent specifications for SWIFT format MT940 DE. 
The following content will parse External Transaction Code XYZ and the payment method mapping will take effect.

:86:XYZ?00Text 

You can verify/maintain the External Transaction code as follow:

  1. Go to Business Configuration Work Center > Implementation projects view
  2. Select your Implementation Project and click Open Activity List
  3. Search for the "Automatically Generated Bank Statements" activity and open it
  4. Click Edit import formats for automatic generated bank statements
  5. Select the Import Format, i.e.: 01 - MT940 DE
  6. Check if the External Transaction Code is maintained, if not, click Add Row and enter the new External transaction code
  7. Click Save

Keywords

Bank Statement  MT940 DE External Transaction Code , KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem

Product

SAP Business ByDesign all versions