P_BOOOperationChangeState

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 P_BOOOperationChangeState.
-- 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: PPPBOOOPERCS

CREATE VIEW P_BOOOperationChangeState AS
SELECT
  plas.BillOfOperationsType AS BillOfOperationsType,
  plas.BillOfOperationsGroup AS BillOfOperationsGroup,
  plas.BillOfOperationsVariant AS BillOfOperationsVariant,
  plas.BillOfOperationsSequence AS BillOfOperationsSequence,
  plas.BOOOperationInternalID AS BOOOperationInternalID,
  plas.BOOSqncOpAssgmtIntVersionCntr AS BOOSqncOpAssgmtIntVersionCntr,
  plpo.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
  plpo.BillOfOperationsVersion AS BillOfOperationsVersion,
  plpo.WorkCenterInternalID AS WorkCenterInternalID,
  plpo.WorkCenterTypeCode AS WorkCenterTypeCode,
  case when plpo.IsDeleted = ' ' then plas.IsDeleted else plpo.IsDeleted end as IsDeleted AS IsDeletedendasIsDeleted,
  plpo.OperationExternalID AS OperationExternalID,
  plpo.Operation AS Operation,
  plpo.Operation_2 AS Operation_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,
  plpo.OrderHasNoSubOperations AS OrderHasNoSubOperations,
  plpo.OperationUnit AS OperationUnit,
  plpo.OpQtyToBaseQtyNmrtr AS OpQtyToBaseQtyNmrtr,
  plpo.OpQtyToBaseQtyDnmntr AS OpQtyToBaseQtyDnmntr,
  plpo.BillOfOperationsBreakDuration AS BillOfOperationsBreakDuration,
  plpo.BillOfOperationsBreakDurnUnit AS BillOfOperationsBreakDurnUnit,
  _WorkCenter._StandardWorkFmlaParamGroup.StandardWorkFormulaParam1 AS StandardWorkFormulaParam1,
  StandardWorkQuantity1,
  StandardWorkQuantityUnit1,
  CostCtrActivityType1,
  PerfEfficiencyRatioCode1,
  _WorkCenter._StandardWorkFmlaParamGroup.StandardWorkFormulaParam2 AS StandardWorkFormulaParam2,
  StandardWorkQuantity2,
  StandardWorkQuantityUnit2,
  CostCtrActivityType2,
  PerfEfficiencyRatioCode2,
  _WorkCenter._StandardWorkFmlaParamGroup.StandardWorkFormulaParam3 AS StandardWorkFormulaParam3,
  StandardWorkQuantity3,
  StandardWorkQuantityUnit3,
  CostCtrActivityType3,
  PerfEfficiencyRatioCode3,
  _WorkCenter._StandardWorkFmlaParamGroup.StandardWorkFormulaParam4 AS StandardWorkFormulaParam4,
  StandardWorkQuantity4,
  StandardWorkQuantityUnit4,
  CostCtrActivityType4,
  PerfEfficiencyRatioCode4,
  _WorkCenter._StandardWorkFmlaParamGroup.StandardWorkFormulaParam5 AS StandardWorkFormulaParam5,
  StandardWorkQuantity5,
  StandardWorkQuantityUnit5,
  CostCtrActivityType5,
  PerfEfficiencyRatioCode5,
  _WorkCenter._StandardWorkFmlaParamGroup.StandardWorkFormulaParam6 AS StandardWorkFormulaParam6,
  StandardWorkQuantity6,
  StandardWorkQuantityUnit6,
  CostCtrActivityType6,
  PerfEfficiencyRatioCode6,
  plpo.BusinessProcess AS BusinessProcess,
  TeardownAndWaitIsParallel,
  MaximumWaitDuration,
  MaximumWaitDurationUnit,
  MinimumWaitDuration,
  MinimumWaitDurationUnit,
  StandardQueueDuration,
  StandardQueueDurationUnit,
  MinimumQueueDuration,
  MinimumQueueDurationUnit,
  StandardMoveDuration,
  StandardMoveDurationUnit,
  MinimumMoveDuration,
  MinimumMoveDurationUnit,
  MaximumNumberOfSplits,
  MinProcessingDurationPerSplit,
  MinProcessingDurnPerSplitUnit,
  OperationOverlappingIsPossible,
  OperationsIsAlwaysOverlapping,
  OverlapMinimumDuration,
  OverlapMinimumDurationUnit,
  OverlapMinimumTransferQty,
  OverlapMinimumTransferQtyUnit,
  plpo.NumberOfEmployees AS NumberOfEmployees,
  OperationSetupGroupCategory,
  OperationSetupGroup,
  OperationCostingRelevancyType,
  IsNonValueAddedOperation,
  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.InspectionLotType AS InspectionLotType,
  plpo.CostElement AS CostElement,
  plpo.CompanyCode AS CompanyCode,
  plpo.OpExternalProcessingCurrency AS OpExternalProcessingCurrency,
  plpo.BOOOperationIsPhase AS BOOOperationIsPhase,
  plpo.BOOPhaseSuperiorOpInternalID AS BOOPhaseSuperiorOpInternalID,
  plpo.ControlRecipeDestination AS ControlRecipeDestination,
  plpo.CapacityCategoryCode AS CapacityCategoryCode,
  plpo.InspSbstHasNoTimeOrQuantity AS InspSbstHasNoTimeOrQuantity,
  FreeDefinedTableFieldSemantic,
  FreeDefinedAttribute01,
  FreeDefinedAttribute02,
  FreeDefinedAttribute03,
  FreeDefinedAttribute04,
  FreeDefinedQuantity1,
  FreeDefinedQuantity1Unit,
  FreeDefinedQuantity2,
  FreeDefinedQuantity2Unit,
  FreeDefinedAmount1,
  FreeDefinedAmount1Currency,
  FreeDefinedAmount2,
  FreeDefinedAmount2Currency,
  FreeDefinedDate1,
  FreeDefinedDate2,
  FreeDefinedIndicator1,
  FreeDefinedIndicator2,
  plpo.CreatedByUser AS CreatedByUser,
  plpo.LastChangeDate AS LastChangeDate,
  plpo.LastChangedByUser AS LastChangedByUser,
  plas._BillOfOperationsType AS _BillOfOperationsType,
  plas._BillOfOperationsGroup AS _BillOfOperationsGroup,
  plas._BillOfOperations AS _BillOfOperations,
  plas._BillOfOperationsSequence AS _BillOfOperationsSequence,
  plas._BOOOperationInternalID AS _BOOOperationInternalID,
  plpo._BillOfOperationsBreakDurnUnit AS _BillOfOperationsBreakDurnUnit,
  plpo._CapacityCategory AS _CapacityCategory,
  plpo._ChangeMaster AS _ChangeMaster,
  plpo._ControlRecipeDestination AS _ControlRecipeDestination,
  plpo._FactoryCalendar AS _FactoryCalendar,
  plpo._FreeDefinedAmount1Currency AS _FreeDefinedAmount1Currency,
  plpo._FreeDefinedAmount2Currency AS _FreeDefinedAmount2Currency,
  plpo._FreeDfndTableFieldSemantic AS _FreeDfndTableFieldSemantic,
  plpo._InspResultRecordingView AS _InspResultRecordingView,
  plpo._InspectionLotType AS _InspectionLotType,
  plpo._LeadTimeReductionStrategy AS _LeadTimeReductionStrategy,
  plpo._LongTextLanguage AS _LongTextLanguage,
  plpo._MaterialGroup AS _MaterialGroup,
  plpo._MaximumWaitDurationUnit AS _MaximumWaitDurationUnit,
  plpo._MinProcessingDurnPerSplitUnit AS _MinProcessingDurnPerSplitUnit,
  plpo._MinimumMoveDurationUnit AS _MinimumMoveDurationUnit,
  plpo._MinimumQueueDurationUnit AS _MinimumQueueDurationUnit,
  plpo._MinimumWaitDurationUnit AS _MinimumWaitDurationUnit,
  plpo._OpExternalProcessingCurrency AS _OpExternalProcessingCurrency,
  plpo._OperationSetupGroup AS _OperationSetupGroup,
  plpo._OperationSetupGroupCategory AS _OperationSetupGroupCategory,
  plpo._OperationStdWorkQtyGrpgCat AS _OperationStdWorkQtyGrpgCat,
  plpo._OperationUnit AS _OperationUnit,
  plpo._OverlapMinimumDurationUnit AS _OverlapMinimumDurationUnit,
  plpo._OverlapMinimumTransferQtyUnit AS _OverlapMinimumTransferQtyUnit,
  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._StandardMoveDurationUnit AS _StandardMoveDurationUnit,
  plpo._StandardQueueDurationUnit AS _StandardQueueDurationUnit,
  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._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_OperationControlProfile AS _OperationControlProfile ON OperationControlProfile = _OperationControlProfile.OperationControlProfile  -- association [1..1]
LEFT OUTER JOIN I_OperationStandardText AS _OperationStandardText ON OperationStandardTextCode = _OperationStandardText.OperationStandardTextCode  -- association [1..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_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]
;