P_MKT_BIMCVARIABLETBLFUNC

21 Fields 3 CDS Views

P_MKT_BIMCVARIABLETBLFUNC is an SAP database table in S/4HANA. It contains 21 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
CUAN_PM_DS_PA_T view left_outer Data Parameter Description (Runtime)
CUAN_PM_SCN_P_T view left_outer Predictive Scenario Parameter Description (Runtime)
I_MKT_BIMCVariable view from BASIC CDS: BIMC Variables

Fields (21)

KeyField CDS FieldsUsed in Views
KEY catalog_name BIMCCatalog 1
KEY cube_name BIMCCube 1
KEY variable_name BIMCVariable 1
column_sql_type BIMCColumnQueryType 1
column_type BIMCColumnType 1
column_type_d BIMCColumnTypeDimn 1
default_value BIMCDefaultValue 1
desc_attribute BIMCDescriptionAttribute 1
description BIMCVariableDescription,text 3
is_expression BIMCIsExpression 1
mandatory BIMCIsMandatory 1
multiline BIMCMultiLine 1
order_nr BIMCAttribSortingNmbr 1
path_name BIMCPath 1
placeholder_name BIMCPlaceholder 1
range_defaults_exist BIMCHasRangeDefault 1
selection_type BIMCSelectionType 1
semantic_type BIMCSemanticType 1
value_attribute BIMCValueAttribute 1
value_entity BIMCValueEntity 1
value_type BIMCValueType 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MKT_BIMCVARIABLETBLFUNC (
    CATALOG_NAME,
    CUBE_NAME,
    VARIABLE_NAME,
    COLUMN_SQL_TYPE,
    COLUMN_TYPE,
    COLUMN_TYPE_D,
    DEFAULT_VALUE,
    DESC_ATTRIBUTE,
    DESCRIPTION,
    IS_EXPRESSION,
    MANDATORY,
    MULTILINE,
    ORDER_NR,
    PATH_NAME,
    PLACEHOLDER_NAME,
    RANGE_DEFAULTS_EXIST,
    SELECTION_TYPE,
    SEMANTIC_TYPE,
    VALUE_ATTRIBUTE,
    VALUE_ENTITY,
    VALUE_TYPE,
    PRIMARY KEY (CATALOG_NAME, CUBE_NAME, VARIABLE_NAME)
);

Learn More