Upload account statement MT940 incorrect

[Stanco]

I got a account statement from the service provider PayJoe. The format is MT940. I upload the account statement in the app: Manage Bank Statements. In the app I click on upload, select the format MT940 and click process. Then the protocol shows me an error. 

Termntn during import: Statement no. missing (rec. type :28:): Acct XXXXX XXXXXXX

When I look in the Account statement I identify the rec. type :28C: . But it is mentioned more than one time. It is mentioned seven times. But is always like this:

:28C: 0

I found out that :28C: describes the part of the account statement. The structure of account statement is:

:20:STARTUMSE
:25:
:28C:
:60F:,
:61:
:86:
:61:
:86:
:62F:
-
:20:STARTUMSE
:25:
:28C:
:60F:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:62F:
-
:20:STARTUMSE
:25:
:28C:
:60F:
:61:
:86:
:61:
:86:
:62M:
-
:20:STARTUMSE
:25:
:28C:
:60M:
:61:
:86:
:62F:
-
:20:STARTUMSE
:25:
:28C:
:60F:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:62F:
-
:20:STARTUMSE
:25:
:28C:
:60F:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:62F:
-
:20:STARTUMSE
:25:
:28C:
:60F:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:62F:
-

Can someone please help with explaining me how I can use the app Map format Data to create a new template for this MT940 format?

Kind Regards

[bjansen]

28C contains the statement number. If this is always 0 you should ask the service provider if they can activate the numbering. Otherwise you will need to update it yourself (badi/userexit)

[Chuma]

Hello @Stanco ,

To create a new MT940 format template using the Map Format Data app in SAP S/4HANA Cloud Public Edition, follow these steps:

1. Access the Map Format Data app via the Finance – Bank Integration scope item (‏1J2‏).

2. Click Create Mapping Template, select MT940, and define your source structure.

3. Use the Structure Mapping and Field Mapping tabs to align the MT940 fields to your internal data structure.

4. Save and activate the mapping for use in Manage Incoming Payment Files (F0770)

Alternatively, follow this link,

https://community.sap.com/t5/enterprise-resource-planning-blog-posts-by-sap/structured-format-for-fi...

Thank you and kind regards

Chuma