I_MaintTaskListGroupCounter

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_MaintTaskListGroupCounter.
-- 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: IMNTTASKGRPCTR

CREATE VIEW I_MaintTaskListGroupCounter AS
SELECT
  plkz.plnty AS BillOfOperationsType,
  plkz.plnnr AS BillOfOperationsGroup,
  plkz.plnal AS BillOfOperationsVariant,
  plkz.subtype AS BillOfOperationsVersionType,
  plkz.subtype AS BillOfOperationsSubtype,
  plkz.abdat AS LastUsageDate,
  plkz.abanz AS NumberOfUsages,
  plkz.flg_ecm AS HasChangeNumber,
  plkz.flg_ecm_par AS HasParameterEffectivity,
  plkz.aeuzeit AS LastChangeTime,
  cast(plkz.aenam as vdm_lastchangedbyuserid preserving type) AS LastChangedByUser,
  plkz.rework AS RoutingIsReworkRouting,
  plkz.relaxed AS ProdnProcgIsFlexible
FROM plkz
LEFT OUTER JOIN I_MaintenanceTaskListType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.TaskListType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsVersionType AS _BillOfOperationsVersionType ON BillOfOperationsVersionType = _BillOfOperationsVersionType.BillOfOperationsVersionType  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_MaintenanceTaskListGroup AS _BillOfOperationsGroup_2 ON BillOfOperationsType = _BillOfOperationsGroup_2.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup_2.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsChangeState AS _BillOfOperationsChangeState ON BillOfOperationsType = _BillOfOperationsChangeState.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsChangeState.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsChangeState.BillOfOperationsVariant  -- association [1..*]
LEFT OUTER JOIN I_BillOfOperationsSequence AS _BillOfOperationsSequence ON BillOfOperationsType = _BillOfOperationsSequence.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsSequence.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsSequence.BillOfOperationsVariant  -- association [1..*]
LEFT OUTER JOIN I_BOOMaterialAssignment AS _BOOMaterialAssignment ON BillOfOperationsType = _BOOMaterialAssignment.BillOfOperationsType AND BillOfOperationsGroup = _BOOMaterialAssignment.BillOfOperationsGroup AND BillOfOperationsVariant = _BOOMaterialAssignment.BillOfOperationsVariant  -- association [1..*]
;