Enterprise Resource Planning Blogs by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
Michal_Pandoscak
Product and Topic Expert
Product and Topic Expert
2,422


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.