MPE_PMDL_OPCA_D

Transparent Table Application Table
106 Fields 2 CDS Views

Draft table for entity R_PRODNMODOPERATIONCOMPONENTTP

MPE_PMDL_OPCA_D is an SAP database table in S/4HANA. Draft table for entity R_PRODNMODOPERATIONCOMPONENTTP. It contains 106 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_ProdnModOperationCompDrft view_entity from EXTENSION Operation Component - Extension
R_ProdnModOperationCompDrft view_entity from BASIC Operation component draft

Fields (106)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY productionmodeluuid mpe_pmdl_uuid Prodn Model UUID
KEY billofoperationsversion plnversn Routing Version
KEY boooperationinternalid cim_plnkn Task list node
KEY booopbomiteminternalid cim_zuord Allocation no.
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
booopinternalversioncounter cim_count Counter
billofmaterialcategory stlty BOM category
billofmaterial cs_stlnr BOM
billofmaterialvariantusage stlan Usage
plant werks_d Plant
billofoperationstype abap.char
productionmodelcomponentuuid cs_guid Guid
material matnr40 Material
billofmaterialitemnodenumber stlkn Item node
validitystartdate datuv Valid From
validityenddate datub to
engineeringchangedocument aennr Change Number
chgtoengineeringchgdocument aenra Change No. To
inheritednodenumberforbomitem stvkn Item node
inheritednodenumberversionbom stvkn Item node
bomiteminternalchangecount cim_count Counter
billofmaterialcomponent idnrk Component
componentdescription maktx Description
billofmaterialitemcategory postp Item Category
billofmaterialitemnumber cs_sposn Item
prodnmodbomcompassgdquantity kmpmg Quantity
prodnmodbomcompassgdqtyunit kmpme Component UoM
billofmaterialitemquantity abap.quan
billofmaterialitemunit kmpme Component UoM
isassembly xfeld Checkbox
issubitem upskz Sub-item ID
isdeleted lkenz Deletion Ind.
identifierbomitem cs_itmid Item ID
bomitemsorter sortp Sort String
bomitemhasfixedquantity fmnge Fixed Quantity
componentscrapinpercent kausf Component Scrap
operationscrapinpercent avoau Operation Scrap
isnetscrap netau Net Indicator
isbulkmaterial schgt Bulk material
isbulkmaterialcomponent schgt Bulk material
materialprovisiontype beikz Mat. Prov. Ind.
matlcomponentspareparttype erskz Spare Part ID
bomitemsalesrelevancy rvrel Sales
isengineeringrelevant sanko Engineering
bomitemisplantmaintrelevant sanin Plant maint.
isproductionrelevant sanfe Production
materialcompcostingrelevancy cs_sanka CostingRelevncy
bomisrecursive rekri Recursive
isbomrecursiveallowed rekrs Rec. allowed
followupgroup cs_nfgrp Follow-up group
alternativeitemgroup cs_alpgr AltItemGroup
materialiscoproduct kzkup Co-product
alternativeitempriority cs_alprf Priority
alternativeitemstrategy cs_alpst Strategy
isale cs_alekz ALE indicator
usageprobabilitypercent ewahr Usage Prob.
ispmassemblyrelevant stkkz PM assembly
documentiscreatedbycad cadpo CAD Indicator
dependencyobjectnumber knobj Assgmt no.
discontinuationgroup cs_nfeag Discont. group
leadtimeoffset nlfzt Lead-tm offset
operationleadtimeoffset cs_nlfzv Oper. LT offset
opsleadtimeoffsetunit cs_nlfmv Oper. LTO unit
distrkeycompconsumption sa_verti Distribution
isphantomitem xfeld Checkbox
purchasinggroup ekgrp Purch. Group
deliverydurationindays lifzt Del time (days)
creditor lifnr Supplier
materialcomponentprice cprei Price
currency waers Currency
costelement sakto Cost element
materialgroup matkl Material Group
goodsreceiptduration webaz GR proc. time
purchasingorganization ekorg Purchasing Org.
preliminarymaterial maktx Description
size1 roms1 Size 1
size2 roms2 Size 2
size3 roms3 Size 3
unitofmeasureforsize1to3 romei Size unit
quantityvariablesizeitem romen VSI Quantity
variablesizeitemquantity pph_roanz Number of Variable-Size Components
variablesizeitemunit roame VSI unit
variablesizecompunitofmeasure abap.unit
formulakey rform VSI Formula
bomitemdescription potx1 Item Text
bomitemtext2 potx2 Item Text
documenttype dokar Document Type
docnumber doknr Document
documentversion dokvr Doc. Version
documentpart doktl_d Document Part
prodorderissuelocation cslgo StorageLocation
productionsupplyarea prvbe Supply Area
explosiontype cs_dispo Explosion type
specialprocurementtype cs_sobsl SpecProcurement
referencepoint cn_rfpnt Reference point
billofmaterialitemobjecttype objty Object Type
bomitemrecordcreationdate andat Created On
bomitemcreatedbyuser annam Created by
bomitemlastchangedate aedat Changed On
bomitemlastchangedbyuser aenam Changed By
createdbyuser vdm_createdbyuserid Created By
creationdate andat Created On
lastchangedate cim_aedat Changed on
lastchangedbyuser vdm_lastchangedbyuserid Changed By

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.

