I_MasterRecipePhase

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_MasterRecipePhase.
-- 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.
-- SQL view name: IMSTRRCPPHS

CREATE VIEW I_MasterRecipePhase AS
SELECT
  _Op.BillOfOperationsType AS BillOfOperationsType,
  _Op.BillOfOperationsGroup AS BillOfOperationsGroup,
  _Op.BOOOperationInternalID AS BOOOperationInternalID,
  _Op.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
  _SupOp.BOOOpInternalVersionCounter AS BillOfOperationsIntID,
  _Op.BillOfOperationsVariant AS BillOfOperationsVariant,
  _Op.OperationExternalID AS OperationExternalID,
  cast( _Op.Operation as pph_vornr preserving type ) AS Operation,
  cast( _SupOp.Operation as pph_vornr preserving type ) AS SuperiorOperation,
  cast( _Op.CreationDate as vdm_andat ) AS CreationDate,
  cast( _Op.CreatedByUser as vdm_annam ) AS CreatedByUser,
  cast( _Op.LastChangeDate as vdm_aedat ) AS LastChangeDate,
  cast( _Op.LastChangedByUser as vdm_aenam ) AS LastChangedByUser,
  _Op.ChangeNumber AS ChangeNumber,
  _Op.IsDeleted AS IsDeleted,
  _Op.IsImplicitlyDeleted AS IsImplicitlyDeleted,
  _Op.OperationText AS OperationText,
  _Op.LongTextLanguageCode AS LongTextLanguageCode,
  _Op.Plant AS Plant,
  _Op.ControlRecipeDestination AS ControlRecipeDestination,
  _SupOp.WorkCenterInternalID AS WorkCenterInternalID,
  _SupOp.WorkCenterTypeCode AS WorkCenterTypeCode,
  _Op.FactoryCalendar AS FactoryCalendar,
  _Op.CapacityCategoryCode AS CapacityCategoryCode,
  _Op.CostElement AS CostElement,
  _Op.OperationCostingRelevancyType AS OperationCostingRelevancyType,
  _Op.NumberOfEmployees AS NumberOfEmployees,
  case _SupOp._WorkCenter.EmployeeWageTypeIsReferenced when 'X' then _SupOp._WorkCenter.EmployeeWageType else _Op.EmployeeWageType end as EmployeeWageType AS EmployeeWageTypeendasEmployeeWageType,
  case _SupOp._WorkCenter.EmployeeWageGroupIsReferenced when 'X' then _SupOp._WorkCenter.EmployeeWageGroup else _Op.EmployeeWageGroup end as EmployeeWageGroup AS EmployeeWageGroupendasEmployeeWageGroup,
  _Op.BillOfOperationsRefType AS BillOfOperationsRefType,
  _Op.BillOfOperationsRefGroup AS BillOfOperationsRefGroup,
  _Op.BillOfOperationsRefVariant AS BillOfOperationsRefVariant,
  _Op.LineSegmentTakt AS LineSegmentTakt,
  _Op.OperationStdWorkQtyGrpgCat AS OperationStdWorkQtyGrpgCat,
  _Op.OrderHasNoSubOperations AS OrderHasNoSubOperations,
  _Op.OperationSetupGroupCategory AS OperationSetupGroupCategory,
  _Op.OperationSetupGroup AS OperationSetupGroup,
  _Op.BOOPhaseSuperiorOpInternalID AS BOOPhaseSuperiorOpInternalID,
  _Op.OpIsExtlyProcdWithSubcontrg AS OpIsExtlyProcdWithSubcontrg,
  _Op.PurchasingInfoRecord AS PurchasingInfoRecord,
  _Op.PurchasingOrganization AS PurchasingOrganization,
  _Op.PurchaseContract AS PurchaseContract,
  _Op.PurchaseContractItem AS PurchaseContractItem,
  _Op.PurchasingInfoRecdAddlGrpgName AS PurchasingInfoRecdAddlGrpgName,
  _Op.MaterialGroup AS MaterialGroup,
  _Op.PurchasingGroup AS PurchasingGroup,
  _Op.Supplier AS Supplier,
  _Op.PlannedDeliveryDuration AS PlannedDeliveryDuration,
  _Op.NumberOfOperationPriceUnits AS NumberOfOperationPriceUnits,
  _Op.OpExternalProcessingCurrency AS OpExternalProcessingCurrency,
  _Op.OpExternalProcessingPrice AS OpExternalProcessingPrice,
  _Op.InspectionLotType AS InspectionLotType,
  _Op.InspResultRecordingView AS InspResultRecordingView,
  _Op.InspSbstCompletionConfirmation AS InspSbstCompletionConfirmation,
  _Op.InspSbstHasNoTimeOrQuantity AS InspSbstHasNoTimeOrQuantity,
  _Op.OperationReferenceQuantity AS OperationReferenceQuantity,
  _Op.OperationUnit AS OperationUnit,
  _Op.OperationScrapPercent AS OperationScrapPercent,
  _Op.OpQtyToBaseQtyNmrtr AS OpQtyToBaseQtyNmrtr,
  _Op.OpQtyToBaseQtyDnmntr AS OpQtyToBaseQtyDnmntr,
  _SupOp.StandardWorkFormulaParam1 AS StandardWorkFormulaParam1,
  _Op.StandardWorkQuantity1 AS StandardWorkQuantity1,
  _Op.StandardWorkQuantityUnit1 AS StandardWorkQuantityUnit1,
  _Op.CostCtrActivityType1 AS CostCtrActivityType1,
  _Op.PerfEfficiencyRatioCode1 AS PerfEfficiencyRatioCode1,
  _SupOp.StandardWorkFormulaParam2 AS StandardWorkFormulaParam2,
  _Op.StandardWorkQuantity2 AS StandardWorkQuantity2,
  _Op.StandardWorkQuantityUnit2 AS StandardWorkQuantityUnit2,
  _Op.CostCtrActivityType2 AS CostCtrActivityType2,
  _Op.PerfEfficiencyRatioCode2 AS PerfEfficiencyRatioCode2,
  _SupOp.StandardWorkFormulaParam3 AS StandardWorkFormulaParam3,
  _Op.StandardWorkQuantity3 AS StandardWorkQuantity3,
  _Op.StandardWorkQuantityUnit3 AS StandardWorkQuantityUnit3,
  _Op.CostCtrActivityType3 AS CostCtrActivityType3,
  _Op.PerfEfficiencyRatioCode3 AS PerfEfficiencyRatioCode3,
  _SupOp.StandardWorkFormulaParam4 AS StandardWorkFormulaParam4,
  _Op.StandardWorkQuantity4 AS StandardWorkQuantity4,
  _Op.StandardWorkQuantityUnit4 AS StandardWorkQuantityUnit4,
  _Op.CostCtrActivityType4 AS CostCtrActivityType4,
  _Op.PerfEfficiencyRatioCode4 AS PerfEfficiencyRatioCode4,
  _SupOp.StandardWorkFormulaParam5 AS StandardWorkFormulaParam5,
  _Op.StandardWorkQuantity5 AS StandardWorkQuantity5,
  _Op.StandardWorkQuantityUnit5 AS StandardWorkQuantityUnit5,
  _Op.CostCtrActivityType5 AS CostCtrActivityType5,
  _Op.PerfEfficiencyRatioCode5 AS PerfEfficiencyRatioCode5,
  _SupOp.StandardWorkFormulaParam6 AS StandardWorkFormulaParam6,
  _Op.StandardWorkQuantity6 AS StandardWorkQuantity6,
  _Op.StandardWorkQuantityUnit6 AS StandardWorkQuantityUnit6,
  _Op.CostCtrActivityType6 AS CostCtrActivityType6,
  _Op.PerfEfficiencyRatioCode6 AS PerfEfficiencyRatioCode6,
  _Op.BusinessProcess AS BusinessProcess,
  _Op.LeadTimeReductionStrategy AS LeadTimeReductionStrategy,
  _Op.TeardownAndWaitIsParallel AS TeardownAndWaitIsParallel,
  _Op.BillOfOperationsBreakDuration AS BillOfOperationsBreakDuration,
  _Op.BreakDurationUnit AS BreakDurationUnit,
  _Op.MaximumWaitDuration AS MaximumWaitDuration,
  _Op.MaximumWaitDurationUnit AS MaximumWaitDurationUnit,
  _Op.MinimumWaitDuration AS MinimumWaitDuration,
  _Op.MinimumWaitDurationUnit AS MinimumWaitDurationUnit,
  _Op.StandardQueueDuration AS StandardQueueDuration,
  _Op.StandardQueueDurationUnit AS StandardQueueDurationUnit,
  _Op.MinimumQueueDuration AS MinimumQueueDuration,
  _Op.MinimumQueueDurationUnit AS MinimumQueueDurationUnit,
  _Op.StandardMoveDuration AS StandardMoveDuration,
  _Op.StandardMoveDurationUnit AS StandardMoveDurationUnit,
  _Op.MinimumMoveDuration AS MinimumMoveDuration,
  _Op.MinimumMoveDurationUnit AS MinimumMoveDurationUnit,
  _Op.OperationSplitIsRequired AS OperationSplitIsRequired,
  _Op.MaximumNumberOfSplits AS MaximumNumberOfSplits,
  _Op.MinProcessingDurationPerSplit AS MinProcessingDurationPerSplit,
  _Op.MinProcessingDurnPerSplitUnit AS MinProcessingDurnPerSplitUnit,
  _Op.OperationOverlappingIsRequired AS OperationOverlappingIsRequired,
  _Op.OperationOverlappingIsPossible AS OperationOverlappingIsPossible,
  _Op.OperationsIsAlwaysOverlapping AS OperationsIsAlwaysOverlapping,
  _Op.OverlapMinimumDuration AS OverlapMinimumDuration,
  _Op.OverlapMinimumDurationUnit AS OverlapMinimumDurationUnit,
  _Op.OverlapMinimumTransferQty AS OverlapMinimumTransferQty,
  _Op.OverlapMinimumTransferQtyUnit AS OverlapMinimumTransferQtyUnit,
  _Op._BillOfOperations AS _BillOfOperations,
  _Op._BillOfOperationsBreakDurnUnit AS _BillOfOperationsBreakDurnUnit,
  _Op._BillOfOperationsGroup AS _BillOfOperationsGroup,
  _Op._BillOfOperationsType AS _BillOfOperationsType,
  _Op._BOOOperationInternalID AS _BOOOperationInternalID,
  _Op._CapacityCategory AS _CapacityCategory,
  _Op._ChangeMaster AS _ChangeMaster,
  _Op._ControlRecipeDestination AS _ControlRecipeDestination,
  _Op._FactoryCalendar AS _FactoryCalendar,
  _Op._InspectionLotType AS _InspectionLotType,
  _Op._InspResultRecordingView AS _InspResultRecordingView,
  _Op._LeadTimeReductionStrategy AS _LeadTimeReductionStrategy,
  _Op._LongTextLanguage AS _LongTextLanguage,
  _Op._MaterialGroup AS _MaterialGroup,
  _Op._MaximumWaitDurationUnit AS _MaximumWaitDurationUnit,
  _Op._MinimumMoveDurationUnit AS _MinimumMoveDurationUnit,
  _Op._MinimumQueueDurationUnit AS _MinimumQueueDurationUnit,
  _Op._MinimumWaitDurationUnit AS _MinimumWaitDurationUnit,
  _Op._MinProcessingDurnPerSplitUnit AS _MinProcessingDurnPerSplitUnit,
  _Op._OperationSetupGroup AS _OperationSetupGroup,
  _Op._OperationSetupGroupCategory AS _OperationSetupGroupCategory,
  _Op._OperationStdWorkQtyGrpgCat AS _OperationStdWorkQtyGrpgCat,
  _Op._OperationUnit AS _OperationUnit,
  _Op._OpExternalProcessingCurrency AS _OpExternalProcessingCurrency,
  _Op._OverlapMinimumDurationUnit AS _OverlapMinimumDurationUnit,
  _Op._OverlapMinimumTransferQtyUnit AS _OverlapMinimumTransferQtyUnit,
  _Op._PerformanceEfficiencyRatio1 AS _PerformanceEfficiencyRatio1,
  _Op._PerformanceEfficiencyRatio2 AS _PerformanceEfficiencyRatio2,
  _Op._PerformanceEfficiencyRatio3 AS _PerformanceEfficiencyRatio3,
  _Op._PerformanceEfficiencyRatio4 AS _PerformanceEfficiencyRatio4,
  _Op._PerformanceEfficiencyRatio5 AS _PerformanceEfficiencyRatio5,
  _Op._PerformanceEfficiencyRatio6 AS _PerformanceEfficiencyRatio6,
  _Op._Plant AS _Plant,
  _Op._PurchaseContract AS _PurchaseContract,
  _Op._PurchaseContractItem AS _PurchaseContractItem,
  _Op._PurchasingGroup AS _PurchasingGroup,
  _Op._PurchasingInfoRecord AS _PurchasingInfoRecord,
  _Op._PurchasingOrganization AS _PurchasingOrganization,
  _Op._StandardMoveDurationUnit AS _StandardMoveDurationUnit,
  _Op._StandardQueueDurationUnit AS _StandardQueueDurationUnit,
  _SupOp._StandardWorkFormulaParameter1 AS _StandardWorkFormulaParameter1,
  _SupOp._StandardWorkFormulaParameter2 AS _StandardWorkFormulaParameter2,
  _SupOp._StandardWorkFormulaParameter3 AS _StandardWorkFormulaParameter3,
  _SupOp._StandardWorkFormulaParameter4 AS _StandardWorkFormulaParameter4,
  _SupOp._StandardWorkFormulaParameter5 AS _StandardWorkFormulaParameter5,
  _SupOp._StandardWorkFormulaParameter6 AS _StandardWorkFormulaParameter6,
  _Op._StandardWorkQuantityUnit1 AS _StandardWorkQuantityUnit1,
  _Op._StandardWorkQuantityUnit2 AS _StandardWorkQuantityUnit2,
  _Op._StandardWorkQuantityUnit3 AS _StandardWorkQuantityUnit3,
  _Op._StandardWorkQuantityUnit4 AS _StandardWorkQuantityUnit4,
  _Op._StandardWorkQuantityUnit5 AS _StandardWorkQuantityUnit5,
  _Op._StandardWorkQuantityUnit6 AS _StandardWorkQuantityUnit6,
  _Op._Supplier AS _Supplier,
  _Op._SupplierCompanyByPlant AS _SupplierCompanyByPlant,
  _SupOp._WorkCenter AS _WorkCenter,
  _SupOp._WorkCenterType AS _WorkCenterType
INNER JOIN I_MfgBillOfOperationsOperation AS _Acty ON /* join condition not captured in parsed metadata */
INNER JOIN I_MfgBOOOperationChangeState AS _SupOp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MasterRecipeHeader AS _Header ON BillOfOperationsType = _Header.BillOfOperationsType AND BillOfOperationsGroup = _Header.BillOfOperationsGroup AND BillOfOperationsVariant = _Header.BillOfOperationsVariant AND ValidityStartDate <= _Header.ValidityEndDate AND ValidityEndDate >= _Header.ValidityStartDate AND _Header.IsDeleted <> 'X' AND _Header.IsImplicitlyDeleted <> 'X'  -- association [1..*]
;