Skip to Content

Search String for EBS (Electronics bank statement)

 

Author: N.K. Patel

Thanks to:

My Colleagues Farooq and Rafae for their valuable inputs

 

 

Search string basics

  • It works only on note to payee line items of EBS statement e.g. Line 86 for MT940 format
  • While defining search string leave, mapping field blank if you are using BDC fields
  • It is preferable to use external transaction when using BDC fields as in some cases entry doesn’t process by system automatically and we need to do post processing.

   

Scenario-1: Trading partner update in Inter company GL account

  • To ensure trading partner update in intercompany account we had validation, as trading partner is not available at field status level.
  • We can’t use substitution as we have user updating different trading partner. We had only one trading partner to be updated for posting thru EBS, so we decide to use search string option.

Update trading partner filed using search string configuration

1.JPG

  • Create search string name “BA_009888xxxx” (you can give any name) and in the search string field give below string.
  • 009888xxxx
  • Delete all mapping values from target field (this you can see in Mapping tab) and save

2.JPG

Go to search string use screen and give below values:

  1. Company code
  2. House bank and Account id
  3. External Transaction (Defined in EBS config.) – NCMZ &sign 
  4. Interpretation algorithm (Same algorithm which is given in Global settings for EBS configuration) used 000 in our case
  5. Select search string- BA_009888xxxx
  6. Target field- EBFKOA1 – BDC1 Account type
  7. Mapping prefix = 0 (For updating trading partner in First line of GL entry)
  8. Activate
  9. Target field- EBFNAM1 – BDC1 Field name
  10. Mapping prefix = BSEG-VBUND 
  11. Activate
  12. Target field- EBFVAL1 – BDC1 Field Value
  13. Mapping prefix = JS1996 (Trading partner value to be updated in 1st line item)
  14. Activate

3.JPG

