Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

EBS Search Strings, algorithms, user exit: Find ref num & get to XBLNR

Hello Colleagues,

I have checked these and other forums, but have not found the information I need, so would be grateful for some help.

I am working with Electronic Bank Statements for the first time, and having some trouble. As a start, I am working with incoming payments and trying to extract the reference number from the "Note to Payee" so that we can match on XBLNR. This field contains all sorts of gibberish, but we do have a specified format on the invoice numbers. For example, the Note to Payee might contain:

---

I10IPKW35741 I10IPKW35740 I10IPKW35 739 I10IPKW35738 I10IPKW3573 7 I10IP KW35742 MAP SVERIGE AB BOX 55136 TRANSFER A MT SEK 200,789.68 ORIGINAL AMT SEK 200,789.68 EXCH. RATE SEK 0.4 206 1500 8311007131

---

I have set up the search string as

(I10|I11|I12)????#####

and the search string simulation correctly finds all the embedded references numbers:

I10IPKW35741

I10IPKW35740

I10IPKW35738

I10IPKW35741

I10IPKW35740

I10IPKW35738

Next, I tested the various algorithms against an existing bank statement using FEBSTS. (If I am testing using a bank statement that already cleared, will those documents still be found in the simulation?)

"000" executes the map correctly against the bank statement and returns the embedded invoice numbers, but does not return the related document to be cleared. However, I cannot see that "000" knows what field to key on.

"001", "015", "019", "021", and "121" do NOT return the embedded invoice numbers in the simulation.

Is there any way to make this work using search strings alone, or does the search string merely parse out the invoice numbers, and the rest of the processing must be done in the user exit FEB0001?

As a related question, what are the 900 series algorithms ("Customer-specific algorithm 901", etc.) and how are they managed or configured? Is that something my predecessors created in our implementation?

Thanks in advance.

Patricia

Not what you were looking for? View more on this topic or Ask a question