What is C_MatlProdnModOperationTP in SAP S/4HANA?

C_MatlProdnModOperationTP is a consumption CDS view in SAP S/4HANA. Matl Prodn Model Operation It contains 119 fields.

Which tables does C_MatlProdnModOperationTP read from?

C_MatlProdnModOperationTP reads data from: R_ProductionModelOperationTP.

What VDM layer is C_MatlProdnModOperationTP?

C_MatlProdnModOperationTP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_MatlProdnModOperationTP

DDL: C_MATLPRODNMODOPERATIONTP Type: view_entity CONSUMPTION

119 Fields 1 Data Sources 1 Associations

Matl Prodn Model Operation

C_MatlProdnModOperationTP is a Consumption CDS View that provides data about "Matl Prodn Model Operation" in SAP S/4HANA. It reads from 1 data source (R_ProductionModelOperationTP) and exposes 119 fields with key fields ProductionModelUUID, BillOfOperationsVersion, BOOOperationInternalID. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
R_ProductionModelOperationTP	R_ProductionModelOperationTP	projection

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	C_ProdnModOpInstcAggrgd	_ProdnModOpInstcAggrgd	`$projection.ProductionModelUUID = _ProdnModOpInstcAggrgd.ProductionModelUUID and $projection.BillOfOperationsVersion = _ProdnModOpInstcAggrgd.BillOfOperationsVersion and $projection.BOOOperationInternalID = _ProdnModOpInstcAggrgd.BOOOperationInternalID`

Annotations (11)

Name	Value	Level
EndUserText.label	Matl Prodn Model Operation	view
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.modelingPattern	#TRANSACTIONAL_QUERY	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
UI.deleteHidden	true	view
UI.headerInfo.typeName	Operation	view
UI.headerInfo.typeNamePlural	Operations	view
UI.headerInfo.title.value	OperationText	view

Fields (119)

