P_RU_StRpJournalEntryLogStat

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 P_RU_StRpJournalEntryLogStat.
-- 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: PRUSRJRNLENTRLS

CREATE VIEW P_RU_StRpJournalEntryLogStat AS
SELECT
  doc_log.StatryRptgEntity AS StatryRptgEntity,
  doc_log.StatryRptCategory AS StatryRptCategory,
  doc_log.StatryRptRunID AS StatryRptRunID,
  doc_log.CompanyCode AS CompanyCode,
  doc_log.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  doc_log.TotalItem AS TotalItem,
  run.StatryRptRunStatus AS StatryRptRunStatus,
  run.StatryRptRunCreatedByUser AS StatryRptRunCreatedByUser,
  cast( run.GeneratedOn as dats preserving type ) AS GeneratedOn,
  concat(concat(concat(substring(run.GeneratedAt, 1, 2), ':'), concat(substring(run.GeneratedAt, 3, 2), ':')), substring(run.GeneratedAt, 3, 2)) as GeneratedAt AS GeneratedAt32asGeneratedAt,
  run.StatryRptCatPhase AS StatryRptCatPhase,
  run.StatryRptDef AS StatryRptDef,
  run.Period AS Period,
  run.StatryRptRunUUID AS StatryRptRunUUID
FROM P_RU_StRpJournalEntryLogStat1 AS doc_log
INNER JOIN P_RU_StRpRepRun AS run ON /* join condition not captured in parsed metadata */
;