I_ENGAGEMENTPROJECTHEADER

CDS View

Engagement Project Header

I_ENGAGEMENTPROJECTHEADER is a CDS View in S/4HANA. Engagement Project Header. It contains 2 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 2 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_EngagementProjPlanActualCost view from COMPOSITE
P_EngagementProjPlanActualCost view union COMPOSITE
P_EngmntProjectRoleAssgmt view from COMPOSITE

Fields (2)

KeyField CDS FieldsUsed in Views
KEY EngagementProject EngagementProject 2
EngmntProjectDataModelVersion EngmntProjectDataModelVersion 1 
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IENGMNTPROJHDR'
@Analytics: { dataCategory: #DIMENSION }
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.representativeKey: 'EngagementProject'
@EndUserText.label: 'Engagement Project Header'
@Metadata.allowExtensions:true
define view I_EngagementProjectHeader
  as select from /cpd/d_mp_hdr as EngagementProject
  inner join /cpd/d_mp_hdr_s as ProjectText on EngagementProject.db_key = ProjectText.parent_key

{
  key cast(EngagementProject.mp_id  as /cpd/eng_mp_id preserving type )                                                                           as             EngagementProject,
      cast(EngagementProject.db_key as /cpd/eng_db_key preserving type )                                                                          as             EngagementProjectUUID,
      cast(EngagementProject.mp_type as /cpd/eng_mp_type  preserving type )                   
                                                          as             EngagementProjectType,
      EngagementProject.mp_stage                                                                                                                  as             EngagementProjectStage,
      EngagementProject.start_date                                                                                                                as             ProjectStartDate,
      EngagementProject.end_date                                                                                                                  as             ProjectEndDate,
      EngagementProject.customer                                                                                                                  as             Customer,
      EngagementProject.org_id                                                                                                                    as             EngagementProjectServiceOrg,
      EngagementProject.confidential                                                                                                              as             ProjectVisibility,
      
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'ProjectManagerWorkAgreement'
      EngagementProject.proj_manager_id                                                                                                           as             ProjectManager,
      EngagementProject.proj_manager_id                                                                                                           as             ProjectManagerWorkAgreement,
      cast(EngagementProject.project_type as /cpd/eng_proj_type preserving type )                                                                 as             EngagementProjectCategory,
      @Semantics.dateTime:true
      @Semantics.systemDateTime.lastChangedAt:true
      cast(EngagementProject.changed_on as /cpd/cpm_changedon)                                                                                    as             LastChangeDateTime,
      EngagementProject.changed_by                                                                                                                as             LastChangedByUser,
      EngagementProject.created_by                                                                                                                as             CreatedByUser,
      @Semantics.dateTime:true
      @Semantics.systemDateTime.createdAt:true
      cast(EngagementProject.created_on as /cpd/cpm_createdon)                                                                                    as             CreationDateTime,
      EngagementProject.cost_center                                                                                                               as             CostCenter,
      EngagementProject.profit_center                                                                                                             as             ProfitCenter,
      ProjectText.text                                                                                                                            as             EngagementProjectName,    
      data_model_version                                                                                                                          as             EngmntProjectDataModelVersion
}

Learn More