SRFD_DocumentDataEnriched

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

CREATE VIEW SRFD_DocumentDataEnriched AS
SELECT
  doc_data.StatryRptDocDataUUID AS StatryRptDocDataUUID,
  doc_data.StatryRptDocUUID AS StatryRptDocUUID,
  doc_data.StatryRptTaskUUID AS StatryRptTaskUUID,
  srf_reporting.reporting_entity AS StatryRptgEntity,
  srf_reporting.rep_cat_id AS StatryRptCategory,
  srf_reporting.begin_of_period AS StatryRptPeriodStartDate,
  srf_reporting.end_of_period AS StatryRptPeriodEndDate,
  srf_reporting.reporting_period_num AS StatryRptReportingPeriodNumber,
  srf_rep_run.report_run_id AS StatryRptRunID,
  srf_rep_run_doc.document_id AS StatryRptDocument,
  doc_data.StatryRptSchemaElementId AS StatryRptSchemaElementId,
  doc_data.StatryRptSchemaAttributeId AS StatryRptSchemaAttributeId,
  doc_data.StatryRptSequenceNumber AS StatryRptSequenceNumber,
  doc_data.StatryRptParentSequenceNumber AS StatryRptParentSequenceNumber,
  SchElem.StatryRptSchemaParentElementId AS StatryRptSchemaParentElementId,
  doc_data.StatryRptDocDataGeneratedValue AS StatryRptDocDataGeneratedValue,
  doc_data.StatryRptDocDataModifiedValue AS StatryRptDocDataModifiedValue,
  doc_data.StatryRptDocDataValue AS StatryRptDocDataValue,
  doc_data.StatryRptDocDataChangeInd AS StatryRptDocDataChangeInd,
  SchElem.StatryRptSchemaRefElementId AS StatryRptSchemaRefElementId,
  SchElem.StatryRptSchemaSingleValLeafEl AS StatryRptSchemaSingleValLeafEl,
  $parameters.p_partition_no AS StatryRptPartitionNo,
  doc_data.StatryRptPreviousSeqNo AS StatryRptPreviousSeqNo,
  doc_data.StatryRptSubordinalNo AS StatryRptSubordinalNo
FROM SRFD_DocumentData AS doc_data
INNER JOIN srf_reporting ON /* join condition not captured in parsed metadata */
INNER JOIN srf_rep_run_doc ON /* join condition not captured in parsed metadata */
INNER JOIN srf_rep_run ON /* join condition not captured in parsed metadata */
INNER JOIN SRFD_SchemaElementEnriched AS SchElem ON /* join condition not captured in parsed metadata */
;