VMP_PLNSCP_HDR

Transparent Table Application Table
42 Fields 4 CDS Views

Document and BOM Links

VMP_PLNSCP_HDR is an SAP database table in S/4HANA. Document and BOM Links. It contains 42 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ChgRecdWithMatl view left_outer BASIC Open Change Record Details with Material
I_PlanningScopeHeaderDetail view from BASIC VEMP Planning Scope Header Details
I_PlngScpBasic view from BASIC Planning Scope Basic View
P_PlanningScopeExplodedBOM view union_all BASIC

Fields (42)

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
description VMP_PLNSCP_DES PlnAlt Description
log_sys RFCDEST Destination
plant WERKS_D Plant
checkout_user VMP_CHECKOUT_USER Checkout User
timestamp TIMESTAMP Time Stamp
change_number AENNR Change Number
is_part_file VMP_PART_FILE Part file
src_matnr MATNR Material
dokar DOKAR Document Type
doknr DOKNR Document
doktl DOKTL_D Document Part
dokvr DOKVR Doc. Version
mbom_usage STLAN Usage
last_synced_by VMP_CHECKOUT_USER Checkout User
plnscp_scenario VMP_SCENARIO Scenario ID
target_matnr MATNR Material
psm_explosion_date DATUM Date
psm_node_guid VMP_PSM_NODE PSM Node Name
psm_simulation VMP_SIMULATION_NAME Simulation Name
mbom_type VMP_MBOM_TYPE MBOM Type
routing_ecn VMP_PLNSCP_ROUTCNR Change Num for Rout
stlst STLST BOM Status
alt_status VMP_PLNSCP_ALT_STATUS PSA status
psm_plant VMP_PPE_LOCID Location ID
psm_usage VMP_PPE_USE Usage
created_on VMP_CREATED_ON Created On
created_by VMP_CREATED_BY Created By
source_filter VMP_SOURCE_FILTER Source Filtering
source_plant VMP_SOURCE_PLANT Source plant
source_bom_alt VMP_SOURCE_STALT Source BOM alt
source_bom_usage VMP_SOURCE_STLAN Source BOM usage
source_validity VMP_SOURCE_DATUM Source validity date
source_bom_type VMP_EBOM_TYPE EBom Type
pspnr PS_POSID WBS Element
is_parameter_effectivity VMP_PAR_EFFECTIVITY Param Effectivity
ve_setting_id VMP_GUIDX GUIDX
changerecord_id VMP_CHNGE_REC_ISSUE_ID Issue ID
related_planningscope VMP_HIERARCHY_RELEVANT Hierarchy Relevant
source_change_number AENNR Change Number

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 and BOM Links
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VMP_PLNSCP_HDR (
    MANDT,                     -- Client [MANDT]
    DOCUMENTID,                -- Document Id [VMP_PLNSCP_DOC_ID]
    PLAN_SCOPE_ALT,            -- Plan Scope Alternate [VMP_PLNSCP_ALT]
    DESCRIPTION,               -- PlnAlt Description [VMP_PLNSCP_DES]
    LOG_SYS,                   -- Destination [RFCDEST]
    PLANT,                     -- Plant [WERKS_D]
    CHECKOUT_USER,             -- Checkout User [VMP_CHECKOUT_USER]
    TIMESTAMP,                 -- Time Stamp [TIMESTAMP]
    CHANGE_NUMBER,             -- Change Number [AENNR]
    IS_PART_FILE,              -- Part file [VMP_PART_FILE]
    SRC_MATNR,                 -- Material [MATNR]
    DOKAR,                     -- Document Type [DOKAR]
    DOKNR,                     -- Document [DOKNR]
    DOKTL,                     -- Document Part [DOKTL_D]
    DOKVR,                     -- Doc. Version [DOKVR]
    MBOM_USAGE,                -- Usage [STLAN]
    LAST_SYNCED_BY,            -- Checkout User [VMP_CHECKOUT_USER]
    PLNSCP_SCENARIO,           -- Scenario ID [VMP_SCENARIO]
    TARGET_MATNR,              -- Material [MATNR]
    PSM_EXPLOSION_DATE,        -- Date [DATUM]
    PSM_NODE_GUID,             -- PSM Node Name [VMP_PSM_NODE]
    PSM_SIMULATION,            -- Simulation Name [VMP_SIMULATION_NAME]
    MBOM_TYPE,                 -- MBOM Type [VMP_MBOM_TYPE]
    ROUTING_ECN,               -- Change Num for Rout [VMP_PLNSCP_ROUTCNR]
    STLST,                     -- BOM Status [STLST]
    ALT_STATUS,                -- PSA status [VMP_PLNSCP_ALT_STATUS]
    PSM_PLANT,                 -- Location ID [VMP_PPE_LOCID]
    PSM_USAGE,                 -- Usage [VMP_PPE_USE]
    CREATED_ON,                -- Created On [VMP_CREATED_ON]
    CREATED_BY,                -- Created By [VMP_CREATED_BY]
    SOURCE_FILTER,             -- Source Filtering [VMP_SOURCE_FILTER]
    SOURCE_PLANT,              -- Source plant [VMP_SOURCE_PLANT]
    SOURCE_BOM_ALT,            -- Source BOM alt [VMP_SOURCE_STALT]
    SOURCE_BOM_USAGE,          -- Source BOM usage [VMP_SOURCE_STLAN]
    SOURCE_VALIDITY,           -- Source validity date [VMP_SOURCE_DATUM]
    SOURCE_BOM_TYPE,           -- EBom Type [VMP_EBOM_TYPE]
    PSPNR,                     -- WBS Element [PS_POSID]
    IS_PARAMETER_EFFECTIVITY,  -- Param Effectivity [VMP_PAR_EFFECTIVITY]
    VE_SETTING_ID,             -- GUIDX [VMP_GUIDX]
    CHANGERECORD_ID,           -- Issue ID [VMP_CHNGE_REC_ISSUE_ID]
    RELATED_PLANNINGSCOPE,     -- Hierarchy Relevant [VMP_HIERARCHY_RELEVANT]
    SOURCE_CHANGE_NUMBER,      -- Change Number [AENNR]
    PRIMARY KEY (MANDT, DOCUMENTID, PLAN_SCOPE_ALT)
);

Learn More