P_ENGMNTPROJPLNDATABYRSCETYPE
P_ENGMNTPROJPLNDATABYRSCETYPE is a CDS View in S/4HANA. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_EngmntProjPlnAggrgnByPerd | view | from | COMPOSITE |
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog:{
sqlViewName: 'PEPDTABYRESTYP',
compiler.compareFilter: true,
preserveKey: true
}
@VDM: {
viewType: #COMPOSITE,
private: true,
lifecycle.contract.type: #NONE
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
usageType: {
sizeCategory: #XXL,
serviceQuality: #D,
dataClass: #MIXED
}
}
@Metadata: {
ignorePropagatedAnnotations: true
}
define view P_EngmntProjPlnDataByRsceType
as select from P_EngmntProjPlnDataByPeriod as A
inner join I_WorkPackage as B on A.WorkPackage = B.WorkPackage
{
key A.EngagementProject,
key A.EngagementProjFinPlanUUID,
A.Customer,
A.EngagementProjectCategory,
A.EngagementProjectReviewStatus,
A.EngagementProjectStage,
A.EngagementProjectType,
A.EngmntProjReviewYearPeriod,
A.WorkPackage,
A.EngmtProjFinPlanVersion,
WorkItem,
A.Currency,
A.EngagementProjectResource,
A.EngagementProjectResourceType,
A.UnitOfMeasure,
A.EngagementProjectServiceOrg,
EngmntProjectDeliveryOrg,
'' as GLAccount, //This is added for revenue recognition to work
//EngmntProjPlanLineType,
//D.EngagementProjectResource as WorkPackageUnit,
//WorkPackageUnit,
// IsUnitBased,
A.IsMyProject,
A.ProjectManager,
A.ProjectManagerName,
A.ProjectManagerExternalID,
A.ProjectAccountant,
A.ProjectAccountantName,
A.ProjectAccountantExternalID,
A.ProjectController,
A.ProjectControllerName,
A.ProjectControllerExternalID,
A.Projectpartner,
A.ProjectPartnerName,
A.ProjectPartnerExternalID,
A.ProjectVisibility,
A.ProjectProfileCode,
A.EngmntProjectHeaderCompanyCode,
A.EngagementProjectCostCenter,
A.ProfitCenter,
case
when B.WorkPackageType = 'U' and A.EngagementProjectResourceType = '0SRV'
//when D.WorkPackage != '' and A.EngagementProjectResourceType = '0SRV'
and A.EngmtProjFinPlanVersion = '1'
then cast(PlndEffrtUnitQty as /cpd/planned_effort)
else 0
end as PlanUnitQuantity,
case
when B.WorkPackageType = 'U' and A.EngagementProjectResourceType = '0SRV'
// when D.WorkPackage != '' and A.EngagementProjectResourceType = '0SRV'
and A.EngmtProjFinPlanVersion = '2'
then cast(PlndEffrtUnitQty as /cpd/planned_effort)
else 0
end as BaselinePlannedQuantity,
A.BaselinePlndCostAmt,
case
when A.EngagementProjectResourceType = '0ACT'
then cast (A.BaselinePlndEffortQty as /cpd/planned_effort preserving type)
else 0
end as BaselinePlndEffortQty,
A.BaselinePlndRevnAmt,
case
when B.WorkPackageType = 'U' and A.EngagementProjectResourceType = '0SRV'
//when D.WorkPackage != '' and A.EngagementProjectResourceType = '0SRV'
then 'X'
else ''
end as IsUnitBased,
case
when B.WorkPackageType = 'U' and A.EngagementProjectResourceType <> '0SRV'
// when D.WorkPackage != '' and A.EngagementProjectResourceType <> '0SRV'
then 1
else 0
end as ResourceIsOfUnitWorkPackage,
case
when A.EngagementProjectResourceType = '0ACT'
then cast(A.PlndEffortQty as /cpd/planned_effort preserving type )
else 0
end as PlndEffortQty,
case
when A.EngagementProjectResourceType = '0ACT'
then
A.PlndCostAmt
else 0
end as PlannedEffortCostAmt,
A.PlndCostAmt,
A.PlndRevnAmt,
ActualPlanDeviationCost,
case
when A.EngagementProjectResourceType = '0ACT'
then
ActualPlanDeviationEffort
else 0
end as ActualPlanDeviationEffort,
case
when A.EngagementProjectResourceType = '0ACT'
then
AdjustedPlndEffort
else 0
end as AdjustedPlndEffort,
case
when A.EngagementProjectResourceType = '0ADL'
then
AdjustedPlndEffort
else 0
end as AdjustedOthRscePlndQty,
SupplyEffortQty,
PlannedCostUpToCurPerd,
PlannedRevnUpToCurPerd,
case
when A.EngagementProjectResourceType = '0ACT'
then PlndEffortUpToCurPerd
else 0
end as PlndEffortUpToCurPerd,
PlndCostAmtUpToRevPerd,
PlndRevnAmtUpToRevPerd,
case
when A.EngagementProjectResourceType = '0ACT'
then PlndEffortQtyUpToRevPerd
else 0
end as PlndEffortQtyUpToRevPerd,
case
when A.EngagementProjectResourceType = '0ADL'
then cast(A.PlndEffortQty as /cpd/planned_effort preserving type )
else 0
end as AddlResourcePlannedQuantity,
case
when A.EngagementProjectResourceType = '0ADL'
then AdjustedPlndEffort
else 0
end as AddlRsceCalcdEstToCmpltQty,
case
when A.EngagementProjectResourceType = '0ADL'
then
ActualPlanDeviationEffort
else 0
end as AddlRsceActlPlanDeviationQty,
case
when A.EngagementProjectResourceType = '0ADL'
then
A.PlndCostAmt
else 0
end as AddlResourcePlannedCostAmount,
case
when A.EngagementProjectResourceType = '0EXP'
then
A.PlndCostAmt
else 0
end as PlannedExpenseCost,
case
when A.EngagementProjectResourceType = '0EXP'
then
ActualPlanDeviationCost
else 0
end as ActualPlanDeviationExpnCost,
case
when A.EngagementProjectResourceType = '0EXP'
then
PlannedCostUpToCurPerd
else 0
end as PlndExpCostUpToCurPerd,
case
when A.EngagementProjectResourceType = '0EXP'
then
PlndCostAmtUpToRevPerd
else 0
end as PlndExpenseCostUpToRevPerd,
case
when A.EngagementProjectResourceType = '0EXP'
then
AdjustedPlndCost
else 0
end as AdjustedExpnCost,
AdjustedPlndCost,
cast(0 as /cpd/sc_completionrate) as UnitCompltnRateUpToCurPerd,
cast(0 as /cpd/sc_completionrate) as UnitCompltnRateUpToRevPerd
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKPACKAGE",
"P_ENGMNTPROJPLNDATABYPERIOD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/