P_RU_StRpRepRunTask

DDL: P_RU_STRPREPRUNTASK SQL: PRUSTRPRTSK Type: view COMPOSITE Package: GLO_FIN_IS_RU
15 Fields 1 Data Sources

All Reported Documents with Report RUN

P_RU_StRpRepRunTask is a Composite CDS View that provides data about "All Reported Documents with Report RUN" in SAP S/4HANA. It reads from 1 data source (I_StRpTaskDetails) and exposes 15 fields with key fields StatryRptTaskUUID, StatryRptRunUUID. Part of development package GLO_FIN_IS_RU.

Data Sources (1)

SourceAliasJoin Type
I_StRpTaskDetails I_StRpTaskDetails from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PRUSTRPRTSK view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY StatryRptTaskUUID I_StRpTaskDetails StatryRptTaskUUID UUID
KEY StatryRptRunUUID I_StRpRepRun StatryRptRunUUID
StatryRptgEntity I_StRpTaskDetails StatryRptgEntity Reporting Entity
StatryRptCategory I_StRpTaskDetails StatryRptCategory Report ID
StatryRptTaskPeriod I_StRpTaskDetails StatryRptTaskPeriod Tax Period
Country I_StRpTaskDetails Country Venue: Ctry/Reg
StatryRptTaskDueDate I_StRpTaskDetails StatryRptTaskDueDate Net Due Date
StatryRptTaskStatus I_StRpTaskDetails StatryRptTaskStatus Report Status
StatryRptTaskPeriodStartDate I_StRpTaskDetails StatryRptTaskPeriodStartDate Start Date
StatryRptTaskPeriodEndDate I_StRpTaskDetails StatryRptTaskPeriodEndDate End Date
ReportingYear I_StRpTaskDetails ReportingYear Year
StatryRptRunID I_StRpRepRun StatryRptRunID Report Run ID
StatryRptRunStatus I_StRpRepRun StatryRptRunStatus
StatryRptRunType I_StRpRepRun StatryRptRunType
StatryRptSubmittedDateTime I_StRpRepRun StatryRptSubmittedDateTime

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_StRpRepRunTask.
-- 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: PRUSTRPRTSK

CREATE VIEW P_RU_StRpRepRunTask AS
SELECT
  I_StRpTaskDetails.StatryRptTaskUUID AS StatryRptTaskUUID,
  I_StRpRepRun.StatryRptRunUUID AS StatryRptRunUUID,
  I_StRpTaskDetails.StatryRptgEntity AS StatryRptgEntity,
  I_StRpTaskDetails.StatryRptCategory AS StatryRptCategory,
  I_StRpTaskDetails.StatryRptTaskPeriod AS StatryRptTaskPeriod,
  I_StRpTaskDetails.Country AS Country,
  I_StRpTaskDetails.StatryRptTaskDueDate AS StatryRptTaskDueDate,
  I_StRpTaskDetails.StatryRptTaskStatus AS StatryRptTaskStatus,
  I_StRpTaskDetails.StatryRptTaskPeriodStartDate AS StatryRptTaskPeriodStartDate,
  I_StRpTaskDetails.StatryRptTaskPeriodEndDate AS StatryRptTaskPeriodEndDate,
  I_StRpTaskDetails.ReportingYear AS ReportingYear,
  I_StRpRepRun.StatryRptRunID AS StatryRptRunID,
  I_StRpRepRun.StatryRptRunStatus AS StatryRptRunStatus,
  I_StRpRepRun.StatryRptRunType AS StatryRptRunType,
  I_StRpRepRun.StatryRptSubmittedDateTime AS StatryRptSubmittedDateTime
FROM I_StRpTaskDetails
;

Learn More