I_BillOfOperationsOpBasic

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_BillOfOperationsOpBasic.
-- 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: IPPBOOOPERBASIC

CREATE VIEW I_BillOfOperationsOpBasic AS
SELECT
  plnty AS BillOfOperationsType,
  plnnr AS BillOfOperationsGroup,
  plnkn AS BOOOperationInternalID,
  zaehl AS BOOOpInternalVersionCounter,
  versn AS BillOfOperationsVersion,
  versn_track_guid AS SourceOperationUUID
FROM plpo
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_BOOOperationInternalID AS _BOOOperationInternalID ON BillOfOperationsType = _BOOOperationInternalID.BillOfOperationsType AND BillOfOperationsGroup = _BOOOperationInternalID.BillOfOperationsGroup AND BOOOperationInternalID = _BOOOperationInternalID.BOOOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeMaster ON ChangeNumber = _ChangeMaster.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_OperationControlProfile AS _OperationControlProfile ON OperationControlProfile = _OperationControlProfile.OperationControlProfile  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OperationUnit ON OperationUnit = _OperationUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_OperationStandardText AS _OperationStandardText ON OperationStandardTextCode = _OperationStandardText.OperationStandardTextCode  -- association [1..1]
LEFT OUTER JOIN I_InspResultRecordingView AS _InspResultRecordingView ON InspResultRecordingView = _InspResultRecordingView.InspResultRecordingView  -- association [0..1]
LEFT OUTER JOIN I_OperationStdWorkQtyGrpgCat AS _OperationStdWorkQtyGrpgCat ON OperationStdWorkQtyGrpgCat = _OperationStdWorkQtyGrpgCat.OperationStdWorkQtyGrpgCat  -- association [1..1]
LEFT OUTER JOIN I_CapacityCategory AS _CapacityCategory ON CapacityCategoryCode = _CapacityCategory.CapacityCategoryCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingInfoRecordApi01 AS _PurchasingInfoRecord ON PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchaseContract AS _PurchaseContract ON PurchaseContract = _PurchaseContract.PurchaseContract  -- association [0..1]
LEFT OUTER JOIN I_PurchaseContractItem AS _PurchaseContractItem ON PurchaseContract = _PurchaseContractItem.PurchaseContract AND PurchaseContractItem = _PurchaseContractItem.PurchaseContractItem  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _OpExternalProcessingCurrency ON OpExternalProcessingCurrency = _OpExternalProcessingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_InspectionLotType AS _InspectionLotType ON InspectionLotType = _InspectionLotType.InspectionLotType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BillOfOperationsBreakDurnUnit ON BillOfOperationsBreakDurnUnit = _BillOfOperationsBreakDurnUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StandardWorkQuantityUnit1 ON StandardWorkQuantityUnit1 = _StandardWorkQuantityUnit1.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StandardWorkQuantityUnit2 ON StandardWorkQuantityUnit2 = _StandardWorkQuantityUnit2.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StandardWorkQuantityUnit3 ON StandardWorkQuantityUnit3 = _StandardWorkQuantityUnit3.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StandardWorkQuantityUnit4 ON StandardWorkQuantityUnit4 = _StandardWorkQuantityUnit4.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StandardWorkQuantityUnit5 ON StandardWorkQuantityUnit5 = _StandardWorkQuantityUnit5.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StandardWorkQuantityUnit6 ON StandardWorkQuantityUnit6 = _StandardWorkQuantityUnit6.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_PerformanceEfficiencyRatio AS _PerformanceEfficiencyRatio1 ON PerfEfficiencyRatioCode1 = _PerformanceEfficiencyRatio1.PerformanceEfficiencyRatioCode  -- association [1..1]
LEFT OUTER JOIN I_PerformanceEfficiencyRatio AS _PerformanceEfficiencyRatio2 ON PerfEfficiencyRatioCode2 = _PerformanceEfficiencyRatio2.PerformanceEfficiencyRatioCode  -- association [1..1]
LEFT OUTER JOIN I_PerformanceEfficiencyRatio AS _PerformanceEfficiencyRatio3 ON PerfEfficiencyRatioCode3 = _PerformanceEfficiencyRatio3.PerformanceEfficiencyRatioCode  -- association [1..1]
LEFT OUTER JOIN I_PerformanceEfficiencyRatio AS _PerformanceEfficiencyRatio4 ON PerfEfficiencyRatioCode4 = _PerformanceEfficiencyRatio4.PerformanceEfficiencyRatioCode  -- association [1..1]
LEFT OUTER JOIN I_PerformanceEfficiencyRatio AS _PerformanceEfficiencyRatio5 ON PerfEfficiencyRatioCode5 = _PerformanceEfficiencyRatio5.PerformanceEfficiencyRatioCode  -- association [1..1]
LEFT OUTER JOIN I_PerformanceEfficiencyRatio AS _PerformanceEfficiencyRatio6 ON PerfEfficiencyRatioCode6 = _PerformanceEfficiencyRatio6.PerformanceEfficiencyRatioCode  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaximumWaitDurationUnit ON MaximumWaitDurationUnit = _MaximumWaitDurationUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MinimumWaitDurationUnit ON MinimumWaitDurationUnit = _MinimumWaitDurationUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StandardMoveDurationUnit ON StandardMoveDurationUnit = _StandardMoveDurationUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MinimumMoveDurationUnit ON MinimumMoveDurationUnit = _MinimumMoveDurationUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StandardQueueDurationUnit ON StandardQueueDurationUnit = _StandardQueueDurationUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MinimumQueueDurationUnit ON MinimumQueueDurationUnit = _MinimumQueueDurationUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MinProcessingDurnPerSplitUnit ON MinProcessingDurnPerSplitUnit = _MinProcessingDurnPerSplitUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OverlapMinimumDurationUnit ON OverlapMinimumDurationUnit = _OverlapMinimumDurationUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OverlapMinimumTransferQtyUnit ON OverlapMinimumTransferQtyUnit = _OverlapMinimumTransferQtyUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StartDateOffsetDurnUnit ON StartDateOffsetDurationUnit = _StartDateOffsetDurnUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EndDateOffsetDurnUnit ON EndDateOffsetDurationUnit = _EndDateOffsetDurnUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_LeadTimeReductionStrategy AS _LeadTimeReductionStrategy ON LeadTimeReductionStrategy = _LeadTimeReductionStrategy.LeadTimeReductionStrategy AND Plant = _LeadTimeReductionStrategy.Plant  -- association [0..1]
LEFT OUTER JOIN I_EmployeeWageGroup AS _EmployeeWageGroup ON EmployeeWageGroup = _EmployeeWageGroup.EmployeeWageGroup AND Plant = _EmployeeWageGroup.Plant  -- association [0..1]
LEFT OUTER JOIN I_EmployeeSuitability AS _EmployeeSuitability ON EmployeeSuitability = _EmployeeSuitability.EmployeeSuitability AND Plant = _EmployeeSuitability.Plant  -- association [0..1]
LEFT OUTER JOIN I_OperationSetupType AS _OperationSetupType ON OperationSetupType = _OperationSetupType.OperationSetupType AND Plant = _OperationSetupType.Plant  -- association [0..1]
LEFT OUTER JOIN I_OperationSetupGroupCategory AS _OperationSetupGroupCategory ON OperationSetupGroupCategory = _OperationSetupGroupCategory.OperationSetupGroupCategory AND Plant = _OperationSetupGroupCategory.Plant  -- association [0..1]
LEFT OUTER JOIN I_OperationSetupGroup AS _OperationSetupGroup ON OperationSetupGroup = _OperationSetupGroup.OperationSetupGroup AND OperationSetupGroupCategory = _OperationSetupGroup.OperationSetupGroupCategory AND Plant = _OperationSetupGroup.Plant  -- association [0..1]
LEFT OUTER JOIN I_ControlRecipeDestination AS _ControlRecipeDestination ON Plant = _ControlRecipeDestination.Plant AND ControlRecipeDestination = _ControlRecipeDestination.ControlRecipeDestination  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedAmount1Currency ON FreeDefinedAmount1Currency = _FreeDefinedAmount1Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedAmount2Currency ON FreeDefinedAmount2Currency = _FreeDefinedAmount2Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_FreeDfndTableFieldSemantic AS _FreeDfndTableFieldSemantic ON FreeDefinedTableFieldSemantic = _FreeDfndTableFieldSemantic.FreeDefinedTableFieldSemantic  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OperationStandardDurationUnit ON OperationStandardDurationUnit = _OperationStandardDurationUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_MaintOperationSystCondition AS _OperationSystemCondition ON OperationSystemCondition = _OperationSystemCondition.OperationSystemCondition  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Assembly ON Assembly = _Assembly.Material  -- association [0..1]
LEFT OUTER JOIN I_OperationCalculationControl AS _OperationCalculationControl ON OperationCalculationControl = _OperationCalculationControl.OperationCalculationControl  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PurchaseOrderQtyUnit ON PurchaseOrderQuantityUnit = _PurchaseOrderQtyUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MinimumDurationUnit ON MinimumDurationUnit = _MinimumDurationUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON FactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [1..1]
LEFT OUTER JOIN I_Language AS _LongTextLanguage ON LongTextLanguageCode = _LongTextLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_MaintOperationExecStageCode AS _MaintOperationExecStageCode ON MaintOperationExecStageCode = _MaintOperationExecStageCode.MaintOperationExecStageCode  -- association [1..1]
;