I_MfgBOOOperationChangeState

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_MfgBOOOperationChangeState.
-- 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: IMFGBOOOPERCHST

CREATE VIEW I_MfgBOOOperationChangeState AS
SELECT
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsSequence,
  BOOOperationInternalID,
  BOOSqncOpAssgmtIntVersionCntr,
  BOOOpInternalVersionCounter,
  OperationExternalID,
  Operation,
  Operation_2,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  ValidityStartDate,
  ValidityEndDate,
  IsDeleted,
  IsImplicitlyDeleted,
  OperationText,
  LongTextLanguageCode,
  OperationControlProfile,
  OperationStandardTextCode,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  FactoryCalendar,
  CapacityCategoryCode,
  CompanyCode,
  OperationCostingRelevancyType,
  NumberOfConfirmationSlips,
  EmployeeWageGroup,
  EmployeeWageType,
  EmployeeSuitability,
  NumberOfEmployees,
  BillOfOperationsRefGroup,
  BillOfOperationsRefVariant,
  OrderHasNoSubOperations,
  OperationSetupGroupCategory,
  OperationSetupGroup,
  BOOOperationIsPhase,
  BOOPhaseSuperiorOpInternalID,
  ControlRecipeDestination,
  OpIsExtlyProcdWithSubcontrg,
  PurchasingOrganization,
  MaterialGroup,
  case when PurchasingInfoRecord is not initial then _PurchasingInfoRec.Supplier else Supplier end as Supplier AS SupplierelseSupplierendasSupplier,
  InspResultRecordingView,
  InspSbstHasNoTimeOrQuantity,
  OperationUnit,
  OperationScrapPercent,
  OpQtyToBaseQtyNmrtr,
  OpQtyToBaseQtyDnmntr,
  cast(StandardWorkQuantity1 as vdm_vgw01 preserving type) AS StandardWorkQuantity1,
  cast(StandardWorkQuantityUnit1 as pph_vge01 preserving type) AS StandardWorkQuantityUnit1,
  cast(CostCtrActivityType1 as vdm_lar01 preserving type) AS CostCtrActivityType1,
  PerfEfficiencyRatioCode1,
  cast(StandardWorkFormulaParam2 as pph_par02 preserving type) AS StandardWorkFormulaParam2,
  cast(StandardWorkQuantity2 as vdm_vgw02 preserving type) AS StandardWorkQuantity2,
  cast(StandardWorkQuantityUnit2 as pph_vge02 preserving type) AS StandardWorkQuantityUnit2,
  cast(CostCtrActivityType2 as vdm_lar02 preserving type) AS CostCtrActivityType2,
  PerfEfficiencyRatioCode2,
  cast(StandardWorkFormulaParam3 as pph_par03 preserving type) AS StandardWorkFormulaParam3,
  cast(StandardWorkQuantity3 as vdm_vgw03 preserving type) AS StandardWorkQuantity3,
  cast(StandardWorkQuantityUnit3 as pph_vge03 preserving type) AS StandardWorkQuantityUnit3,
  cast(CostCtrActivityType3 as vdm_lar03 preserving type) AS CostCtrActivityType3,
  PerfEfficiencyRatioCode3,
  cast(StandardWorkFormulaParam4 as pph_par04 preserving type) AS StandardWorkFormulaParam4,
  cast(StandardWorkQuantity4 as vdm_vgw04 preserving type) AS StandardWorkQuantity4,
  cast(StandardWorkQuantityUnit4 as pph_vge04 preserving type) AS StandardWorkQuantityUnit4,
  cast(CostCtrActivityType4 as vdm_lar04 preserving type) AS CostCtrActivityType4,
  PerfEfficiencyRatioCode4,
  cast(StandardWorkFormulaParam5 as pph_par05 preserving type) AS StandardWorkFormulaParam5,
  cast(StandardWorkQuantity5 as vdm_vgw05 preserving type) AS StandardWorkQuantity5,
  cast(StandardWorkQuantityUnit5 as pph_vge05 preserving type) AS StandardWorkQuantityUnit5,
  cast(CostCtrActivityType5 as vdm_lar05 preserving type) AS CostCtrActivityType5,
  PerfEfficiencyRatioCode5,
  cast(StandardWorkFormulaParam6 as pph_par06 preserving type) AS StandardWorkFormulaParam6,
  cast(StandardWorkQuantity6 as vdm_vgw06 preserving type) AS StandardWorkQuantity6,
  cast(StandardWorkQuantityUnit6 as pph_vge06 preserving type) AS StandardWorkQuantityUnit6,
  cast(CostCtrActivityType6 as vdm_lar06 preserving type) AS CostCtrActivityType6,
  PerfEfficiencyRatioCode6,
  LeadTimeReductionStrategy,
  TeardownAndWaitIsParallel,
  BillOfOperationsBreakDuration,
  BillOfOperationsBreakDurnUnit AS BreakDurationUnit,
  MaximumWaitDuration,
  MaximumWaitDurationUnit,
  MinimumWaitDuration,
  MinimumWaitDurationUnit,
  StandardQueueDuration,
  StandardQueueDurationUnit,
  MinimumQueueDuration,
  MinimumQueueDurationUnit,
  StandardMoveDuration,
  StandardMoveDurationUnit,
  MinimumMoveDuration,
  MinimumMoveDurationUnit,
  MaximumNumberOfSplits,
  MinProcessingDurationPerSplit,
  MinProcessingDurnPerSplitUnit,
  OperationOverlappingIsPossible,
  OperationsIsAlwaysOverlapping,
  OverlapMinimumDuration,
  OverlapMinimumDurationUnit,
  OverlapMinimumTransferQty,
  OverlapMinimumTransferQtyUnit
