VMP_PLNSCP_MBOM

Transparent Table Application Table
17 Fields 1 CDS Views

Document Mbom links

VMP_PLNSCP_MBOM is an SAP database table in S/4HANA. Document Mbom links. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PlanningScopeMBOM view from BASIC Document Mbom links

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY documentid vmp_plnscp_doc_id Document Id
KEY plan_scope_alt vmp_plnscp_alt Plan Scope Alternate
KEY plnscp_item_cnt cim_count Counter
mbom_guid cs_guidb Guid
mbom_material matnr Material
mbom_usage stlan Usage
mbom_alternative stalt Alternative
mbom_state vmp_mbom_state MBOM State
mbom_type vmp_mbom_type MBOM Type
group_type plnty Task List Type
group_id plnnr Group
group_counter plnal Group Counter
instance_count cim_count Counter
network nw_aufnr Network
ve_setting_id vmp_guidx GUIDX
is_custom_asm vmp_custom_asm Custom Assembly

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.

-- Document Mbom links
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VMP_PLNSCP_MBOM (
    MANDT,             -- Client [mandt]
    DOCUMENTID,        -- Document Id [vmp_plnscp_doc_id]
    PLAN_SCOPE_ALT,    -- Plan Scope Alternate [vmp_plnscp_alt]
    PLNSCP_ITEM_CNT,   -- Counter [cim_count]
    MBOM_GUID,         -- Guid [cs_guidb]
    MBOM_MATERIAL,     -- Material [matnr]
    MBOM_USAGE,        -- Usage [stlan]
    MBOM_ALTERNATIVE,  -- Alternative [stalt]
    MBOM_STATE,        -- MBOM State [vmp_mbom_state]
    MBOM_TYPE,         -- MBOM Type [vmp_mbom_type]
    GROUP_TYPE,        -- Task List Type [plnty]
    GROUP_ID,          -- Group [plnnr]
    GROUP_COUNTER,     -- Group Counter [plnal]
    INSTANCE_COUNT,    -- Counter [cim_count]
    NETWORK,           -- Network [nw_aufnr]
    VE_SETTING_ID,     -- GUIDX [vmp_guidx]
    IS_CUSTOM_ASM,     -- Custom Assembly [vmp_custom_asm]
    PRIMARY KEY (MANDT, DOCUMENTID, PLAN_SCOPE_ALT, PLNSCP_ITEM_CNT)
);

Learn More