P_ENGAGEMENTPROJECT

CDS View

P_ENGAGEMENTPROJECT is a CDS View in S/4HANA. It contains 21 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 21 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_EngagementProject view from BASIC Engagement Project
I_EngmntProjSrchModel view from BASIC Engagement Project Search Model

Fields (21)

KeyField CDS FieldsUsed in Views
changed_by LastChangedByUser 1
changed_on LastChangeDateTime 1
CompanyCode CompanyCode 2
confidential ProjectVisibility 2
ControllingArea ControllingArea 1
cost_center CostCenter 1
created_by CreatedByUser 1
created_on CreationDateTime 1
customer Customer 2
db_key EngagementProjectUUID 1
end_date ProjectEndDate 2
mp_stage EngagementProjectStage 2
org_id EngagementProjectServiceOrg 2
profit_center ProfitCenter 2
proj_manager_id ProjectManager,ProjectManagerWorkAgreement 2
ProjectProfileCode ProjectProfileCode 2
restrict_time_posting RestrictedTimePosting,TimePostingIsRestricted 1
start_date ProjectStartDate 2
text EngagementProjectName 2
textu EngmntProjNameUprCase 1
use_project_billing ProjectBillingIsUsed 1 
//@EndUserText.label: 'Engagement Project'

@VDM.private: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'PIENGMNTPROJ'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_EngagementProject
  as select from           /cpd/d_mp_hdr   as EngagementProject
    inner join             /cpd/d_mp_hdr_s as EngagementProjectText on EngagementProject.db_key = EngagementProjectText.parent_key
    left outer to one join proj            as Project               on EngagementProject.mp_id = Project.pspid
{
  EngagementProject.db_key,
  EngagementProject.mp_id,
  EngagementProject.mp_type,
  EngagementProject.mp_stage,
  EngagementProject.start_date,
  EngagementProject.end_date,
  EngagementProject.customer,
  EngagementProject.org_id,
  EngagementProject.confidential,
  EngagementProject.proj_manager_id,
  EngagementProject.project_type,
  EngagementProject.created_by,
  cast( EngagementProject.created_on as /cpd/cpm_createdon ) as created_on,
  EngagementProject.changed_by,
  cast( EngagementProject.changed_on as /cpd/cpm_changedon ) as changed_on,
  EngagementProject.cost_center,
  EngagementProject.profit_center,
  EngagementProject.restrict_time_posting,
  EngagementProject.use_project_billing,
  EngagementProjectText.text,
  EngagementProjectText.textu,
  Project.vkokr                                              as ControllingArea,
  Project.vbukr                                              as CompanyCode,
  Project.profl                                              as ProjectProfileCode

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/CPD/D_MP_HDR",
"/CPD/D_MP_HDR_S",
"PROJ"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More