I_MasterRecipeSecondaryRsce

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_MasterRecipeSecondaryRsce.
-- 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: IMSTRRCPSECRSC

CREATE VIEW I_MasterRecipeSecondaryRsce AS
SELECT
  plpo.BillOfOperationsType AS BillOfOperationsType,
  plpo.BillOfOperationsGroup AS BillOfOperationsGroup,
  plpo.BOOOperationInternalID AS BOOOperationInternalID,
  plpo.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
  plpo.BillOfOperationsVariant AS BillOfOperationsVariant,
  IsDeleted,
  IsImplicitlyDeleted,
  cast(SubOperation as pph_vornr preserving type ) AS Operation,
  SubOperationText AS OperationText,
  LongTextLanguageCode,
  Plant,
  SuperiorOperationInternalID,
  _ActyType.BOOOperationIsPhase AS BOOSuperiorOperationIsPhase,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  OperationControlProfile,
  OperationStandardTextCode,
  OperationReferenceQuantity,
  OperationUnit,
  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,
  OperationCostingRelevancyType,
  NumberOfTimeTickets,
  NumberOfConfirmationSlips,
  EmployeeWageGroup,
  EmployeeWageType,
  EmployeeSuitability,
  NumberOfEmployees,
  BusinessProcess,
  OpIsExtlyProcdWithSubcontrg,
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchaseContract,
  PurchaseContractItem,
  PurchasingInfoRecdAddlGrpgName,
  MaterialGroup,
  PurchasingGroup,
  Supplier,
  PlannedDeliveryDuration,
  NumberOfOperationPriceUnits,
  OpExternalProcessingPrice,
  InspectionLotType,
  CostElement,
  OpExternalProcessingCurrency,
  cast( ValidityStartDate as vdm_datuv ) AS ValidityStartDate,
  cast( ValidityEndDate as vdm_datub ) AS ValidityEndDate,
  cast( plpo.CreationDate as vdm_andat ) AS CreationDate,
  cast( plpo.CreatedByUser as vdm_annam ) AS CreatedByUser,
  cast( plpo.LastChangeDate as vdm_aedat ) AS LastChangeDate,
  cast( plpo.LastChangedByUser as vdm_aenam ) AS LastChangedByUser,
  plpo.ChangeNumber AS ChangeNumber,
  FactoryCalendar,
  StartDateOffsetDuration,
  StartDateOffsetDurationUnit,
  EndDateOffsetDuration,
  EndDateOffsetDurationUnit,
  CapacityCategoryCode
FROM I_MfgBOOSubOperationChgSt AS plpo
LEFT OUTER JOIN I_MasterRecipeOperation AS _Acty ON BillOfOperationsType = _Acty.BillOfOperationsType AND BillOfOperationsGroup = _Acty.BillOfOperationsGroup AND SuperiorOperationInternalID = _Acty.BOOOperationInternalID AND ValidityStartDate <= _Acty.ValidityEndDate AND ValidityEndDate >= _Acty.ValidityStartDate AND _Acty.BOOOperationIsPhase <> 'X' AND _Acty.IsDeleted <> 'X' AND _Acty.IsImplicitlyDeleted <> 'X'  -- association [1..*]
LEFT OUTER JOIN I_MasterRecipePhase AS _Phase ON BillOfOperationsType = _Phase.BillOfOperationsType AND BillOfOperationsGroup = _Phase.BillOfOperationsGroup AND SuperiorOperationInternalID = _Phase.BOOOperationInternalID AND ValidityStartDate <= _Phase.ValidityEndDate AND ValidityEndDate >= _Phase.ValidityStartDate AND _Phase.IsDeleted <> 'X' AND _Phase.IsImplicitlyDeleted <> 'X'  -- association [1..*]
LEFT OUTER JOIN I_TaskListOperationLongText AS _LongText ON BillOfOperationsType = _LongText.TaskListType AND BillOfOperationsGroup = _LongText.TaskListGroup AND BOOOperationInternalID = _LongText.BOOOperationInternalID AND BOOOpInternalVersionCounter = _LongText.BOOInternalVersionCounter AND LongTextLanguageCode is not null  -- association [0..1]
LEFT OUTER JOIN P_BillOfOperationsActivityType AS _ActyType ON BillOfOperationsType = _ActyType.BillOfOperationsType AND BillOfOperationsGroup = _ActyType.BillOfOperationsGroup AND SuperiorOperationInternalID = _ActyType.BOOOperationInternalID  -- association [1..1]
;