P_RU_StRpJournalEntryLogStat2

DDL: P_RU_STRPJOURNALENTRYLOGSTAT2 SQL: PRUSRJRNLENTRLS2 Type: view BASIC

P_RU_StRpJournalEntryLogStat2 is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_StRpRepRun) and exposes 9 fields.

Data Sources (1)

SourceAliasJoin Type
I_StRpRepRun run from

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PRUSRJRNLENTRLS2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
StatryRptgEntity I_StRpRepRun StatryRptgEntity Reporting Entity
StatryRptCategory I_StRpRepRun StatryRptCategory Report ID
StatryRptRunID I_StRpRepRun StatryRptRunID Report Run ID
StatryRptRunStatus I_StRpRepRun StatryRptRunStatus Report Run Status
StatryRptRunCreatedByUser I_StRpRepRun StatryRptRunCreatedByUser Version Created By
ts_delta run_log timestamp_delta
StatryRptCatPhase I_StRpRepRun StatryRptCatPhase
StatryRptDef I_StRpRepRun StatryRptDef Report ID
StatryRptRunUUID I_StRpRepRun StatryRptRunUUID UUID

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_StRpJournalEntryLogStat2.
-- 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: PRUSRJRNLENTRLS2

CREATE VIEW P_RU_StRpJournalEntryLogStat2 AS
SELECT
  run.StatryRptgEntity AS StatryRptgEntity,
  run.StatryRptCategory AS StatryRptCategory,
  run.StatryRptRunID AS StatryRptRunID,
  run.StatryRptRunStatus AS StatryRptRunStatus,
  run.StatryRptRunCreatedByUser AS StatryRptRunCreatedByUser,
  run_log.timestamp_delta AS ts_delta,
  run.StatryRptCatPhase AS StatryRptCatPhase,
  run.StatryRptDef AS StatryRptDef,
  run.StatryRptRunUUID AS StatryRptRunUUID
FROM I_StRpRepRun AS run
;