R_MaintenanceTaskListBasicTP

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_MaintenanceTaskListBasicTP.
-- 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: RMAINTTLBASICTP

CREATE VIEW R_MaintenanceTaskListBasicTP AS
SELECT
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  TaskListVersionCounter,
  MaintenancePlanningPlant,
  TaskListStatus,
  TechnicalObject,
  TaskListObjectKey,
  TechObjIsEquipOrFuncnlLoc,
  TaskListUsage,
  TaskListDesc,
  _WorkCenter.WorkCenter AS WorkCenter,
  WorkCenterTypeCode,
  WorkCenterInternalID,
  MaintenanceStrategy,
  OperationSystemCondition,
  Assembly,
  ChangeNumber,
  SafetyRelevantObject,
  ValidityStartDate,
  ValidityEndDate,
  IsMarkedForDeletion,
  LastChangeDate,
  LastChangedByUser,
  CreatedByUser,
  CreationDate,
  Plant,
  ResponsiblePlannerGroup,
  ReferenceElement,
  InspSubsetFieldCombination,
  InspExternalNumberingOfValues,
  IsDeleted,
  Equipment,
  FunctionalLocation,
  FunctionalLocationLabelName,
  BillOfOperationsUsage,
  TaskListIsHierarchical,
  _TaskListStatus._Text[1:Language = $session.system_language].BillOfOperationsStatusDesc AS TaskListStatusDesc,
  case TechObjIsEquipOrFuncnlLoc when 'EAMS_EQUI' then _Equipmentts._LocationAccountAssignment.ControllingArea else _FunctionalLocation._LocationAccountAssignment.ControllingArea end as ControllingArea AS ControllingAreaendasControllingArea,
  case TechObjIsEquipOrFuncnlLoc when 'EAMS_EQUI' then _Equipmentts._LocationAccountAssignment.CostCenter else _FunctionalLocation._LocationAccountAssignment.CostCenter end as CostCenter AS CostCenterendasCostCenter,
  case TechObjIsEquipOrFuncnlLoc when 'EAMS_EQUI' then _Equipmentts._LocationAccountAssignment.MaintenancePlant else _FunctionalLocation._LocationAccountAssignment.MaintenancePlant end as MaintenancePlant AS MaintenancePlantendasMaintenancePlant
FROM I_MaintenanceTaskList
LEFT OUTER JOIN R_TaskListLongTextTP AS _LongText ON TaskListType = _LongText.TaskListType AND TaskListGroup = _LongText.TaskListGroup AND TaskListGroupCounter = _LongText.TaskListGroupCounter AND TaskListVersionCounter = _LongText.TaskListVersionCounter  -- association [0..1]
LEFT OUTER JOIN R_MaintTskListStrgyPackageTP AS _MaintPackage ON TaskListType = _MaintPackage.TaskListType AND TaskListGroup = _MaintPackage.TaskListGroup AND TaskListGroupCounter = _MaintPackage.TaskListGroupCounter  -- association [0..*]
LEFT OUTER JOIN R_MaintTaskListOpBasicTP AS _Operation ON TaskListType = _Operation.TaskListType AND TaskListGroup = _Operation.TaskListGroup AND TaskListGroupCounter = _Operation.TaskListGroupCounter AND ValidityEndDate >= _Operation.ValidityStartDate AND ValidityStartDate <= _Operation.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_EquipmentTimeSeg AS _Equipmentts ON Equipment = _Equipmentts.Equipment AND _Equipmentts.ValidityEndDate = '99991231' AND _Equipmentts.EquipUsagePeriodSequenceNumber = '001'  -- association [0..1]
;