I_TaskListToFuncnlLocAlloc

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_TaskListToFuncnlLocAlloc.
-- 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.

CREATE VIEW I_TaskListToFuncnlLocAlloc AS
SELECT
  tapl.tplnr AS FunctionalLocation,
  tapl.plnty AS TaskListType,
  tapl.plnnr AS TaskListGroup,
  tapl.plnal AS TaskListGroupCounter,
  tapl.zkriz AS AdditionalCriteriaCounter,
  tapl.zaehl AS ItemCounter,
  tapl.datuv AS ValidityStartDate,
  tapl.loekz AS IsDeleted,
  tapl.aennr AS ChangeNumber,
  tapl.iwerk AS MaintenancePlanningPlant,
  tapl.andat AS CreationDate,
  cast(tapl.annam as vdm_createdbyuserid preserving type) AS CreatedByUser,
  tapl.aedat AS LastChangeDate,
  cast(tapl.aenam as vdm_lastchangedbyuserid preserving type) AS LastChangedByUser
FROM tapl
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON _FunctionalLocation.FunctionalLocation = FunctionalLocation  -- association [1..1]
LEFT OUTER JOIN I_MaintenanceTaskList AS _MaintenanceTaskList ON _MaintenanceTaskList.TaskListType = TaskListType AND _MaintenanceTaskList.TaskListGroup = TaskListGroup AND _MaintenanceTaskList.TaskListGroupCounter = TaskListGroupCounter  -- association [1..1]
LEFT OUTER JOIN I_MaintenanceTaskListType AS _MaintenanceTaskListType ON _MaintenanceTaskListType.TaskListType = TaskListType  -- association [1..1]
;