SRFD_DocumentDataChangeLog

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

CREATE VIEW SRFD_DocumentDataChangeLog AS
SELECT
  srf_rep_run_dlog.db_key AS StatryRptDocDataChangeLogUUID,
  doc_data.StatryRptDocUUID AS StatryRptDocUUID,
  doc_data.StatryRptTaskUUID AS StatryRptTaskUUID,
  doc_data.StatryRptgEntity AS StatryRptgEntity,
  doc_data.StatryRptCategory AS StatryRptCategory,
  doc_data.StatryRptPeriodStartDate AS StatryRptPeriodStartDate,
  doc_data.StatryRptPeriodEndDate AS StatryRptPeriodEndDate,
  doc_data.StatryRptReportingPeriodNumber AS StatryRptReportingPeriodNumber,
  doc_data.StatryRptRunID AS StatryRptRunID,
  srf_rep_run_dlog.rep_run_data_key AS StatryRptDocDataUUID,
  srf_rep_run_dlog.old_value AS StatryRptDocDataOldValue,
  srf_rep_run_dlog.new_value AS StatryRptDocDataNewValue,
  srf_rep_run_dlog.comments AS StatryRptDocDataChangeComment,
  srf_rep_run_dlog.change_indicator AS StatryRptDocDataChangeInd,
  srf_rep_run_dlog.changed_by AS StatryRptDocDataChangedByUser,
  srf_rep_run_dlog.changed_on AS StatryRptDocDataChangedOnDate,
  doc_data.StatryRptDocument AS StatryRptDocument,
  doc_data.StatryRptSchemaElementId AS StatryRptSchemaElementId,
  doc_data.StatryRptSchemaAttributeId AS StatryRptSchemaAttributeId,
  doc_data.StatryRptSequenceNumber AS StatryRptSequenceNumber,
  doc_data.StatryRptParentSequenceNumber AS StatryRptParentSequenceNumber,
  doc_data.StatryRptSchemaParentElementId AS StatryRptSchemaParentElementId,
  _adrp.name_text AS StatryRptDocDataChangedByName,
  doc_data.StatryRptSchemaSingleValLeafEl AS StatryRptSchemaSingleValLeafEl
FROM srf_rep_run_dlog
INNER JOIN SRFD_DocumentDataEnriched ON /* join condition not captured in parsed metadata */
;