CNV_20000_S4_C_PROJECT_U

DDL: CNV_20000_S4_C_PROJECT_U Type: view_entity Package: CNV_20000_S4
10 Fields 1 Data Sources 1 OData Services

CDS Projection View for Project Entity

CNV_20000_S4_C_PROJECT_U is a CDS View that provides data about "CDS Projection View for Project Entity" in SAP S/4HANA. It reads from 1 data source (CNV_20000_S4_I_PROJECT_U) and exposes 10 fields with key field ProjectID. It is exposed through 1 OData service (CNV_20000_S4_UI_PROJECT_U). Part of development package CNV_20000_S4.

Data Sources (1)

SourceAliasJoin Type
CNV_20000_S4_I_PROJECT_U CNV_20000_S4_I_PROJECT_U projection

Annotations (6)

NameValueLevelField
EndUserText.label CDS Projection View for Project Entity view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
AccessControl.authorizationCheck #NOT_REQUIRED view

OData Services (1)

ServiceBindingVersionContractRelease
CNV_20000_S4_UI_PROJECT_U CNV_20000_S4_UI_PROJECT_O2 V2 C1 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ProjectID Runid UUID
ProjectName RunidDescr RunID Description
createtime Crtime Time Created
createdate Crdate Sizing Date
createdBy Cruser User Name
lastChangedBy Chuser Who Changed
rstat Rstat Status of the RunID
ProjectStatus Project_status Project State
Sstat Sstat RunIDs Sub Status
char30

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

CREATE VIEW CNV_20000_S4_C_PROJECT_U AS
SELECT
  Runid AS ProjectID,
  RunidDescr AS ProjectName,
  Crtime AS createtime,
  Crdate AS createdate,
  Cruser AS createdBy,
  Chuser AS lastChangedBy,
  rstat,
  Project_status AS ProjectStatus,
  Sstat,
  virtual OverallStatus : abap.char(30) AS char30
FROM CNV_20000_S4_I_PROJECT_U
;

Learn More