I_MasterRecipeOperation

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_MasterRecipeOperation.
-- 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: IMSTRRCPOPR

CREATE VIEW I_MasterRecipeOperation AS
SELECT
  _Op.BillOfOperationsType AS BillOfOperationsType,
  _Op.BillOfOperationsGroup AS BillOfOperationsGroup,
  _Op.BOOOperationInternalID AS BOOOperationInternalID,
  _Op.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
  _Op.BillOfOperationsVariant AS BillOfOperationsVariant,
  OperationExternalID,
  cast(Operation as pph_vornr preserving type) AS Operation,
  cast( CreationDate as vdm_andat ) AS CreationDate,
  cast( CreatedByUser as vdm_annam ) AS CreatedByUser,
  cast( LastChangeDate as vdm_aedat ) AS LastChangeDate,
  cast( LastChangedByUser as vdm_aenam ) AS LastChangedByUser,
  ChangeNumber,
  cast( ValidityStartDate as vdm_datuv ) AS ValidityStartDate,
  cast( ValidityEndDate as vdm_datub ) AS ValidityEndDate,
  IsDeleted,
  IsImplicitlyDeleted,
  OperationText,
  LongTextLanguageCode,
  Plant,
  OperationControlProfile,
  OperationStandardTextCode,
  WorkCenterTypeCode,
  WorkCenterInternalID,
  CapacityCategoryCode,
  CostElement,
  OperationCostingRelevancyType,
  NumberOfTimeTickets,
  NumberOfConfirmationSlips,
  EmployeeWageGroup,
  EmployeeWageType,
  EmployeeSuitability,
  NumberOfEmployees,
  BillOfOperationsRefType,
  BillOfOperationsRefGroup,
  BillOfOperationsRefVariant,
  LineSegmentTakt,
  OperationStdWorkQtyGrpgCat,
  OrderHasNoSubOperations,
  OperationSetupType,
  OperationSetupGroupCategory,
  OperationSetupGroup,
  BOOOperationIsPhase,
  BOOPhaseSuperiorOpInternalID,
  ControlRecipeDestination,
  OpIsExtlyProcdWithSubcontrg,
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchaseContract,
  PurchaseContractItem,
  PurchasingInfoRecdAddlGrpgName,
  MaterialGroup,
  PurchasingGroup,
  Supplier,
  PlannedDeliveryDuration,
  NumberOfOperationPriceUnits,
  OpExternalProcessingCurrency,
  OpExternalProcessingPrice,
  InspectionLotType,
  InspResultRecordingView,
  InspSbstCompletionConfirmation,
  InspSbstHasNoTimeOrQuantity,
  OperationReferenceQuantity,
  OperationUnit,
  OperationScrapPercent,
  OpQtyToBaseQtyNmrtr,
  OpQtyToBaseQtyDnmntr,
  StandardWorkFormulaParam1,
  StandardWorkQuantity1,
  StandardWorkQuantityUnit1,
  CostCtrActivityType1,
  PerfEfficiencyRatioCode1,
  StandardWorkFormulaParam2,
  StandardWorkQuantity2,
  StandardWorkQuantityUnit2,
  CostCtrActivityType2,
  PerfEfficiencyRatioCode2,
  StandardWorkFormulaParam3,
  StandardWorkQuantity3,
  StandardWorkQuantityUnit3,
  CostCtrActivityType3,
  PerfEfficiencyRatioCode3,
  StandardWorkFormulaParam4,
  StandardWorkQuantity4,
  StandardWorkQuantityUnit4,
  CostCtrActivityType4,
  PerfEfficiencyRatioCode4,
  StandardWorkFormulaParam5,
  StandardWorkQuantity5,
  StandardWorkQuantityUnit5,
  CostCtrActivityType5,
  PerfEfficiencyRatioCode5,
  StandardWorkFormulaParam6,
  StandardWorkQuantity6,
  StandardWorkQuantityUnit6,
  CostCtrActivityType6,
  PerfEfficiencyRatioCode6,
  BusinessProcess,
  LeadTimeReductionStrategy,
  TeardownAndWaitIsParallel,
  BillOfOperationsBreakDuration,
  BreakDurationUnit,
  MaximumWaitDuration,
  MaximumWaitDurationUnit,
  MinimumWaitDuration,
  MinimumWaitDurationUnit,
  StandardQueueDuration,
  StandardQueueDurationUnit,
  MinimumQueueDuration,
  MinimumQueueDurationUnit,
  StandardMoveDuration,
  StandardMoveDurationUnit,
  MinimumMoveDuration,
  MinimumMoveDurationUnit,
  OperationSplitIsRequired,
  MaximumNumberOfSplits,
  MinProcessingDurationPerSplit,
  MinProcessingDurnPerSplitUnit,
  OperationOverlappingIsRequired,
  OperationOverlappingIsPossible,
  OperationsIsAlwaysOverlapping,
  OverlapMinimumDuration,
  OverlapMinimumDurationUnit,
  OverlapMinimumTransferQty,
  OverlapMinimumTransferQtyUnit,
  _Op.FactoryCalendar AS FactoryCalendar,
  _Op._BillOfOperations AS _BillOfOperations,
  _Op._BillOfOperationsGroup AS _BillOfOperationsGroup,
  _Op._BillOfOperationsType AS _BillOfOperationsType,
  _Op._BOOOperationInternalID AS _BOOOperationInternalID,
  _Op._SupplierCompanyByPlant AS _SupplierCompanyByPlant
INNER JOIN I_MfgBillOfOperationsOperation AS _Acty 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..*]
LEFT OUTER JOIN I_MfgBOOOperationChangeState AS _SupOp ON BillOfOperationsType = _SupOp.BillOfOperationsType AND BillOfOperationsGroup = _SupOp.BillOfOperationsGroup AND BOOPhaseSuperiorOpInternalID = _SupOp.BOOOperationInternalID AND ValidityStartDate <= _SupOp.ValidityEndDate AND ValidityEndDate >= _SupOp.ValidityStartDate AND BOOOperationIsPhase = 'X' AND _SupOp.IsDeleted <> 'X' AND _SupOp.IsImplicitlyDeleted <> 'X'  -- association [1..*]
;