SAP BLOG Switzerland: Search Strategies Relevant for Interpretation Algorithm 800

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,366
Tepki puanı
7
Puanları
6
283164_Data_Mining_2_R_purple.png


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):

2-38.png


Prepare ISR Procedure (101870):

3-34.png


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


4-36.png


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.

5-32.png


First, determine your work area – in this case, it is Interpretation Algorithm 800.

6-30.png


Optimize the priority order of the search strategies in the Search Priority Maintenance View.

7-26.png




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.

Okumaya devam et...
 
Üst