Search String for Cheque And Transfer is not working for MT940

[Former Member]

Hi All,

We have the requirement to populate the particular value from MT940 file from the field note to payee into BSEG-ZUONR. Also the same value will be clearing search criteria during EBRS batch session processing to clear the open item.

We also have another requirement for outgoing cheque clearing based on the cheque No.

I have defined 3 search strings for this one for Assignment field Identifier and second one to pass the value into assignment field. For Cheque also I have created separate search string.

I believe there is some issue in the search string as when we simulate it in the configuration is showing us the expected results but in the actual run (SM35) it is not working correctly.

MT940 Format:

Simulation is showing that system is considering the payment document no. in the mapping to pass the same in ZUONR

Simulation is showing that system is considering the payment document no. in the mapping to pass the same in CHECT

As per the Search String value for the assignment should be payment document # 1150000021 instead of OUTWARD T/T.

Also the value to search open item should be 1150000021 instead of OUTWARD T/T. Similar case with Cheque in which it is clearing by WRBTR and not with Cheque No.

NCLR - Payment Document

NCHK - Cheque

Generally system should clear this by searching the payment document no. using provided cheque details.

Kindly help me to troubleshoot the missing part of the defined search strings.

Best Regards

Sagar C'kar

[Former Member]

Hi Mr. Bastiaan Jansen,

First of all thank you for your valuable inputs which really helped me to further analyze the issue regarding MT940 file upload.

I have tried to simulate the results in T.code - FEBSTS for one of my earlier successfully uploaded statement, I am getting below screen which I am unable to understand. For Cheque Model Hit & Mapped Hit both are showing me correct value to be updated in CHECT for Outward TT

Model Hit & Mapped Hit both are not showing any values.

When I am executing Batch in SM35 according to simulation system should clear all NCHK (-) transactions with reference to Payment document no. posted in SAP (Linked with Cheque No.) but in my case it is still clearing based on WRBTR.

For NCLR(-) Outward TT the rule itself is not working, I will try to right the same in different way.

Please let me know if my understanding is correct for cheque?

Best Regards

Sagar C'Kar

[Former Member]

I would expect something in the column "MAPPED HIT". However item 6 misses OUTWARD T/T in the item text. So can you import the MT950 file as shown in this message and retry the FEBTST report?

[Former Member]

Can you enter one of the tested statements in FEBSTS (TRX) and post the results?

Another option is to start with some really short searchstrings and get that working, as the MT940 lines are merged to the FEBRE table SAP sometimes adds extra spaces (depending on version) which can cause problems RFEKA400 form MEHRZWECKFELD.