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
- 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 - Copy to new format
- In New Format /CAMT053_001_02 change the type of this restriction (in node ISODateTime) from DateTime to String.
- Save and Release
- Use the new format mapping to import files via app Manage Incoming Payment Files.
See Also
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