P_Cproject

DDL: P_CPROJECT SQL: PCPROJECT Type: view COMPOSITE Package: VDM_CPM_WS

CPROJECT

P_Cproject is a Composite CDS View that provides data about "CPROJECT" in SAP S/4HANA. It reads from 2 data sources (I_CProject, I_CProjectItem) and exposes 9 fields. Part of development package VDM_CPM_WS.

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
}