Usage of Search String

[Former Member]

Hello SAP Gurus,

I have a requirement where my client wants to use Search String to identify Customer and post payment to the customer.

ie The EBS file from Bank statement will contain words for a specific customer (its not a Customer Name). Upon identifying the search string, payment should be credited to Customer account. This is not a clear entry and just a post entry.

Posting rule is as follows:

Post rule Z999

Posting area 2

Debit Pstg Key 40

Acct symbol Z-CASH MAIN

Cr Pstg Key 15

Cr Acct Symbol Left blank (to search for customer)

Doc Type DZ

Posting Type 3 (Post Credit entry to subledger)

I have already configured the search string. However, when I am trying to define usage, I use BDC field name1, BDC value name1, BDC Account Type 1 for the search string but my attempts are in vain:

I tried BDC Account Type 1 "D"

BDC field name1 "KNB1-KUNNR"

BDC value name1, 400020 where 400020 is Customer Number (Customer code in sap).

Can anyone please point out where have I gone wrong. Also, would like to know how to change to this posting rule Z999 for an external transaction (say 175) whenever this search string is encountered for the specific customer.

Appreciate your response to this mail.

Thanks in advance.

NK

Edited by: Narayanan Kasthuri on Nov 24, 2010 5:06 PM

[former_member581688]

For search string usage, the valid values for the BDC account type field are:

0: First line, posting area 1

1: First line, posting area 2

2: Second line, posting area 1

3: Second line, posting area 2

In your case, I think you're going to want Account type = 3.

For the field name, it should be the screen field where the value needs to be populated. For posting rules that are post only, not clear, SAP uses transaction FB01. The field in FB01 where account number is entered is RF05A-NEWKO.

You may also need to add leading zeros to the customer number so it's a total of 10 digits - 0000400020.

To assign Z999, just set up another entry for the search string with Posting Rule for the target field and assign Z999. If you're on a later version of SAP, you can specify an external transaction in the usage entry.

Regards,

Shannon

[Former Member]

Shannon,

Thanks for your response. I did try as you suggested, and have my Account Type as 3 and changed the BDC field name. But now, when I test, I get the message that "Field BSEG-HKONT is not an input field". What I would like to know is whether we can make system to post to customer or is it not possible.

One more thing I didnt understand is that the error is pointing towards the GL account ie it says GL account is not an input field but it is an input field. So I am not sure what error the message it is referring to.

Please share your inputs if any.

Thanks in advance,

NK

[former_member581688]

Would you please post the search string use entries as you currently have them set up?

Regards,

Shannon

[Former Member]

Shanon,

Sorry for the belated reply. Please fiind the usage of search string entries as configured in the system now:-

Cocd HouseBk Acct ID External T.Type +/- Interpretation Srch strng name Target field Act Mapping Prefix

4160 SCB SCB (Blank) Positive No Iinterpretation 1000_NS_400020 BDC Acct Type1 (Activated) 3

4160 SCB SCB (Blank) Positive No Interpretation 1000_NS_400020 BDC Field Name 1 (Activated) RF05A-NEWKO

4160 SCB SCB (Blank) Positive No Interpretation 1000_NS_400020 BDC Field Value1 (Activated) 0004000020

And this does not work and as mentioned before the error message appears.

Also the posting rule configured is as follows:

Post rule Post Area Post key Acct symbol Cr.Pst key Cr. Acct Doc Type Posting Type

MI23 2 40 Z-CASH-MAIN 15 Blank DZ 3

[Former Member]

Shanon,

Can you please respond with a feedback on my search string. Awaiting eagerly.

Thanks in advance,

NK

[former_member581688]

Sorry for not responding sooner.... I'm not seeing anything obvious with the search string set up that would be causing the error. Do you have the same interpretation algorithm on the external transaction mapping (in the Global EBS config) as the search string usage? A different interpretation algorithm would cause the search string to not be called.

Regards,

Shannon

[shanid_mp]

Hi Narayanan,

I am getting the same error.

"Field BSEG-HKONT is not an input field"

Did you get any solution on this?

Regards

Shanu

[Former Member]

HI,

I tried to replicate the 'Search String Use' configuration but haven't been able to update the BSEG-SGTXT with the desired text from the search string (it fetches some number which concatenated with some fixed text becomes the value for the BSEG-SGTXT). Below are the details.

Co. Code; House Bank; ACCT ID; External Transaction; Search String;Target Field; Mapping Prefix

0158; BOAUK; GBP; 169; 0183 - TEST1; BDC Account Type 1; 1

0158; BOAUK; GBP; 169; 0183 - TEST1; BDC Account Name 1; BSEG-SGTXT

0158; BOAUK; GBP; 169; 0183 - TEST1; BDC Account Value 1;

Even after this configuration, the text field BSEG-SGTXT field is not getting updated though the document is getting posted.

Please let me know if there is any trouble with the configuration.

Regards

Sourabh