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
- 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
Go to search string use screen and give below values:
- Company code
- House bank and Account id
- External Transaction (Defined in EBS config.) - NCMZ & - sign
- Interpretation algorithm (Same algorithm which is given in Global settings for EBS configuration) used 000 in our case
- Select search string- BA_009888xxxx
- Target field- EBFKOA1 – BDC1 Account type
- Mapping prefix = 0 (For updating trading partner in First line of GL entry)
- Activate
- Target field- EBFNAM1 – BDC1 Field name
- Mapping prefix = BSEG-VBUND
- Activate
- Target field- EBFVAL1 – BDC1 Field Value
- Mapping prefix = JS1996 (Trading partner value to be updated in 1st line item)
- Activate
Go to search string use screen and give below values:
- Company code
- House bank and Account id
- External Transaction (Defined in EBS config.) - NCMZ & + sign
- Interpretation algorithm (Same algorithm which is given in Global settings for EBS configuration) used 000 in our case
- Select search string- BA_009888xxxx
- Target field- EBFKOA2 – BDC2 Account type
- Mapping prefix = 2 ((For updating trading partner in Second line of GL entry)
- Activate
- Target field- EBFNAM2 – BDC2 Field name
- Mapping prefix = BSEG-VBUND
- Activate
- Target field- EBFVAL2 – BDC2 Field Value
- Mapping prefix = JS1996 (Trading partner value to be updated in 2nd line item)
- 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
- 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)
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
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