P_SK_StRpVATCSAccptRun

DDL: P_SK_STRPVATCSACCPTRUN Type: view_entity COMPOSITE
6 Fields 2 Data Sources

P_SK_StRpVATCSAccptRun is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_StRpRepRun, P_SK_StRpVATCSAccptRunMax) and exposes 6 fields with key fields StatryRptgEntity, StatryRptCategory, ReportingYear, StatryRptTaskPeriodStartDate, StatryRptTaskPeriodEndDate.

Data Sources (2)

SourceAliasJoin Type
I_StRpRepRun Run from
P_SK_StRpVATCSAccptRunMax RunMax inner

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity I_StRpRepRun StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpRepRun StatryRptCategory Report ID
KEY ReportingYear I_StRpRepRun ReportingYear
KEY StatryRptTaskPeriodStartDate I_StRpRepRun StatryRptTaskPeriodStartDate
KEY StatryRptTaskPeriodEndDate I_StRpRepRun StatryRptTaskPeriodEndDate
StatryRptRunID I_StRpRepRun StatryRptRunID Report Run ID

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_SK_StRpVATCSAccptRun.
-- 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.

CREATE VIEW P_SK_StRpVATCSAccptRun AS
SELECT
  Run.StatryRptgEntity AS StatryRptgEntity,
  Run.StatryRptCategory AS StatryRptCategory,
  Run.ReportingYear AS ReportingYear,
  Run.StatryRptTaskPeriodStartDate AS StatryRptTaskPeriodStartDate,
  Run.StatryRptTaskPeriodEndDate AS StatryRptTaskPeriodEndDate,
  Run.StatryRptRunID AS StatryRptRunID
FROM I_StRpRepRun AS Run
INNER JOIN P_SK_StRpVATCSAccptRunMax AS RunMax ON /* join condition not captured in parsed metadata */
;

Learn More