What is C_SlsOrdProdnModOperationTP in SAP S/4HANA?

C_SlsOrdProdnModOperationTP is a consumption CDS view in SAP S/4HANA. Sls Ord Prodn Model Operation It contains 119 fields.

Which tables does C_SlsOrdProdnModOperationTP read from?

C_SlsOrdProdnModOperationTP reads data from: R_ProductionModelOperationTP.

What VDM layer is C_SlsOrdProdnModOperationTP?

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

C_SlsOrdProdnModOperationTP

DDL: C_SLSORDPRODNMODOPERATIONTP Type: view_entity CONSUMPTION

119 Fields 1 Data Sources 1 Associations 1 OData Services

Sls Ord Prodn Model Operation

C_SlsOrdProdnModOperationTP is a Consumption CDS View that provides data about "Sls Ord 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. It is exposed through 1 OData service (UI_SLSORD_PRODNMODEL_MANAGE).

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	Sls Ord 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

OData Services (1)

Service	Binding	Version	Contract	Release
UI_SLSORD_PRODNMODEL_MANAGE	UI_SLSORD_PRODNMODEL_MANAGE	V4	C1	NOT_RELEASED

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
	PlantName	_Plant	PlantName	Plant Name
	WorkCenter		WorkCenter	Work Center
	WorkCenterText	_WorkCenterText	WorkCenterText	Work Center Text
	OperationControlProfile		OperationControlProfile	Control Key
	OperationControlProfileName	_ControlProfileText	OperationControlProfileName
	OperationReferenceQuantity		OperationReferenceQuantity	Base Quantity
	OperationUnit		OperationUnit	Act/op UoM
	BillOfOperationsBreakDuration		BillOfOperationsBreakDuration	Break Time
	BillOfOperationsBreakDurnUnit		BillOfOperationsBreakDurnUnit	Break Time Unit
	BusinessProcess		BusinessProcess	Business Process
	ShopFloorRoutingTemplateType		ShopFloorRoutingTemplateType	Template Type
	ShopFloorRtgTemplateGroup		ShopFloorRtgTemplateGroup	Template Group
	ShopFloorRtgTemplateGrpVariant		ShopFloorRtgTemplateGrpVariant	Group Counter
	ShopFloorRtgTemplateVersion		ShopFloorRtgTemplateVersion	Template Versn
	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
	LeadTimeReductionStrategyName	_LeadTimeReductionStrategyText	LeadTimeReductionStrategyName
	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
	BOOOperationOverlappingText	_ProdnModelBOOOpOvrlpngText	BOOOperationOverlappingText
	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
	EmployeeWageGroupName	_EmployeeWageGroupText	EmployeeWageGroupName
	EmployeeWageType		EmployeeWageType	Wage type
	NumberOfEmployees		NumberOfEmployees	No. employees
	OperationSetupType		OperationSetupType	Setup Type Key
	OperationSetupTypeName	_OperationSetupTypeText	OperationSetupTypeName
	OperationSetupGroupCategory		OperationSetupGroupCategory	Setup group cat
	OperationSetupGroupCatName	_OperationSetupGroupCatText	OperationSetupGroupCatName
	OperationSetupGroup		OperationSetupGroup	Setup group key
	OperationSetupGroupName	_OperationSetupGroupText	OperationSetupGroupName
	OperationCostingRelevancyType		OperationCostingRelevancyType	Operation Costing Relevancy Type
	CostingRelevantDescription	_CostRelevancyText	CostingRelevantDescription
	PurchasingInfoRecord		PurchasingInfoRecord	Info Record
	PurchaseContract		PurchaseContract	Outline Agreement
	PurchasingInfoRecdAddlGrpgName		PurchasingInfoRecdAddlGrpgName	Sort Term
	MaterialGroup		MaterialGroup	Product Group
	PurchasingGroup		PurchasingGroup	Purchasing Group
	PurchasingGroupName	_PurchasingGroupText	PurchasingGroupName	Purchasing Grp. Name
	Supplier		Supplier	Supplier
	SupplierName	_Supplier	SupplierName	Supplier Name
	PlannedDeliveryDuration		PlannedDeliveryDuration	Pl. Deliv. Time
	NumberOfOperationPriceUnits		NumberOfOperationPriceUnits	Price Unit
	OpExternalProcessingPrice		OpExternalProcessingPrice	Price
	InspectionLotType		InspectionLotType	Inspection Type
	InspectionLotTypeText	_InspectionLotTypeText	InspectionLotTypeText
	PurchasingOrganization		PurchasingOrganization	Purchasing Organization
	PurchasingOrganizationName	_PurchasingOrganization	PurchasingOrganizationName	Purch. Org. Name
	PurchaseContractItem		PurchaseContractItem	Item in Outline Agreement
	GoodsRecipientName		GoodsRecipientName	Recipient Name
	UnloadingPointName		UnloadingPointName	Unloading Point Name
	CostElement		CostElement	G/L Account
	OpExternalProcessingCurrency		OpExternalProcessingCurrency	Currency
	CurrencyShortName	_OpExtProcessingCurrencyText	CurrencyShortName
	CreatedByUserDescription	_CreatedByUser	UserDescription	Full Name
	LastChangedByUserDescription	_ChangedByUser	UserDescription	Full Name
	_ProdnModOpInstcAggrgd		_ProdnModOpInstcAggrgd

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_SlsOrdProdnModOperationTP.
-- 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_SlsOrdProdnModOperationTP AS
SELECT
  ProductionModelUUID,
  BillOfOperationsVersion,
  BOOOperationInternalID,
  BOOOpInternalVersionCounter,
  BillOfMaterialCategory,
  BillOfMaterialVariantUsage,
  Plant,
  BillOfOperationsType,
  OperationExternalID,
  Operation,
  OperationText,
  LongTextLanguageCode,
  BOOOperationPlant,
  _Plant.PlantName AS PlantName,
  WorkCenter,
  _WorkCenterText.WorkCenterText AS WorkCenterText,
  OperationControlProfile,
  _ControlProfileText.OperationControlProfileName AS OperationControlProfileName,
  OperationReferenceQuantity,
  OperationUnit,
  BillOfOperationsBreakDuration,
  BillOfOperationsBreakDurnUnit,
  BusinessProcess,
  ShopFloorRoutingTemplateType,
  ShopFloorRtgTemplateGroup,
  ShopFloorRtgTemplateGrpVariant,
  ShopFloorRtgTemplateVersion,
  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,
  _LeadTimeReductionStrategyText.LeadTimeReductionStrategyName AS LeadTimeReductionStrategyName,
  TeardownAndWaitIsParallel,
  MinimumWaitDuration,
  MinimumWaitDurationUnit,
  MaximumWaitDuration,
  MaximumWaitDurationUnit,
  MinimumQueueDuration,
  MinimumQueueDurationUnit,
  StandardQueueDuration,
  StandardQueueDurationUnit,
  MinimumMoveDuration,
  MinimumMoveDurationUnit,
  StandardMoveDuration,
  StandardMoveDurationUnit,
  WorkCenterStandardQueueDurn,
  WorkCenterStdQueueDurnUnit,
  WorkCenterMinimumQueueDuration,
  WorkCenterMinimumQueueDurnUnit,
  OperationSplitIsRequired,
  MaximumNumberOfSplits,
  MinProcessingDurationPerSplit,
  MinProcessingDurnPerSplitUnit,
  BOOOperationOverlapping,
  _ProdnModelBOOOpOvrlpngText.BOOOperationOverlappingText AS BOOOperationOverlappingText,
  OverlapMinimumDuration,
  OverlapMinimumDurationUnit,
  OverlapMinimumTransferQty,
  OverlapMinimumTransferQtyUnit,
  OperationScrapPercent,
  NumberOfTimeTickets,
  NumberOfConfirmationSlips,
  EmployeeWageGroup,
  _EmployeeWageGroupText.EmployeeWageGroupName AS EmployeeWageGroupName,
  EmployeeWageType,
  NumberOfEmployees,
  OperationSetupType,
  _OperationSetupTypeText.OperationSetupTypeName AS OperationSetupTypeName,
  OperationSetupGroupCategory,
  _OperationSetupGroupCatText.OperationSetupGroupCatName AS OperationSetupGroupCatName,
  OperationSetupGroup,
  _OperationSetupGroupText.OperationSetupGroupName AS OperationSetupGroupName,
  OperationCostingRelevancyType,
  _CostRelevancyText.CostingRelevantDescription AS CostingRelevantDescription,
  PurchasingInfoRecord,
  PurchaseContract,
  PurchasingInfoRecdAddlGrpgName,
  MaterialGroup,
  PurchasingGroup,
  _PurchasingGroupText.PurchasingGroupName AS PurchasingGroupName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  PlannedDeliveryDuration,
  NumberOfOperationPriceUnits,
  OpExternalProcessingPrice,
  InspectionLotType,
  _InspectionLotTypeText.InspectionLotTypeText AS InspectionLotTypeText,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchaseContractItem,
  GoodsRecipientName,
  UnloadingPointName,
  CostElement,
  OpExternalProcessingCurrency,
  _OpExtProcessingCurrencyText.CurrencyShortName AS CurrencyShortName,
  _CreatedByUser.UserDescription AS CreatedByUserDescription,
  _ChangedByUser.UserDescription AS LastChangedByUserDescription
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_SlsOrdProdnModOperationTP view_entity

R_ProductionModelOperationTP view_entity