I_MaintPckgTaskListOpAlloc

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_MaintPckgTaskListOpAlloc.
-- 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: IMPCKTLOPALLOC

CREATE VIEW I_MaintPckgTaskListOpAlloc AS
SELECT
  plwp.plnty AS TaskListType,
  plwp.plnnr AS TaskListGroup,
  plwp.plnal AS TaskListGroupCounter,
  plwp.plnfl AS Sequence,
  plwp.plnkn AS TaskListOperationInternalId,
  plwp.paket AS MaintenancePackage,
  plwp.zaehl AS MaintPckgTskListOpAllocIntNmbr,
  plwp.datuv AS ValidityStartDate,
  plwp.iwpok AS MaintenancePackageIsRequired,
  plwp.flgwp AS AllocIsMaintainedByMaintPlan,
  plwp.loekz AS IsDeleted,
  plwp.strat AS MaintenanceStrategy,
  plwp.parkz AS AllocationHasInactiveChanges,
  plwp.aennr AS ChangeNumber,
  plwp.andat AS CreationDate,
  plwp.annam AS CreatedByUser,
  plwp.aedat AS LastChangeDate,
  plwp.aenam AS LastChangedByUser
FROM plwp
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON TaskListType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON TaskListType = _BillOfOperationsGroup.BillOfOperationsType AND TaskListGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperations AS _BillOfOperations ON TaskListType = _BillOfOperations.BillOfOperationsType AND TaskListGroup = _BillOfOperations.BillOfOperationsGroup AND TaskListGroupCounter = _BillOfOperations.BillOfOperationsVariant  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsSequence AS _BillOfOperationsSequence ON TaskListType = _BillOfOperationsSequence.BillOfOperationsType AND TaskListGroup = _BillOfOperationsSequence.BillOfOperationsGroup AND TaskListGroupCounter = _BillOfOperationsSequence.BillOfOperationsVariant AND Sequence = _BillOfOperationsSequence.BillOfOperationsSequence  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsOperation AS _BillOfOperationsOperation ON TaskListType = _BillOfOperationsOperation.BillOfOperationsType AND TaskListGroup = _BillOfOperationsOperation.BillOfOperationsGroup AND TaskListGroupCounter = _BillOfOperationsOperation.BillOfOperationsVariant AND Sequence = _BillOfOperationsOperation.BillOfOperationsSequence AND TaskListOperationInternalId = _BillOfOperationsOperation.BOOOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceTaskList AS _MaintenanceTaskList ON TaskListType = _MaintenanceTaskList.TaskListType AND TaskListGroup = _MaintenanceTaskList.TaskListGroup AND TaskListGroupCounter = _MaintenanceTaskList.TaskListGroupCounter  -- association [1..1]
LEFT OUTER JOIN I_MaintTaskListOperation AS _MaintTaskListOperation ON TaskListType = _MaintTaskListOperation.TaskListType AND TaskListGroup = _MaintTaskListOperation.TaskListGroup AND TaskListGroupCounter = _MaintTaskListOperation.TaskListGroupCounter AND Sequence = _MaintTaskListOperation.TaskListSequence AND TaskListOperationInternalId = _MaintTaskListOperation.TaskListOperationInternalId  -- association [1..1]
LEFT OUTER JOIN I_MaintenancePackage AS _MaintenancePackage ON MaintenanceStrategy = _MaintenancePackage.MaintenanceStrategy AND MaintenancePackage = _MaintenancePackage.MaintenancePackage  -- association [1..1]
LEFT OUTER JOIN I_MaintenanceStrategy AS _MaintenanceStrategy ON MaintenanceStrategy = _MaintenanceStrategy.MaintenanceStrategy  -- association [1..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumber ON ChangeNumber = _ChangeNumber.ChangeNumber  -- association [0..1]
;