SAP Knowledge Base Article - Public

3649342 - Error during MT940 bank statement upload due to incorrect balance format

Symptom

Error occurs during uploading bank statement in pre-delivered MT940, MT940_STRUCTURED format in "Manage Incoming Payment Files" application.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP S/4HANA Public Cloud Edition

SAP S/4HANA Private Cloud Edition

Reproducing the Issue

  1. Open the "Manage Incoming Payment Files" application.
  2. Attempt to upload MT940 bank statement file.
  3. Upload returns to error.

Cause

MT940 bank statement contains more statements with its own currency. The currency is in tag ':60F: Opening Balance’ or in ‘:60M: Intermediate Opening Balance’ record. The amounts corresponding to the currency are in subsequent :61: records. Number of decimal places is for each amount defined by the corresponding currency. 

When the amount in :61: refers to the currency in :60F: it leads to wrong amounts when the currencies have different number of decimal places. From CE2508 such situation does not have be processed at all.  

Resolution

The issue must be solved by a modification of the format. Create your own copy of MT940, MT940_STRUCTURED. The below case example is for MT940_STRUCTURED:

  1. Create a text variable which will record whether the statement has record 60F or 60M 
  2. Clear this variable before the record group :60x: 
  3. Set this variable to ‘F’ somewhere in :60F: and to ‘M’ somewhere in :60M: 
  4. Duplicate the :61: record and  
  • For the better readability rename them to ‘:61: Line Item F’ and ‘:61: Line Item M’.  
  • Create corresponding condition for each of them – the condition must check whether the new variable has value F or M. 
  • Set the reference to the Currency in the Amount field accordingly – in F to F and in M to M. 

Keywords

MT940, MT940_STRUCTURED, Mandatory node N01309002337 (D/C Mark original) is missing, Manage Incoming Payment Files, F1680, F1 680, bank statement, Mandatory node , KBA , CA-GTF-CSC-DME , Data Medium Exchange Engine , Known Error

Product

SAP S/4HANA Cloud Public Edition all versions