I_ENGMNTPROJECTPLANDATA
Plan Data for engagement projects
I_ENGMNTPROJECTPLANDATA is a CDS View in S/4HANA. Plan Data for engagement projects. It contains 19 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_EngmntProjPlandata | view | from | CONSUMPTION | Engagement Project Plandata |
| P_EngmntProjPlngData | view | inner | COMPOSITE | Engagement Project Planning data |
| P_EngmntProjPlngFcst | view | from | COMPOSITE | Engagement Project Plan with billing control catagory |
Fields (19)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| BillingControlCategory | BillingControlCategory | 1 | |
| EmploymentInternalID | EmploymentInternalID | 1 | |
| EngagementProjectResource | EngagementProjectResource | 1 | |
| EngagementProjectResourceType | EngagementProjectResourceType | 1 | |
| EngmntProjPlanLineType | EngmntProjPlanLineType | 1 | |
| EngmtProjEmployeeIsStaffed | EngmtProjEmployeeIsStaffed | 1 | |
| EngmtProjFinPlanVersion | EngmtProjFinPlanVersion | 1 | |
| FiscalPeriod | FiscalPeriod | 1 | |
| FiscalYear | FiscalYear | 1 | |
| IsUnitBased | IsUnitBased | 1 | |
| PlndCostAmt | PlndCostAmt | 1 | |
| PlndEffortQty | PlndEffortQty | 1 | |
| PlndRevnAmt | PlndRevnAmt | 1 | |
| ResourceDemand | ResourceDemand | 1 | |
| ResourceDemandUUID | ResourceDemandUUID | 1 | |
| ResourceSupply | ResourceSupply | 1 | |
| UnitOfMeasure | UnitOfMeasure | 1 | |
| WorkItem | WorkItem | 1 | |
| WorkPackage | WorkPackage | 1 |
@AbapCatalog.sqlViewName: 'IEPRPLANDATA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Plan Data for engagement projects'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #BASIC
define view I_EngmntProjectPlanData as select from /cpd/plandata
association [0..1] to I_EngagementProject as _EngagementProject on $projection.EngagementProject = _EngagementProject.EngagementProject
{
key plan_line_guid as PlanLineItemUUID,
cast(fp_key as /cpd/eng_pfp_db_key preserving type ) as EngagementProjFinPlanUUID,
cast(wp_key as /cpd/wp_db_key preserving type ) as WorkPackageUUID,
version as EngmtProjFinPlanVersion,
res_type as EngagementProjectResourceType,
period as FiscalPeriod,
fc_year as FiscalYear,
resource_id as EngagementProjectResource,
employee as EmploymentInternalID,
confirmed as EngmtProjEmployeeIsStaffed,
workitem_id as WorkItem,
delvry_serv_org as EngagementProjectServiceOrg,
demand_key as ResourceDemandUUID,
@Semantics.currencyCode: true
currency as Currency,
@Semantics.amount.currencyCode : 'Currency'
cost as PlndCostAmt,
@Semantics.unitOfMeasure: true
uom as UnitOfMeasure,
@Semantics.quantity.unitOfMeasure:'UnitOfMeasure'
effort as PlndEffortQty,
@Semantics.amount.currencyCode : 'Currency'
revenue as PlndRevnAmt,
line_type as EngmntProjPlanLineType,
resource_demand_id as ResourceDemand,
resource_supply_id as ResourceSupply,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'SupplySource'
source_of_supply as SourceOfSupply,
source_of_supply as SupplySource,
billgctrlcat as BillingControlCategory,
cast(mp_id as /cpd/eng_mp_id preserving type) as EngagementProject,
wp_id as WorkPackage,
is_unit_based as IsUnitBased,
parent_unit_demand_key as ParentUnitDemandUUID,
is_draft as DraftExist,
@DefaultAggregation: #SUM
cost_deviation as ActualPlanDeviationCost,
@DefaultAggregation: #SUM
effort_deviation as ActualPlanDeviationEffort,
@DefaultAggregation: #SUM
revenue_deviation as ActualPlanDeviationRevenue,
_EngagementProject
}