I_TaskListToEquipAlloc

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_TaskListToEquipAlloc.
-- 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: ITSKLSTTOEQALLOC

CREATE VIEW I_TaskListToEquipAlloc AS
SELECT
  eapl.equnr AS Equipment,
  eapl.plnty AS TaskListType,
  eapl.plnnr AS TaskListGroup,
  eapl.plnal AS TaskListGroupCounter,
  eapl.zkriz AS AdditionalCriteriaCounter,
  eapl.zaehl AS ItemCounter,
  eapl.datuv AS ValidityStartDate,
  eapl.loekz AS IsDeleted,
  eapl.aennr AS ChangeNumber,
  eapl.swerk AS MaintenancePlant,
  eapl.iwerk AS MaintenancePlanningPlant,
  eapl.plnvw AS TaskListUsage,
  eapl.andat AS CreationDate,
  cast(eapl.annam as vdm_createdbyuserid preserving type) AS CreatedByUser,
  eapl.aedat AS LastChangeDate,
  cast(eapl.aenam as vdm_lastchangedbyuserid preserving type) AS LastChangedByUser
FROM eapl
LEFT OUTER JOIN I_Equipment AS _Equipment ON _Equipment.Equipment = Equipment  -- association [1..1]
LEFT OUTER JOIN I_MaintenanceTaskList AS _MaintenanceTaskList ON _MaintenanceTaskList.TaskListType = TaskListType AND _MaintenanceTaskList.TaskListGroup = TaskListGroup AND _MaintenanceTaskList.TaskListGroupCounter = TaskListGroupCounter  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceTaskListType AS _MaintenanceTaskListType ON _MaintenanceTaskListType.TaskListType = TaskListType  -- association [1..1]
;