What is I_MasterRecipePhaseTP in SAP S/4HANA?

I_MasterRecipePhaseTP is a transactional CDS view in SAP S/4HANA. Master Recipe - Phases It contains 86 fields.

Which tables does I_MasterRecipePhaseTP read from?

I_MasterRecipePhaseTP reads data from: I_MasterRecipePhase.

What VDM layer is I_MasterRecipePhaseTP?

I_MasterRecipePhaseTP is classified as a Transactional view that supports create, update, and delete operations.

I_MasterRecipePhaseTP

DDL: I_MASTERRECIPEPHASETP Type: view_entity TRANSACTIONAL

86 Fields 1 Data Sources 6 Associations

Master Recipe - Phases

I_MasterRecipePhaseTP is a Transactional CDS View that provides data about "Master Recipe - Phases" in SAP S/4HANA. It reads from 1 data source (I_MasterRecipePhase) and exposes 86 fields with key fields MasterRecipeGroup, MasterRecipe, MasterRecipeOperationIntID, MstrRcpOperationIntVersion, MstrRcpPhaseIntVersion. It has 6 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_MasterRecipePhase	I_MasterRecipePhase	from

Associations (6)

Cardinality	Target	Alias	Condition
[0..*]	I_MasterRecipePhseCompAllocTP	_PhseCompAlloc	`$projection.MasterRecipeGroup = _PhseCompAlloc.MasterRecipeGroup and $projection.MasterRecipe = _PhseCompAlloc.MasterRecipe and $projection.MasterRecipeOperationIntID = _PhseCompAlloc.MasterRecipeOperationIntID and $projection.ValidityEndDate >= _PhseCompAlloc.ValidityStartDate and $projection.ValidityStartDate <= _PhseCompAlloc.ValidityEndDate -- to Phases Secondary Resources`
[0..*]	I_MasterRecipePhseSecdryRsceTP	_PhseSecdryRsce	`$projection.MasterRecipeGroup = _PhseSecdryRsce.MasterRecipeGroup and $projection.MasterRecipe = _PhseSecdryRsce.MasterRecipe and $projection.MasterRecipeOperationIntID = _PhseSecdryRsce.SuperiorOperationInternalID and $projection.ValidityEndDate >= _PhseSecdryRsce.ValidityStartDate and $projection.ValidityStartDate <= _PhseSecdryRsce.ValidityEndDate -- to Phases Relationships`
[0..*]	I_MasterRecipeRelationshipTP	_PhseRelshp	`$projection.MasterRecipeGroup = _PhseRelshp.PrdcssrMasterRecipeGroup and $projection.MasterRecipe = _PhseRelshp.PrdcssrMasterRecipe and $projection.MasterRecipeOperationIntID = _PhseRelshp.PrdcssrMstrRcpOpInternalID and $projection.ValidityEndDate >= _PhseRelshp.ValidityStartDate and $projection.ValidityStartDate <= _PhseRelshp.ValidityEndDate -- for Plain Long Text`
[0..1]	I_TaskListOperationLongText	_LongText	`$projection.MasterRecipeGroup = _LongText.TaskListGroup and $projection.MasterRecipeOperationIntID = _LongText.BOOOperationInternalID and $projection.MstrRcpPhaseIntVersion = _LongText.BOOInternalVersionCounter and $projection.LongTextLanguageCode is not null and _LongText.TaskListType = '2' -- for DCLS`
[1..*]	I_MasterRecipeHeaderTP	_Header	`$projection.MasterRecipeGroup = _Header.MasterRecipeGroup and $projection.MasterRecipe = _Header.MasterRecipe and $projection.ValidityEndDate >= _Header.ValidityStartDate and $projection.ValidityStartDate <= _Header.ValidityEndDate -- to top root node`
[0..1]	P_MasterRecipePhaseParamText	_PhseParamText	`_PhseParamText.BillOfOperationsType = '2' and _PhseParamText.BillOfOperationsGroup = $projection.MasterRecipeGroup and _PhseParamText.BillOfOperationsVariant = $projection.MasterRecipe and _PhseParamText.BOOOperationInternalID = $projection.MasterRecipeOperationIntID and _PhseParamText.BillOfOperationsIntID = $projection.MstrRcpOperationIntVersion and _PhseParamText.BOOOpInternalVersionCounter = $projection.MstrRcpPhaseIntVersion`

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Master Recipe - Phases	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (86)

