C_ProjectForNetworkGraph

DDL: C_PROJECTFORNETWORKGRAPH SQL: CPROJFORNTWKGR Type: view CONSUMPTION

Project for Network Graph

C_ProjectForNetworkGraph is a Consumption CDS View that provides data about "Project for Network Graph" in SAP S/4HANA. It reads from 1 data source (I_ProjectByInternalKey) and exposes 11 fields with key field ProjectInternalID. It has 1 association to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_ProjectByInternalKey Project from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPROJFORNTWKGR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Project for Network Graph view
ObjectModel.representativeKey ProjectInternalID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID ProjectInternalID
ProjectExternalID ProjectWithCodingMask
ResponsiblePerson ResponsiblePerson
ResponsiblePersonName ResponsiblePersonName Person Responsible Name
ProfitCenter ProfitCenter
ControllingArea ControllingArea
PlannedStartDate PlannedStartDate
PlannedEndDate PlannedEndDate
IsMarkedForDeletion IsMarkedForDeletion
ControllingAreaName _ControllingArea ControllingAreaName
_ControllingArea _ControllingArea 
@AbapCatalog.sqlViewName: 'CPROJFORNTWKGR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Project for Network Graph'
@ObjectModel.representativeKey: 'ProjectInternalID'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Metadata.ignorePropagatedAnnotations:true
@VDM.viewType: #CONSUMPTION

define view C_ProjectForNetworkGraph 
  as select from I_ProjectByInternalKey as Project
  association [1..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
{
  key ProjectInternalID,
      ProjectWithCodingMask                as ProjectExternalID,
      case 
      when Project._ProjectShortText.LanguageBasedShortText is not initial
      then Project._ProjectShortText.LanguageBasedShortText 
      else ProjectDescription  
      end as ProjectDescription,      
      //ProjectDescription,

      ResponsiblePerson,
      @EndUserText.label: 'Person Responsible Name'
      ResponsiblePersonName,
      ProfitCenter,
      ControllingArea,
      PlannedStartDate,
      PlannedEndDate,
      IsMarkedForDeletion,

      _ControllingArea.ControllingAreaName as ControllingAreaName,

      //associacions

      _ControllingArea
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CONTROLLINGAREA",
"I_PROJECTBYINTERNALKEY",
"I_PROJECTOBJECTSHORTTEXT"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More