MPE_RTGV_ORD_CMP

Transparent Table Application Table
52 Fields 1 CDS Views

Delta BOM items: Order specific components

MPE_RTGV_ORD_CMP is an SAP database table in S/4HANA. Delta BOM items: Order specific components. It contains 52 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RoutingOrderSpecificComp view from BASIC Delta BOM Items Order Spec Components

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY plnty PLNTY Task List Type
KEY plnnr PLNNR Group
KEY plnal PLNAL Group Counter
KEY versn PLNVERSN Routing Version
KEY delta_cmp_cnt MPE_RTGV_DELTA_CMP_CNT Comp. Counter
delta_type MPE_RTGV_DELTA_TYPE Delta Type
aufnr AUFNR Order
stlan STLAN Usage
werks WERKS_D Plant
matnr MATNR Material
stlty STLTY BOM category
stlnr CIM_STNUM BOM
stlal STALT Alternative
bom_versn CIM_BOM_VERSN BOM Version
stlkn KNTNR Nodes
stvkn KNTNR Nodes
stvkn_versn KNTNR Nodes
stlkn_reference KNTNR Nodes
insmk MPE_INSMK Stock Type
assembly_type MPE_ASSEMBLY_TYPE Assembly Type
oan_element_number MPE_OAN_ELEMENT_NUMBER Element Number
idnrk IDNRK Component
pswrk PSWRK Issuing Plant
postp POSTP Item Category
posnr SPOSN Item
matkl MATKL Material Group
meins KMPME Component UoM
menge KMPMG Quantity
fmeng FMNGE Fixed Quantity
ausch KAUSF Component Scrap
avoau AVOAU Operation Scrap
netau NETAU Net Indicator
schgt SCHGT Bulk material
lgort CSLGO StorageLocation
itsob CS_SOBSL SpecProcurement
prvbe PRVBE Supply Area
potx1 POTX1 Item Text
potx2 POTX2 Item Text
created_by MPE_CREATE_USER Created By
created_at MPE_CREATE_TIMESTAMP Created On
changed_by MPE_LCHANGE_USER Changed By
changed_at MPE_LCHANGE_TIMESTAMP Changed On
dummy_stpo_incl_eew_ps STPO_INCL_EEW Ext. Include
roanz ROANZ Number Required
roms1 ROMS1 Size 1
roms2 ROMS2 Size 2
roms3 ROMS3 Size 3
romei ROMEI Size unit
romen ROMEN VSI Quantity
rform RFORM VSI Formula
sanka MPE_COSTING_RELEVANCY Cost. Relevancy

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.

-- Delta BOM items: Order specific components
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_RTGV_ORD_CMP (
    MANDT,                   -- Client [MANDT]
    PLNTY,                   -- Task List Type [PLNTY]
    PLNNR,                   -- Group [PLNNR]
    PLNAL,                   -- Group Counter [PLNAL]
    VERSN,                   -- Routing Version [PLNVERSN]
    DELTA_CMP_CNT,           -- Comp. Counter [MPE_RTGV_DELTA_CMP_CNT]
    DELTA_TYPE,              -- Delta Type [MPE_RTGV_DELTA_TYPE]
    AUFNR,                   -- Order [AUFNR]
    STLAN,                   -- Usage [STLAN]
    WERKS,                   -- Plant [WERKS_D]
    MATNR,                   -- Material [MATNR]
    STLTY,                   -- BOM category [STLTY]
    STLNR,                   -- BOM [CIM_STNUM]
    STLAL,                   -- Alternative [STALT]
    BOM_VERSN,               -- BOM Version [CIM_BOM_VERSN]
    STLKN,                   -- Nodes [KNTNR]
    STVKN,                   -- Nodes [KNTNR]
    STVKN_VERSN,             -- Nodes [KNTNR]
    STLKN_REFERENCE,         -- Nodes [KNTNR]
    INSMK,                   -- Stock Type [MPE_INSMK]
    ASSEMBLY_TYPE,           -- Assembly Type [MPE_ASSEMBLY_TYPE]
    OAN_ELEMENT_NUMBER,      -- Element Number [MPE_OAN_ELEMENT_NUMBER]
    IDNRK,                   -- Component [IDNRK]
    PSWRK,                   -- Issuing Plant [PSWRK]
    POSTP,                   -- Item Category [POSTP]
    POSNR,                   -- Item [SPOSN]
    MATKL,                   -- Material Group [MATKL]
    MEINS,                   -- Component UoM [KMPME]
    MENGE,                   -- Quantity [KMPMG]
    FMENG,                   -- Fixed Quantity [FMNGE]
    AUSCH,                   -- Component Scrap [KAUSF]
    AVOAU,                   -- Operation Scrap [AVOAU]
    NETAU,                   -- Net Indicator [NETAU]
    SCHGT,                   -- Bulk material [SCHGT]
    LGORT,                   -- StorageLocation [CSLGO]
    ITSOB,                   -- SpecProcurement [CS_SOBSL]
    PRVBE,                   -- Supply Area [PRVBE]
    POTX1,                   -- Item Text [POTX1]
    POTX2,                   -- Item Text [POTX2]
    CREATED_BY,              -- Created By [MPE_CREATE_USER]
    CREATED_AT,              -- Created On [MPE_CREATE_TIMESTAMP]
    CHANGED_BY,              -- Changed By [MPE_LCHANGE_USER]
    CHANGED_AT,              -- Changed On [MPE_LCHANGE_TIMESTAMP]
    DUMMY_STPO_INCL_EEW_PS,  -- Ext. Include [STPO_INCL_EEW]
    ROANZ,                   -- Number Required [ROANZ]
    ROMS1,                   -- Size 1 [ROMS1]
    ROMS2,                   -- Size 2 [ROMS2]
    ROMS3,                   -- Size 3 [ROMS3]
    ROMEI,                   -- Size unit [ROMEI]
    ROMEN,                   -- VSI Quantity [ROMEN]
    RFORM,                   -- VSI Formula [RFORM]
    SANKA,                   -- Cost. Relevancy [MPE_COSTING_RELEVANCY]
    PRIMARY KEY (MANDT, PLNTY, PLNNR, PLNAL, VERSN, DELTA_CMP_CNT)
);

Learn More