Go to search string use screen and give below values:

  1. Company code 
  2. House bank and Account id
  3. External Transaction (Defined in EBS config.) – NCMZ & + sign 
  4. Interpretation algorithm (Same algorithm which is given in Global settings for EBS configuration) used 000 in our case
  5. Select search string- BA_009888xxxx
  6. Target field- EBFKOA2 – BDC2 Account type
  7. Mapping prefix = 2 ((For updating trading partner in Second line of GL entry)
  8. Activate
  9. Target field- EBFNAM2 – BDC2 Field name
  10. Mapping prefix = BSEG-VBUND 
  11. Activate
  12. Target field- EBFVAL2 – BDC2 Field Value
  13. Mapping prefix = JS1996 (Trading partner value to be updated in 2nd  line item)
  14. Activate

Sample file used

:20:1205210436049763

:21:1205210436049763

:25:960001xxxx

:28C:1/1

:60F:C110928USD0,

:61:1205210711CD1265,NCMZ00098883788//IA009995999063

:86:CONTROLLED DISBURSEMENT VAN WERT FUNDING FROM 009888xxxx

:61:1205210711DD1265,NCMZ00098883788//IA009995999063

:86:CONTROLLED DISBURSEMENT VAN WERT FUNDING FROM 009888xxxx

:62F:C120521USD0,

:64:C120521USD0,

:65:C120521USD0

 
 

Scenario-2: Alternative posting rule for Interbank posting

We have several main accounts which transfer or get fund from one funding account, so we decide to use search string, to identify Account no in note to payee ( item 86 for MT940 format) and based on that system will identify posting rule to be used (each posting rule have same funding account but different main account as contra account)

Drawback of this approach:

  • Need to create at least one search string and posting rule for each contra main account

Configuration of EBS Posting rule

  • Changed existing posting rule 10 and removed /CONTR-DIS-DB (assigned to 11131200 account) from both rules to avoid direct posting by this rule
  • Crated new rule /016 by copying earlier rule /010 and assigned /CONTR-DIS-DB to Debit side in Rule 16 

7.JPG

  • Assigned new rule /016 to search strings created

Posting rule change using search string configuration

  • Create search string name “BA_RULE” (you can give any name) and in the search string field give  string: 00000009888xxxx
  • Delete all mapping values from target field (this you can see in Mapping tab) and specify /016 (New rule created that will be used in place of Rule /010 specified in configuration)

8.JPG

Go to search string use screen and give below values:

  • Company code: 1101
  • House bank : WFCON and Account id: DISTR (960001xxxx corresponds to house bank WFCON)
  • External Transaction- NMSC & + sign as per requirement
  • Interpretation algorithm (Same algorithm which is given in Global settings for EBS configuration)
  • Select search string- BA_RULE
  • Target field – EBVGINT posting rule
  • Tick to Activate
  • Mapping prefix- Leave it Blank

9.JPG

Sample EBS file (MT940 format) used

:20:1205030533107242

:21:1205030533107242

:25:960001xxxx

:28C:13/1

:60F:C111102USD0,

:61:1111021102CD1000,00NMSC0009888xxxx//IA009995999089

:86:CONTROLLED DISBURSEMENT VAN WERT FUNDING FROM 00000009888xxxx

:61:1111021102DD700,00NTRF00000375770//IA008589037385

:61:1111021102DD300,00NCHK00000376182//IA008524589028

:62F:C120503USD0,

:64:C120503USD0,

:65:C120503USD0,

 
 

References

Disclaimer:

The knowledge sharing is based on my personal experience, Author is not responsible in any manner for any error or omission, users are requested to refer SAP documentation before taking decision for their project

To report this post you need to login first.

18 Comments

You must be Logged on to comment or reply to a post.

    1. NITESH PATEL Post author

      Thanks Lakshmi

       

      To make blogs Improve in quality and save others time, Appreciate if you can “Rate” every Blog you like.

      We all like Movies with Good rating

      (0) 
  1. Stefan Upmeier zu Belzen

    Hi Nitesch!


    Great work! This helps to avoid using the user exit ZXF01U01 in many cases.

     

    Remark on customizing for Scenario-2:

     

    As you write a little bit hidden: It only works with the same alogorithm as in the assignment of the EBS to posting rules:

     

    Interpretation algorithm (Same algorithm which is given in Global settings for EBS configuration)


    In case this does not work: Try it with 999 “all interpreation algorithm” instead of the 0 “no interpreation algorithm” as in the example.

     

    Best regards

     

    Stefan

    (0) 
    1. NITESH PATEL Post author

      Hi Stefan,

       

      Thanks for your Kind words and Rating

      I agree that Algorithm column is bit small. Don’t have that system so can’t edit blog.

      In future will take care.

       

      Warm Regards,

       

      Nitesh

      (0) 
    1. NITESH PATEL Post author

      Thanks Sam

       

      To make blogs Improve in quality and save others time, Appreciate if you can “Rate” every Blog you like.

      (0) 
  2. Sadhana degaonkar

    Hi Nitesh,

     

    Great Document.   I was trying to use this functionality but did not know how to go about it.  We use MULTICASH format and not the format that you have used in your example.

     

    Will try to fit in my MULTICASH scenario in this.  I want to  pass on text supplied by bank in BRS to line item text in the GL.  Lets hope I succed in this.

     

    Regards,

     

    Sadhana

    (0) 
  3. Zatopek Ondrej

    Dear Nitesh,

     

    many thanks for sharing this. It helped me really. I did not realize that you can fill in any field (even Z fields) in a document from a bank statement using search strings. I  am having a struggle, however. I would like to ask you, whether it is possible to pick values to be filled in dynamically? Let me explain on an example:

    I have a Z field “csh flow code” which is filled with values CF## (# representing numbers). Now my search string is as follow:

     

    In note to payee there is this text: example invoice CF12text text text. The search string identifies CF12 as CF## which is correct. No I would need to tell the SAP to fill the field ZZ_FI_CF with the value found in note-to-payee. What works is this:

     

    It means I have to specify every single cash flow code with one search string. So is it possible to somehow set up the search string so that it fills any value that represents this masking CF##??

     

    Thanks a lot.

     

    Regards,

     

    Ondrej

    (0) 
    1. Zatopek Ondrej

      Hi Sangarsh,

       

      yes I was. You need to create two search strings with the same values but different mapping as per the screenshot below:

      So the first search string has no mapping and it is a reference to the field you want to populate and the second one has the mapping you want to achieve.

       

      Regards,

       

      Ondrej

      (0) 
  4. Zorzonel Andreea

     

    Hi Nitesh,

     

    Great Document.  I was trying to use this functionality but did not know how to go about it.  We use MT940 format too. Is there a way to identify receipts by customer name in the note to payee field on the bank statement?

    Regards,

     

    Andreea

    (0) 

Leave a Reply