ESH_TAU_CL_PVPD

Transparent Table Application Table
20 Fields 1 CDS Views

Classification Test: Property Value Assignm. to EPM Product

ESH_TAU_CL_PVPD is an SAP database table in S/4HANA. Classification Test: Property Value Assignm. to EPM Product. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
esh_tau_v_classification view from ES Tests: Classification Search Core View

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY object_id TREX_PROP_OBJECT_ID Object ID
KEY class_type TREX_PROP_CLASS_TYPE Class Type
KEY property_uuid TREX_PROP_UUID Property UUID
KEY value_uuid TREX_PROP_VALUE_UUID Value UUID
change_order_id TREX_PROP_CHANGE_ID Change Order ID
valid_from TZNTSTMPS Time Stamp
valid_to TZNTSTMPS Time Stamp
has_param_effect TREX_PROP_PARAM_EFF Param. Effect.
interv_bnd_tp_cd TREX_PROP_BOUNDARY_CODE Interval Type
value_string TREX_PROP_STRING String Value
value_num_low TREX_PROP_NUM_LOW Numeric low
value_curr_code TREX_PROP_CURRENCY Currency
display_uom_low TREX_PROP_UOM_LOW UoM, low
measure_low TREX_PROP_MEASURE_LOW Measure, low
value_num_high TREX_PROP_NUM_HIGH Numeric high
display_uom_high TREX_PROP_UOM_HIGH UoM, high
measure_high TREX_PROP_MEASURE_HIGH Measure, high
search_val TREX_PROP_SEARCH_VALUE normalized val.
search_val_norm TREX_PROP_SEARCH_VALUE_NORM normalized val.

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.

-- Classification Test: Property Value Assignm. to EPM Product
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ESH_TAU_CL_PVPD (
    MANDT,             -- Client [MANDT]
    OBJECT_ID,         -- Object ID [TREX_PROP_OBJECT_ID]
    CLASS_TYPE,        -- Class Type [TREX_PROP_CLASS_TYPE]
    PROPERTY_UUID,     -- Property UUID [TREX_PROP_UUID]
    VALUE_UUID,        -- Value UUID [TREX_PROP_VALUE_UUID]
    CHANGE_ORDER_ID,   -- Change Order ID [TREX_PROP_CHANGE_ID]
    VALID_FROM,        -- Time Stamp [TZNTSTMPS]
    VALID_TO,          -- Time Stamp [TZNTSTMPS]
    HAS_PARAM_EFFECT,  -- Param. Effect. [TREX_PROP_PARAM_EFF]
    INTERV_BND_TP_CD,  -- Interval Type [TREX_PROP_BOUNDARY_CODE]
    VALUE_STRING,      -- String Value [TREX_PROP_STRING]
    VALUE_NUM_LOW,     -- Numeric low [TREX_PROP_NUM_LOW]
    VALUE_CURR_CODE,   -- Currency [TREX_PROP_CURRENCY]
    DISPLAY_UOM_LOW,   -- UoM, low [TREX_PROP_UOM_LOW]
    MEASURE_LOW,       -- Measure, low [TREX_PROP_MEASURE_LOW]
    VALUE_NUM_HIGH,    -- Numeric high [TREX_PROP_NUM_HIGH]
    DISPLAY_UOM_HIGH,  -- UoM, high [TREX_PROP_UOM_HIGH]
    MEASURE_HIGH,      -- Measure, high [TREX_PROP_MEASURE_HIGH]
    SEARCH_VAL,        -- normalized val. [TREX_PROP_SEARCH_VALUE]
    SEARCH_VAL_NORM,   -- normalized val. [TREX_PROP_SEARCH_VALUE_NORM]
    PRIMARY KEY (MANDT, OBJECT_ID, CLASS_TYPE, PROPERTY_UUID, VALUE_UUID)
);

Learn More