MPE_PMDL_OP_D

Transparent Table Application Table
136 Fields 1 CDS Views

Draft table for entity R_PRODUCTIONMODELOPERATIONTP

MPE_PMDL_OP_D is an SAP database table in S/4HANA. Draft table for entity R_PRODUCTIONMODELOPERATIONTP. It contains 136 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProdnModOperationDraft view_entity from BASIC Production Model Operation - Draft

Fields (136)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY productionmodeluuid MPE_PMDL_UUID Prodn Model UUID
KEY billofoperationsversion PLNVERSN Routing Version
KEY boooperationinternalid PLNKN Node
KEY draftuuid SDRAFT_UUID Draft Document ID
prodnmodopdraftinternalid PLNKN Node
booopinternalversioncounter CIM_COUNT Counter
billofmaterialcategory STLTY BOM category
material MATNR40 Material
plant WERKS_D Plant
billofmaterialvariantusage STLAN Usage
billofmaterial CS_STLNR BOM
billofmaterialvariant STLAL AlternativeBOM
billofoperationstype abap.char
billofoperationsgroup PLNNR Group
billofoperationsvariant PLNAL Group Counter
billofoperationssequence PLNFOLGE Sequence
boosqncinternalversioncounter CIM_COUNT Counter
operationexternalid CP_OPRID Ext. Oper. ID
operation MPE_VDM_RTG_OPERATION Operation No.
operationtext MPE_LTXA1 Description
longtextlanguagecode SPRAS Language
workcenter PPH_ARBPL Work Center
boooperationplant WERKS_D Plant
operationcontrolprofile STEUS Control Key
operationreferencequantity BMSCH Base Quantity
operationunit VORME Act/op UoM
billofoperationsbreakduration DZMERH Break Time
billofoperationsbreakdurnunit DZEIER Break Time Unit
businessprocess CO_PRZNR Business Process
leadtimereductionstrategy RSTRA Red. Strategy
teardownandwaitisparallel ABLIPKZ Teardown/Wait Par.
minimumwaitduration DZLPRO Min. Wait Time
minimumwaitdurationunit DZEILP Req. Wait Unit
maximumwaitduration DZLMAX Max. Wait Time
maximumwaitdurationunit DZEILM Max. Wait Unit
minimumqueueduration DZWMIN Min. Queue Time
minimumqueuedurationunit DZEIWM Min. Queue Unit
standardqueueduration DZWNOR Std Queue Time
standardqueuedurationunit DZEIWN Std Queue Unit
minimummoveduration DZTMIN Min. Move Time
minimummovedurationunit DZEITM MinMoveTime Un
standardmoveduration DZTNOR Std Move Time
standardmovedurationunit DZEITN StdMoveTime Un
workcenterstandardqueuedurn DZWMIN Min. Queue Time
workcenterstdqueuedurnunit DZEIWN Std Queue Unit
workcenterminimumqueueduration DZWMIN Min. Queue Time
workcenterminimumqueuedurnunit DZEIWN Std Queue Unit
operationsplitisrequired SPLITTUNG Splitting Reqd
maximumnumberofsplits MAXIMUMNUMBEROFSPLITS Maximum Splits
minprocessingdurationpersplit DZMINB Min. Proc. Time
minprocessingdurnpersplitunit DZEIMB Min. Proc. Time
boooperationoverlapping MPE_RTG_OP_OVERLAPPING Overlapping
overlapminimumduration DZMINU Minimum Overlap
overlapminimumdurationunit DZEIMU Min.Overlap Tme
overlapminimumtransferqty MINWEI Min. Send-Ahead
overlapminimumtransferqtyunit VORME Act/op UoM
operationscrappercent AUSCHUFAK Scrap
numberoftimetickets LOHNANZ No.TimeTickets
numberofconfirmationslips CR_RS_ANZ No. of Conf. Slips
employeewagegroup LOHNGRP Wage Group
employeewagetype LOHNART Wage type
numberofemployees ANZMS No. employees
operationsetuptype RUEARSCHLU Setup Type Key
operationsetupgroupcategory RUEFAGRP Setup group cat
operationsetupgroup RUEFASCHLU Setup group key
operationcostingrelevancytype OPERATIONCOSTINGRELEVANCYTYPE Operation Costing Relevancy Type
nmbroftimeticketsisreferenced LOANZ_REF No. Time Ticktes Ref
numberofconfslipsisreferenced RSANZ_REF No. Conf. Slips Ref.
employeewagegroupisreferenced LOGRP_REF Wage Group Ref.
employeewagetypeisreferenced LOART_REF Wage Type Ref.
workcentersetptypeisreferenced RASCH_REF Setup Type Ref.
standardworkformulaparamname1 abap.char
standardworkformulaparamname2 abap.char
standardworkformulaparamname3 abap.char
standardworkformulaparamname4 abap.char
standardworkformulaparamname5 abap.char
standardworkformulaparamname6 abap.char
standardworkquantity1 VGWRT Standard Value
standardworkquantity2 VGWRT Standard Value
standardworkquantity3 VGWRT Standard Value
standardworkquantity4 VGWRT Standard Value
standardworkquantity5 VGWRT Standard Value
standardworkquantity6 VGWRT Standard Value
standardworkquantityunit1 VGWRTEH Std value unit
standardworkquantityunit2 VGWRTEH Std value unit
standardworkquantityunit3 VGWRTEH Std value unit
standardworkquantityunit4 VGWRTEH Std value unit
standardworkquantityunit5 VGWRTEH Std value unit
standardworkquantityunit6 VGWRTEH Std value unit
costctractivitytype1 LSTAR Activity Type
costctractivitytype2 LSTAR Activity Type
costctractivitytype3 LSTAR Activity Type
costctractivitytype4 LSTAR Activity Type
costctractivitytype5 LSTAR Activity Type
costctractivitytype6 LSTAR Activity Type
costctractytype1isreferenced AP_KZREF Reference ind.
costctractytype2isreferenced AP_KZREF Reference ind.
costctractytype3isreferenced AP_KZREF Reference ind.
costctractytype4isreferenced AP_KZREF Reference ind.
costctractytype5isreferenced AP_KZREF Reference ind.
costctractytype6isreferenced AP_KZREF Reference ind.
purchasinginforecord INFNR Info record
purchasecontract EBELN Purchasing Doc.
purchasinginforecdaddlgrpgname SORTI Sort Term
materialgroup MATKL Material Group
purchasinggroup VG_EKGRP Purch. Group
supplier LIFNR Supplier
planneddeliveryduration PLIFZ Pl. Deliv. Time
numberofoperationpriceunits EPEIN Price unit
opexternalprocessingprice IPREI Net Price
inspectionlottype QPART Inspection Type
purchasingorganization EKORG Purchasing Org.
purchasecontractitem EBELP Item
costelement KSTAR Cost Element
opexternalprocessingcurrency WAERS Currency
goodsrecipientname WEMPF Recipient
unloadingpointname ABLAD Unloading Point
shopfloorroutingtemplatetype MPE_RTG_REF_TEMPLATE_TYPE Template Type
shopfloorrtgtemplategroup MPE_RTG_REFT_GROUP Template Group
shopfloorrtgtemplategrpvariant MPE_RTG_REFT_VARIANT Group Counter
shopfloorrtgtemplateversion MPE_RTG_REFT_VERSION Template Versn
changenumber CHANGENUMBER Change Number
parameffctyobjectreferencekey CHAR60 Logical System
parameffctyparentobjrefkey CHAR60 Logical System
parameffctyobjecttype CHAR20 Char20
createdbyuser VDM_CREATEDBYUSERID Created By
creationdate ANDAT Created On
lastchangedbyuser VDM_LASTCHANGEDBYUSERID Changed By
lastchangedate AEDAT Changed On
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft 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_PRODUCTIONMODELOPERATIONTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_PMDL_OP_D (
    MANDT,                           -- Client [MANDT]
    PRODUCTIONMODELUUID,             -- Prodn Model UUID [MPE_PMDL_UUID]
    BILLOFOPERATIONSVERSION,         -- Routing Version [PLNVERSN]
    BOOOPERATIONINTERNALID,          -- Node [PLNKN]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PRODNMODOPDRAFTINTERNALID,       -- Node [PLNKN]
    BOOOPINTERNALVERSIONCOUNTER,     -- Counter [CIM_COUNT]
    BILLOFMATERIALCATEGORY,          -- BOM category [STLTY]
    MATERIAL,                        -- Material [MATNR40]
    PLANT,                           -- Plant [WERKS_D]
    BILLOFMATERIALVARIANTUSAGE,      -- Usage [STLAN]
    BILLOFMATERIAL,                  -- BOM [CS_STLNR]
    BILLOFMATERIALVARIANT,           -- AlternativeBOM [STLAL]
    BILLOFOPERATIONSTYPE,            -- abap.char
    BILLOFOPERATIONSGROUP,           -- Group [PLNNR]
    BILLOFOPERATIONSVARIANT,         -- Group Counter [PLNAL]
    BILLOFOPERATIONSSEQUENCE,        -- Sequence [PLNFOLGE]
    BOOSQNCINTERNALVERSIONCOUNTER,   -- Counter [CIM_COUNT]
    OPERATIONEXTERNALID,             -- Ext. Oper. ID [CP_OPRID]
    OPERATION,                       -- Operation No. [MPE_VDM_RTG_OPERATION]
    OPERATIONTEXT,                   -- Description [MPE_LTXA1]
    LONGTEXTLANGUAGECODE,            -- Language [SPRAS]
    WORKCENTER,                      -- Work Center [PPH_ARBPL]
    BOOOPERATIONPLANT,               -- Plant [WERKS_D]
    OPERATIONCONTROLPROFILE,         -- Control Key [STEUS]
    OPERATIONREFERENCEQUANTITY,      -- Base Quantity [BMSCH]
    OPERATIONUNIT,                   -- Act/op UoM [VORME]
    BILLOFOPERATIONSBREAKDURATION,   -- Break Time [DZMERH]
    BILLOFOPERATIONSBREAKDURNUNIT,   -- Break Time Unit [DZEIER]
    BUSINESSPROCESS,                 -- Business Process [CO_PRZNR]
    LEADTIMEREDUCTIONSTRATEGY,       -- Red. Strategy [RSTRA]
    TEARDOWNANDWAITISPARALLEL,       -- Teardown/Wait Par. [ABLIPKZ]
    MINIMUMWAITDURATION,             -- Min. Wait Time [DZLPRO]
    MINIMUMWAITDURATIONUNIT,         -- Req. Wait Unit [DZEILP]
    MAXIMUMWAITDURATION,             -- Max. Wait Time [DZLMAX]
    MAXIMUMWAITDURATIONUNIT,         -- Max. Wait Unit [DZEILM]
    MINIMUMQUEUEDURATION,            -- Min. Queue Time [DZWMIN]
    MINIMUMQUEUEDURATIONUNIT,        -- Min. Queue Unit [DZEIWM]
    STANDARDQUEUEDURATION,           -- Std Queue Time [DZWNOR]
    STANDARDQUEUEDURATIONUNIT,       -- Std Queue Unit [DZEIWN]
    MINIMUMMOVEDURATION,             -- Min. Move Time [DZTMIN]
    MINIMUMMOVEDURATIONUNIT,         -- MinMoveTime Un [DZEITM]
    STANDARDMOVEDURATION,            -- Std Move Time [DZTNOR]
    STANDARDMOVEDURATIONUNIT,        -- StdMoveTime Un [DZEITN]
    WORKCENTERSTANDARDQUEUEDURN,     -- Min. Queue Time [DZWMIN]
    WORKCENTERSTDQUEUEDURNUNIT,      -- Std Queue Unit [DZEIWN]
    WORKCENTERMINIMUMQUEUEDURATION,  -- Min. Queue Time [DZWMIN]
    WORKCENTERMINIMUMQUEUEDURNUNIT,  -- Std Queue Unit [DZEIWN]
    OPERATIONSPLITISREQUIRED,        -- Splitting Reqd [SPLITTUNG]
    MAXIMUMNUMBEROFSPLITS,           -- Maximum Splits [MAXIMUMNUMBEROFSPLITS]
    MINPROCESSINGDURATIONPERSPLIT,   -- Min. Proc. Time [DZMINB]
    MINPROCESSINGDURNPERSPLITUNIT,   -- Min. Proc. Time [DZEIMB]
    BOOOPERATIONOVERLAPPING,         -- Overlapping [MPE_RTG_OP_OVERLAPPING]
    OVERLAPMINIMUMDURATION,          -- Minimum Overlap [DZMINU]
    OVERLAPMINIMUMDURATIONUNIT,      -- Min.Overlap Tme [DZEIMU]
    OVERLAPMINIMUMTRANSFERQTY,       -- Min. Send-Ahead [MINWEI]
    OVERLAPMINIMUMTRANSFERQTYUNIT,   -- Act/op UoM [VORME]
    OPERATIONSCRAPPERCENT,           -- Scrap [AUSCHUFAK]
    NUMBEROFTIMETICKETS,             -- No.TimeTickets [LOHNANZ]
    NUMBEROFCONFIRMATIONSLIPS,       -- No. of Conf. Slips [CR_RS_ANZ]
    EMPLOYEEWAGEGROUP,               -- Wage Group [LOHNGRP]
    EMPLOYEEWAGETYPE,                -- Wage type [LOHNART]
    NUMBEROFEMPLOYEES,               -- No. employees [ANZMS]
    OPERATIONSETUPTYPE,              -- Setup Type Key [RUEARSCHLU]
    OPERATIONSETUPGROUPCATEGORY,     -- Setup group cat [RUEFAGRP]
    OPERATIONSETUPGROUP,             -- Setup group key [RUEFASCHLU]
    OPERATIONCOSTINGRELEVANCYTYPE,   -- Operation Costing Relevancy Type [OPERATIONCOSTINGRELEVANCYTYPE]
    NMBROFTIMETICKETSISREFERENCED,   -- No. Time Ticktes Ref [LOANZ_REF]
    NUMBEROFCONFSLIPSISREFERENCED,   -- No. Conf. Slips Ref. [RSANZ_REF]
    EMPLOYEEWAGEGROUPISREFERENCED,   -- Wage Group Ref. [LOGRP_REF]
    EMPLOYEEWAGETYPEISREFERENCED,    -- Wage Type Ref. [LOART_REF]
    WORKCENTERSETPTYPEISREFERENCED,  -- Setup Type Ref. [RASCH_REF]
    STANDARDWORKFORMULAPARAMNAME1,   -- abap.char
    STANDARDWORKFORMULAPARAMNAME2,   -- abap.char
    STANDARDWORKFORMULAPARAMNAME3,   -- abap.char
    STANDARDWORKFORMULAPARAMNAME4,   -- abap.char
    STANDARDWORKFORMULAPARAMNAME5,   -- abap.char
    STANDARDWORKFORMULAPARAMNAME6,   -- abap.char
    STANDARDWORKQUANTITY1,           -- Standard Value [VGWRT]
    STANDARDWORKQUANTITY2,           -- Standard Value [VGWRT]
    STANDARDWORKQUANTITY3,           -- Standard Value [VGWRT]
    STANDARDWORKQUANTITY4,           -- Standard Value [VGWRT]
    STANDARDWORKQUANTITY5,           -- Standard Value [VGWRT]
    STANDARDWORKQUANTITY6,           -- Standard Value [VGWRT]
    STANDARDWORKQUANTITYUNIT1,       -- Std value unit [VGWRTEH]
    STANDARDWORKQUANTITYUNIT2,       -- Std value unit [VGWRTEH]
    STANDARDWORKQUANTITYUNIT3,       -- Std value unit [VGWRTEH]
    STANDARDWORKQUANTITYUNIT4,       -- Std value unit [VGWRTEH]
    STANDARDWORKQUANTITYUNIT5,       -- Std value unit [VGWRTEH]
    STANDARDWORKQUANTITYUNIT6,       -- Std value unit [VGWRTEH]
    COSTCTRACTIVITYTYPE1,            -- Activity Type [LSTAR]
    COSTCTRACTIVITYTYPE2,            -- Activity Type [LSTAR]
    COSTCTRACTIVITYTYPE3,            -- Activity Type [LSTAR]
    COSTCTRACTIVITYTYPE4,            -- Activity Type [LSTAR]
    COSTCTRACTIVITYTYPE5,            -- Activity Type [LSTAR]
    COSTCTRACTIVITYTYPE6,            -- Activity Type [LSTAR]
    COSTCTRACTYTYPE1ISREFERENCED,    -- Reference ind. [AP_KZREF]
    COSTCTRACTYTYPE2ISREFERENCED,    -- Reference ind. [AP_KZREF]
    COSTCTRACTYTYPE3ISREFERENCED,    -- Reference ind. [AP_KZREF]
    COSTCTRACTYTYPE4ISREFERENCED,    -- Reference ind. [AP_KZREF]
    COSTCTRACTYTYPE5ISREFERENCED,    -- Reference ind. [AP_KZREF]
    COSTCTRACTYTYPE6ISREFERENCED,    -- Reference ind. [AP_KZREF]
    PURCHASINGINFORECORD,            -- Info record [INFNR]
    PURCHASECONTRACT,                -- Purchasing Doc. [EBELN]
    PURCHASINGINFORECDADDLGRPGNAME,  -- Sort Term [SORTI]
    MATERIALGROUP,                   -- Material Group [MATKL]
    PURCHASINGGROUP,                 -- Purch. Group [VG_EKGRP]
    SUPPLIER,                        -- Supplier [LIFNR]
    PLANNEDDELIVERYDURATION,         -- Pl. Deliv. Time [PLIFZ]
    NUMBEROFOPERATIONPRICEUNITS,     -- Price unit [EPEIN]
    OPEXTERNALPROCESSINGPRICE,       -- Net Price [IPREI]
    INSPECTIONLOTTYPE,               -- Inspection Type [QPART]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [EKORG]
    PURCHASECONTRACTITEM,            -- Item [EBELP]
    COSTELEMENT,                     -- Cost Element [KSTAR]
    OPEXTERNALPROCESSINGCURRENCY,    -- Currency [WAERS]
    GOODSRECIPIENTNAME,              -- Recipient [WEMPF]
    UNLOADINGPOINTNAME,              -- Unloading Point [ABLAD]
    SHOPFLOORROUTINGTEMPLATETYPE,    -- Template Type [MPE_RTG_REF_TEMPLATE_TYPE]
    SHOPFLOORRTGTEMPLATEGROUP,       -- Template Group [MPE_RTG_REFT_GROUP]
    SHOPFLOORRTGTEMPLATEGRPVARIANT,  -- Group Counter [MPE_RTG_REFT_VARIANT]
    SHOPFLOORRTGTEMPLATEVERSION,     -- Template Versn [MPE_RTG_REFT_VERSION]
    CHANGENUMBER,                    -- Change Number [CHANGENUMBER]
    PARAMEFFCTYOBJECTREFERENCEKEY,   -- Logical System [CHAR60]
    PARAMEFFCTYPARENTOBJREFKEY,      -- Logical System [CHAR60]
    PARAMEFFCTYOBJECTTYPE,           -- Char20 [CHAR20]
    CREATEDBYUSER,                   -- Created By [VDM_CREATEDBYUSERID]
    CREATIONDATE,                    -- Created On [ANDAT]
    LASTCHANGEDBYUSER,               -- Changed By [VDM_LASTCHANGEDBYUSERID]
    LASTCHANGEDATE,                  -- Changed On [AEDAT]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, PRODUCTIONMODELUUID, BILLOFOPERATIONSVERSION, BOOOPERATIONINTERNALID, DRAFTUUID)
);

Learn More