I_BOOSubOperationChangeState

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_BOOSubOperationChangeState.
-- 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: IPPBOOSUBOPERCS

CREATE VIEW I_BOOSubOperationChangeState AS
SELECT
  plpo.BillOfOperationsType AS BillOfOperationsType,
  plpo.BillOfOperationsGroup AS BillOfOperationsGroup,
  plas.BillOfOperationsVariant AS BillOfOperationsVariant,
  plas.BillOfOperationsSequence AS BillOfOperationsSequence,
  plpo.BOOOperationInternalID AS BOOOperationInternalID,
  plas.BOOSqncOpAssgmtIntVersionCntr AS BOOSqncOpAssgmtIntVersionCntr,
  plpo.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
  plpo.BillOfOperationsVersion AS BillOfOperationsVersion,
  plpo.WorkCenterInternalID AS WorkCenterInternalID,
  plpo.WorkCenterTypeCode AS WorkCenterTypeCode,
  case plpo.IsDeleted when ' ' then plas.IsDeleted else plpo.IsDeleted end as IsDeleted AS IsDeletedendasIsDeleted,
  cast(plpo.Operation as pph_uvorn preserving type) AS SubOperation,
  cast(plpo.Operation_2 as vdm_uvorn preserving type) AS SubOperation_2,
  plpo.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  plpo.LongTextLanguageCode AS LongTextLanguageCode,
  plpo.Plant AS Plant,
  plpo.FactoryCalendar AS FactoryCalendar,
  plpo.BillOfOperationsRefGroup AS BillOfOperationsRefGroup,
  plpo.BillOfOperationsRefVariant AS BillOfOperationsRefVariant,
  cast(plpo.CapacityCategoryCode as pph_kapart preserving type) AS CapacityCategoryCode,
  plpo.CreatedByUser AS CreatedByUser,
  plpo.LastChangeDate AS LastChangeDate,
  plpo.LastChangedByUser AS LastChangedByUser,
  plpo.OperationUnit AS OperationUnit,
  plpo.OpQtyToBaseQtyNmrtr AS OpQtyToBaseQtyNmrtr,
  plpo.OpQtyToBaseQtyDnmntr AS OpQtyToBaseQtyDnmntr,
  plpo.BillOfOperationsBreakDuration AS BillOfOperationsBreakDuration,
  plpo.BillOfOperationsBreakDurnUnit AS BillOfOperationsBreakDurnUnit,
  plpo._WorkCenter._StandardWorkFmlaParamGroup.StandardWorkFormulaParam1 AS StandardWorkFormulaParam1,
  plpo.StandardWorkQuantity1 AS StandardWorkQuantity1,
  plpo.StandardWorkQuantityUnit1 AS StandardWorkQuantityUnit1,
  plpo.CostCtrActivityType1 AS CostCtrActivityType1,
  plpo.PerfEfficiencyRatioCode1 AS PerfEfficiencyRatioCode1,
  plpo._WorkCenter._StandardWorkFmlaParamGroup.StandardWorkFormulaParam2 AS StandardWorkFormulaParam2,
  plpo.StandardWorkQuantity2 AS StandardWorkQuantity2,
  plpo.StandardWorkQuantityUnit2 AS StandardWorkQuantityUnit2,
  plpo.CostCtrActivityType2 AS CostCtrActivityType2,
  plpo.PerfEfficiencyRatioCode2 AS PerfEfficiencyRatioCode2,
  plpo._WorkCenter._StandardWorkFmlaParamGroup.StandardWorkFormulaParam3 AS StandardWorkFormulaParam3,
  plpo.StandardWorkQuantity3 AS StandardWorkQuantity3,
  plpo.StandardWorkQuantityUnit3 AS StandardWorkQuantityUnit3,
  plpo.CostCtrActivityType3 AS CostCtrActivityType3,
  plpo.PerfEfficiencyRatioCode3 AS PerfEfficiencyRatioCode3,
  plpo._WorkCenter._StandardWorkFmlaParamGroup.StandardWorkFormulaParam4 AS StandardWorkFormulaParam4,
  plpo.StandardWorkQuantity4 AS StandardWorkQuantity4,
  plpo.StandardWorkQuantityUnit4 AS StandardWorkQuantityUnit4,
  plpo.CostCtrActivityType4 AS CostCtrActivityType4,
  plpo.PerfEfficiencyRatioCode4 AS PerfEfficiencyRatioCode4,
  plpo._WorkCenter._StandardWorkFmlaParamGroup.StandardWorkFormulaParam5 AS StandardWorkFormulaParam5,
  plpo.StandardWorkQuantity5 AS StandardWorkQuantity5,
  plpo.StandardWorkQuantityUnit5 AS StandardWorkQuantityUnit5,
  plpo.CostCtrActivityType5 AS CostCtrActivityType5,
  plpo.PerfEfficiencyRatioCode5 AS PerfEfficiencyRatioCode5,
  plpo._WorkCenter._StandardWorkFmlaParamGroup.StandardWorkFormulaParam6 AS StandardWorkFormulaParam6,
  plpo.StandardWorkQuantity6 AS StandardWorkQuantity6,
  plpo.StandardWorkQuantityUnit6 AS StandardWorkQuantityUnit6,
  plpo.CostCtrActivityType6 AS CostCtrActivityType6,
  plpo.PerfEfficiencyRatioCode6 AS PerfEfficiencyRatioCode6,
  plpo.BusinessProcess AS BusinessProcess,
  plpo.StartDateOffsetDuration AS StartDateOffsetDuration,
  plpo.EndDateOffsetDurationUnit AS EndDateOffsetDurationUnit,
  plpo.EndDateOffsetDuration AS EndDateOffsetDuration,
  plpo.NumberOfEmployees AS NumberOfEmployees,
  plpo.OperationSetupGroupCategory AS OperationSetupGroupCategory,
  plpo.OperationSetupGroup AS OperationSetupGroup,
  plpo.ControlRecipeDestination AS ControlRecipeDestination,
  plpo.PurchasingInfoRecord AS PurchasingInfoRecord,
  plpo.PurchasingOrganization AS PurchasingOrganization,
  plpo.PurchaseContract AS PurchaseContract,
  plpo.PurchaseContractItem AS PurchaseContractItem,
  plpo.PurchasingInfoRecdAddlGrpgName AS PurchasingInfoRecdAddlGrpgName,
  plpo.MaterialGroup AS MaterialGroup,
  plpo.PurchasingGroup AS PurchasingGroup,
  plpo.Supplier AS Supplier,
  plpo.PlannedDeliveryDuration AS PlannedDeliveryDuration,
  plpo.NumberOfOperationPriceUnits AS NumberOfOperationPriceUnits,
  plpo.OpExternalProcessingPrice AS OpExternalProcessingPrice,
  plpo.OpExternalProcessingCurrency AS OpExternalProcessingCurrency,
  plpo.InspectionLotType AS InspectionLotType,
  plpo.CostElement AS CostElement,
  plpo.OperationCostingRelevancyType AS OperationCostingRelevancyType,
  plpo._BillOfOperationsBreakDurnUnit AS _BillOfOperationsBreakDurnUnit,
  plpo._CapacityCategory AS _CapacityCategory,
  plpo._ChangeMaster AS _ChangeMaster,
  plpo._ControlRecipeDestination AS _ControlRecipeDestination,
  plpo._EndDateOffsetDurnUnit AS _EndDateOffsetDurnUnit,
  plpo._FactoryCalendar AS _FactoryCalendar,
  plpo._InspectionLotType AS _InspectionLotType,
  plpo._LeadTimeReductionStrategy AS _LeadTimeReductionStrategy,
  plpo._LongTextLanguage AS _LongTextLanguage,
  plpo._MaterialGroup AS _MaterialGroup,
  plpo._OperationSetupGroup AS _OperationSetupGroup,
  plpo._OperationSetupGroupCategory AS _OperationSetupGroupCategory,
  plpo._OperationStdWorkQtyGrpgCat AS _OperationStdWorkQtyGrpgCat,
  plpo._OperationUnit AS _OperationUnit,
  plpo._OpExternalProcessingCurrency AS _OpExternalProcessingCurrency,
  plpo._PerformanceEfficiencyRatio1 AS _PerformanceEfficiencyRatio1,
  plpo._PerformanceEfficiencyRatio2 AS _PerformanceEfficiencyRatio2,
  plpo._PerformanceEfficiencyRatio3 AS _PerformanceEfficiencyRatio3,
  plpo._PerformanceEfficiencyRatio4 AS _PerformanceEfficiencyRatio4,
  plpo._PerformanceEfficiencyRatio5 AS _PerformanceEfficiencyRatio5,
  plpo._PerformanceEfficiencyRatio6 AS _PerformanceEfficiencyRatio6,
  plpo._Plant AS _Plant,
  plpo._PurchaseContract AS _PurchaseContract,
  plpo._PurchaseContractItem AS _PurchaseContractItem,
  plpo._PurchasingGroup AS _PurchasingGroup,
  plpo._PurchasingInfoRecord AS _PurchasingInfoRecord,
  plpo._PurchasingOrganization AS _PurchasingOrganization,
  plpo._StandardWorkQuantityUnit1 AS _StandardWorkQuantityUnit1,
  plpo._StandardWorkQuantityUnit2 AS _StandardWorkQuantityUnit2,
  plpo._StandardWorkQuantityUnit3 AS _StandardWorkQuantityUnit3,
  plpo._StandardWorkQuantityUnit4 AS _StandardWorkQuantityUnit4,
  plpo._StandardWorkQuantityUnit5 AS _StandardWorkQuantityUnit5,
  plpo._StandardWorkQuantityUnit6 AS _StandardWorkQuantityUnit6,
  plpo._StartDateOffsetDurnUnit AS _StartDateOffsetDurnUnit,
  plpo._Supplier AS _Supplier,
  plpo._WorkCenter AS _WorkCenter,
  plpo._WorkCenterType AS _WorkCenterType
