cancel
Showing results for 
Search instead for 
Did you mean: 

Search Strings bank statement: reference field

Former Member
0 Kudos

Hi,

I am just trying to look for any invoice reference in the note a payee of the bank statement. As all the invoices have 5 digits I have inlcuded as search string parameter like #####. The program finds what I am looking for (perfect), but also is taking into account other numbers in the note a payee without 5 digits and it is also trying to clear them. Any idea?

Example:

CREDIT/ID//REMI/50312+50311+50313+50337+50362/ISDT/00000000/ULTD//NAME//ID//ULTB//NAME//ID/ /PURP//PRTRY//OCMT/EUR57278,54/EXCH/1.0000000

The program is finding 50312, 50311, etc (5 strings) but also is looking for references in the invoices numbers like "54" or "1". Any idea? Please let me know.

Regards,

Daniel

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

I finally solve it with the refrence range in the FF_5.

regards,

daniel

former_member198032
Active Contributor
0 Kudos

Hi Daniel,



review your configuration of search string. Use transactions below for configure and testing.

You may need to create a separated search strings.

If you use prefixed number like 50###?


T-code FEBSTS - search string simulation

T-code OTPM - set search string algorithm

Look documentation again that says about start and finishes of search:

Define Search String for Electronic Bank Statement - Bank Accounting - SAP Library

Hope could be helpful.

Regards,

Cristiano