P_EngmntProjPlanDataWithDraft

DDL: P_ENGMNTPROJPLANDATAWITHDRAFT SQL: PEPROJPLNWDFT Type: view COMPOSITE

P_EngmntProjPlanDataWithDraft is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_EngmntProjAssgmtToSessionUsr, I_EngmntProjPlanDataWithDraft) and exposes 39 fields.

2 data source(s) 39 fields

Data Sources (2)

SourceAliasJoin Type
I_EngmntProjAssgmtToSessionUsr A from
I_EngmntProjPlanDataWithDraft B inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PEPROJPLNWDFT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (39)

KeyFieldSource TableSource FieldDescription
ResourceDemandUUID I_EngmntProjPlanDataWithDraft ResourceDemandUUID
EngmtProjFinPlanVersion I_EngmntProjPlanDataWithDraft EngmtProjFinPlanVersion
FiscalPeriod I_EngmntProjPlanDataWithDraft FiscalPeriod
FiscalYear I_EngmntProjPlanDataWithDraft FiscalYear
EngagementProject I_EngmntProjAssgmtToSessionUsr EngagementProject
WorkPackage I_EngmntProjPlanDataWithDraft WorkPackage
EngagementProjFinPlanUUID I_EngmntProjPlanDataWithDraft EngagementProjFinPlanUUID
WorkPackageUUID I_EngmntProjPlanDataWithDraft WorkPackageUUID
EngagementProjectResourceType I_EngmntProjPlanDataWithDraft EngagementProjectResourceType
EngagementProjectResource I_EngmntProjPlanDataWithDraft EngagementProjectResource
EmploymentInternalID I_EngmntProjPlanDataWithDraft EmploymentInternalID
EngmtProjEmployeeIsStaffed I_EngmntProjPlanDataWithDraft EngmtProjEmployeeIsStaffed
WorkItem I_EngmntProjPlanDataWithDraft WorkItem
BillingControlCategory I_EngmntProjPlanDataWithDraft BillingControlCategory
EngagementProjectServiceOrg I_EngmntProjPlanDataWithDraft EngagementProjectServiceOrg
CustomerProjectServiceOrg I_EngmntProjAssgmtToSessionUsr EngagementProjectServiceOrg
Currency I_EngmntProjPlanDataWithDraft Currency
UnitOfMeasure I_EngmntProjPlanDataWithDraft UnitOfMeasure
EngmntProjPlanLineType I_EngmntProjPlanDataWithDraft EngmntProjPlanLineType
ResourceDemand I_EngmntProjPlanDataWithDraft ResourceDemand
IsUnitBased I_EngmntProjPlanDataWithDraft IsUnitBased
IsMyProject I_EngmntProjAssgmtToSessionUsr IsMyProject
EngagementProjectCategory I_EngmntProjAssgmtToSessionUsr EngagementProjectCategory
EngagementProjectType I_EngmntProjAssgmtToSessionUsr EngagementProjectType
Customer I_EngmntProjAssgmtToSessionUsr Customer
ProjectVisibility I_EngmntProjAssgmtToSessionUsr ProjectVisibility
EngagementProjectStage I_EngmntProjAssgmtToSessionUsr EngagementProjectStage
EngagementProjectCostCenter I_EngmntProjAssgmtToSessionUsr EngagementProjectCostCenter
EngmntProjectHeaderCompanyCode I_EngmntProjAssgmtToSessionUsr EngmntProjectHeaderCompanyCode
ProfitCenter I_EngmntProjAssgmtToSessionUsr ProfitCenter
ProjectProfileCode I_EngmntProjAssgmtToSessionUsr ProjectProfileCode
ControllingArea I_EngmntProjAssgmtToSessionUsr ControllingArea
LastChangeDateTime I_EngmntProjAssgmtToSessionUsr LastChangeDateTime
PlndCostAmt
PlndEffortQty
PlndRevnAmt
ActualPlanDeviationCost
ActualPlanDeviationEffort
ActualPlanDeviationRevenue 
@AbapCatalog.sqlViewName: 'PEPROJPLNWDFT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
//@EndUserText.label: 'Engagement Project Plan Data with Draft'

define view P_EngmntProjPlanDataWithDraft
  as select from I_EngmntProjAssgmtToSessionUsr as A
  inner join I_EngmntProjPlanDataWithDraft as B on A.EngagementProject = B.EngagementProject
{
  B.ResourceDemandUUID,
  B.EngmtProjFinPlanVersion,
  B.FiscalPeriod,
  B.FiscalYear,
  A.EngagementProject,
  B.WorkPackage,
  B.EngagementProjFinPlanUUID,
  B.WorkPackageUUID,
  B.EngagementProjectResourceType,
  B.EngagementProjectResource,
  B.EmploymentInternalID,
  B.EngmtProjEmployeeIsStaffed,
  B.WorkItem,
  B.BillingControlCategory,
  B.EngagementProjectServiceOrg,
  A.EngagementProjectServiceOrg as CustomerProjectServiceOrg,
  B.Currency,     
  B.UnitOfMeasure,
  B.EngmntProjPlanLineType,
  B.ResourceDemand,
  B.IsUnitBased,  
  A.IsMyProject,
  A.EngagementProjectCategory,
  A.EngagementProjectType,
  A.Customer,
  A.ProjectVisibility,
  A.EngagementProjectStage,
  A.EngagementProjectCostCenter,
  A.EngmntProjectHeaderCompanyCode,
  A.ProfitCenter,
  A.ProjectProfileCode,
  A.ControllingArea,
  A.LastChangeDateTime,
    
  sum(B.PlndCostAmt)                as PlndCostAmt, 
  sum(B.PlndEffortQty)              as PlndEffortQty, 
  sum(B.PlndRevnAmt)                as PlndRevnAmt,
  sum(B.ActualPlanDeviationCost)    as ActualPlanDeviationCost,
  sum(B.ActualPlanDeviationEffort)  as ActualPlanDeviationEffort,
  sum(B.ActualPlanDeviationRevenue) as ActualPlanDeviationRevenue
}
where
  B.EngmntProjPlanLineType = 'D'

group by

  B.ResourceDemandUUID,
  B.EngmtProjFinPlanVersion,
  B.FiscalPeriod,
  B.FiscalYear,
  A.EngagementProject,
  B.WorkPackage,
  B.EngagementProjFinPlanUUID,
  B.WorkPackageUUID,
  B.EngagementProjectResourceType,
  B.EngagementProjectResource,
  B.EmploymentInternalID,
  B.EngmtProjEmployeeIsStaffed,
  B.WorkItem,
  B.BillingControlCategory,
  B.EngagementProjectServiceOrg,
  A.EngagementProjectServiceOrg,
  B.Currency,
  B.UnitOfMeasure,
  B.EngmntProjPlanLineType,
  B.ResourceDemand,
  B.IsUnitBased,
  A.IsMyProject,
  A.EngagementProjectCategory,
  A.EngagementProjectType,
  A.Customer,
  A.ProjectVisibility,
  A.EngagementProjectStage,
  A.EngagementProjectCostCenter,
  A.EngmntProjectHeaderCompanyCode,
  A.ProfitCenter,
  A.ProjectProfileCode,
  A.ControllingArea,
  A.LastChangeDateTime
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENGMNTPROJASSGMTTOSESSIONUSR",
"I_ENGMNTPROJPLANDATAWITHDRAFT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More