SRFD_DocumentDataHierarchySrc

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 SRFD_DocumentDataHierarchySrc.
-- 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.
-- Parameters: p_schema_id : srf_schema_id, p_partition_no : srf_partition_no

CREATE VIEW SRFD_DocumentDataHierarchySrc AS
SELECT
  StatryRptDocDataUUID,
  StatryRptDocUUID,
  StatryRptTaskUUID,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptPeriodStartDate,
  StatryRptPeriodEndDate,
  StatryRptReportingPeriodNumber,
  StatryRptRunID,
  StatryRptDocument,
  StatryRptSchemaElementId,
  StatryRptSchemaAttributeId,
  StatryRptSequenceNumber,
  StatryRptSchemaParentElementId,
  '' AS StatryRptSchemaParentAttribId,
  StatryRptParentSequenceNumber,
  StatryRptDocDataValue,
  StatryRptDocDataChangeInd,
  StatryRptDocDataGeneratedValue,
  StatryRptDocDataModifiedValue,
  StatryRptSchemaRefElementId,
  StatryRptDocDataRefValue,
  StatryRptSchemaSingleValLeafEl
FROM SRFD_DocumentDataEnriched
LEFT OUTER JOIN SRFD_DocumentDataHierarchySrc AS _Parent ON StatryRptDocUUID = _Parent.StatryRptDocUUID AND StatryRptSchemaParentElementId = _Parent.StatryRptSchemaElementId AND StatryRptSchemaParentAttribId = _Parent.StatryRptSchemaAttributeId AND StatryRptParentSequenceNumber = _Parent.StatryRptSequenceNumber  -- association [0..*]
;