C_ProjDmndProjectDisplay

DDL: C_PROJDMNDPROJECTDISPLAY SQL: CPROJDMNDPROJDSP Type: view CONSUMPTION

Project Details

C_ProjDmndProjectDisplay is a Consumption CDS View that provides data about "Project Details" in SAP S/4HANA. It reads from 1 data source (I_EnterpriseProject) and exposes 29 fields with key fields ProjectUUID, ProjectDescription. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_EnterpriseProject I_EnterpriseProject from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PPM_ProjectProcgStatusVH _ProcessingStatus _ProcessingStatus.ProcessingStatus = $projection.ProcessingStatus

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPROJDMNDPROJDSP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Project Details view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ProjectDescription view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID ProjectUUID
KEY ProjectDescription ProjectDescription Project Name
ControllingArea ControllingArea
ProfitCenter ProfitCenter
CompanyCode CompanyCode
ResponsibleCostCenter ResponsibleCostCenter
Plant Plant
EnterpriseProjectType EnterpriseProjectType
ProjectProfileCode ProjectProfileCode
FunctionalArea FunctionalArea
ProcessingStatusText
ProjectProcessingStatus _ProcessingStatus ProcessingStatus Project Processing Status
ProcessingStatus ProcessingStatus
Project Project Project
PlannedStartDate PlannedStartDate Project Planned Start
PlannedEndDate PlannedEndDate Project Planned End
ActualStartDate ActualStartDate Project Actual Start
ActualFinishDate ActualFinishDate Project Actual Finish
ProjectSummaryTaskUUID ProjectSummaryTaskUUID
WBSElementInternalID WBSElementInternalID
_ProjectElement _ProjectElement
_ProjectRole _ProjectRole
_ProjectTeamMember _ProjectTeamMember
EnterpriseProjectServiceOrg EnterpriseProjectServiceOrg
ProjectCategory ProjectCategory
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup
@AbapCatalog.sqlViewName: 'CPROJDMNDPROJDSP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Project Details'
@AbapCatalog.preserveKey: true

@AccessControl.personalData.blocking:#REQUIRED
@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   semanticKey:       [ 'ProjectUUID' ],
   representativeKey: 'ProjectDescription',
   usageType: {
     serviceQuality:  #C,
     dataClass:       #MIXED,
     sizeCategory:    #L
    }
}
@Search.searchable: true
define view C_ProjDmndProjectDisplay
  as select from I_EnterpriseProject


  association [0..1] to I_PPM_ProjectProcgStatusVH as _ProcessingStatus on _ProcessingStatus.ProcessingStatus = $projection.ProcessingStatus
  // association [0..1] to I_PPM_ProjectManager       as _PPMProjectManager         on  _PPMProjectManager.ProjectUUID = $projection.ProjectUUID

  //  association [0..1] to I_BusinessUser             as _ProjectManager            on  _ProjectManager.BusinessPartnerUUID = $projection.projectmanageruuid


