When you import a bank statement, the open items are searched for in the system using the interpretation algorithm 800 (for Switzerland and Lichtenstein) based on the ISR or QR Reference. These open items can then be cleared.
Expected content in the memo line (FEBRE) is:
For QR procedure: |
- For QRR reference
- String starting with ‘QR-IBAN’ + QR-IBAN number
- String starting with ‘QRR’ + 27 digits for QR reference
- For SCOR reference
- String starting with ‘QR-IBAN’ + standard IBAN number
- String starting with ‘SCOR’ + reference based on the ISO… (RF + up to 23 digits)
- For NON
- String starting with ‘QR-IBAN’ + normal IBAN number
|
For ISR procedure: |
- ISR reference
- String starting with ‘ISRPNO’ + ISR number
- String starting with ‘ISRReference’ + ISR reference number (27 digits)
|
The determination rules can be defined in the following configuration steps (SSCUIs):
- Define Control Data for QR-Bill (103321) for QR-bill procedure (view V_CH_QR_T049Q for SAP S/4HANA onPremise)
- Prepare ISR Procedure (101870) for ISR procedure (view V_T049E for SAP S/4HANA onPremise)
The main parameter of the rule is to define the offset and the length of the document and customer number. This information is transferred to the search strategies together with the whole reference.
Define Control Data for QR-Bill (103321):
Prepare ISR Procedure (101870):
Information from the ISR/QR reference is identified as follows:
Reference: 00000000001111119999999999X
Customer Number offset: 10
Customer Number length: 6
Document Number offset: 16
Document Number length: 10
Check digit: X
These values are then used by the search strategy to identify the proper open items.
Search Strategies
Search strategies contain the logic for searching for open items (based on values like Journal Entry, Customer Number, etc.). Each search strategy is implemented by a function module (e.g. “IDFI_S_STR_1”). It is also possible to use more search strategies and define the priority order.
Multiple search strategies are available because the generation of the ISR/QR reference does not always directly identify a document posted in an SAP system but can also contain references generated in an external system.
Examples of possible fields, which can be used as reference:
- Document Number (BSEG-BELNR)
- Partial information from the reference
- Payment reference (BSEG-KIDNO)
- Full length of the reference or partial information from the reference
- Document Reference (BKPF-XBLNR)
- Partial information from the reference
- Advice number
- Partial information from the reference
- Business Partner Reference Key (BSEG-XREF1)
- Partial information from the reference
Search strategies used for Switzerland and Lichtenstein
For Finance:
IDFI_S_STR_2
Requires: |
Customer number to be part of the reference |
Selects Open Item based on: |
Customer number (BSEG-KUNNR) |
Payment reference (BSEG-KIDNO) containing the full length of the ISR/QR reference |
IDFI_S_STR_3
Requires: |
Advice number to be part of the reference. |
Selects Open Item based on: |
Advice number |
- ISR procedure:
- The Advice number always starts with ‘08’ followed by 8 characters
- Concatenation of these values forms the proper payment advice number
- The rule must define the document length of 8 characters
- QR procedure:
- As opposed to the ISR procedure, the whole advice number can be defined with the rule
- The usual document length is 10
IDFI_S_STR_4
Requires: |
Customer and document number to be part of the reference |
Selects Open Item based on: |
Customer number (BSEG-KUNNR) |
Document number (BSEG-BELNR) |
IDFI_S_STR_5
Requires: |
Document number to be part of the reference |
Selects Open Item based on: |
Document number (BSEG-BELNR) |
IDFI_S_STR_6
Requires: |
Customer and document number to be part of the reference |
Selects Open Item based on: |
Customer number (BSEG-KUNNR) |
Reference document number (BKPF-XBLNR)
Note: In this case, the Reference Document Number corresponds to/contains the same value as the Document Number. |
IDFI_S_STR_7
Requires: |
Document number to be part of the reference |
Selects Open Items which are Customer Down Payment Request based on: |
Reference document number (BKPF-XBLNR)
Note: In this case, the Reference Document Number corresponds to/contains the same value as the Document Number. |
IDFI_S_STR_10
Requires: |
Document number to be part of the reference |
Selects Open Item based on: |
Customer number (BSEG-KUNNR) |
Reference document number (BKPF-XBELNR)
With leading zeroes = 000000010
or
Without leading zeroes = 10 |
IDFI_S_STR_11
Requires: |
Document number to be part of the reference |
Selects Open Item which are Down Payments based on: |
Reference document number (BKPF-XBELNR)
With leading zeroes = 000000010
or
Without leading zeroes = 10 |
For Real Estate:
IDFI_S_STR_1
Requires: |
Customer and document number to be part of the reference |
Selects the oldest document based on: |
Customer number |
Business partner reference key |
Open Items are matched when the total amount is the same as in the bank statement. |
IDFI_S_STR_8
Requires: |
Customer and document number to be part of the reference |
Selects the oldest document based on: |
Customer number |
Business partner reference key |
Search strategy intends to match the oldest open item based on the search criteria. |
IDFI_S_STR_9
Requires: |
Customer and document number to be part of the reference |
Selects the oldest document based on: |
Customer number |
Business partner reference key |
Search strategy intends to match one of the oldest open item based on the search criteria that match the amount coming from the bank statement. |
Defining Search Priorities
After the data in the bank statement has been imported, the system searches for the open items in the system and matches them to the imported payment data for further processing, which is posting and clearing activities. The search for these open items can be optimized using interpretation algorithm 800, by defining search strategies and setting the priority order of the search strategies in the
Define Search Priorities (101280) configuration step in the Configure Your Solution app
.
First, determine your work area – in this case, it is Interpretation Algorithm 800.
Optimize the priority order of the search strategies in the
Search Priority Maintenance View.
Read more about QR-Bill in our blogs:
QR-Bill in SAP S/4HANA and
QR-Bill in SAP S/4HANA Cloud.
Do you have any further comments regarding this topic? Do not hesitate to share them in the comment section below. You are also welcome to ask any questions about SAP S4/HANA Finance in the Community Q&A section.