P_EngmntProjDemandPlanItem

DDL: P_ENGMNTPROJDEMANDPLANITEM SQL: PENGPDMDPLNITM Type: view COMPOSITE

P_EngmntProjDemandPlanItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_EngmntProjPlnDataUnitVers) and exposes 22 fields.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_EngmntProjPlnDataUnitVers A from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PENGPDMDPLNITM view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (22)

KeyFieldSource TableSource FieldDescription
EngagementProject I_EngmntProjPlnDataUnitVers EngagementProject
ResourceDemandUUID I_EngmntProjPlnDataUnitVers ResourceDemandUUID
EngagementProjFinPlanUUID I_EngmntProjPlnDataUnitVers EngagementProjFinPlanUUID
EngmtProjFinPlanVersion I_EngmntProjPlnDataUnitVers EngmtProjFinPlanVersion
Currency I_EngmntProjPlnDataUnitVers Currency
EmploymentInternalID I_EngmntProjPlnDataUnitVers EmploymentInternalID
EngagementProjectResource I_EngmntProjPlnDataUnitVers EngagementProjectResource
EngagementProjectResourceType I_EngmntProjPlnDataUnitVers EngagementProjectResourceType
EngagementProjectServiceOrg I_EngmntProjPlnDataUnitVers EngagementProjectServiceOrg
BillingControlCategory I_EngmntProjPlnDataUnitVers BillingControlCategory
EngmntProjPlanLineType I_EngmntProjPlnDataUnitVers EngmntProjPlanLineType
DemandCostAmt
DemandEffortQty
DemandRevnAmt
UnitOfMeasure I_EngmntProjPlnDataUnitVers UnitOfMeasure
WorkItem I_EngmntProjPlnDataUnitVers WorkItem
WorkPackageUUID I_EngmntProjPlnDataUnitVers WorkPackageUUID
WorkPackage I_EngmntProjPlnDataUnitVers WorkPackage
IsUnitBased I_EngmntProjPlnDataUnitVers IsUnitBased
ParentUnitDemandUUID I_EngmntProjPlnDataUnitVers ParentUnitDemandUUID
ResourceDemand I_EngmntProjPlnDataUnitVers ResourceDemand
ProjectStaffingInstructionText B ProjectStaffingInstructionText 
@AbapCatalog.sqlViewName: 'PENGPDMDPLNITM'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_EngmntProjDemandPlanItem
  as select from           I_EngmntProjPlnDataUnitVers as A
    left outer to one join I_EngmntProjDmndHdr         as B on  A.EngagementProject  = B.EngagementProject
                                                            and A.WorkPackage        = B.WorkPackage
                                                            and A.ResourceDemandUUID = B.ResourceDemandUUID
{
  A.EngagementProject,
  A.ResourceDemandUUID,
  A.EngagementProjFinPlanUUID,
  A.EngmtProjFinPlanVersion,
  A.Currency,
  A.EmploymentInternalID,
  A.EngagementProjectResource,
  A.EngagementProjectResourceType,
  A.EngagementProjectServiceOrg,
  A.BillingControlCategory,
  A.EngmntProjPlanLineType,
  sum(A.PlndCostAmt)   as DemandCostAmt,
  sum(A.PlndEffortQty) as DemandEffortQty,
  sum(A.PlndRevnAmt)   as DemandRevnAmt,
  A.UnitOfMeasure,
  A.WorkItem,
  A.WorkPackageUUID,
  A.WorkPackage,
  A.IsUnitBased,
  A.ParentUnitDemandUUID,
  A.ResourceDemand,
  B.ProjectStaffingInstructionText
}
where
  A.EngmntProjPlanLineType = 'D' 
group by
  A.EngagementProject,
  A.ResourceDemandUUID,
  A.EngagementProjFinPlanUUID,
  A.EngmtProjFinPlanVersion,
  A.Currency,
  A.EmploymentInternalID,
  A.EngagementProjectResource,
  A.EngagementProjectResourceType,
  A.EngagementProjectServiceOrg,
  A.BillingControlCategory,
  A.EngmntProjPlanLineType,
  A.UnitOfMeasure,
  A.WorkItem,
  A.WorkPackageUUID,
  A.WorkPackage,
  A.IsUnitBased,
  A.ParentUnitDemandUUID,
  A.ResourceDemand,
  B.ProjectStaffingInstructionText
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENGMNTPROJDMNDHDR",
"I_ENGMNTPROJPLNDATAUNITVERS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More