FF.5 (EBS) - External transaction code is not provided by the bank

[former_member185951]

Dear FI experts,

I need to implement the electronic bank statement for a bank that provides statement information in the format MT940.

The problem is that the external transaction code doesn't change depending on the items; it's always a constant, for instance NTRF , and I am not able to relate the items to an external transaction created via TC OT51.

Here it is an example:

=================

:20:9400110341014444

:25:005456132

:28:006-1

:60F:C110108PEN408349,73

:61:1101080108DL700000,00NTRFNONREF//0003732222

/CTC/ 500 /TED SENT

:86:/PT/DE/EI/BENEF.: REF:

BCO:0 0 AG:0000 C/C:0 0

DEBITO REFERENTE A 1 PAGO

:61:1101080108CL1094197,81NTRFNONREF//0000560971

/CTC/ 090 /COLLATERAL CREDIT

:86:/PT/DE/EI/TRANSACCION

:61:1101080108DL837956,71NTRFNONREF//0003722722

/CTC/ 196 /SUPPLIER PAYMENT

:86:/PT/DE/EI/BENEF.: REF:

DEBITO REFERENTE A 63 PAGO

:62F:C110108PEN408349,73

:64:C110108PEN408349,73

The bank tells me it cannot change the constant NTRF and that I should use the codes in bold above.

Please is there any solution to this issue?

Best regards,

Marcos.

[Former Member]

Although I am more familiar with BAI2, I was wondering what transaction type are you using in OT51?

Are you saying that when you go to OT51 and select the correct transaction type, the codes you see do not correspond to the bold entries in the file the bank is sending? Or are you saying that there is no way to create any new entries for external transaction codes in OT51 because codes are already there? Are you saying that the bold items that bank are indicating as codes are not really codes?

[Former Member]

Take a look at the following threads as they may shed some light if you have not already read through them...

[former_member185951]

Hi, Will.

When you ask Are you saying that when you go to OT51 and select the correct transaction type, the codes you see do not correspond to the bold entries in the file the bank is sending?, you're right.

I run FF.5 to upload the EBS but, no matter the parameters I choose there for this format (MT940), SAP never finds the codes 500, 090 and 196. Either it finds NTRF or /PT.

Hope you may help.

Best regards,

Marcos.

[Former Member]

Ok. I am more familiar with BAI format but It appears that the format of the file you are receiving from the bank is related to a different format than is setup in OT51 configuration. I have seen some threads that link codes such as NTRF in field 61 to the muticash or MT940 format. I would suggest getting 100% verification from the bank as to what is the exact format you are receiving and making sure SAP supports it. Some formats have to be converted for SAP. It sounds like SAP is understanding the format of the file and reading the NTRF (transfer) code.

http://help.sap.com/saphelp_erp60_sp/helpdata/en/43/0bd87b43de11d1896f0000e8322d00/frameset.htm

Also you can check notes 13283 and 36833 for some additional information on the multicash/ MT940 format.

In searching the web, I ran across a listing of sample codes such as below...

NRTI = Returned item

NSEC = Securities

NSTO = Standing order

NTCK = Travellers cheques

NTRF = Transfer

Sorry, but this is all I can help with since I only know the BAI format. If I had more time I would configure a different transaction type with the codes above in our test system and run a test file.