N_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 N_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: NMAINTTASKLIST

CREATE VIEW N_MaintenanceTaskList AS
SELECT
  I_BillOfOperationsChangeState.BillOfOperationsType AS TaskListType,
  I_BillOfOperationsChangeState.BillOfOperationsGroup AS TaskListGroup,
  I_BillOfOperationsChangeState.BillOfOperationsVariant AS TaskListGroupCounter,
  I_BillOfOperationsChangeState.BOOInternalVersionCounter AS TaskListVersionCounter,
  I_BillOfOperationsChangeState.BillOfOperationsDesc AS TaskListDesc,
  I_BillOfOperationsChangeState.MaintenanceStrategy AS MaintenanceStrategy,
  I_BillOfOperationsChangeState.Plant AS Plant,
  I_BillOfOperationsChangeState.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  I_BillOfOperationsChangeState.IsDeleted AS IsDeleted,
  I_BillOfOperationsChangeState.Assembly AS Assembly,
  I_BillOfOperationsChangeState.BillOfOperationsStatus AS TaskListStatus,
  I_BillOfOperationsChangeState.ValidityStartDate AS ValidityStartDate,
  case I_BillOfOperationsChangeState.ValidityEndDate when '00000000' then cast ('99991231' as datub) else I_BillOfOperationsChangeState.ValidityEndDate end as ValidityEndDate AS ValidityEndDateendasValidityEndDate,
  I_BillOfOperationsChangeState.OperationSystemCondition AS OperationSystemCondition,
  I_BillOfOperationsChangeState.WorkCenterTypeCode AS WorkCenterTypeCode,
  I_BillOfOperationsChangeState.WorkCenterInternalID AS WorkCenterInternalID,
  I_BillOfOperationsChangeState.BillOfOperationsUsage AS TaskListUsage,
  I_BillOfOperationsChangeState.ControllingArea AS ControllingArea,
  _TaskListEquip.Equipment AS Equipment,
  _TaskListFuncnlLoc.FunctionalLocation AS FunctionalLocation,
  _TaskListFuncnlLoc._FunctionalLocation._FunctionalLocationLabel.FuncnlLocPrimaryLabelName AS FuncnlLocPrimaryLabelName,
  I_BillOfOperationsChangeState.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_BillOfOperationsChangeState._BillOfOperationsStatus AS _TaskListStatus,
  I_BillOfOperationsChangeState._WorkCenter AS _WorkCenter,
  I_BillOfOperationsChangeState._MaintenanceStrategy AS _MaintenanceStrategy,
  I_BillOfOperationsChangeState._Assembly AS _Assembly,
  I_BillOfOperationsChangeState._BillOfOperationsUsage AS _TaskListUsage,
  I_BillOfOperationsChangeState._ResponsiblePlannerGroup AS _ResponsiblePlannerGroup,
  _LongText.PlainLongText AS PlainLongText,
  _TaskListEquip._Equipment AS _Equipment,
  _TaskListFuncnlLoc._FunctionalLocation AS _FunctionalLocation
FROM I_BillOfOperationsChangeState
LEFT OUTER JOIN I_MaintenanceTaskListType AS _TaskListType ON _TaskListType.TaskListType = TaskListType  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
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]
LEFT OUTER JOIN I_TaskListToEquipAlloc AS _TaskListEquip ON _TaskListEquip.TaskListType = TaskListType AND _TaskListEquip.TaskListGroup = TaskListGroup AND _TaskListEquip.TaskListGroupCounter = TaskListGroupCounter  -- association [0..1]
LEFT OUTER JOIN I_TaskListToFuncnlLocAlloc AS _TaskListFuncnlLoc ON _TaskListFuncnlLoc.TaskListType = TaskListType AND _TaskListFuncnlLoc.TaskListGroup = TaskListGroup AND _TaskListFuncnlLoc.TaskListGroupCounter = TaskListGroupCounter  -- association [0..1]
LEFT OUTER JOIN I_TaskListLongText AS _LongText ON TaskListType = _LongText.TaskListType AND TaskListGroup = _LongText.TaskListGroup AND TaskListGroupCounter = _LongText.TaskListGroupCounter AND TaskListVersionCounter = _LongText.TaskListVersionCounter  -- association [0..*]
;