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,
  Plant AS MainWorkCenterPlant,
  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]
;