C_ObjPgMaintTaskListOperation

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 C_ObjPgMaintTaskListOperation.
-- 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: COBJPGMAINTTLOP

CREATE VIEW C_ObjPgMaintTaskListOperation AS
SELECT
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  TaskListSequence,
  TaskListOperationInternalId,
  TaskListOpBOMItmIntVersCounter,
  MaintenanceTaskListOperation,
  MaintTaskListSubOperation,
  OperationText,
  cast (' ' as abap.sstring( 1333 )) AS MaintTaskListOperationLongText,
  OperationControlProfile,
  _OperationControlProfile._Text[1:Language = $session.system_language].OperationControlProfileName AS OperationControlProfileName,
  WorkCenterTypeCode,
  _WorkCenter.WorkCenter AS WorkCenter,
  _WorkCenter._Text[1:Language = $session.system_language].WorkCenterText AS WorkCenterText,
  Plant,
  _Plant.PlantName AS PlantName,
  _TechnicalObject.TechnicalObjectLabel AS TechnicalObjectLabel,
  _TechnicalObject._TechnicalObjectText[1:Language = $session.system_language].TechnicalObjectDescription AS TechnicalObjectDescription,
  TechObjIsEquipOrFuncnlLoc,
  _TechObjIsEquipOrFuncnlLoc._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  Assembly,
  _Assembly._Text[1:Language = $session.system_language].MaterialName AS AssemblyName,
  OpPlannedWorkQuantity,
  OpWorkQuantityUnit,
  ChangeNumber,
  ValidityStartDate,
  ValidityEndDate,
  OperationStandardTextCode,
  _OperationStandardText._Text[1:Language = $session.system_language].OperationStandardTextCodeName AS OperationStandardTextCodeName,
  PurchasingInfoRecdAddlGrpgName,
  OpExternalProcessingPrice,
  OpExternalProcessingCurrency,
  NumberOfOperationPriceUnits,
  PurchasingInfoRecord,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  PurchaseContract,
  PurchaseContractItem,
  OperationStandardDuration,
  OperationStandardDurationUnit,
  NumberOfCapacities,
  OperationSystemCondition,
  _OperationSystemCondition._Text[1:Language = $session.system_language].OperationSystemConditionText AS OperationSystemConditionText,
  CostCtrActivityType,
  OperationCalculationControl,
  _OperationCalculationControl._Text[1:Language = $session.system_language].OperationCalcControlDesc AS OperationCalcControlDesc,
  PurchaseOrderQty,
  PurchaseOrderQuantityUnit,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecutionStageName AS MaintOpExecutionStageName,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecStageShortText AS MaintOpExecStageShortText,
  MaintOperationalChecklistType,
  TaskListOperationObjectKey,
  TechnicalObject,
  MaintOperationExecStageCode,
  _ChecklistType.MaintenanceChecklistTypeText AS MaintenanceChecklistTypeText
FROM I_MaintTaskListOperationTP
LEFT OUTER JOIN C_ObjPgMaintTaskListOpMaterial AS _MaintTaskListOpMaterial ON _MaintTaskListOpMaterial.TaskListType = TaskListType AND _MaintTaskListOpMaterial.TaskListGroup = TaskListGroup AND _MaintTaskListOpMaterial.TaskListGroupCounter = TaskListGroupCounter AND _MaintTaskListOpMaterial.TaskListSequence = TaskListSequence AND _MaintTaskListOpMaterial.TaskListOperationInternalId = TaskListOperationInternalId  -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintTaskListOpPRT AS _MaintTaskListOpPRT ON _MaintTaskListOpPRT.TaskListType = TaskListType AND _MaintTaskListOpPRT.TaskListGroup = TaskListGroup AND _MaintTaskListOpPRT.TaskListGroupCounter = TaskListGroupCounter AND _MaintTaskListOpPRT.TaskListSequence = TaskListSequence AND _MaintTaskListOpPRT.TaskListOperationInternalId = TaskListOperationInternalId  -- association [0..*]
LEFT OUTER JOIN C_TechObjQuickVw AS _OpTechnicalObjQuickVw ON _OpTechnicalObjQuickVw.TechnicalObject = TechnicalObject AND _OpTechnicalObjQuickVw.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc AND _OpTechnicalObjQuickVw.TechnicalObjectLabel = technicalobjectlabel  -- association [0..1]
LEFT OUTER JOIN I_MaintOpExecStageCodeText AS _MaintOpExecStageCodeText ON _MaintOpExecStageCodeText.MaintOperationExecStageCode = MaintOperationExecStageCode  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceChecklistType AS _ChecklistType ON _ChecklistType.MaintOperationalChecklistType = MaintOperationalChecklistType  -- association [0..1]
;