I_NrOfDgtlAccLicArchived

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_NrOfDgtlAccLicArchived.
-- 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: IDGACLICARCH

CREATE VIEW I_NrOfDgtlAccLicArchived AS
SELECT
  agg.creation_date AS DgtlAccLicArchivingDate,
  agg.unit AS DgtlAccLicDocumentItemID,
  case when agg.unit = '4071' or agg.unit = '4101' then cast(agg.obj_count as abap.fltp) * 0.2 else agg.obj_count end as NrOfDgtlAccLicArchived AS obj_countendasNrOfDgtlAccLicArchived
FROM dac_d_aggregate AS agg
INNER JOIN I_DgtlAccLicDocumentTypeInfo AS doc_type ON /* join condition not captured in parsed metadata */
INNER JOIN I_DgtlAccLicEntitlementPeriod AS date ON /* join condition not captured in parsed metadata */
;