CNV_20551_S4_I_PROJECT_U

DDL: CNV_20551_S4_I_PROJECT_U SQL: CNV20551_I_PROJ Type: view_entity
13 Fields 1 Data Sources

CDS Interface View for Project Entity

CNV_20551_S4_I_PROJECT_U is a CDS View that provides data about "CDS Interface View for Project Entity" in SAP S/4HANA. It reads from 1 data source (cnv_runid) and exposes 13 fields with key field Runid.

Data Sources (1)

SourceAliasJoin Type
cnv_runid project from

Annotations (6)

NameValueLevelField
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS Interface View for Project Entity view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Runid cnv_runid runid UUID
RunidDescr cnv_runid runid_descr RunID Description
Rstat cnv_runid rstat Status of the RunID
Sstat cnv_runid sstat RunIDs Sub Status
Purpose cnv_runid purpose Purpose Type
Crdate cnv_runid crdate Sizing Date
Crtime cnv_runid crtime Time Created
Cruser cnv_runid cruser User Name
Changed cnv_runid changed Time Stamp
Chdate cnv_runid chdate Date Changed
Chtime cnv_runid chtime Time Changed
Chuser cnv_runid chuser Who Changed
Source cnv_runid source ViolationSource

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 CNV_20551_S4_I_PROJECT_U.
-- 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: CNV20551_I_PROJ

CREATE VIEW CNV_20551_S4_I_PROJECT_U AS
SELECT
  project.runid AS Runid,
  project.runid_descr AS RunidDescr,
  project.rstat AS Rstat,
  project.sstat AS Sstat,
  project.purpose AS Purpose,
  project.crdate AS Crdate,
  project.crtime AS Crtime,
  project.cruser AS Cruser,
  project.changed AS Changed,
  project.chdate AS Chdate,
  project.chtime AS Chtime,
  project.chuser AS Chuser,
  project.source AS Source
FROM cnv_runid AS project
;

Learn More