Ansicht
Dokumentation
T243G - Convert Sender G/L Accounts
Fill RESBD Structure from EBP Component Structure ROGBILLS - Synchronize billing plansThis documentation is copyright by SAP AG.
Convert a specific or general G/L account of the sender subsystem to the G/L account of the central system.
Convert a specific or general G/L account of the sender subsystem to the G/L account of the central system.
SAP recommends that you separate the G/L accounts of the sender systems from those of the central cash management system.
Before you convert the G/L accounts, you must have set up the company code reassignment. For more information, see Convert Company Codes.
You make the settings for converting the G/L accounts of the sender subsystems in the central cash management system. You also define the sender subsystem to which the conversion settings apply.
- Select G/L Accountin the Filter column.
- In the No. (Sort Number)column, enter the sort number. It's a unique sort number for a matching regular expression. For more information, see Sort Number.
- In the Regular Expression for Matchingcolumn, enter the regular expression.
- In the Regular Expression for Replacingcolumn, enter the regular expression.
All the G/L accounts 113450, 113451, 113452, 113453, 113454, 113455, 113456, 113457, and 113458 from the company code CC01 and the logic system QI3CLNT003 should be converted into 113450. Only the G/L account 113459 should be still be 113459. There should be no change for this account.
| G/L Account in Distributed Cash Management | New Account |
|---|---|
| QI3CLNT003CC010000113450 | 0000113450 |
| QI3CLNT003CC010000113451 | 0000113450 |
| QI3CLNT003CC010000113452 | 0000113450 |
| QI3CLNT003CC010000113453 | 0000113450 |
| QI3CLNT003CC010000113454 | 0000113450 |
| QI3CLNT003CC010000113455 | 0000113450 |
| QI3CLNT003CC010000113456 | 0000113450 |
| QI3CLNT003CC010000113457 | 0000113450 |
| QI3CLNT003CC010000113458 | 0000113450 |
| QI3CLNT003CC010000113459 | 0000113459 |
The following regular expressions work well in this case:
- Find: ^(QI3CLNT003CC01)(000011\d{3})[0-8]$
The symbol ^ marks the beginning of the string, and the symbol $ marks the end of the string. There should be two groups in the string. Each group is defined by the symbol (). The first group contains QI3CLNT003CC01, and the second group contains 000011 and 3 digits. Following these 2 groups, there is 1 digit in the range of 0-8.
Replace: $2$`0
The matched second group is unchanged. The tail digit is replaced by 0.
- Find: ^(.{10})(.{4})(000011\d{3})([0-8])$
From the beginning to the end of the string, there should be four groups. The first group contains 10 characters. The second group contains 4 characters. The third group contains 01000011 and 3 digits. The fourth group contains 1 digit in the range of 0-8.
Replace: $3$`0
The matched third group is unchanged. The tail digit is replaced by 0.
You can test the regular expressions manually by the program DEMO_REGEX_TOY. You can call up the transaction code SE38 to run the program and choose the Documentation on Regular Expressions button to get a basic syntax of regular expressions.
Regular expressions with POSIX syntax can be specified after an addition REGEX of statements or for the argument regex of built-in functions. Respective objects of the system classes CL_ABAP_REGEX and CL_ABAP_MATCHER can be created with the factory method CREATE_POSIX.
Using the POSIX syntax for single characters and character strings, regular expressions can be created that match whole character strings or substrings of character strings. The POSIX syntax for find and replace offers some additional elements that support the finding and replacement of substrings in character strings.
Proceed as follows:
- Select REGEX, not PCRE.
- Select REPLACE.
- Select ALL OCCURRENCE and IN TABLEfor testing multiple accounts for one regex.
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up RFUMSV00 - Advance Return for Tax on Sales/Purchases
This documentation is copyright by SAP AG.
Length: 5531 Date: 20240523 Time: 170121 sap01-206 ( 80 ms )
