SAP RSZ_DB_QUERY_GET Function Module for Load Query

Search SAP Function Modules

RSZ_DB_QUERY_GET is a standard rsz db query get SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for Load Query processing and below is the pattern details for this FM, showing its interface including any import and export parameters, exceptions etc. there is also a full "cut and paste" ABAP pattern code example, along with implementation ABAP coding, documentation and contribution comments specific to this or related objects.

See here to view full function module documentation and code listing for rsz db query get FM, simply by entering the name RSZ_DB_QUERY_GET into the relevant SAP transaction such as SE37 or SE38.

Function Group: RZD1
Program Name: SAPLRZD1
Main Program: SAPLRZD1
Appliation area:
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:

Function RSZ_DB_QUERY_GET pattern details

In-order to call this FM within your sap programs, simply using the below ABAP pattern details to trigger the function call...or see the full ABAP code listing at the end of this article. You can simply cut and paste this code into your ABAP progrom as it is, including variable declarations.

CALL FUNCTION 'RSZ_DB_QUERY_GET'"Load Query
  EXPORTING
*  I_COMPUID = ' ' "
*  I_TH_ELTXREF =  "
*  I_TH_COMPDIR =  "
*  I_TH_COMPIC =  "
*  I_TH_SELECT =  "
*  I_TH_RANGE =  "
*  I_TH_CALC =  "
*  I_TH_CEL =  "
*  I_TH_GLOBV =  "
*  I_OBJVERS = RS_C_OBJVERS-ACTIVE "
*  I_USE_XREF_BUFFER =  "Boolean
*  I_CHECK_MODE =  "Boolean
*  I_TH_ELTDIR =  "
*  I_TH_ELTTXT =  "
*  I_TH_ELTPROP =  "
*  I_TH_ELTPRIO =  "
*  I_TH_ELTATTR =  "

 IMPORTING
   E_COMPUID =  "UUID in Compressed Form
   E_TH_MAP =  "
   E_SUBRC =  "Return Value, Return Value After ABAP Statements
   E_T_PRPTYS =  "Transport structure for query-based properties
   E_T_DIM =  "Catalog of the dimensions
   E_T_ATR =  "BRAIN Interface: Attributes->IObj relationship
   E_T_MEM =  "Catalog of the members of different dimensions
   E_T_CEL =  "Cell properties
   E_T_CON =  "Catalog of Conditions and Exceptions
   E_T_FAC =  "Catalog of Parts of Conditions and Exceptions

.

IMPORTING Parameters details for RSZ_DB_QUERY_GET

I_COMPUID -

Data type: RSZ_UID
Default: SPACE
Optional: Yes
Call by Reference: No ( called with pass by value option)

I_TH_ELTXREF -

Data type: RZD1_TH_ELTXREF
Optional: Yes
Call by Reference: Yes

I_TH_COMPDIR -

Data type: RZD1_TH_COMPDIR
Optional: Yes
Call by Reference: Yes

I_TH_COMPIC -

Data type: RZD1_TH_COMPIC
Optional: Yes
Call by Reference: Yes

I_TH_SELECT -

Data type: RZD1_TH_SELECT
Optional: Yes
Call by Reference: Yes

I_TH_RANGE -

Data type: RZD1_TH_RANGE
Optional: Yes
Call by Reference: Yes

I_TH_CALC -

Data type: RZD1_TH_CALC
Optional: Yes
Call by Reference: Yes

I_TH_CEL -

Data type: RZD1_TH_CEL
Optional: Yes
Call by Reference: Yes

I_TH_GLOBV -

Data type: RZD1_TH_GLOBV
Optional: Yes
Call by Reference: Yes

I_OBJVERS -

Data type: RS_OBJVERS
Default: RS_C_OBJVERS-ACTIVE
Optional: Yes
Call by Reference: No ( called with pass by value option)

I_USE_XREF_BUFFER - Boolean

Data type: RS_BOOL
Optional: Yes
Call by Reference: No ( called with pass by value option)

I_CHECK_MODE - Boolean

Data type: RS_BOOL
Optional: Yes
Call by Reference: No ( called with pass by value option)

I_TH_ELTDIR -

Data type: RZD1_TH_ELTDIR
Optional: Yes
Call by Reference: Yes

I_TH_ELTTXT -

Data type: RZD1_TH_ELTTXT
Optional: Yes
Call by Reference: Yes

I_TH_ELTPROP -

Data type: RZD1_TH_ELTPROP
Optional: Yes
Call by Reference: Yes

I_TH_ELTPRIO -

Data type: RZD1_TH_ELTPRIO
Optional: Yes
Call by Reference: Yes

I_TH_ELTATTR -

Data type: RZD1_TH_ELTATTR
Optional: Yes
Call by Reference: Yes

EXPORTING Parameters details for RSZ_DB_QUERY_GET

E_COMPUID - UUID in Compressed Form

Data type: RSZCOMPDIR-COMPUID
Optional: No
Call by Reference: No ( called with pass by value option)

E_TH_MAP -

Data type: RZD1_TH_MAP
Optional: No
Call by Reference: Yes

E_SUBRC - Return Value, Return Value After ABAP Statements

Data type: SY-SUBRC
Optional: No
Call by Reference: No ( called with pass by value option)

E_T_PRPTYS - Transport structure for query-based properties

Data type: RRX1_T_PRPTYS
Optional: No
Call by Reference: Yes

E_T_DIM - Catalog of the dimensions

Data type: RRX1_T_DIM
Optional: No
Call by Reference: Yes

E_T_ATR - BRAIN Interface: Attributes->IObj relationship

Data type: RRX1_T_ATR
Optional: No
Call by Reference: Yes

E_T_MEM - Catalog of the members of different dimensions

Data type: RRX1_T_MEM
Optional: No
Call by Reference: Yes

E_T_CEL - Cell properties

Data type: RRX1_T_CEL
Optional: No
Call by Reference: Yes

E_T_CON - Catalog of Conditions and Exceptions

Data type: RRX1_T_CON
Optional: No
Call by Reference: Yes

E_T_FAC - Catalog of Parts of Conditions and Exceptions

Data type: RRX1_T_FAC
Optional: No
Call by Reference: Yes

Copy and paste ABAP code example for RSZ_DB_QUERY_GET Function Module

The ABAP code below is a full code listing to execute function module POPUP_TO_CONFIRM including all data declarations. The code uses the original data declarations rather than the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the newer method of declaring data variables on the fly. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8), which i why i have stuck to the origianl for this example.

ABAP code using 7.40 inline data declarations to call FM RSZ_DB_QUERY_GET

The below ABAP code uses the newer in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. Please note some of the newer syntax below, such as the @DATA is not available until 4.70 EHP 8.

Search for further information about these or an SAP related objects