FROM I_BOOOperationChangeState
LEFT OUTER JOIN I_MfgBillOfOperations AS _BillOfOperations ON BillOfOperationsType = _BillOfOperations.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant  -- association [1..1]
LEFT OUTER JOIN I_MfgBillOfOperationsSequence AS _BillOfOperationsSequence ON BillOfOperationsType = _BillOfOperationsSequence.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsSequence.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsSequence.BillOfOperationsVariant AND BillOfOperationsSequence = _BillOfOperationsSequence.BillOfOperationsSequence  -- association [1..1]
LEFT OUTER JOIN I_MfgBillOfOperationsOperation AS _BillOfOperationsOperation ON BillOfOperationsType = _BillOfOperationsOperation.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsOperation.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsOperation.BillOfOperationsVariant AND BillOfOperationsSequence = _BillOfOperationsOperation.BillOfOperationsSequence AND BOOOperationInternalID = _BillOfOperationsOperation.BOOOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_MfgBOOSequenceOpAssgmtChgSt AS _BOOSqncOperationAssgmtChgSt ON BillOfOperationsType = _BOOSqncOperationAssgmtChgSt.BillOfOperationsType AND BillOfOperationsGroup = _BOOSqncOperationAssgmtChgSt.BillOfOperationsGroup AND BillOfOperationsVariant = _BOOSqncOperationAssgmtChgSt.BillOfOperationsVariant AND BillOfOperationsSequence = _BOOSqncOperationAssgmtChgSt.BillOfOperationsSequence AND BOOOperationInternalID = _BOOSqncOperationAssgmtChgSt.BOOOperationInternalID AND BOOSqncOpAssgmtIntVersionCntr = _BOOSqncOperationAssgmtChgSt.BOOSqncOpAssgmtIntVersionCntr  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingInfoRecord AS _PurchasingInfoRec ON _PurchasingInfoRec.PurchasingInfoRecord = PurchasingInfoRecord  -- association [0..1]
LEFT OUTER JOIN I_PurgInfoRecdOrgPlntDataApi01 AS _Std_with_plant ON _Std_with_plant.PurchasingInfoRecord = PurchasingInfoRecord AND _Std_with_plant.PurchasingOrganization = PurchasingOrganization AND _Std_with_plant.PurchasingInfoRecordCategory = '0' AND _Std_with_plant.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_PurgInfoRecdOrgPlntDataApi01 AS _SubCtrct_with_plant ON _SubCtrct_with_plant.PurchasingInfoRecord = PurchasingInfoRecord AND _SubCtrct_with_plant.PurchasingOrganization = PurchasingOrganization AND _SubCtrct_with_plant.PurchasingInfoRecordCategory = '3' AND _SubCtrct_with_plant.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_PurgInfoRecdOrgPlntDataApi01 AS _Std_without_plant ON _Std_without_plant.PurchasingInfoRecord = PurchasingInfoRecord AND _Std_without_plant.PurchasingOrganization = PurchasingOrganization AND _Std_without_plant.PurchasingInfoRecordCategory = '0' AND ( _Std_without_plant.Plant = '' OR _Std_without_plant.Plant is initial )  -- association [0..1]
LEFT OUTER JOIN I_PurgInfoRecdOrgPlntDataApi01 AS _SubCtrct_without_plant ON _SubCtrct_without_plant.PurchasingInfoRecord = PurchasingInfoRecord AND _SubCtrct_without_plant.PurchasingOrganization = PurchasingOrganization AND _SubCtrct_without_plant.PurchasingInfoRecordCategory = '3' AND ( _SubCtrct_without_plant.Plant = '' OR _SubCtrct_without_plant.Plant is initial )  -- 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_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompanyByPlant AS _SupplierCompanyByPlant ON Plant = _SupplierCompanyByPlant.Plant AND Supplier = _SupplierCompanyByPlant.Supplier  -- association [0..1]
;