MPE_STA_ITEM

Transparent Table Application Table
10 Fields 1 CDS Views

STA item

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProdMfgInfoItem view from BASIC Item of Product Manufacturing Inform

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY item_guid mpe_sta_item_guid Item GUID
file_guid mpe_sta_file_guid File GUID
item_guid_parent mpe_sta_parent_guid Parent GUID
item_guid_predecessor mpe_sta_item_predecessor_guid Item pred. GUID
sibling_sort_number mpe_sta_sibling_sort_number Sibling sort number
item_hash mpe_sta_item_hash Item hash
subitem_sqnc_hash mpe_sta_subitem_sqnc_hash Subitems sqns hash
aggregated_item_hash mpe_sta_aggregated_item_hash Aggregated item hash
aggregated_sqnc_hash mpe_sta_aggregated_sqnc_hash Aggregated sequence

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_STA_ITEM (
    MANDT,                  -- Client [mandt]
    ITEM_GUID,              -- Item GUID [mpe_sta_item_guid]
    FILE_GUID,              -- File GUID [mpe_sta_file_guid]
    ITEM_GUID_PARENT,       -- Parent GUID [mpe_sta_parent_guid]
    ITEM_GUID_PREDECESSOR,  -- Item pred. GUID [mpe_sta_item_predecessor_guid]
    SIBLING_SORT_NUMBER,    -- Sibling sort number [mpe_sta_sibling_sort_number]
    ITEM_HASH,              -- Item hash [mpe_sta_item_hash]
    SUBITEM_SQNC_HASH,      -- Subitems sqns hash [mpe_sta_subitem_sqnc_hash]
    AGGREGATED_ITEM_HASH,   -- Aggregated item hash [mpe_sta_aggregated_item_hash]
    AGGREGATED_SQNC_HASH,   -- Aggregated sequence [mpe_sta_aggregated_sqnc_hash]
    PRIMARY KEY (MANDT, ITEM_GUID)
);

Learn More