I_MfgBOOSubOperationChgSt

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_MfgBOOSubOperationChgSt.
-- 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: IMFGBOOSUBOPCHST

CREATE VIEW I_MfgBOOSubOperationChgSt AS
SELECT
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsSequence,
  BOOOperationInternalID,
  BOOSqncOpAssgmtIntVersionCntr,
  BOOOpInternalVersionCounter,
  SubOperation,
  SubOperation_2,
  SuperiorOperationInternalID,
  SubOperationText,
  LongTextLanguageCode,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  ValidityStartDate,
  ValidityEndDate,
  IsDeleted,
  IsImplicitlyDeleted,
  OperationControlProfile,
  OperationStandardTextCode,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  FactoryCalendar,
  CapacityCategoryCode,
  OperationStdWorkQtyGrpgCat,
  NumberOfConfirmationSlips,
  EmployeeWageGroup,
  EmployeeWageType,
  EmployeeSuitability,
  NumberOfEmployees,
  BillOfOperationsRefGroup,
  BillOfOperationsRefVariant,
  OperationSetupGroupCategory,
  OperationSetupGroup,
  ControlRecipeDestination,
  OpIsExtlyProcdWithSubcontrg,
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchaseContract,
  PurchaseContractItem,
  PurchasingInfoRecdAddlGrpgName,
  MaterialGroup,
  PurchasingGroup,
  Supplier,
  PlannedDeliveryDuration,
  NumberOfOperationPriceUnits,
  OpExternalProcessingCurrency,
  OpExternalProcessingPrice,
  InspectionLotType,
  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,
  StartDateOffsetDurationUnit,
  StartDateOffsetDuration,
  EndDateOffsetDurationUnit,
  EndDateOffsetDuration,
  LeadTimeReductionStrategy
FROM I_BOOSubOperationChangeState
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 SuperiorOperationInternalID = _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_SupplierCompanyByPlant AS _SupplierCompanyByPlant ON Plant = _SupplierCompanyByPlant.Plant AND Supplier = _SupplierCompanyByPlant.Supplier  -- association [0..1]
;