MPE_PMDL_OPCA_D

Transparent Table Application Table
109 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 109 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 (109)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY productionmodeluuid MPE_PMDL_UUID Prodn Model UUID
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
billofmaterialcategory STLTY BOM category
billofmaterial CS_STLNR BOM
billofmaterialvariantusage STLAN Usage
plant WERKS_D Plant
billofoperationstype PLNTY Task List Type
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 OJTXP Description
billofmaterialitemcategory POSTP Item Category
billofmaterialitemnumber CS_SPOSN Item
billofmaterialitemunit KMPME Component UoM
prodnmodbomcompassgdquantity KMPMG Quantity
billofmaterialitemquantity KMPMG Quantity
isassembly STLKZ Assembly
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 DUMPS Phantom item
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 ROAME VSI 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
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
dummy_stpo_incl_eew_ps STPO_INCL_EEW Ext. Include
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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]
    BOOOPERATIONINTERNALID,         -- Task list node [CIM_PLNKN]
    BOOOPBOMITEMINTERNALID,         -- Allocation no. [CIM_ZUORD]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                -- Draft Document ID [SDRAFT_UUID]
    BILLOFMATERIALCATEGORY,         -- BOM category [STLTY]
    BILLOFMATERIAL,                 -- BOM [CS_STLNR]
    BILLOFMATERIALVARIANTUSAGE,     -- Usage [STLAN]
    PLANT,                          -- Plant [WERKS_D]
    BILLOFOPERATIONSTYPE,           -- Task List Type [PLNTY]
    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 [OJTXP]
    BILLOFMATERIALITEMCATEGORY,     -- Item Category [POSTP]
    BILLOFMATERIALITEMNUMBER,       -- Item [CS_SPOSN]
    BILLOFMATERIALITEMUNIT,         -- Component UoM [KMPME]
    PRODNMODBOMCOMPASSGDQUANTITY,   -- Quantity [KMPMG]
    BILLOFMATERIALITEMQUANTITY,     -- Quantity [KMPMG]
    ISASSEMBLY,                     -- Assembly [STLKZ]
    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,                  -- Phantom item [DUMPS]
    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,  -- VSI unit [ROAME]
    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]
    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]
    DUMMY_STPO_INCL_EEW_PS,         -- Ext. Include [STPO_INCL_EEW]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, PRODUCTIONMODELUUID, BOOOPERATIONINTERNALID, BOOOPBOMITEMINTERNALID, DRAFTUUID)
);

Learn More