Key	Field	Source Table	Source Field	Description
KEY	ProductionModelUUID		ProductionModelUUID	Prodn Model UUID
KEY	BillOfOperationsVersion		BillOfOperationsVersion	Routing Version
KEY	BOOOperationInternalID		BOOOperationInternalID	Task list node
	BOOOpInternalVersionCounter		BOOOpInternalVersionCounter	Counter
	BillOfMaterialCategory		BillOfMaterialCategory	BOM category
	BillOfMaterialVariantUsage		BillOfMaterialVariantUsage	Usage
	Plant		Plant	Valuation Area
	BillOfOperationsType		BillOfOperationsType	Task List Type
	OperationExternalID		OperationExternalID	Ext. Oper. ID
	Operation		Operation	Transaction
	OperationText		OperationText	Description
	LongTextLanguageCode		LongTextLanguageCode	Language
	BOOOperationPlant		BOOOperationPlant	Plant
	WorkCenter		WorkCenter	Work Center
	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
	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
	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
	PurchasingInfoRecord		PurchasingInfoRecord	Info Record
	PurchaseContract		PurchaseContract	Outline Agreement
	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 in Outline Agreement
	GoodsRecipientName		GoodsRecipientName	Recipient Name
	UnloadingPointName		UnloadingPointName	Unloading Point Name
	CostElement		CostElement	G/L Account
	OpExternalProcessingCurrency		OpExternalProcessingCurrency	Currency
	ShopFloorRoutingTemplateType		ShopFloorRoutingTemplateType	Template Type
	ShopFloorRtgTemplateGroup		ShopFloorRtgTemplateGroup	Template Group
	ShopFloorRtgTemplateGrpVariant		ShopFloorRtgTemplateGrpVariant	Group Counter
	ShopFloorRtgTemplateVersion		ShopFloorRtgTemplateVersion	Template Versn
	_ProdnModOpInstcAggrgd		_ProdnModOpInstcAggrgd
	LastChangedByUserDescription	_ChangedByUser	UserDescription	Full Name
	OperationControlProfileName	_ControlProfileText	OperationControlProfileName
	CostingRelevantDescription	_CostRelevancyText	CostingRelevantDescription
	CreatedByUserDescription	_CreatedByUser	UserDescription	Full Name
	EmployeeWageGroupName	_EmployeeWageGroupText	EmployeeWageGroupName
	InspectionLotTypeText	_InspectionLotTypeText	InspectionLotTypeText
	LeadTimeReductionStrategyName	_LeadTimeReductionStrategyText	LeadTimeReductionStrategyName
	OperationSetupGroupCatName	_OperationSetupGroupCatText	OperationSetupGroupCatName
	OperationSetupGroupName	_OperationSetupGroupText	OperationSetupGroupName
	OperationSetupTypeName	_OperationSetupTypeText	OperationSetupTypeName
	CurrencyShortName	_OpExtProcessingCurrencyText	CurrencyShortName
	PlantName	_Plant	PlantName	Plant Name
	BOOOperationOverlappingText	_ProdnModelBOOOpOvrlpngText	BOOOperationOverlappingText
	PurchasingGroupName	_PurchasingGroupText	PurchasingGroupName	Purchasing Grp. Name
	PurchasingOrganizationName	_PurchasingOrganization	PurchasingOrganizationName	Purch. Org. Name
	SupplierName	_Supplier	SupplierName	Supplier Name
	WorkCenterText	_WorkCenterText	WorkCenterText	Work Center Text

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 C_MatlProdnModOperationTP.
-- 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 C_MatlProdnModOperationTP AS
SELECT
  ProductionModelUUID,
  BillOfOperationsVersion,
  BOOOperationInternalID,
  BOOOpInternalVersionCounter,
  BillOfMaterialCategory,
  BillOfMaterialVariantUsage,
  Plant,
  BillOfOperationsType,
  OperationExternalID,
  Operation,
  OperationText,
  LongTextLanguageCode,
  BOOOperationPlant,
  WorkCenter,
  OperationControlProfile,
  OperationReferenceQuantity,
  OperationUnit,
  BillOfOperationsBreakDuration,
  BillOfOperationsBreakDurnUnit,
  BusinessProcess,
  StandardWorkFormulaParamName1,
  StandardWorkFormulaParamName2,
  StandardWorkFormulaParamName3,
  StandardWorkFormulaParamName4,
  StandardWorkFormulaParamName5,
  StandardWorkFormulaParamName6,
  StandardWorkQuantity1,
  StandardWorkQuantity2,
  StandardWorkQuantity3,
  StandardWorkQuantity4,
  StandardWorkQuantity5,
  StandardWorkQuantity6,
  StandardWorkQuantityUnit1,
  StandardWorkQuantityUnit2,
  StandardWorkQuantityUnit3,
  StandardWorkQuantityUnit4,
  StandardWorkQuantityUnit5,
  StandardWorkQuantityUnit6,
  CostCtrActivityType1,
  CostCtrActivityType2,
  CostCtrActivityType3,
  CostCtrActivityType4,
  CostCtrActivityType5,
  CostCtrActivityType6,
  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,
  PurchasingInfoRecord,
  PurchaseContract,
  PurchasingInfoRecdAddlGrpgName,
  MaterialGroup,
  PurchasingGroup,
  Supplier,
  PlannedDeliveryDuration,
  NumberOfOperationPriceUnits,
  OpExternalProcessingPrice,
  InspectionLotType,
  PurchasingOrganization,
  PurchaseContractItem,
  GoodsRecipientName,
  UnloadingPointName,
  CostElement,
  OpExternalProcessingCurrency,
  ShopFloorRoutingTemplateType,
  ShopFloorRtgTemplateGroup,
  ShopFloorRtgTemplateGrpVariant,
  ShopFloorRtgTemplateVersion,
  _ChangedByUser.UserDescription AS LastChangedByUserDescription,
  _ControlProfileText.OperationControlProfileName AS OperationControlProfileName,
  _CostRelevancyText.CostingRelevantDescription AS CostingRelevantDescription,
  _CreatedByUser.UserDescription AS CreatedByUserDescription,
  _EmployeeWageGroupText.EmployeeWageGroupName AS EmployeeWageGroupName,
  _InspectionLotTypeText.InspectionLotTypeText AS InspectionLotTypeText,
  _LeadTimeReductionStrategyText.LeadTimeReductionStrategyName AS LeadTimeReductionStrategyName,
  _OperationSetupGroupCatText.OperationSetupGroupCatName AS OperationSetupGroupCatName,
  _OperationSetupGroupText.OperationSetupGroupName AS OperationSetupGroupName,
  _OperationSetupTypeText.OperationSetupTypeName AS OperationSetupTypeName,
  _OpExtProcessingCurrencyText.CurrencyShortName AS CurrencyShortName,
  _Plant.PlantName AS PlantName,
  _ProdnModelBOOOpOvrlpngText.BOOOperationOverlappingText AS BOOOperationOverlappingText,
  _PurchasingGroupText.PurchasingGroupName AS PurchasingGroupName,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _Supplier.SupplierName AS SupplierName,
  _WorkCenterText.WorkCenterText AS WorkCenterText
FROM R_ProductionModelOperationTP
LEFT OUTER JOIN C_ProdnModOpInstcAggrgd AS _ProdnModOpInstcAggrgd ON ProductionModelUUID = _ProdnModOpInstcAggrgd.ProductionModelUUID AND BillOfOperationsVersion = _ProdnModOpInstcAggrgd.BillOfOperationsVersion AND BOOOperationInternalID = _ProdnModOpInstcAggrgd.BOOOperationInternalID  -- association [0..*]
;

Depth:

C_MatlProdnModOperationTP view_entity

R_ProductionModelOperationTP view_entity