SAP Knowledge Base Article - Public

3159797 - Incoming Payment File Manager Error with format camt.053.001.02

Symptom

When importing bank statements in the app Manage Incoming Payment Files (App ID F1680)with format camt.053.001.02 

In Job Log the following errors shown:

An error occured during the mapping.
Error Restriction failed for node CreDtTm.
Error Value "&1" is not a valid datetime.

"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 Cloud

SAP S/4HANA 

Cause

At present the Import Bank Statements does not support fractional seconds. DateTime restriction currently has format 
YYYY-MM-DDThh:mm:ss[Z|(+|-)hh:mm]

This will be changed so that the format will support fractional seconds, so the DateTime format would be YYYY-MM-DDThh:mm:ss.sss[Z|(+|-)hh:mm] in release 2208. 

Resolution

  1. In app Manage Your Solution 
    Application Area: Finance 
    Sub Application Area: Bank Accounting 
    Item Name: Electronic Bank Statement 
    Step Name: 4. Map Format Data for Incoming Files from Banks (ID 170010)
    Format Mapping Name  Description                                     Data Format
    CAMT053_001_02            camt.053.001.02 (Format Mapping)  XML Structure 

  2. Copy to new format 

  3. In New Format /CAMT053_001_02 change  the type of this restriction (in node ISODateTime) from DateTime to String.

  4. Save and Release 

  5. Use the new format mapping to import files via app Manage Incoming Payment Files.

See Also

How to Create a Format Mapping

Keywords

IFME_ENGINE  201 IFME_ENGINE201, camt.053.001.02, FF.5 , KBA , CA-GTF-CSC-DME , Data Medium Exchange Engine , FI-BL-PT-BA , bank statement , Problem

Product

SAP S/4HANA Cloud 2202