R_MaintTaskListSubOpTP

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 R_MaintTaskListSubOpTP.
-- 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.

CREATE VIEW R_MaintTaskListSubOpTP AS
SELECT
  BillOfOperationsType AS TaskListType,
  BillOfOperationsGroup AS TaskListGroup,
  BillOfOperationsVariant AS TaskListGroupCounter,
  BillOfOperationsSequence AS TaskListSequence,
  BOOOperationInternalID AS TaskListOperationInternalId,
  BOOOpInternalVersionCounter AS TaskListOpBOMItmIntVersCounter,
  BOOSqncOpAssgmtIntVersionCntr,
  _Operation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  _Operation.MaintenanceTaskListOperation AS MaintenanceTaskListOperation,
  BillOfOperationsVersion,
  _Operation.WorkCenter AS WorkCenter,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  SubOperation,
  SuperiorOperationInternalID,
  LongTextLanguageCode,
  Plant,
  FactoryCalendar,
  BillOfOperationsRefGroup,
  BillOfOperationsRefVariant,
  cast(CapacityCategoryCode as pph_kapart preserving type) AS CapacityCategoryCode,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  OperationUnit,
  OpQtyToBaseQtyNmrtr,
  OpQtyToBaseQtyDnmntr,
  BillOfOperationsBreakDuration,
  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,
  BusinessProcess,
  StartDateOffsetDurationUnit,
  EndDateOffsetDuration,
  EndDateOffsetDurationUnit,
  NumberOfTimeTickets,
  NumberOfEmployees,
  OperationSetupGroupCategory,
  OperationSetupGroup,
  ControlRecipeDestination,
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchaseContract,
  PurchaseContractItem,
  PurchasingInfoRecdAddlGrpgName,
  MaterialGroup,
  PurchasingGroup,
  Supplier,
  PlannedDeliveryDuration,
  NumberOfOperationPriceUnits,
  OpExternalProcessingPrice,
  InspectionLotType,
  CostElement,
  OpExternalProcessingCurrency,
  OperationCostingRelevancyType,
  Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit' _SubOperation.PurchaseOrderQty as PurchaseOrderQty AS PurchaseOrderQtyasPurchaseOrderQty,
  _SubOperation.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit
LEFT OUTER JOIN R_MaintTaskListOpBasicTP AS _Operation ON TaskListType = _Operation.TaskListType AND TaskListGroup = _Operation.TaskListGroup AND TaskListGroupCounter = _Operation.TaskListGroupCounter AND TaskListSequence = _Operation.TaskListSequence AND SuperiorOperationInternalID = _Operation.TaskListOperationInternalId  -- association [1..*]
LEFT OUTER JOIN R_MaintTaskListOpBasicTP AS _SubOperation ON TaskListType = _SubOperation.TaskListType AND TaskListGroup = _SubOperation.TaskListGroup AND TaskListGroupCounter = _SubOperation.TaskListGroupCounter AND TaskListSequence = _SubOperation.TaskListSequence AND TaskListOperationInternalId = _SubOperation.TaskListOperationInternalId AND TaskListOpBOMItmIntVersCounter = _SubOperation.TaskListOpBOMItmIntVersCounter  -- association [1..1]
;