What is I_ProdnModOperationDraft in SAP S/4HANA?

I_ProdnModOperationDraft is a basic CDS view in SAP S/4HANA. Production Model Operation - Draft It contains 128 fields.

Which tables does I_ProdnModOperationDraft read from?

I_ProdnModOperationDraft reads data from: mpe_pmdl_op_d.

What VDM layer is I_ProdnModOperationDraft?

I_ProdnModOperationDraft is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_ProdnModOperationDraft

DDL: I_PRODNMODOPERATIONDRAFT Type: view_entity BASIC

128 Fields 1 Data Sources

Production Model Operation - Draft

I_ProdnModOperationDraft is a Basic CDS View that provides data about "Production Model Operation - Draft" in SAP S/4HANA. It reads from 1 data source (mpe_pmdl_op_d) and exposes 128 fields with key fields ProductionModelUUID, BillOfOperationsVersion, BOOOperationInternalID, DraftUUID.

Data Sources (1)

Source	Alias	Join Type
mpe_pmdl_op_d	mpe_pmdl_op_d	from

Annotations (8)

Name	Value	Level
EndUserText.label	Production Model Operation - Draft	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
AccessControl.personalData.blocking	#REQUIRED	view
VDM.viewType	#BASIC	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view

Fields (128)

Key	Field	Source Field	Description
KEY	ProductionModelUUID	productionmodeluuid	Prodn Model UUID
KEY	BillOfOperationsVersion	billofoperationsversion	Routing Version
KEY	BOOOperationInternalID	boooperationinternalid	Task list node
KEY	DraftUUID	draftuuid	UUID
	BOOOpInternalVersionCounter	booopinternalversioncounter	Counter
	BillOfMaterialCategory	billofmaterialcategory	BOM category
	Material	material	Vehicle Model
	Plant	plant	Valuation Area
	BillOfMaterialVariantUsage	billofmaterialvariantusage	Usage
	BillOfMaterial	billofmaterial	BOM
	BillOfMaterialVariant	billofmaterialvariant	AlternativeBOM
	BillOfOperationsType	billofoperationstype	Task List Type
	BillOfOperationsGroup	billofoperationsgroup	Group
	BillOfOperationsVariant	billofoperationsvariant	Group Counter
	BillOfOperationsSequence	billofoperationssequence	Sequence
	BOOSqncInternalVersionCounter	boosqncinternalversioncounter	Counter
	OperationExternalID	operationexternalid	Ext. Oper. ID
	Operation	operation	Transaction
	OperationText	operationtext	Description
	LongTextLanguageCode	longtextlanguagecode	Language
	WorkCenter	workcenter	Work Center
	BOOOperationPlant	boooperationplant	Plant
	OperationControlProfile	operationcontrolprofile	Control Key
	OperationReferenceQuantity	operationreferencequantity	Base Quantity
	OperationUnit	operationunit	Act/op UoM
	BillOfOperationsBreakDuration	billofoperationsbreakduration	Break Time
	BillOfOperationsBreakDurnUnit	billofoperationsbreakdurnunit	Break Time Unit
	BusinessProcess	businessprocess	Business Process
	LeadTimeReductionStrategy	leadtimereductionstrategy	Red. Strategy
	TeardownAndWaitIsParallel	teardownandwaitisparallel	Teardown/Wait Par.
	MinimumWaitDuration	minimumwaitduration	Min. Wait Time
	MinimumWaitDurationUnit	minimumwaitdurationunit	Req. Wait Unit
	MaximumWaitDuration	maximumwaitduration	Max. Wait Time
	MaximumWaitDurationUnit	maximumwaitdurationunit	Max. Wait Unit
	MinimumQueueDuration	minimumqueueduration	Min. Queue Time
	MinimumQueueDurationUnit	minimumqueuedurationunit	Min. Queue Unit
	StandardQueueDuration	standardqueueduration	Std Queue Time
	StandardQueueDurationUnit	standardqueuedurationunit	Std Queue Unit
	MinimumMoveDuration	minimummoveduration	Min. Move Time
	MinimumMoveDurationUnit	minimummovedurationunit	MinMoveTime Un
	StandardMoveDuration	standardmoveduration	Std Move Time
	StandardMoveDurationUnit	standardmovedurationunit	StdMoveTime Un
	WorkCenterStandardQueueDurn	workcenterstandardqueuedurn	Min. Queue Time
	WorkCenterStdQueueDurnUnit	workcenterstdqueuedurnunit	Std Queue Unit
	WorkCenterMinimumQueueDuration	workcenterminimumqueueduration	Min. Queue Time
	WorkCenterMinimumQueueDurnUnit	workcenterminimumqueuedurnunit	Std Queue Unit
	OperationSplitIsRequired	operationsplitisrequired	Splitting Reqd
	MaximumNumberOfSplits	maximumnumberofsplits	Maximum Splits
	MinProcessingDurationPerSplit	minprocessingdurationpersplit	Min. Proc. Time
	MinProcessingDurnPerSplitUnit	minprocessingdurnpersplitunit	Min. Proc. Time
	BOOOperationOverlapping	boooperationoverlapping	Overlapping
	OverlapMinimumDuration	overlapminimumduration	Minimum Overlap
	OverlapMinimumDurationUnit	overlapminimumdurationunit	Min.Overlap Tme
	OverlapMinimumTransferQty	overlapminimumtransferqty	Min. Send-Ahead
	OverlapMinimumTransferQtyUnit	overlapminimumtransferqtyunit	Act/op UoM
	OperationScrapPercent	operationscrappercent	Scrap
	NumberOfTimeTickets	numberoftimetickets	No.TimeTickets
	NumberOfConfirmationSlips	numberofconfirmationslips	No. of Conf. Slips
	EmployeeWageGroup	employeewagegroup	Wage Group
	EmployeeWageType	employeewagetype	Wage type
	NumberOfEmployees	numberofemployees	No. employees
	OperationSetupType	operationsetuptype	Setup Type Key
	OperationSetupGroupCategory	operationsetupgroupcategory	Setup group cat
	OperationSetupGroup	operationsetupgroup	Setup group key
	OperationCostingRelevancyType	operationcostingrelevancytype	Operation Costing Relevancy Type
	NmbrOfTimeTicketsIsReferenced	nmbroftimeticketsisreferenced	No. Time Ticktes Ref
	NumberOfConfSlipsIsReferenced	numberofconfslipsisreferenced	No. Conf. Slips Ref.
	EmployeeWageGroupIsReferenced	employeewagegroupisreferenced	Wage Group Ref.
	EmployeeWageTypeIsReferenced	employeewagetypeisreferenced	Wage Type Ref.
	WorkCenterSetpTypeIsReferenced	workcentersetptypeisreferenced	Setup Type Ref.
	StandardWorkFormulaParamName1	standardworkformulaparamname1
	StandardWorkFormulaParamName2	standardworkformulaparamname2
	StandardWorkFormulaParamName3	standardworkformulaparamname3
	StandardWorkFormulaParamName4	standardworkformulaparamname4
	StandardWorkFormulaParamName5	standardworkformulaparamname5
	StandardWorkFormulaParamName6	standardworkformulaparamname6
	StandardWorkQuantity1	standardworkquantity1	Standard Value
	StandardWorkQuantity2	standardworkquantity2	Standard Value
	StandardWorkQuantity3	standardworkquantity3	Standard Value
	StandardWorkQuantity4	standardworkquantity4	Standard Value
	StandardWorkQuantity5	standardworkquantity5	Standard Value
	StandardWorkQuantity6	standardworkquantity6	Standard Value
	StandardWorkQuantityUnit1	standardworkquantityunit1	Std value unit
	StandardWorkQuantityUnit2	standardworkquantityunit2	Std value unit
	StandardWorkQuantityUnit3	standardworkquantityunit3	Std value unit
	StandardWorkQuantityUnit4	standardworkquantityunit4	Std value unit
	StandardWorkQuantityUnit5	standardworkquantityunit5	Std value unit
	StandardWorkQuantityUnit6	standardworkquantityunit6	Std value unit
	CostCtrActivityType1	costctractivitytype1	Activity Type
	CostCtrActivityType2	costctractivitytype2	Activity Type
	CostCtrActivityType3	costctractivitytype3	Activity Type
	CostCtrActivityType4	costctractivitytype4	Activity Type
	CostCtrActivityType5	costctractivitytype5	Activity Type
	CostCtrActivityType6	costctractivitytype6	Activity Type
	CostCtrActyType1IsReferenced	costctractytype1isreferenced	Reference ind.
	CostCtrActyType2IsReferenced	costctractytype2isreferenced	Reference ind.
	CostCtrActyType3IsReferenced	costctractytype3isreferenced	Reference ind.
	CostCtrActyType4IsReferenced	costctractytype4isreferenced	Reference ind.
	CostCtrActyType5IsReferenced	costctractytype5isreferenced	Reference ind.
	CostCtrActyType6IsReferenced	costctractytype6isreferenced	Reference ind.
	PurchasingInfoRecord	purchasinginforecord	Info Record
	PurchaseContract	purchasecontract	Purchasing Doc.
	PurchasingInfoRecdAddlGrpgName	purchasinginforecdaddlgrpgname	Sort Term
	MaterialGroup	materialgroup	Product Group
	PurchasingGroup	purchasinggroup	Purchasing Group
	Supplier	supplier	Supplier
	PlannedDeliveryDuration	planneddeliveryduration	Pl. Deliv. Time
	NumberOfOperationPriceUnits	numberofoperationpriceunits	Price Unit
	OpExternalProcessingPrice	opexternalprocessingprice	Price
	InspectionLotType	inspectionlottype	Inspection Type
	PurchasingOrganization	purchasingorganization	Purchasing Organization
	PurchaseContractItem	purchasecontractitem	Item
	CostElement	costelement	G/L Account
	OpExternalProcessingCurrency	opexternalprocessingcurrency	Currency
	GoodsRecipientName	goodsrecipientname	Recipient Name
	UnloadingPointName	unloadingpointname	Unloading Point Name
	ShopFloorRoutingTemplateType	shopfloorroutingtemplatetype	Template Type
	ShopFloorRtgTemplateGroup	shopfloorrtgtemplategroup	Template Group
	ShopFloorRtgTemplateGrpVariant	shopfloorrtgtemplategrpvariant	Group Counter
	ShopFloorRtgTemplateVersion	shopfloorrtgtemplateversion	Template Versn
	ChangeNumber	changenumber	Change Number
	ParamEffctyObjectReferenceKey	parameffctyobjectreferencekey	Logical System
	ParamEffctyParentObjRefKey	parameffctyparentobjrefkey	Logical System
	ParamEffctyObjectType	parameffctyobjecttype	Char20
	CreatedByUser	createdbyuser	User Name
	CreationDate	creationdate	Time Stamp
	LastChangedByUser	lastchangedbyuser	User Name
	LastChangeDate	lastchangedate	Time Stamp

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ProdnModOperationDraft.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ProdnModOperationDraft AS
SELECT
  ProductionModelUUID,
  BillOfOperationsVersion,
  BOOOperationInternalID,
  DraftUUID,
  BOOOpInternalVersionCounter,
  BillOfMaterialCategory,
  Material,
  Plant,
  BillOfMaterialVariantUsage,
  BillOfMaterial,
  BillOfMaterialVariant,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsSequence,
  BOOSqncInternalVersionCounter,
  OperationExternalID,
  Operation,
  OperationText,
  LongTextLanguageCode,
  WorkCenter,
  BOOOperationPlant,
  OperationControlProfile,
  OperationReferenceQuantity,
  OperationUnit,
  BillOfOperationsBreakDuration,
  BillOfOperationsBreakDurnUnit,
  BusinessProcess,
  LeadTimeReductionStrategy,
  TeardownAndWaitIsParallel,
  MinimumWaitDuration,
  MinimumWaitDurationUnit,
  MaximumWaitDuration,
  MaximumWaitDurationUnit,
  MinimumQueueDuration,
  MinimumQueueDurationUnit,
  StandardQueueDuration,
  StandardQueueDurationUnit,
  MinimumMoveDuration,
  MinimumMoveDurationUnit,
  StandardMoveDuration,
  StandardMoveDurationUnit,
  WorkCenterStandardQueueDurn,
  WorkCenterStdQueueDurnUnit,
  WorkCenterMinimumQueueDuration,
  WorkCenterMinimumQueueDurnUnit,
  OperationSplitIsRequired,
  MaximumNumberOfSplits,
  MinProcessingDurationPerSplit,
  MinProcessingDurnPerSplitUnit,
  BOOOperationOverlapping,
  OverlapMinimumDuration,
  OverlapMinimumDurationUnit,
  OverlapMinimumTransferQty,
  OverlapMinimumTransferQtyUnit,
  OperationScrapPercent,
  NumberOfTimeTickets,
  NumberOfConfirmationSlips,
  EmployeeWageGroup,
  EmployeeWageType,
  NumberOfEmployees,
  OperationSetupType,
  OperationSetupGroupCategory,
  OperationSetupGroup,
  OperationCostingRelevancyType,
  NmbrOfTimeTicketsIsReferenced,
  NumberOfConfSlipsIsReferenced,
  EmployeeWageGroupIsReferenced,
  EmployeeWageTypeIsReferenced,
  WorkCenterSetpTypeIsReferenced,
  StandardWorkFormulaParamName1,
  StandardWorkFormulaParamName2,
  StandardWorkFormulaParamName3,
  StandardWorkFormulaParamName4,
  StandardWorkFormulaParamName5,
  StandardWorkFormulaParamName6,
  StandardWorkQuantity1,
  StandardWorkQuantity2,
  StandardWorkQuantity3,
  StandardWorkQuantity4,
  StandardWorkQuantity5,
  StandardWorkQuantity6,
  StandardWorkQuantityUnit1,
  StandardWorkQuantityUnit2,
  StandardWorkQuantityUnit3,
  StandardWorkQuantityUnit4,
  StandardWorkQuantityUnit5,
  StandardWorkQuantityUnit6,
  CostCtrActivityType1,
  CostCtrActivityType2,
  CostCtrActivityType3,
  CostCtrActivityType4,
  CostCtrActivityType5,
  CostCtrActivityType6,
  CostCtrActyType1IsReferenced,
  CostCtrActyType2IsReferenced,
  CostCtrActyType3IsReferenced,
  CostCtrActyType4IsReferenced,
  CostCtrActyType5IsReferenced,
  CostCtrActyType6IsReferenced,
  PurchasingInfoRecord,
  PurchaseContract,
  PurchasingInfoRecdAddlGrpgName,
  MaterialGroup,
  PurchasingGroup,
  Supplier,
  PlannedDeliveryDuration,
  NumberOfOperationPriceUnits,
  OpExternalProcessingPrice,
  InspectionLotType,
  PurchasingOrganization,
  PurchaseContractItem,
  CostElement,
  OpExternalProcessingCurrency,
  GoodsRecipientName,
  UnloadingPointName,
  ShopFloorRoutingTemplateType,
  ShopFloorRtgTemplateGroup,
  ShopFloorRtgTemplateGrpVariant,
  ShopFloorRtgTemplateVersion,
  ChangeNumber,
  ParamEffctyObjectReferenceKey,
  ParamEffctyParentObjRefKey,
  ParamEffctyObjectType,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate
FROM mpe_pmdl_op_d
;

Depth:

I_ProdnModOperationDraft view_entity

mpe_pmdl_op_d

C_ProdnModOperationDraftVH view_entity