Key	Field	Source Table	Source Field	Description
KEY	MasterRecipeGroup		BillOfOperationsGroup	Group
KEY	MasterRecipe		BillOfOperationsVariant	Group Counter
KEY	MasterRecipeOperationIntID		BOOOperationInternalID	Task list node
KEY	MstrRcpOperationIntVersion		BillOfOperationsIntID	Counter
KEY	MstrRcpPhaseIntVersion		BOOOpInternalVersionCounter	Counter
	BOOPhaseSuperiorOpInternalID		BOOPhaseSuperiorOpInternalID
	Operation		Operation	Transaction
	OperationText		OperationText	Description
	LongTextLanguageCode		LongTextLanguageCode	Language
	PlainLongText	_LongText	PlainLongText	Long Text
	WorkCenterTypeCode		WorkCenterTypeCode	Object Type
	WorkCenterInternalID		WorkCenterInternalID	Work Center
	Plant		Plant	Valuation Area
	OperationControlProfile		OperationControlProfile	Control Key
	ControlRecipeDestination		ControlRecipeDestination
	OperationStandardTextCode		OperationStandardTextCode	Std Text Key
	OperationReferenceQuantity		OperationReferenceQuantity	Base Quantity
	OperationUnit		OperationUnit	Act/op UoM
	OpQtyToBaseQtyNmrtr		OpQtyToBaseQtyNmrtr
	OpQtyToBaseQtyDnmntr		OpQtyToBaseQtyDnmntr
	StandardWorkFormulaParam1		StandardWorkFormulaParam1
	StandardWorkFormulaParamName1
	StandardWorkQuantity1		StandardWorkQuantity1	Standard Value
	StandardWorkQuantityUnit1		StandardWorkQuantityUnit1	Std value unit
	StandardWorkFormulaParam2		StandardWorkFormulaParam2
	StandardWorkFormulaParamName2
	StandardWorkQuantity2		StandardWorkQuantity2	Standard Value
	StandardWorkQuantityUnit2		StandardWorkQuantityUnit2	Std value unit
	StandardWorkFormulaParam3		StandardWorkFormulaParam3
	StandardWorkFormulaParamName3
	StandardWorkQuantity3		StandardWorkQuantity3	Standard Value
	StandardWorkQuantityUnit3		StandardWorkQuantityUnit3	Std value unit
	StandardWorkFormulaParam4		StandardWorkFormulaParam4
	StandardWorkFormulaParamName4
	StandardWorkQuantity4		StandardWorkQuantity4	Standard Value
	StandardWorkQuantityUnit4		StandardWorkQuantityUnit4	Std value unit
	StandardWorkFormulaParam5		StandardWorkFormulaParam5
	StandardWorkFormulaParamName5
	StandardWorkQuantity5		StandardWorkQuantity5	Standard Value
	StandardWorkQuantityUnit5		StandardWorkQuantityUnit5	Std value unit
	StandardWorkFormulaParam6		StandardWorkFormulaParam6
	StandardWorkFormulaParamName6
	StandardWorkQuantity6		StandardWorkQuantity6	Standard Value
	StandardWorkQuantityUnit6		StandardWorkQuantityUnit6	Std value unit
	NumberOfTimeTickets		NumberOfTimeTickets	No.TimeTickets
	EmployeeWageType		EmployeeWageType	Wage type
	EmployeeWageGroup		EmployeeWageGroup	Wage Group
	NumberOfConfirmationSlips		NumberOfConfirmationSlips	No. of Conf. Slips
	NumberOfEmployees		NumberOfEmployees	No. employees
	OperationCostingRelevancyType		OperationCostingRelevancyType	Operation Costing Relevancy Type
	BusinessProcess		BusinessProcess	Business Process
	OperationSetupType		OperationSetupType	Setup Type Key
	OperationSetupGroupCategory		OperationSetupGroupCategory	Setup group cat
	OperationSetupGroup		OperationSetupGroup	Setup group key
	CapacityCategoryCode		CapacityCategoryCode
	OpIsExtlyProcdWithSubcontrg
	InspectionLotType		InspectionLotType	Inspection Type
	PurchasingInfoRecord		PurchasingInfoRecord	Info Record
	PurchasingOrganization		PurchasingOrganization	Purchasing Organization
	PurchaseContract		PurchaseContract	Purchasing Doc.
	PurchaseContractItem		PurchaseContractItem	Item
	PurchasingInfoRecdAddlGrpgName		PurchasingInfoRecdAddlGrpgName	Sort Term
	PlannedDeliveryDuration		PlannedDeliveryDuration	Pl. Deliv. Time
	MaterialGroup		MaterialGroup	Product Group
	PurchasingGroup		PurchasingGroup	Purchasing Group
	Supplier		Supplier	Supplier
	NumberOfOperationPriceUnits		NumberOfOperationPriceUnits	Price Unit
	CostElement		CostElement	G/L Account
	OpExternalProcessingPrice		OpExternalProcessingPrice	Price
	OpExternalProcessingCurrency		OpExternalProcessingCurrency	Currency
	CreationDate		CreationDate	Time Stamp
	CreatedByUser		CreatedByUser	User Name
	LastChangeDate		LastChangeDate	Time Stamp
	LastChangedByUser		LastChangedByUser	User Name
	ValidityStartDate		ValidityStartDate	Validity Start Date
	ValidityEndDate		ValidityEndDate	ValidTo
	ChangeNumber		ChangeNumber	Change Number
	ChangedDateTime	_ActyTP	ChangedDateTime	Time Stamp
	_Supplier		_Supplier
	_SupplierCompanyByPlant		_SupplierCompanyByPlant
	_PhseCompAlloc		_PhseCompAlloc
	_PhseSecdryRsce		_PhseSecdryRsce
	_PhseRelshp		_PhseRelshp
	_Header		_Header
	_ActyTP		_ActyTP
	_RcpTP		_RcpTP

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_MasterRecipePhaseTP.
-- 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_MasterRecipePhaseTP AS
SELECT
  BillOfOperationsGroup AS MasterRecipeGroup,
  BillOfOperationsVariant AS MasterRecipe,
  BOOOperationInternalID AS MasterRecipeOperationIntID,
  BillOfOperationsIntID AS MstrRcpOperationIntVersion,
  BOOOpInternalVersionCounter AS MstrRcpPhaseIntVersion,
  BOOPhaseSuperiorOpInternalID,
  Operation,
  OperationText,
  LongTextLanguageCode,
  _LongText.PlainLongText AS PlainLongText,
  WorkCenterTypeCode,
  WorkCenterInternalID,
  Plant,
  OperationControlProfile,
  ControlRecipeDestination,
  OperationStandardTextCode,
  OperationReferenceQuantity,
  OperationUnit,
  OpQtyToBaseQtyNmrtr,
  OpQtyToBaseQtyDnmntr,
  StandardWorkFormulaParam1,
  _PhseParamText._ParamText[1: StandardWorkFormulaParameter = standardworkformulaparam1 ].StandardWorkFormulaParamName AS StandardWorkFormulaParamName1,
  StandardWorkQuantity1,
  StandardWorkQuantityUnit1,
  StandardWorkFormulaParam2,
  _PhseParamText._ParamText[1: StandardWorkFormulaParameter = standardworkformulaparam2 ].StandardWorkFormulaParamName AS StandardWorkFormulaParamName2,
  StandardWorkQuantity2,
  StandardWorkQuantityUnit2,
  StandardWorkFormulaParam3,
  _PhseParamText._ParamText[1: StandardWorkFormulaParameter = standardworkformulaparam3 ].StandardWorkFormulaParamName AS StandardWorkFormulaParamName3,
  StandardWorkQuantity3,
  StandardWorkQuantityUnit3,
  StandardWorkFormulaParam4,
  _PhseParamText._ParamText[1: StandardWorkFormulaParameter = standardworkformulaparam4 ].StandardWorkFormulaParamName AS StandardWorkFormulaParamName4,
  StandardWorkQuantity4,
  StandardWorkQuantityUnit4,
  StandardWorkFormulaParam5,
  _PhseParamText._ParamText[1: StandardWorkFormulaParameter = standardworkformulaparam5 ].StandardWorkFormulaParamName AS StandardWorkFormulaParamName5,
  StandardWorkQuantity5,
  StandardWorkQuantityUnit5,
  StandardWorkFormulaParam6,
  _PhseParamText._ParamText[1: StandardWorkFormulaParameter = standardworkformulaparam6 ].StandardWorkFormulaParamName AS StandardWorkFormulaParamName6,
  StandardWorkQuantity6,
  StandardWorkQuantityUnit6,
  NumberOfTimeTickets,
  EmployeeWageType,
  EmployeeWageGroup,
  NumberOfConfirmationSlips,
  NumberOfEmployees,
  OperationCostingRelevancyType,
  BusinessProcess,
  OperationSetupType,
  OperationSetupGroupCategory,
  OperationSetupGroup,
  CapacityCategoryCode,
  cast( OpIsExtlyProcdWithSubcontrg as pph_frdlb) AS OpIsExtlyProcdWithSubcontrg,
  InspectionLotType,
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchaseContract,
  PurchaseContractItem,
  PurchasingInfoRecdAddlGrpgName,
  PlannedDeliveryDuration,
  MaterialGroup,
  PurchasingGroup,
  Supplier,
  NumberOfOperationPriceUnits,
  CostElement,
  OpExternalProcessingPrice,
  OpExternalProcessingCurrency,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  ValidityStartDate,
  ValidityEndDate,
  ChangeNumber,
  _ActyTP.ChangedDateTime AS ChangedDateTime