{
      @UI.facet: [
      {
      purpose: #QUICK_VIEW,
      type: #FIELDGROUP_REFERENCE,
      targetQualifier: 'PPOPOVER1',
      label: 'General Information'
      },
      {
      purpose: #QUICK_VIEW,
      type: #FIELDGROUP_REFERENCE,
      targetQualifier: 'PPOPOVER2',
      label: 'Dates'
      }
      ]

      @UI.hidden: true
  key ProjectUUID,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #MEDIUM
      @EndUserText.label: 'Project Name'
      @EndUserText.quickInfo: 'Project Name'
      @Consumption.valueHelpDefinition: [{entity: {name: 'C_EnterpriseProjectVH', element: 'ProjectName'}}]
  key ProjectDescription,

      @UI.hidden: true
      ControllingArea,

      @UI.hidden: true
      ProfitCenter,
      // @EndUserText.label: 'Project Manager'

      //       @UI: {

      //    fieldGroup:     [{ qualifier:'PPOPOVER1', position: 20}]

      // }

      //   @ObjectModel.foreignKey: {

      //          association: '_ProjectManager'

      //      }


      // _PPMProjectManager.ProjectManagerUUID,

      
      //CE2308 - Fields added for Auth checks

      @UI.hidden: true
      CompanyCode,
      
      @UI.hidden: true
      ResponsibleCostCenter,
      
      @UI.hidden: true
      Plant,
      
      @UI.hidden: true
      EnterpriseProjectType,
      
      @UI.hidden: true
      ProjectProfileCode,
      
      @UI.hidden: true
      FunctionalArea,

      _ProcessingStatus._Text[1:Language = $session.system_language].ProcessingStatusText as ProcessingStatusText,

      @EndUserText.label: 'Project Processing Status'
      @UI: {
   fieldGroup:     [{ qualifier:'PPOPOVER1', position: 10, label: 'Processing Status'}]
}
      @ObjectModel.text.element: 'ProcessingStatusText'
      @UI.textArrangement: #TEXT_ONLY
      @Consumption.valueHelpDefinition: [{entity: {name: 'I_PPM_ProjectProcgStatusVH', element: 'ProcessingStatus'}}]
      _ProcessingStatus.ProcessingStatus                                                  as ProjectProcessingStatus,

      @UI.hidden: true
      ProcessingStatus,
      @EndUserText.label: 'Project'
      @Consumption.valueHelpDefinition: [{entity: {name: 'C_EnterpriseProjectVH', element: 'Project'}}]
      Project,

      @EndUserText.label: 'Project Planned Start'
      @UI: {
       fieldGroup:     [{ qualifier:'PPOPOVER2', position: 30, label: 'Planned Start'}]
   }
      @Consumption.filter.selectionType: #INTERVAL
      PlannedStartDate,
      @EndUserText.label: 'Project Planned End'
      @UI: {
       fieldGroup:     [{ qualifier:'PPOPOVER2', position: 40, label: 'Planned End'}]
      }
      @Consumption.filter.selectionType: #INTERVAL
      PlannedEndDate,
      @EndUserText.label: 'Project Actual Start'
      @UI: {
      fieldGroup:     [{ qualifier:'PPOPOVER2', position: 50, label: 'Actual Start'}]
    }
      @Consumption.filter.hidden: true
      ActualStartDate,
      @EndUserText.label: 'Project Actual Finish'
      @UI: {
      fieldGroup:     [{ qualifier:'PPOPOVER2', position: 60, label: 'Actual Finish'}]
    }
      @Consumption.filter.hidden: true
      ActualFinishDate,

      @UI.hidden: true
      ProjectSummaryTaskUUID,
      @UI.hidden: true
      WBSElementInternalID,
      _ProjectElement,
      _ProjectRole,
      _ProjectTeamMember,
      @Consumption.filter.hidden: true
      EnterpriseProjectServiceOrg,
      ProjectCategory,
      //


      // _Project,

      // Authorization Association, do not expose externally

      @Consumption.hidden: true
      _AuthUser,
      @Consumption.hidden: true
      _AuthSubst,
      @Consumption.hidden: true
      _AuthRole,
      @Consumption.hidden: true
      _AuthGroup
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENTERPRISEPROJECT",
"I_PPM_PROCESSINGSTATUSTEXT",
"I_PPM_PROJECTPROCGSTATUSVH"
],
"ASSOCIATED":
[
"I_ENTERPRISEPROJECTELEMENT",
"I_ENTERPRISEPROJECTROLE",
"I_ENTERPRISEPROJECTTEAMMEMBER",
"I_PPM_AUTHZNBYSUBSTITH",
"I_PPM_AUTHZNBYUSERROLEH",
"I_PPM_AUTHZNBYUSRGRPH",
"I_PPM_AUTHZNBYUSRH",
"I_PPM_PROJECTPROCGSTATUSVH"
],
"BASE":
[
"I_ENTERPRISEPROJECT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/