CNV_20551_I_PROJECT

DDL: CNV_20551_I_PROJECT Type: view_entity
16 Fields 1 Data Sources 3 Associations

Project Information

CNV_20551_I_PROJECT is a CDS View that provides data about "Project Information" in SAP S/4HANA. It reads from 1 data source (cnv_runid) and exposes 16 fields with key field Runid. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
cnv_runid Project from

Associations (3)

CardinalityTargetAliasCondition
[0..*] CNV_20551_I_COCODELIST _CompanyCodeList
[0..*] CNV_20551_I_RESULTS_ORGUNITS _OrgResults
[0..*] CNV_20551_I_RESULTS_MD _MasterDataResults

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Project Information view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (16)

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

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_I_PROJECT.
-- 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_20551_I_PROJECT AS
SELECT
  Runid,
  runid_descr AS RunidDescr,
  Rstat,
  Sstat,
  Purpose,
  Crdate,
  Crtime,
  Cruser,
  Changed,
  Chdate,
  Chtime,
  Chuser,
  Source
FROM cnv_runid AS Project
LEFT OUTER JOIN CNV_20551_I_COCODELIST AS _CompanyCodeList ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN CNV_20551_I_RESULTS_ORGUNITS AS _OrgResults ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN CNV_20551_I_RESULTS_MD AS _MasterDataResults ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More