MPE_WI_VARBL

Transparent Table Application Table
14 Fields 1 CDS Views

Work Instruction Variable

MPE_WI_VARBL is an SAP database table in S/4HANA. Work Instruction Variable. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MfgWorkInstructionVariable view from BASIC Embedded WI: Variable

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY wi_id mpe_wi_id Work Instruction
KEY wi_version_no mpe_wi_version_no Version No.
KEY wi_variable mpe_wi_variable Variable
KEY plmb_zuonr cim_zuord Allocation no.
variable_type mpe_variable_type Var TYpe
merknr qmerknrp Characteristic
pzlfh pzlfh PRT Item Count.
plmz_zuonr cim_zuord Allocation no.
chargroup qchargroup Characteristic Group
log_comp_counter mpe_log_comp_counter Logical Component
camera_counter mpe_camera_counter Camera counter
item_val_guid mpe_sta_item_val_guid Item value GUID
mrs_leaf_asgmt_uuid mpe_mrs_leaf_assignment_uuid Leaf Assignment UUID

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.

-- Work Instruction Variable
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_WI_VARBL (
    MANDT,                -- Client [mandt]
    WI_ID,                -- Work Instruction [mpe_wi_id]
    WI_VERSION_NO,        -- Version No. [mpe_wi_version_no]
    WI_VARIABLE,          -- Variable [mpe_wi_variable]
    PLMB_ZUONR,           -- Allocation no. [cim_zuord]
    VARIABLE_TYPE,        -- Var TYpe [mpe_variable_type]
    MERKNR,               -- Characteristic [qmerknrp]
    PZLFH,                -- PRT Item Count. [pzlfh]
    PLMZ_ZUONR,           -- Allocation no. [cim_zuord]
    CHARGROUP,            -- Characteristic Group [qchargroup]
    LOG_COMP_COUNTER,     -- Logical Component [mpe_log_comp_counter]
    CAMERA_COUNTER,       -- Camera counter [mpe_camera_counter]
    ITEM_VAL_GUID,        -- Item value GUID [mpe_sta_item_val_guid]
    MRS_LEAF_ASGMT_UUID,  -- Leaf Assignment UUID [mpe_mrs_leaf_assignment_uuid]
    PRIMARY KEY (MANDT, WI_ID, WI_VERSION_NO, WI_VARIABLE, PLMB_ZUONR)
);

Learn More