cancel
Showing results for 
Search instead for 
Did you mean: 

What should the MT940 with Structured Memo Line look like?

kamilfilochowsk
Explorer
0 Kudos
1,529

Hi Experts!

Can someone explain a bit what is the difference between MT940 and MT940 with Structured Memo Line (Format Mapping)?

And what is the difference between MT940 with Unstructured Memo Line and MT940 with Structured Memo Line?

Could you provide an example of how to prepare a test file to test these new functionalities?

This puzzles me because in previous releases I tested MT940 file and there was a memo line in the sub tag of the 86.

This is an example:

:20:20211027203135

:25://AT20815/00000543116/EUR

:28C:21200/1

:60F:C211022EUR191022,48

:61:2110271027C1000,00NTRFNONREF

:86:166?00SEPA Uberweisung (Haben)?20STESTVWZ+Re.1060280990?30STSPAT2GXXX

?31AT422081500042437947?32OSG GmbH

:62F:C211027EUR192022,48

:86:/BICC/STSPAT2GXXX

/IBAN/AT232081500000543116

and I read this but that does not help me to test the MT940 with Structured Memo Line (Format Mapping)

https://blogs.sap.com/2019/10/25/structured-format-for-field-86-in-mt940-bank-statement/

Best Regards,

Kamil

View Entire Topic

Hi Kamil,

The first three characters of tag :86: in MT940 file decides whether it is a structured or unstructured format. We call it as external transaction code.

  • If the value of first three characters is 999, then it is MT940 unstructured format. System considers all the data of tag :86: as note to payee(memo line).
  • If the value of first three characters is not equal to 999, then it is MT940 structured format. System considers sub tags from ?20 to ?27 as note to payee(memo line) from tag :86:

Hope it clarifies your question.

Thanks
Manikandan

kamilfilochowsk
Explorer
0 Kudos

Thanks Manikandan,

Thanks a lot, this is useful information for me.

I tried upload file with value 999 in the MT940 unstructured format. Problem is when I select this option in the Manage Incoming Payment Files app I get the error 'An error occurred during the mapping."

And similar problem when I'm trying to add with value for instance 166 in tag :86: and select file type MT940 with Structured Memo Line.

The content of both files is here:


for MT940 with Structured Memo Line

:20:20211027203135
:25://AT20815/00000543116/EUR
:28C:22125/1
:60F:C220818EUR317826,66
:61:2208180818C1000,00NTRFNONREF
:86:166?00SEPA Uberweisung (Haben)?20SVWZ+Re.1060280990TEST64LONG
?30STSPAT2GXXXTEST64LONGLO65OVERSIXTYFOUR?31AT422081500042437947
?32OSG GmbH TEST
:62F:C220818EUR318826,66
:86:/BICC/STSPAT2GXXX
/IBAN/AT232081500000543116<br>

for MT940 with Unstructured Memo Line

:20:20211027203135
:25://AT20815/00000543116/EUR
:28C:22125/1
:60F:C220818EUR317826,66
:61:2208180818C1000,00NTRFNONREF
:86:999?00SEPA Uberweisung (Haben) SVWZ+Re.1060280990TEST64
:62F:C220818EUR318826,66
:86:/BICC/STSPAT2GXXX
/IBAN/AT232081500000543116

Do you see here any wrong logic or other problem?

Thanks,

Kamil