P_StRpRepRunDoc

DDL: P_STRPREPRUNDOC SQL: PSRREPRUNDOC Type: view BASIC Package: GLO_GEN_SRF_RUNTIME

Report Run document data

P_StRpRepRunDoc is a Basic CDS View that provides data about "Report Run document data" in SAP S/4HANA. It reads from 1 data source (srf_rep_run_doc) and exposes 10 fields with key field StatryRptRunDocUUID. Part of development package GLO_GEN_SRF_RUNTIME.

Data Sources (1)

SourceAliasJoin Type
srf_rep_run_doc srf_rep_run_doc from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSRREPRUNDOC view
VDM.viewType #BASIC view
VDM.private true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.compiler.compareFilter true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY StatryRptRunDocUUID db_key UUID
StatryRptRunUUID parent_key UUID
StatryRptTaskUUID root_key UUID
StatryDocID document_id Snapshot ID
StatryFileID file_id UUID
StatryNumQueries num_queries Number of Queries
StatryDocChangedOn changed_on Variant Changed on
StatryDocSequenceNum sequence_number Sort Sequence
StatryRefDocId reference_document_id Ref. Document ID
StatryDocStatus status Workflow Status

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_StRpRepRunDoc.
-- 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: PSRREPRUNDOC

CREATE VIEW P_StRpRepRunDoc AS
SELECT
  db_key AS StatryRptRunDocUUID,
  parent_key AS StatryRptRunUUID,
  root_key AS StatryRptTaskUUID,
  document_id AS StatryDocID,
  file_id AS StatryFileID,
  num_queries AS StatryNumQueries,
  changed_on AS StatryDocChangedOn,
  sequence_number AS StatryDocSequenceNum,
  reference_document_id AS StatryRefDocId,
  status AS StatryDocStatus
FROM srf_rep_run_doc
;