I_MaintenanceTaskList

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 I_MaintenanceTaskList.
-- 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: IMAINTTASKLIST

CREATE VIEW I_MaintenanceTaskList AS
SELECT
  I_BillOfOperations.BillOfOperationsType AS TaskListType,
  I_BillOfOperations.BillOfOperationsGroup AS TaskListGroup,
  I_BillOfOperations.BillOfOperationsVariant AS TaskListGroupCounter,
  I_BillOfOperationsChangeState.BillOfOperationsDesc AS TaskListDesc,
  I_BillOfOperationsChangeState.MaintenanceStrategy AS MaintenanceStrategy,
  I_BillOfOperationsChangeState.Plant AS Plant,
  I_BillOfOperationsChangeState.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  I_BillOfOperationsChangeState.WorkCenterTypeCode AS WorkCenterTypeCode,
  I_BillOfOperationsChangeState.WorkCenterInternalID AS WorkCenterInternalID,
  I_BillOfOperationsChangeState.BillOfOperationsStatus AS TaskListStatus,
  I_BillOfOperationsChangeState.ValidityStartDate AS ValidityStartDate,
  I_BillOfOperationsChangeState.ValidityEndDate AS ValidityEndDate,
  I_BillOfOperationsChangeState.ChangeNumber AS ChangeNumber,
  I_BillOfOperationsChangeState.Assembly AS Assembly,
  I_BillOfOperationsChangeState.OperationSystemCondition AS OperationSystemCondition,
  I_BillOfOperationsChangeState.ReferenceElement AS ReferenceElement,
  I_BillOfOperationsChangeState.BillOfOperationsUsage AS TaskListUsage,
  I_BillOfOperationsChangeState.InspSubsetFieldCombination AS InspSubsetFieldCombination,
  I_BillOfOperationsChangeState.InspExternalNumberingOfValues AS InspExternalNumberingOfValues,
  I_BillOfOperationsChangeState.ControllingArea AS ControllingArea,
  I_BillOfOperationsChangeState.BillOfOperationIsConfigurable AS BillOfOperationIsConfigurable,
  I_BillOfOperationsChangeState.IsDeleted AS IsDeleted,
  I_BillOfOperationsChangeState.IsMarkedForDeletion AS IsMarkedForDeletion,
  _TaskListEquip.Equipment AS Equipment,
  _TaskListFuncnlLoc.FunctionalLocation AS FunctionalLocation,
  _TaskListFuncnlLoc._FunctionalLocation._FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  I_BillOfOperationsChangeState.BOOInternalVersionCounter AS TaskListVersionCounter,
  I_BillOfOperations.LastChangeDate AS LastChangeDate,
  I_BillOfOperations.LastChangedByUser AS LastChangedByUser,
  I_BillOfOperationsChangeState.CreatedByUser AS CreatedByUser,
  I_BillOfOperationsChangeState.CreationDate AS CreationDate,
  I_BillOfOperationsChangeState.BillOfOperationsUsage AS BillOfOperationsUsage,
  I_BillOfOperationsChangeState.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_BillOfOperationsChangeState.TaskListIsHierarchical AS TaskListIsHierarchical,
  I_BillOfOperationsChangeState.BillOfOperationsDateTime AS LastChangeDateTime,
  I_BillOfOperationsChangeState._MaintenanceStrategy AS _MaintenanceStrategy,
  I_BillOfOperationsChangeState._Plant AS _Plant,
  I_BillOfOperationsChangeState._ResponsiblePlannerGroup AS _ResponsiblePlannerGroup,
  I_BillOfOperationsChangeState._BillOfOperationsStatus AS _TaskListStatus,
  I_BillOfOperationsChangeState._WorkCenter AS _WorkCenter,
  I_BillOfOperationsChangeState._Assembly AS _Assembly,
  I_BillOfOperationsChangeState._OperationSystemCondition AS _OperationSystemCondition,
  I_BillOfOperationsChangeState._BillOfOperationsUsage AS _TaskListUsage,
  I_BillOfOperationsChangeState._InspSubsetFieldCombination AS _InspSubsetFieldCombination,
  I_BillOfOperationsChangeState._InspExtNumbering AS _InspExtNumbering,
  I_BillOfOperationsChangeState._MaintenancePlanningPlant AS _MaintenancePlanningPlant,
  I_BillOfOperationsChangeState._ControllingArea AS _ControllingArea,
  I_BillOfOperationsChangeState._ConfigurableIndicator AS _ConfigurableIndicator,
  I_BillOfOperationsChangeState.LongTextLanguageCode AS LongTextLanguageCode,
  _TaskListEquip._Equipment AS _Equipment,
  _TaskListFuncnlLoc._FunctionalLocation AS _FunctionalLocation
FROM I_BillOfOperations
INNER JOIN I_BillOfOperationsChangeState ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintenanceTaskListType AS _TaskListType ON _TaskListType.TaskListType = TaskListType  -- association [0..1]
LEFT OUTER JOIN I_PMReferenceElement AS _PMReferenceElement ON _PMReferenceElement.ReferenceElement = ReferenceElement  -- association [0..1]
LEFT OUTER JOIN I_SafetyRelevance AS _SafetyRelevance ON _SafetyRelevance.SafetyRelevantObject = SafetyRelevantObject AND _SafetyRelevance.SafetyRelevantObjectType = 'TL'  -- association [0..1]
LEFT OUTER JOIN P_TaskListToEquipAlloc AS _TaskListEquip ON _TaskListEquip.TaskListType = TaskListType AND _TaskListEquip.TaskListGroup = TaskListGroup  -- association [0..1]
LEFT OUTER JOIN P_TaskListToFuncnlLocAlloc AS _TaskListFuncnlLoc ON _TaskListFuncnlLoc.TaskListType = TaskListType AND _TaskListFuncnlLoc.TaskListGroup = TaskListGroup  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON _TechnicalObject.TechnicalObject = TechnicalObject AND _TechnicalObject.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_MaintTaskListOperation AS _MaintTaskListOperation ON _MaintTaskListOperation.TaskListType = TaskListType AND _MaintTaskListOperation.TaskListGroup = TaskListGroup AND _MaintTaskListOperation.TaskListGroupCounter = TaskListGroupCounter  -- association [0..*]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _TaskListGroup ON _TaskListGroup.BillOfOperationsType = TaskListType AND _TaskListGroup.BillOfOperationsGroup = TaskListGroup AND ( _TaskListGroup.BillOfOperationsType = 'A' OR _TaskListGroup.BillOfOperationsType = 'E' OR _TaskListGroup.BillOfOperationsType = 'T' )  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperations AS _TaskListGroupCounter ON _TaskListGroupCounter.BillOfOperationsType = TaskListType AND _TaskListGroupCounter.BillOfOperationsGroup = TaskListGroup AND _TaskListGroupCounter.BillOfOperationsVariant = TaskListGroupCounter AND ( _TaskListGroupCounter.BillOfOperationsType = 'A' OR _TaskListGroupCounter.BillOfOperationsType = 'E' OR _TaskListGroupCounter.BillOfOperationsType = 'T' )  -- association [1..1]
;