Scribd
Upload
154 views

Search String Basics: Scenario-1: Trading Partner Update in Inter-Company GL Account

This document discusses using search strings in SAP to update fields and posting rules based on text in bank statements. It provides examples of configuring search strings to: 1. Update a trading partner field for inter-company postings based on a bank account number in the statement text. 2. Identify different posting rules to use for interbank postings based on bank account numbers, to direct funds to different target accounts. 3. References for more information on SAP search string configuration.

Uploaded by

Kenisha Khatri
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
154 views

Search String Basics: Scenario-1: Trading Partner Update in Inter-Company GL Account

This document discusses using search strings in SAP to update fields and posting rules based on text in bank statements. It provides examples of configuring search strings to: 1. Update a trading partner field for inter-company postings based on a bank account number in the statement text. 2. Identify different posting rules to use for interbank postings based on bank account numbers, to direct funds to different target accounts. 3. References for more information on SAP search string configuration.

Uploaded by

Kenisha Khatri
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 6

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


o To ensure trading partner update in intercompany account we had validation, as trading partner is not
available at field status level.
o 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:

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
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 

 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

 http://help.sap.com/saphelp_46c/helpdata/es/af/0a242bc925d311b60f0060b03c2bff/content.htm
 http://help.sap.com/saphelp_46c/helpdata/en/6d/0cdf4b142e11d3963800a0c9426c73/content.htm
 http://scn.sap.com/message/6420687#6420687
 http://scn.sap.com/thread/1478026
 http://scn.sap.com/thread/1980335

You might also like