MPE_STA_ITEM_VAL

Transparent Table Application Table
7 Fields 1 CDS Views

STA item values

MPE_STA_ITEM_VAL is an SAP database table in S/4HANA. STA item values. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProdMfgInfoItemValue view from BASIC Item Value of Product Manufacturing Information

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY item_val_guid MPE_STA_ITEM_VAL_GUID Item value GUID
file_guid MPE_STA_FILE_GUID File GUID
item_guid MPE_STA_ITEM_GUID Item GUID
sort_position MPE_STA_ITEM_VAL_SORT_POSITION Sort position
item_property MPE_STA_ITEM_PROPERTY Srce Item Property
item_value MPE_STA_ITEM_VALUE Item Value

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.

-- STA item values
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_STA_ITEM_VAL (
    MANDT,          -- Client [MANDT]
    ITEM_VAL_GUID,  -- Item value GUID [MPE_STA_ITEM_VAL_GUID]
    FILE_GUID,      -- File GUID [MPE_STA_FILE_GUID]
    ITEM_GUID,      -- Item GUID [MPE_STA_ITEM_GUID]
    SORT_POSITION,  -- Sort position [MPE_STA_ITEM_VAL_SORT_POSITION]
    ITEM_PROPERTY,  -- Srce Item Property [MPE_STA_ITEM_PROPERTY]
    ITEM_VALUE,     -- Item Value [MPE_STA_ITEM_VALUE]
    PRIMARY KEY (MANDT, ITEM_VAL_GUID)
);

Learn More