CNV_20000_S4_I_PROJECT_U

DDL: CNV_20000_S4_I_PROJECT_U SQL: CNV20000_IPROJ Type: view_entity
15 Fields 1 Data Sources 1 Associations

CDS View for Project Entity

CNV_20000_S4_I_PROJECT_U is a CDS View that provides data about "CDS View for Project Entity" in SAP S/4HANA. It reads from 1 data source (cnv_runid) and exposes 15 fields with key field Runid. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
cnv_runid project from

Associations (1)

CardinalityTargetAliasCondition
[1] P_CNV_20000_S4_I_DOM_DESCR _DomainDescr _DomainDescr.Rstat = $projection.Rstat

Annotations (6)

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

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Runid cnv_runid runid UUID
RunidDescr cnv_runid runid_descr RunID Description
Rstat cnv_runid rstat Status of the RunID
Project_status _DomainDescr Rstat Status of the RunID
Sstat cnv_runid sstat RunIDs Sub Status
Purpose cnv_runid purpose Purpose Type
Created cnv_runid created UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
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_20000_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: CNV20000_IPROJ

CREATE VIEW CNV_20000_S4_I_PROJECT_U AS
SELECT
  project.runid AS Runid,
  project.runid_descr AS RunidDescr,
  project.rstat AS Rstat,
  _DomainDescr.Rstat AS Project_status,
  project.sstat AS Sstat,
  project.purpose AS Purpose,
  project.created AS Created,
  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
LEFT OUTER JOIN P_CNV_20000_S4_I_DOM_DESCR AS _DomainDescr ON _DomainDescr.Rstat = Rstat  -- association [1]
;

Learn More