FROM I_BillOfOperationsOpBasic AS plpo
INNER JOIN I_BOOSqncOperationAssgmtChgSt AS plas ON /* join condition not captured in parsed metadata */
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_BillOfOperations AS _BillOfOperations ON BillOfOperationsType = _BillOfOperations.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant  -- 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_BillOfOperationsSequence 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_BillOfOperationsOperation 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_BOOSqncOperationAssgmtChgSt 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_StandardWorkFormulaParameter AS _StandardWorkFormulaParameter1 ON standardworkformulaparam1 = _StandardWorkFormulaParameter1.StandardWorkFormulaParameter  -- association [0..1]
LEFT OUTER JOIN I_StandardWorkFormulaParameter AS _StandardWorkFormulaParameter2 ON standardworkformulaparam2 = _StandardWorkFormulaParameter2.StandardWorkFormulaParameter  -- association [0..1]
LEFT OUTER JOIN I_StandardWorkFormulaParameter AS _StandardWorkFormulaParameter3 ON standardworkformulaparam3 = _StandardWorkFormulaParameter3.StandardWorkFormulaParameter  -- association [0..1]
LEFT OUTER JOIN I_StandardWorkFormulaParameter AS _StandardWorkFormulaParameter4 ON standardworkformulaparam4 = _StandardWorkFormulaParameter4.StandardWorkFormulaParameter  -- association [0..1]
LEFT OUTER JOIN I_StandardWorkFormulaParameter AS _StandardWorkFormulaParameter5 ON standardworkformulaparam5 = _StandardWorkFormulaParameter5.StandardWorkFormulaParameter  -- association [0..1]
LEFT OUTER JOIN I_StandardWorkFormulaParameter AS _StandardWorkFormulaParameter6 ON standardworkformulaparam6 = _StandardWorkFormulaParameter6.StandardWorkFormulaParameter  -- association [0..1]
LEFT OUTER JOIN I_OperationControlProfile AS _OperationControlProfile ON OperationControlProfile = _OperationControlProfile.OperationControlProfile  -- association [1..1]
LEFT OUTER JOIN I_OperationStandardText AS _OperationStandardText ON OperationStandardTextCode = _OperationStandardText.OperationStandardTextCode  -- 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]
;