-- Draft table for entity R_PRODNMODOPERATIONCOMPONENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_PMDL_OPCA_D (
    MANDT,                          -- Client [mandt]
    PRODUCTIONMODELUUID,            -- Prodn Model UUID [mpe_pmdl_uuid]
    BILLOFOPERATIONSVERSION,        -- Routing Version [plnversn]
    BOOOPERATIONINTERNALID,         -- Task list node [cim_plnkn]
    BOOOPBOMITEMINTERNALID,         -- Allocation no. [cim_zuord]
    DRAFTUUID,                      -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                -- Draft Document ID [sdraft_uuid]
    BOOOPINTERNALVERSIONCOUNTER,    -- Counter [cim_count]
    BILLOFMATERIALCATEGORY,         -- BOM category [stlty]
    BILLOFMATERIAL,                 -- BOM [cs_stlnr]
    BILLOFMATERIALVARIANTUSAGE,     -- Usage [stlan]
    PLANT,                          -- Plant [werks_d]
    BILLOFOPERATIONSTYPE,           -- abap.char
    PRODUCTIONMODELCOMPONENTUUID,   -- Guid [cs_guid]
    MATERIAL,                       -- Material [matnr40]
    BILLOFMATERIALITEMNODENUMBER,   -- Item node [stlkn]
    VALIDITYSTARTDATE,              -- Valid From [datuv]
    VALIDITYENDDATE,                -- to [datub]
    ENGINEERINGCHANGEDOCUMENT,      -- Change Number [aennr]
    CHGTOENGINEERINGCHGDOCUMENT,    -- Change No. To [aenra]
    INHERITEDNODENUMBERFORBOMITEM,  -- Item node [stvkn]
    INHERITEDNODENUMBERVERSIONBOM,  -- Item node [stvkn]
    BOMITEMINTERNALCHANGECOUNT,     -- Counter [cim_count]
    BILLOFMATERIALCOMPONENT,        -- Component [idnrk]
    COMPONENTDESCRIPTION,           -- Description [maktx]
    BILLOFMATERIALITEMCATEGORY,     -- Item Category [postp]
    BILLOFMATERIALITEMNUMBER,       -- Item [cs_sposn]
    PRODNMODBOMCOMPASSGDQUANTITY,   -- Quantity [kmpmg]
    PRODNMODBOMCOMPASSGDQTYUNIT,    -- Component UoM [kmpme]
    BILLOFMATERIALITEMQUANTITY,     -- abap.quan
    BILLOFMATERIALITEMUNIT,         -- Component UoM [kmpme]
    ISASSEMBLY,                     -- Checkbox [xfeld]
    ISSUBITEM,                      -- Sub-item ID [upskz]
    ISDELETED,                      -- Deletion Ind. [lkenz]
    IDENTIFIERBOMITEM,              -- Item ID [cs_itmid]
    BOMITEMSORTER,                  -- Sort String [sortp]
    BOMITEMHASFIXEDQUANTITY,        -- Fixed Quantity [fmnge]
    COMPONENTSCRAPINPERCENT,        -- Component Scrap [kausf]
    OPERATIONSCRAPINPERCENT,        -- Operation Scrap [avoau]
    ISNETSCRAP,                     -- Net Indicator [netau]
    ISBULKMATERIAL,                 -- Bulk material [schgt]
    ISBULKMATERIALCOMPONENT,        -- Bulk material [schgt]
    MATERIALPROVISIONTYPE,          -- Mat. Prov. Ind. [beikz]
    MATLCOMPONENTSPAREPARTTYPE,     -- Spare Part ID [erskz]
    BOMITEMSALESRELEVANCY,          -- Sales [rvrel]
    ISENGINEERINGRELEVANT,          -- Engineering [sanko]
    BOMITEMISPLANTMAINTRELEVANT,    -- Plant maint. [sanin]
    ISPRODUCTIONRELEVANT,           -- Production [sanfe]
    MATERIALCOMPCOSTINGRELEVANCY,   -- CostingRelevncy [cs_sanka]
    BOMISRECURSIVE,                 -- Recursive [rekri]
    ISBOMRECURSIVEALLOWED,          -- Rec. allowed [rekrs]
    FOLLOWUPGROUP,                  -- Follow-up group [cs_nfgrp]
    ALTERNATIVEITEMGROUP,           -- AltItemGroup [cs_alpgr]
    MATERIALISCOPRODUCT,            -- Co-product [kzkup]
    ALTERNATIVEITEMPRIORITY,        -- Priority [cs_alprf]
    ALTERNATIVEITEMSTRATEGY,        -- Strategy [cs_alpst]
    ISALE,                          -- ALE indicator [cs_alekz]
    USAGEPROBABILITYPERCENT,        -- Usage Prob. [ewahr]
    ISPMASSEMBLYRELEVANT,           -- PM assembly [stkkz]
    DOCUMENTISCREATEDBYCAD,         -- CAD Indicator [cadpo]
    DEPENDENCYOBJECTNUMBER,         -- Assgmt no. [knobj]
    DISCONTINUATIONGROUP,           -- Discont. group [cs_nfeag]
    LEADTIMEOFFSET,                 -- Lead-tm offset [nlfzt]
    OPERATIONLEADTIMEOFFSET,        -- Oper. LT offset [cs_nlfzv]
    OPSLEADTIMEOFFSETUNIT,          -- Oper. LTO unit [cs_nlfmv]
    DISTRKEYCOMPCONSUMPTION,        -- Distribution [sa_verti]
    ISPHANTOMITEM,                  -- Checkbox [xfeld]
    PURCHASINGGROUP,                -- Purch. Group [ekgrp]
    DELIVERYDURATIONINDAYS,         -- Del time (days) [lifzt]
    CREDITOR,                       -- Supplier [lifnr]
    MATERIALCOMPONENTPRICE,         -- Price [cprei]
    CURRENCY,                       -- Currency [waers]
    COSTELEMENT,                    -- Cost element [sakto]
    MATERIALGROUP,                  -- Material Group [matkl]
    GOODSRECEIPTDURATION,           -- GR proc. time [webaz]
    PURCHASINGORGANIZATION,         -- Purchasing Org. [ekorg]
    PRELIMINARYMATERIAL,            -- Description [maktx]
    SIZE1,                          -- Size 1 [roms1]
    SIZE2,                          -- Size 2 [roms2]
    SIZE3,                          -- Size 3 [roms3]
    UNITOFMEASUREFORSIZE1TO3,       -- Size unit [romei]
    QUANTITYVARIABLESIZEITEM,       -- VSI Quantity [romen]
    VARIABLESIZEITEMQUANTITY,       -- Number of Variable-Size Components [pph_roanz]
    VARIABLESIZEITEMUNIT,           -- VSI unit [roame]
    VARIABLESIZECOMPUNITOFMEASURE,  -- abap.unit
    FORMULAKEY,                     -- VSI Formula [rform]
    BOMITEMDESCRIPTION,             -- Item Text [potx1]
    BOMITEMTEXT2,                   -- Item Text [potx2]
    DOCUMENTTYPE,                   -- Document Type [dokar]
    DOCNUMBER,                      -- Document [doknr]
    DOCUMENTVERSION,                -- Doc. Version [dokvr]
    DOCUMENTPART,                   -- Document Part [doktl_d]
    PRODORDERISSUELOCATION,         -- StorageLocation [cslgo]
    PRODUCTIONSUPPLYAREA,           -- Supply Area [prvbe]
    EXPLOSIONTYPE,                  -- Explosion type [cs_dispo]
    SPECIALPROCUREMENTTYPE,         -- SpecProcurement [cs_sobsl]
    REFERENCEPOINT,                 -- Reference point [cn_rfpnt]
    BILLOFMATERIALITEMOBJECTTYPE,   -- Object Type [objty]
    BOMITEMRECORDCREATIONDATE,      -- Created On [andat]
    BOMITEMCREATEDBYUSER,           -- Created by [annam]
    BOMITEMLASTCHANGEDATE,          -- Changed On [aedat]
    BOMITEMLASTCHANGEDBYUSER,       -- Changed By [aenam]
    CREATEDBYUSER,                  -- Created By [vdm_createdbyuserid]
    CREATIONDATE,                   -- Created On [andat]
    LASTCHANGEDATE,                 -- Changed on [cim_aedat]
    LASTCHANGEDBYUSER,              -- Changed By [vdm_lastchangedbyuserid]
    PRIMARY KEY (MANDT, PRODUCTIONMODELUUID, BILLOFOPERATIONSVERSION, BOOOPERATIONINTERNALID, BOOOPBOMITEMINTERNALID, DRAFTUUID)
);

Learn More