Hierarchy
SAP_FIN (Software Component) SAP_FIN⤷
FIN-FSCM-CLM-CM-CM (Application Component) Basic Functions⤷
FTE (Package) Bank accounting: External payment information
IMG Activity
| ID | FI_BL_EBS_VC_T028P | Define Search String for Electronic Bank Statement |
| Transaction Code | S_ALR_87099795 | (empty) |
| Created on | 19990323 | |
| Customizing Attributes | ACC_BLEBS_K_U_A | Define Attributes for Planning Types per Bank Account |
| Customizing Activity | FIBLEBS_VC_T028P_OB | Define Search String for Document Numbers |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | FIBLEBS_VC_T028P_DC |
When importing an electronic bank statement, the system identifies the business transactions and uses the settings you have already made to determine how each should be recorded. In most cases, the system uses the document number entered in the "note to payee" lines of the bank statement to determine the appropriate clearing transaction. For example, a cash receipt clears customer open items.
The information in the note to payee may be incomplete - for example, the first characters in the document number may be cut off or new characters may be added. The interpretation algorithm then reaches the limits and cannot find the appropriate document numbers. This means the document cannot be cleared and you must post- process the transactions manually.
In addition to the search for clearing information, you can use the the search string to fill other fields (such as the cost center or posting rule, depending on the content of the note to payee.
It is the "Target Field" which determined which field is filled in each case. The target field in the bank data store indicates to where the result of the search is written. The target field must always be the note to payee when you are searching for clearing information (document number, reference document number. (Unlike other fields, it is not necessary to repeatedly change the note to payee field - the information in it is temporarily "enriched" while the intepretation algorithm is running.) The explanations and examples that follow all refer to the search for clearing information (meaning that the note to payee is the target field), but they can also be applied to most other fields (such as "Cost Center"; see the section on "Other Target Fields").
To increase the number of hits in the document number search, you can use this step to define strings for the search. The system uses this string to conduct the search before the interpretation algorithm comes into effect.
- Step one is to define the search string. The end of this section gives definitions of some special characters.
Having defined the search string, you must then define "mapping". Mapping is used, for example, to eliminate characters that customers have added to document numbers.
To illustrate which sign in the search string is assigned to which character in mapping, the example which follows gives vertical representations of the search strings and associated mapping. See the end of this section for definitions of some special characters. These characters cannot be entered in mapping.
In the example, the symbol "#" means any figure between 0 and 9. A blank in mapping causes the system to delete the respective item.
Example:
Search string Mapping
...
# -> #
. -> (Blank in mapping: '.' eliminate)
# -> #
# -> #
# -> #
...
So: you can assign a different character to each character in the search string (example: a blank to a period). If you are recreating a search string, the system first defaults the unchanged search string as mapping. You can then change the characters as you wish.
You can test the search strin in the detail screen for search string definition. To this end, enter any chain of characters you like, as it could appear in the "Note to payee" field in the bank statement, and choose Test. The system displays the search result.
- In the second step, you stipulate the note to payee for the search string.
You can define as many strings as you like per bank account and interpretation algorithm.
In addition, you can also enter a mapping basis and select the ID flag.
Notes
- You have to activate the strings before the system can use them in the document number search.
- Be sure to enter start and finish charactercs (' ', ^, $) in search strings to eliminate incorrecet hits.
Example: A string with no start and finishe characteristics is called "###". The number in the note to payee in the bank statement is 12345678. The sting search then finds no fewer than six hits in the note to payee, namely: 123, 234, 345, 456, 567, 678. This is not usually desirable because it may lead to a defective selection of items if the matching document numbers actually exist in the system.
Special Characters in Search Strings
Character Definition Example
| or a|b finds a or b
() Group c(ac|b)d finds cacd or cbd
+ Repetition (ab)+ finds, for example, ab or ababababab
* Repetition ab* finds a or ab or abbbbbbb
? Wild card a?b finds aQb or a1b
# Figures 0-9
\ Escape character \#\#\# finds ### and not,for example,
123 (looks for special characters)
^ Start of line
$ End of line
Special Characters in Mapping
Character Definition Example
' ' Blank Character is eliminated.
/ Slash See under Example 2
Example
Example 1
You enter search string (^| )###( |$) with Mapping ###.
The system searches for a document number which starts at the beginning of the line or with a blank, then has three figures and ends with a bland or at the end of the line.
You enter 18000000 as the mapping basis.
The system replaces the last three characters of the basis with 123 so that the searchy result is 18000123. The sysytem looks for document 18000123 to clear the open items.
Example 2
You specify search string (^| )#####/###/###( |$) with mapping #####/###/###.
The system searches for a document number consisting of five figures followed by two sets of three figures, all the sets being separated by "/". (Example: 80429/234/123). The "/" is of special significance in mapping: the chain of charactes is not interpreted as one document number, but as three. The three strings of charactes are separated and the last three in the first string replace by strings 2 and 3 respectively, giving three document numbers in the search result: 80429, 80234, and 80123. If you defined a mapping basis, it is now applied to the three numbers to bring them up to the number of characters required for the document number.
The system verifies that the first number is at least as long as the following. If it is shorter, the hit is rejected. No replacement is made.
You can also search for any other character used to separate document number in your bank statements. The character in question must be in the search string.
More Search String Examples
Search String Mapping Description
(^|)### ####($| ) ### #### 7 characters, blank at position 4
(^|)#(.|)######($| ) # ###### 7 characters, period/blank at pos.2
(|^)##############( |$) ####### 14 char. number, take first 7
(|^)############( |$) #### 12-char., take last 4
(|^)#+(/#+)+( |$) #/# Sequence, separated by slash
Requirements
Standard settings
Recommendation
Activities
Defining and Simulating Strings
Define string
- Double click in the tree Search string definition.
- Choose "New entries".
- Enter a search string name (example: STRING1), a description ("Five digit document number") and a search string (example: (^| )###.##( |$)),then choose Enter.
- In the Mapping area, assign a character to each character in your string.
The system proposes the unchanged search string as initial mapping. Change the characters as you want.
Test the string
- In the Test area, enter a text under Input text. The text must included&#
Business Attributes
| ASAP Roadmap ID | 204 | Establish Functions and Processes |
| Mandatory / Optional | 2 | Optional activity |
| Critical / Non-Critical | 2 | Non-critical |
| Country-Dependency | A | Valid for all countries |
Maintenance Objects
| Maintenance object type | C | Customizing Object |
| Assigned objects | ||||||
|---|---|---|---|---|---|---|
| Customizing Object | Object Type | Transaction Code | Sub-object | Do not Summarize | Skip Subset Dialog Box | Description for multiple selections |
| VC_T028P | C - View cluster | SM34 | 01 |
History
| Last changed by/on | SAP | 20000201 |
| SAP Release Created in |
