Show TOC

Export Parameter: VariablesLocate this document in the navigation structure

Export Parameter: Variables

Short text

Result: VARIABLES

Significance

The Variables export parameter returns VARIABLES as a result.

The parameter consists of a table with the following fields:

Name

Description

CAT_NAM

CATALOG name, to which the CUBE belongs

CUBE_NAM

Name of CUBE, to which the variable belongs

VAR_NAM

Variable technical name (including the separator '[')

VAR_CAP

Caption

VAR_UID

Unique ID (UUID) in compressed form, variable GUID

VAR_ORDINAL

General reference field for numerations; An ordinal number assigned to a variable in the group of variables for a CUBE.

VAR_TYPE

Variable type; this field corresponds to the VARIABLE_TYPE column of the SAP VARIABLES Schema-rowset The following values are possible:

  • SAP_VAR_TYPE_MEMBER
  • SAP_VAR_TYPE_HIERARCHY
  • SAP_VAR_TYPE_NUMERIC

You can find additional information fromBW Specific Enhancement: SAP VARIABLES schema-rowset .

DATA_TYPE

Data type in ABAP dictionary

  • char
    for SAP_VAR_TYPE_MEMBER and SAP_VAR_TYPE_HIERARCHY types
  • fltp
    for SAP_VAR_TYPE_NUMERIC type

CHR_MAX_LEN

Maximum length of a variable value in
charactersbytes
or

VAR_PROC_TYPE

Variable processing type; this field corresponds to the VARIABLE_PROCESSING_TYPE column of the SAP VARIABLES Schema-rowset

The value is always SAP_VAR_PROC_TYPE_USER_INPUT. Only variables with the "manual entry/default value" processing type are returned to the OLAP BAPI MDDataProvider BW.

You can find additional information fromBW Specific Enhancement: SAP VARIABLES schema-rowset .

VAR_SELC_TYPE

Variable selection type; this field corresponds to the VARIABLE_SELECTION_TYPE column of the SAP VARIABLES Schema-rowset The following values are possible:

  • SAP_ VAR _SEL_TYPE_VALUE
  • SAP_ VAR _SEL_TYPE_INTERVAL
  • SAP_ VAR _SEL_TYPE_COMPLEX

You can find additional information fromBW Specific Enhancement: SAP VARIABLES schema-rowset .

VAR_ENTRY_TYPE

Variable entry type; this field corresponds to the VARIABLE_ENTRY_TYPE column of the SAP VARIABLES Schema-rowset The following values are possible:

  • SAP_VAR_INPUT_TYPE_OPTIONAL
  • SAP_VAR_INPUT_TYPE_MANDATORY
  • SAP_VAR_INPUT_TYPE_MANDATORY_NOT_INITIAL

You can find additional information fromBW Specific Enhancement: SAP VARIABLES schema-rowset .

REF_DIM

Dimension unique name; this field corresponds to the REFERENCE_DIMENSION column of the SAP VARIABLES Schema rowset.

For variables having type SAP_VAR_TYPE_MEMBER, this field determines from which DIMENSION values for the variable can be selected.

REF_HRY

Hierarchy unique name; this field corresponds to the REFERENCE_HIERARCHY column of the SAP VARIABLES Schema rowset.

For variables having type SAP_VAR_TYPE_MEMBER, this field determines from which HIERARCHY values for the variable can be selected.

DFLT_LOW

Member unique name, default value for variable (if available)

DFLT_HIGH

Member unique name, default value for variable (if available)

DFLT_LOW_CAP

Description for default value for variable (if available)

DFLT_HIGH_CAP

Description for default value for variable (if available)

DSCRPTN

Variable description

You can find additional information about the individual parameter fields in the corresponding data element documentation in the ABAP Dictionary.