Ansicht
Dokumentation
BAPI_MDPROVIDER_GET_VARIABLES - Delivers a List of VARIABLES
Vendor Master (General Section) SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3upThis documentation is copyright by SAP AG.
This method returns a list of variables for a QUERY_CUBE (processing by 'Manual Entry').
The following information is returned for every variable:
CAT_NAM: Name of CATALOGS (InfoCubes) that the QUERY_CUBE belongs to
CUBE_NAM: Name of CUBE that the variable is used in
VAR_NAM: Variable name. Restricted by delimiter '['.
VAR_CAP: Short description of variables
VAR_UID: Variable GUID
VAR_ORDINAL: Sort sequence of variables in the query
VAR_TYPE: Type of variables. This field displays the object type represented by the variable as a placeholder. The field can have the following values:
,, ,,SAP_VAR_TYPE_MEMBER
,, ,,SAP_VAR_TYPE_HIERARCHY
,, ,,SAP_ VAR _TYPE_NUMERIC
,,
DATA_TYPE: ABAP data type of variables. This is either CHAR for types SAP_VAR_TYPE_MEMBER and SAP_VAR_TYPE_HIERARCHY, or FLTP for type AP_ VAR _TYPE_NUMERIC
CHR_MAX_LEN: Max. length of a variable value.
VAR_PROC_TYPE: Processing type of variable. On the MDPROVIDER BAPI, only variables with processing type 'Manual Entry' are returned. The value for this column is always _PROC_TYPE_USER_INPUT with 2.0
VAR_SELC_TYPE: Selection type for variables. This field displays whether the variable allows a single value, an interval or a complex selection of characteristic values. Possible values:
,,,,SAP_ VAR _SEL_TYPE_VALUE
,,,,SAP_ VAR _SEL_TYPE_INTERVAL
,,,,SAP_ VAR _SEL_TYPE_COMPLEX
,,,,
VAR_ENTRY_TYPE: Mandatory entry for variables. This column can have one of the following values:
,,,,
,,,, SAP_ VAR _INPUT_TYPE_OPTIONAL
,,,, SAP_ VAR _INPUT_TYPE_MANDATORY
,,,, SAP_ VAR _INPUT_TYPE_MANDATORY_NOT_INITIAL
REF_DIM: For variables of type SAP_VAR_TYPE_MEMBER; this field specifies which dimension values you can select from for the variables.
REF_HRY: For variables of type SAP_VAR_TYPE_MEMBER; this field specifies which hierarchy values you can select from for the variable.
DFLT_LOW: Proposed value for variables
DFLT_HIGH: Proposed value
DFLT_LOW_CAP: Text for proposed value
DFLT_HIGH_CAP: Text for proposed value
DSCRPTN: Long text for variables
The MDX Grammar has been enhanced with a SAP specific variable clause. This has the following general structure:
,,,,,,SELECT [
,,,,,,FROM [
,,,,,,WHERE [
,,,,,,[
,,,,,,[
,,,,,,,,|
,,,,,,,,|
,,,,,,,,,,|
,,,,|EXCLUDING,,
,,,,,,,,|
Example
,,1. This example sets a single value for the variable [ODBBRANC]
Select [DUYZ7E3E5GH2F0W4D7OGO6RKD].members on columns,
Non-empty [ODB_CUST].members on rows from [ODBOSCEN1/MKTBRANCH]
SAP VARIABLES [ODBBRANC] INCLUDING [ODB_BRANC].[CHEM]
,,2. This example excludes an individual variable
Select [DUYZ7E3E5GH2F0W4D7OGO6RKD].members on columns,
Non-empty [ODB_CUST].members on rows from [ODBOSCEN1/MKTBRANCH]
SAP VARIABLES [ODBBRANC] EXCLUDING [ODB_BRANC].[CHEM]
3. This example specifies an interval
Select [2M19UOW3BTEMXNZMHSSSEP631].members on columns, non-empty [0CALYEAR].members on rows from [ODBOSCEN1/MKTCUST]
SAP VARIABLES [ODBCUST] INCLUDING [ODB_CUST].[B01] : [ODB_CUST].[C05]
4. This example specifies a complex selection
Select [4G3SFZOHUNDFDZN137S0IQ425].members on columns, non-empty [ODB_BRANC].members on rows from [ODBOSCEN1/MKTPROD] SAP VARIABLES [ODBPROD] INCLUDING [ODB_PROD].[CP01230111] INCLUDING [ODB_PROD].[LP10101190] INCLUDING [ODB_PROD].[PP98010102]:[ODB_PROD].[PR48666001]
Notes
Further information
Parameters
CAT_NAMCUBE_NAM
RETURN
STATISTIC
VARIABLES
Exceptions
Function Group
RSOBCL_GUI_FRONTEND_SERVICES - Frontend Services BAL Application Log Documentation
This documentation is copyright by SAP AG.
Length: 5794 Date: 20240523 Time: 182737 sap01-206 ( 64 ms )