I_DfsEnterpriseProject

DDL: I_DFSENTERPRISEPROJECT SQL: IDFSENTPROJECTS Type: view COMPOSITE

Defence Enterprise Projects

I_DfsEnterpriseProject is a Composite CDS View that provides data about "Defence Enterprise Projects" in SAP S/4HANA. It reads from 1 data source (I_PPM_ProjectSummaryTask) and exposes 16 fields with key fields ProjectUUID, ProjectSummaryTaskUUID. It has 1 association to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_PPM_ProjectSummaryTask Project from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PPM_TaskText _ProjectName _ProjectName.TaskUUID = $projection.ProjectSummaryTaskUUID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IDFSENTPROJECTS view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Defence Enterprise Projects view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.representativeKey ProjectUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID I_PPM_ProjectSummaryTask ProjectUUID
KEY ProjectSummaryTaskUUID I_PPM_ProjectSummaryTask ProjectSummaryTaskUUID
ProjectInternalID I_PPM_ProjectSummaryTask ProjectInternalID
Project I_PPM_ProjectSummaryTask Project
WBSElementInternalID I_PPM_ProjectSummaryTask WBSElementInternalID
ProjectName _ProjectName ObjectName
LastChangedByUser I_PPM_ProjectSummaryTask ProjectLastChangedByUser
LastChangeDateTime I_PPM_ProjectSummaryTask ProjectLastChangedDateTime
CreatedByUser I_PPM_ProjectSummaryTask CreatedByUser
CreationDateTime I_PPM_ProjectSummaryTask CreationDateTime
_ProjObjRoot I_PPM_ProjectSummaryTask _ProjObjRoot
_AuthUser I_PPM_ProjectSummaryTask _AuthUser
_AuthSubst I_PPM_ProjectSummaryTask _AuthSubst
_AuthRole I_PPM_ProjectSummaryTask _AuthRole
_AuthGroup I_PPM_ProjectSummaryTask _AuthGroup
_ProjectName _ProjectName 
@AbapCatalog.sqlViewName: 'IDFSENTPROJECTS'
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Defence Enterprise Projects'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

@AccessControl: {
    authorizationCheck:     #CHECK,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED,
    privilegedAssociations: ['_ProjectName']
}

@ObjectModel: {
   semanticKey:       [ 'Project' ],
   representativeKey: 'ProjectUUID',
   alternativeKey: [ { id : 'ProjectSummaryTaskUUID', uniqueness: #UNIQUE, element: 'ProjectSummaryTaskUUID' },
                     { id : 'ProjectInternalID'     , uniqueness: #UNIQUE, element: 'ProjectInternalID' }       ],
   usageType: {
     serviceQuality:  #C,
     dataClass:       #MASTER,
     sizeCategory:    #L
   }
} 
define view I_DfsEnterpriseProject
  as select from I_PPM_ProjectSummaryTask as Project
  association [0..1] to I_PPM_TaskText as _ProjectName on _ProjectName.TaskUUID = $projection.ProjectSummaryTaskUUID

{
  key Project.ProjectUUID,
  key Project.ProjectSummaryTaskUUID,

      Project.ProjectInternalID,      

      @EndUserText: {     label:    'Project ID',
                      quickInfo:    'Unique identification of the project'
      }

      Project.Project,

      @Consumption.hidden: true
      Project.WBSElementInternalID,
      _ProjectName.ObjectName            as ProjectName,

      /*  Admin data  */
      Project.ProjectLastChangedByUser   as LastChangedByUser,
      Project.ProjectLastChangedDateTime as LastChangeDateTime,
      Project.CreatedByUser,
      Project.CreationDateTime,

      /* Assocations */
      Project._ProjObjRoot,
      Project._AuthUser,
      Project._AuthSubst,
      Project._AuthRole,
      Project._AuthGroup,
      
      _ProjectName
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_PROJECTSUMMARYTASK",
"I_PPM_TASKTEXT"
],
"ASSOCIATED":
[
"I_PPM_AUTHZNBYSUBSTITH",
"I_PPM_AUTHZNBYUSERROLEH",
"I_PPM_AUTHZNBYUSRGRPH",
"I_PPM_AUTHZNBYUSRH",
"I_PPM_TASKTEXT",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"I_PPM_PROJECTSUMMARYTASK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More