P_Cproject

DDL: P_CPROJECT SQL: PCPROJECT Type: view COMPOSITE

P_Cproject is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_CProject, I_CProjectItem) and exposes 9 fields.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_CProject CProject from
I_CProjectItem CProjectItem union_all

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCPROJECT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (9)

KeyFieldSource TableSource FieldDescription
ProjectExternalID I_CProject ProjectExternalID
MasterProjectUUID I_CProject MasterProjectUUID
MasterProjectItem I_CProject MasterProjectItem
MasterProjectItemObjectType I_CProject MasterProjectItemObjectType
ProjectExternalID
MasterProjectUUID I_CProjectItem MasterProjectUUID
MasterProjectItem I_CProjectItem MasterProjectItem
MasterProjectItemObjectType I_CProjectItem MasterProjectItemObjectType
ExternalObjectIdentifier I_CProjectItem ExternalObjectIdentifier 
@AbapCatalog.sqlViewName: 'PCPROJECT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_Cproject
  as select from I_CProject as CProject
{

  
  CProject.ProjectExternalID,

  
  
  CProject.MasterProjectUUID,

  CProject.MasterProjectItem,

  CProject.MasterProjectItemObjectType,
  CProject.ExternalObjectIdentifier

}
union all select from I_CProjectItem as CProjectItem
{

  CProjectItem.ProjectExternalID,
 
  CProjectItem.MasterProjectUUID,

  CProjectItem.MasterProjectItem,

  CProjectItem.MasterProjectItemObjectType,
  CProjectItem.ExternalObjectIdentifier
}   
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CPROJECT",
"I_CPROJECTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More