SAP ABAP Class CL_FIN_AR_QUERY_CACHE (Cache for CPU-Intensive OLAP Queries (with COMMIT WORK))
Hierarchy
SAP_FIN (Software Component) SAP_FIN
   FI (Application Component) Financial Accounting
     FIN_APAR_HDB_LISTS (Package) Reports Based on SAP HANA DB Views
Properties
Class CL_FIN_AR_QUERY_CACHE  
Short Description Cache for CPU-Intensive OLAP Queries (with COMMIT WORK)    
Super Class    
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package FIN_APAR_HDB_LISTS   Reports Based on SAP HANA DB Views 
Created 20130402   SAP 
Last change 20131127   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
# Type group / Object type Type Type Description
1 ABAP Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
2 IF_FIN_SELECTION_TYPES Forward declaration interface (INTERFACE i DEFINITION DEF...  Forward declaration interface (INTERFACE i DEFINITION DEF...
3 RSDS Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
Interfaces
Class CL_FIN_AR_QUERY_CACHE has no interface implemented.
Friends
Class CL_FIN_AR_QUERY_CACHE has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 GC_60_SECONDS Constant Public Type reference (TYPE) INT4 60 60 Seconds = 1 Minute 20130517
2 GC_BADI_METH_DUE_CUST Constant Public Type reference (TYPE) SEOCPDNAME 'GET_DUE_CUSTOMER' Method Name in BAdI FIN_AR_DBSYS_OPT 20130517
3 GC_BADI_METH_DUNNING_CUST Constant Public Type reference (TYPE) SEOCPDNAME 'GET_DUNNING_CUSTOMER' Method Name in BAdI FIN_AR_DBSYS_OPT 20130517
4 GC_BADI_METH_DUN_LEVEL_STAT Constant Public Type reference (TYPE) SEOCPDNAME 'GET_DUN_LEVEL_STATISTIC' Method Name in BAdI FIN_AR_DBSYS_OPT 20130517
5 GC_BADI_METH_OVERDUE_CUST Constant Public Type reference (TYPE) SEOCPDNAME 'GET_OVERDUE_CUSTOMER' Method Name in BAdI FIN_AR_DBSYS_OPT 20130517
6 GC_BADI_METH_PAY_DIFF_STAT Constant Public Type reference (TYPE) SEOCPDNAME 'GET_PAY_DIFF_STATISTIC' Method Name in BAdI FIN_AR_DBSYS_OPT 20130517
7 GC_DEACTIVATE_ASYNC Constant Private Type reference (TYPE) FIN_AR_QRYCACHE_ASYNC_REFRESH 2147483647 Never Update Asynchronously 20130517
8 GC_DEFAULT_ASYNC_5_MIN Constant Public Type reference (TYPE) FIN_AR_QRYCACHE_ASYNC_REFRESH 300 Asynchronous Update After more than 5 Minutes 20130517
9 GC_DEFAULT_SYNC_10_MIN Constant Public Type reference (TYPE) FIN_AR_QRYCACHE_SYNC_REFRESH 600 Obsolete After 10 Minutes 20130517
10 GC_MAX_BUFFER_TIME_1_DAY Constant Public Type reference (TYPE) FIN_AR_QRYCACHE_SYNC_REFRESH 1440 Buffer Obsolete at the Latest After 1 Day 20130517
11 GC_RELID_ACC_RECEIVABLE Constant Public Type reference (TYPE) RELID 'AR' Cache for Debit-Side DB Queries 20130517
12 GC_UNITTEST_CLASS_NAME Constant Public Type reference (TYPE) PROGNAME 'LCL_FIN_AR_QUERY_CACHE' ABAP Program Name 20130517
13 MO_BADI_DBSYS_OPT Instance attribute Private Object reference (TYPE REF TO) FIN_APAR_HDB_DBSYS_OPT DB-specific reading of due date for net payment 20130517
14 MV_ASYNC_REFRESH_TIME Instance attribute Private Type reference (TYPE) FIN_AR_QRYCACHE_ASYNC_REFRESH Asynchronous Update After more than X Seconds 20130517
15 MV_PROGRAM_NAME Instance attribute Private Type reference (TYPE) PROGNAME ABAP Program to Which Data in Cache Relate 20130517
16 MV_SYNC_REFRESH_TIME Instance attribute Private Type reference (TYPE) FIN_AR_QRYCACHE_SYNC_REFRESH Seconds until a buffer entry is no longer used 20130517
Methods
# Method Level Visibility Method type Description Created on
1 CHECK_AND_ADJUST_CONFIG Static method Private Method Check configuration and set defaults 20130517
2 CONSTRUCTOR Instance method Public Constructor CONSTRUCTOR 20130517
3 GET_CACHE_CONFIG_IN_SECONDS Static method Public Method Determine Current Cache Configuration Being Used 20130517
4 GET_DUE_CUSTOMER Instance method Public Method Top n Customers with Highest Amount Due Soon 20130517
5 GET_DUNNING_CUSTOMER Instance method Public Method Top N Customers by Dunning Levels 20130517
6 GET_DUN_LEVEL_STATISTIC Instance method Public Method Dunned Amounts by Dunning Level (Dunning Pie Chart) 20130517
7 GET_OVERDUE_CUSTOMER Instance method Public Method Top N Customers with Highest Overdue Amount 20130517
8 GET_PAY_DIFF_STATISTIC Instance method Public Method Statistics: Customer Items by Payment Difference Reason Code 20130517
9 INSERT_BUFFER Static method Public Method Write query and result to the cache 20130517
10 READ_BUFFER Instance method Public Method Read Query and Result from the Cache 20130517
Events
Class CL_FIN_AR_QUERY_CACHE has no event.
Types
# Type Visibility Typing Associated Type Description Created on Type Source
1 GTY_S_DUE_CUST Public See coding Parameter for BAdI Method GET_DUE_CUSTOMER 20130517 BEGIN OF gty_s_due_cust, t_bukrs_range TYPE acc_t_ra_bukrs, t_kunnr_range TYPE fagl_range_t_kunnr, t_begru_kna1_range TYPE fin_t_brgru_range, t_begru_knb1_range TYPE fin_t_brgru_range, t_free_selections TYPE rsds_trange, keydate TYPE d, due_days TYPE i, num_rows TYPE i, END OF gty_s_due_cust
2 GTY_S_DUNNING_CUST Public See coding Parameter for BAdI Method GET_DUNNING_CUSTOMER 20130517 BEGIN OF gty_s_dunning_cust, t_bukrs_range TYPE acc_t_ra_bukrs, t_kunnr_range TYPE fagl_range_t_kunnr, t_begru_kna1_range TYPE fin_t_brgru_range, t_begru_knb1_range TYPE fin_t_brgru_range, t_manst_range TYPE fin_t_manst_range, t_free_selections TYPE rsds_trange, num_rows TYPE i, lean_select TYPE abap_bool, END OF gty_s_dunning_cust
3 GTY_S_DUN_LEVEL_STAT Public See coding Parameter for BAdI Method GET_DUN_LEVEL_STATISTIC 20130517 BEGIN OF gty_s_dun_level_stat, t_bukrs_range TYPE acc_t_ra_bukrs, t_manst_range TYPE fin_t_manst_range, t_free_selections TYPE rsds_trange, END OF gty_s_dun_level_stat
4 GTY_S_OVERDUE_CUST Public See coding Parameter for BAdI Method GET_OVERDUE_CUSTOMER 20130517 BEGIN OF gty_s_overdue_cust, t_bukrs_range TYPE acc_t_ra_bukrs, t_kunnr_range TYPE fagl_range_t_kunnr, t_begru_kna1_range TYPE fin_t_brgru_range, t_begru_knb1_range TYPE fin_t_brgru_range, t_free_selections TYPE rsds_trange, keydate_due TYPE allgstid, overdue_days TYPE i, num_rows TYPE i, lean_select TYPE abap_bool, END OF gty_s_overdue_cust
5 GTY_S_PAY_DIFF_STAT Public See coding Parameter for BAdI Method GET_PAY_DIFF_STATISTIC 20130517 BEGIN OF gty_s_pay_diff_stat, t_bukrs_range TYPE acc_t_ra_bukrs, t_kunnr_range TYPE fagl_range_t_kunnr, t_begru_kna1_range TYPE fin_t_brgru_range, t_begru_knb1_range TYPE fin_t_brgru_range, t_rstgr_range TYPE fin_t_rstgr_range, t_free_selections TYPE rsds_trange, num_rows TYPE i, lean_select TYPE abap_bool, END OF gty_s_pay_diff_stat
Method Signatures

Method CHECK_AND_ADJUST_CONFIG Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EV_ASYNC_REFRESH_TIME Call by reference Type reference (TYPE) FIN_AR_QRYCACHE_ASYNC_REFRESH Asynchrone Aktualisierung nach mehr als X Minuten 20130517
2 Exporting EV_SYNC_REFRESH_TIME Call by reference Type reference (TYPE) FIN_AR_QRYCACHE_SYNC_REFRESH Zeitdauer bis ein Puffereintrag nicht mehr verwendet wird 20130517
3 Importing IS_CACHE_CFG Call by reference Type reference (TYPE) FIN_AR_CACHE_CFG Cache für CPU-lastintensive Queries 20130517

Method CHECK_AND_ADJUST_CONFIG on class CL_FIN_AR_QUERY_CACHE has no exception.

Method CONSTRUCTOR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IO_BADI_DBSYS_OPT Call by reference Object reference (TYPE REF TO) FIN_APAR_HDB_DBSYS_OPT DB-spezifisches Lesen des Nettofälligkeitsviews 20130517
2 Importing I_PROGRAM_NAME Call by reference Type reference (TYPE) PROGNAME ABAP-Programm, dem die Daten im Cache gehören 20130517

Method CONSTRUCTOR on class CL_FIN_AR_QUERY_CACHE has no exception.

Method GET_CACHE_CONFIG_IN_SECONDS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EV_ASYNC_REFRESH_TIME Call by reference Type reference (TYPE) FIN_AR_QRYCACHE_ASYNC_REFRESH Zeitraum für asynchrone Aktualisierung des Cache 20130517
2 Exporting EV_SYNC_REFRESH_TIME Call by reference Type reference (TYPE) FIN_AR_QRYCACHE_SYNC_REFRESH Zeitraum für synchrone Aktualisierung des Cache 20130517

Method GET_CACHE_CONFIG_IN_SECONDS on class CL_FIN_AR_QUERY_CACHE has no exception.

Method GET_DUE_CUSTOMER Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_TOP_LIST Call by reference Type reference (TYPE) FIN_AR_T_OVERDUE_CUSTOMER Daten für das AR Dashboard: Top N Kunden (zukünftig fällig) 20130517
2 Importing IT_BEGRU_KNA1_RANGE Call by reference Type reference (TYPE) FIN_T_BRGRU_RANGE Range für Stammdaten-Berechtigungsgruppen im A-Segment 20130517
3 Importing IT_BEGRU_KNB1_RANGE Call by reference Type reference (TYPE) FIN_T_BRGRU_RANGE Range für Stammdaten-Berechtigungsgruppen im B-Segment 20130517
4 Importing IT_BUKRS_RANGE Call by reference Type reference (TYPE) ACC_T_RA_BUKRS Ranges Tabelle für Buchungskreise 20130517
5 Importing IT_FREE_SELECTIONS Call by reference Type reference (TYPE) RSDS_TRANGE Freie Abgrenzungen 20130517
6 Importing IT_KUNNR_RANGE Call by reference Type reference (TYPE) FAGL_RANGE_T_KUNNR Range-Tabelle für Debitoren 20130517
7 Importing I_BYPASS_BUFFER Call by reference Type reference (TYPE) ABAP_BOOL ' ' 'X' = ungepuffert lesen 20130517
8 Importing I_DUE_DAYS Call by reference Type reference (TYPE) I Fällig in n Tagen 20130517
9 Importing I_KEYDATE Call by reference Type reference (TYPE) D Stichtag 20130517
10 Importing I_ROWS Call by reference Type reference (TYPE) I Anzahl angeforderte Zeilen 20130517

Method GET_DUE_CUSTOMER on class CL_FIN_AR_QUERY_CACHE has no exception.

Method GET_DUNNING_CUSTOMER Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_TOP_LIST Call by reference Type reference (TYPE) STANDARD TABLE Daten fürs AR Dashboard: Top N Kunden nach Mahnstufe 20130517
2 Importing IT_BEGRU_KNA1_RANGE Call by reference Type reference (TYPE) FIN_T_BRGRU_RANGE Range für Stammdaten-Berechtigungsgruppen im A-Segment 20130517
3 Importing IT_BEGRU_KNB1_RANGE Call by reference Type reference (TYPE) FIN_T_BRGRU_RANGE Range für Stammdaten-Berechtigungsgruppen im B-Segment 20130517
4 Importing IT_BUKRS_RANGE Call by reference Type reference (TYPE) ACC_T_RA_BUKRS Ranges Tabelle für Buchungskreise 20130517
5 Importing IT_FREE_SELECTIONS Call by reference Type reference (TYPE) RSDS_TRANGE Freie Abgrenzungen 20130517
6 Importing IT_KUNNR_RANGE Call by reference Type reference (TYPE) FAGL_RANGE_T_KUNNR Range-Tabelle für Debitoren 20130517
7 Importing IT_MANST_RANGE Call by reference Type reference (TYPE) FIN_T_MANST_RANGE Range für Mahnstufen 20130517
8 Importing I_BYPASS_BUFFER Call by reference Type reference (TYPE) ABAP_BOOL ' ' 'X' = ungepuffert lesen 20130517
9 Importing I_LEAN_SELECT Call by reference Type reference (TYPE) ABAP_BOOL ' ' 'X' = Selektion in schmale Struktur 20130517
10 Importing I_ROWS Call by reference Type reference (TYPE) I Anzahl angeforderte Zeilen 20130517

Method GET_DUNNING_CUSTOMER on class CL_FIN_AR_QUERY_CACHE has no exception.

Method GET_DUN_LEVEL_STATISTIC Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_RESULT Call by reference Type reference (TYPE) STANDARD TABLE Daten fürs AR Dashboard: Statistik Mahnstufe 20130517
2 Importing IT_BUKRS_RANGE Call by reference Type reference (TYPE) ACC_T_RA_BUKRS Ranges Tabelle für Buchungskreise 20130517
3 Importing IT_FREE_SELECTIONS Call by reference Type reference (TYPE) RSDS_TRANGE Freie Abgrenzungen 20130517
4 Importing IT_MANST_RANGE Call by reference Type reference (TYPE) FIN_T_MANST_RANGE Range für Mahnstufen 20130517
5 Importing I_BYPASS_BUFFER Call by reference Type reference (TYPE) ABAP_BOOL ' ' 'X' = ungepuffert lesen 20130517

Method GET_DUN_LEVEL_STATISTIC on class CL_FIN_AR_QUERY_CACHE has no exception.

Method GET_OVERDUE_CUSTOMER Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_TOP_LIST Call by reference Type reference (TYPE) STANDARD TABLE Daten für das AR Dashboard: Top N Kunden (überfällig) 20130517
2 Importing IT_BEGRU_KNA1_RANGE Call by reference Type reference (TYPE) FIN_T_BRGRU_RANGE Range für Stammdaten-Berechtigungsgruppen im A-Segment 20130517
3 Importing IT_BEGRU_KNB1_RANGE Call by reference Type reference (TYPE) FIN_T_BRGRU_RANGE Range für Stammdaten-Berechtigungsgruppen im B-Segment 20130517
4 Importing IT_BUKRS_RANGE Call by reference Type reference (TYPE) ACC_T_RA_BUKRS Ranges Tabelle für Buchungskreise 20130517
5 Importing IT_FREE_SELECTIONS Call by reference Type reference (TYPE) RSDS_TRANGE Freie Abgrenzungen 20130517
6 Importing IT_KUNNR_RANGE Call by reference Type reference (TYPE) FAGL_RANGE_T_KUNNR Range-Tabelle für Debitoren 20130517
7 Importing I_BYPASS_BUFFER Call by reference Type reference (TYPE) ABAP_BOOL ' ' 'X' = ungepuffert lesen 20130517
8 Importing I_KEYDATE_DUE Call by reference Type reference (TYPE) D Fälligkeitsdatum der Posten 20130517
9 Importing I_LEAN_SELECT Call by reference Type reference (TYPE) ABAP_BOOL ' ' 'X' = Selektion in schmale Struktur 20130517
10 Importing I_OVERDUE_DAYS Call by reference Type reference (TYPE) I Anzahl Tage überfällig 20130517
11 Importing I_ROWS Call by reference Type reference (TYPE) I Anzahl angeforderte Zeilen 20130517

Method GET_OVERDUE_CUSTOMER on class CL_FIN_AR_QUERY_CACHE has no exception.

Method GET_PAY_DIFF_STATISTIC Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_TOP_LIST Call by reference Type reference (TYPE) STANDARD TABLE Daten fürs AR Dashboard: Top N Kunden nach Restegrund 20130517
2 Importing IT_BEGRU_KNA1_RANGE Call by reference Type reference (TYPE) FIN_T_BRGRU_RANGE Range für Stammdaten-Berechtigungsgruppen im A-Segment 20130517
3 Importing IT_BEGRU_KNB1_RANGE Call by reference Type reference (TYPE) FIN_T_BRGRU_RANGE Range für Stammdaten-Berechtigungsgruppen im B-Segment 20130517
4 Importing IT_BUKRS_RANGE Call by reference Type reference (TYPE) ACC_T_RA_BUKRS Ranges Tabelle für Buchungskreise 20130517
5 Importing IT_FREE_SELECTIONS Call by reference Type reference (TYPE) RSDS_TRANGE Freie Abgrenzungen 20130517
6 Importing IT_KUNNR_RANGE Call by reference Type reference (TYPE) FAGL_RANGE_T_KUNNR Range-Tabelle für Debitoren 20130517
7 Importing IT_RSTGR_RANGE Call by reference Type reference (TYPE) FIN_T_RSTGR_RANGE Range für Zahlungsdifferenzgründe 20130517
8 Importing I_BYPASS_BUFFER Call by reference Type reference (TYPE) ABAP_BOOL ' ' 'X' = ungepuffert lesen 20130517
9 Importing I_LEAN_SELECT Call by reference Type reference (TYPE) ABAP_BOOL ' ' 'X' = Selektion in schmale Struktur 20130517
10 Importing I_ROWS Call by reference Type reference (TYPE) I Anzahl angeforderte Zeilen 20130517

Method GET_PAY_DIFF_STATISTIC on class CL_FIN_AR_QUERY_CACHE has no exception.

Method INSERT_BUFFER Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IS_QUERY Call by reference Type reference (TYPE) ANY Importparameter für HDB_DBSYS_OPT BAdI Methode 20130517
2 Importing IT_QUERY_RESULT Call by reference Type reference (TYPE) STANDARD TABLE Tabelle mit dem Ergebnis der Query 20130517
3 Importing I_METHOD_NAME Call by reference Type reference (TYPE) FIN_AR_DBSYS_OPT_BADI_METHOD Methodenname im BAdI FIN_AR_DBSYS_OPT 20130517
4 Importing I_PROGNAME Call by reference Type reference (TYPE) PROGNAME ABAP-Programm, dem die Daten im Cache gehören 20130517
5 Importing I_QUERY_ID Call by reference Type reference (TYPE) FIN_AR_QUERY_HASH_VALUE Hashwert der Importparameter für HDB_DBSYS_OPT BAdI Methode 20130517
# Exception Resumable Description Created on
1 WRITE_CACHE_FAILED Fehler beim Schreiben in den Puffer 20130517

Method READ_BUFFER Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ES_QUERY Call by reference Type reference (TYPE) ANY Importparameter für HDB_DBSYS_OPT BAdI Methode 20130517
2 Exporting ET_QUERY_RESULT Call by reference Type reference (TYPE) STANDARD TABLE Tabelle mit dem Ergebnis der Query 20130517
3 Exporting E_LAST_REFRESH Call by reference Type reference (TYPE) TZNTSTMPL Zeitpunkt des letzten Refresh der gepufferten Query 20130517
4 Importing I_METHOD_NAME Call by reference Type reference (TYPE) FIN_AR_DBSYS_OPT_BADI_METHOD Methodenname im BAdI FIN_AR_DBSYS_OPT 20130517
5 Importing I_PROGNAME Call by reference Type reference (TYPE) PROGNAME ABAP-Programm, dem die Daten im Cache gehören 20130517
6 Importing I_QUERY_ID Call by reference Type reference (TYPE) FIN_AR_QUERY_HASH_VALUE Hashwert der Importparameter für HDB_DBSYS_OPT BAdI Methode 20130517
# Exception Resumable Description Created on
1 CODEPAGE_MISMATCH Liste mit anderer Codepage gespeichert 20130517
2 NOT_IN_BUFFER Query wurde im Puffer nicht gefunden; keine Daten 20130517
3 PROGNAME_MISMATCH Programmname stimmt nicht mit dem geforderten überein 20130517
4 QUERY_ID_NOT_FOUND Query Daten nicht lesbar 20130517
5 RESULT_OUTDATED Gepufferte Liste ist stark veraltet; Daten nicht nutzbar 20130517
6 RESULT_TYPE_MISMATCH Daten im Puffer haben eine andere Struktur als verlangt wird 20130517
History
Last changed by/on SAP  20131127 
SAP Release Created in