cancel
Showing results for 
Search instead for 
Did you mean: 

Search String for EBS leading zero

pooja_gupta123
Explorer
0 Kudos
1,109

Hi

We are getting Camt Bank statement and check number is in notes to payee. Check number in the bank statement is with 6 leading zero so it's 12 digit in the bank statement vs SAP has 6 digit. Check number start with number 6.

I created below search string but it's not working.

1 # ->
2 # ->
3 # ->
4 # ->
5 # ->
6 # ->
7 6 -> 6
8 # -> #
9 # -> #
10 # -> #
11 # -> #
12 # -> #

Please help.
__________ __ __

View Entire Topic
Bohdan
Active Contributor

Hi POOJA GUPTA,

Please try the following definition of search string. I tested the string with value "000000145745", seems to work:)

If it is not working for you, you can try to do a bit of debugging via setting break-point in FM BSPS_PATTERN_SEARCH.

Apart from proper configuration of search string, you should pay attention to bank statement uploading mode: if you've configured the mapping of search string to take into account business tranaction codes from line :86: (which assumes structured MT940 statement), but you upload the statement as unstructured, search string will not be triggered. See some explanation below:

yash99
Explorer
0 Kudos
Dear Sir,
yash99
Explorer
0 Kudos

I have assign 01 standard algorithm for Eternal transaction type NTRF. Now I want to use different 15 clear via assignment for external transaction type NTRF for some transaction with the bases of some hints. :61:2410011001CR15000,00NMSC000079//9863 000079 :86:CMS-F40UFMVQMC-20242564/BOD/LCT Based on 86 tag line I want create search string BOD/LCT Is unique In this cases When /BOD/LCT come in the statement I want to use algorithm 15 clear via assignment. 

i have created search string but it is not working.

WhatsApp Image 2024-10-11 at 12.10.22.jpegWhatsApp Image 2024-10-11 at 12.10.21.jpeg