FROM I_MasterRecipePhase
LEFT OUTER JOIN I_MasterRecipePhseCompAllocTP AS _PhseCompAlloc ON MasterRecipeGroup = _PhseCompAlloc.MasterRecipeGroup AND MasterRecipe = _PhseCompAlloc.MasterRecipe AND MasterRecipeOperationIntID = _PhseCompAlloc.MasterRecipeOperationIntID AND ValidityEndDate >= _PhseCompAlloc.ValidityStartDate AND ValidityStartDate <= _PhseCompAlloc.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_MasterRecipePhseSecdryRsceTP AS _PhseSecdryRsce ON MasterRecipeGroup = _PhseSecdryRsce.MasterRecipeGroup AND MasterRecipe = _PhseSecdryRsce.MasterRecipe AND MasterRecipeOperationIntID = _PhseSecdryRsce.SuperiorOperationInternalID AND ValidityEndDate >= _PhseSecdryRsce.ValidityStartDate AND ValidityStartDate <= _PhseSecdryRsce.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_MasterRecipeRelationshipTP AS _PhseRelshp ON MasterRecipeGroup = _PhseRelshp.PrdcssrMasterRecipeGroup AND MasterRecipe = _PhseRelshp.PrdcssrMasterRecipe AND MasterRecipeOperationIntID = _PhseRelshp.PrdcssrMstrRcpOpInternalID AND ValidityEndDate >= _PhseRelshp.ValidityStartDate AND ValidityStartDate <= _PhseRelshp.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_TaskListOperationLongText AS _LongText ON MasterRecipeGroup = _LongText.TaskListGroup AND MasterRecipeOperationIntID = _LongText.BOOOperationInternalID AND MstrRcpPhaseIntVersion = _LongText.BOOInternalVersionCounter AND LongTextLanguageCode is not null AND _LongText.TaskListType = '2'  -- association [0..1]
LEFT OUTER JOIN I_MasterRecipeHeaderTP AS _Header ON MasterRecipeGroup = _Header.MasterRecipeGroup AND MasterRecipe = _Header.MasterRecipe AND ValidityEndDate >= _Header.ValidityStartDate AND ValidityStartDate <= _Header.ValidityEndDate  -- association [1..*]
LEFT OUTER JOIN P_MasterRecipePhaseParamText AS _PhseParamText ON _PhseParamText.BillOfOperationsType = '2' AND _PhseParamText.BillOfOperationsGroup = MasterRecipeGroup AND _PhseParamText.BillOfOperationsVariant = MasterRecipe AND _PhseParamText.BOOOperationInternalID = MasterRecipeOperationIntID AND _PhseParamText.BillOfOperationsIntID = MstrRcpOperationIntVersion AND _PhseParamText.BOOOpInternalVersionCounter = MstrRcpPhaseIntVersion  -- association [0..1]
;

Depth:

I_MasterRecipePhaseTP view_entity

I_MasterRecipePhase view_entity

A_MasterRecipePhase view_entity