P_WorkPackageUnitKPI

DDL: P_WORKPACKAGEUNITKPI SQL: PWRKPKGUKPI Type: view COMPOSITE

P_WorkPackageUnitKPI is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_EngmntProjAssgmtToSessionUsr, I_EngmntProjectUnitDataVersion) and exposes 37 fields with key fields EngagementProject, WorkPackage, EngagementProjFinPlanUUID, WorkPackageUUID, EngmtProjFinPlanVersion.

2 data source(s) 37 fields

Data Sources (2)

SourceAliasJoin Type
I_EngmntProjAssgmtToSessionUsr A from
I_EngmntProjectUnitDataVersion B inner

Annotations (6)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PWRKPKGUKPI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY EngagementProject I_EngmntProjectUnitDataVersion EngagementProject
KEY WorkPackage I_EngmntProjectUnitDataVersion WorkPackage
KEY EngagementProjFinPlanUUID I_EngmntProjectUnitDataVersion EngagementProjFinPlanUUID
KEY WorkPackageUUID I_EngmntProjectUnitDataVersion WorkPackageUUID
KEY EngmtProjFinPlanVersion I_EngmntProjectUnitDataVersion EngmtProjFinPlanVersion
KEY EngagementProjectResourceType I_EngmntProjectUnitDataVersion EngagementProjectResourceType
KEY WorkPackageUnit I_EngmntProjectUnitDataVersion EngagementProjectResource
KEY ResourceDemandUUID I_EngmntProjectUnitDataVersion ResourceDemandUUID
BillingControlCategory I_EngmntProjectUnitDataVersion BillingControlCategory
EngagementProjectServiceOrg I_EngmntProjectUnitDataVersion EngagementProjectServiceOrg
Currency I_EngmntProjectUnitDataVersion Currency
PlndCostAmt I_EngmntProjectUnitDataVersion PlndCostAmt
WorkPackageUnitUoM I_EngmntProjectUnitDataVersion UnitOfMeasure
PlanUnitQuantity I_EngmntProjectUnitDataVersion PlndEffortQty
PlndRevnAmt I_EngmntProjectUnitDataVersion PlndRevnAmt
EngmntProjPlanLineType I_EngmntProjectUnitDataVersion EngmntProjPlanLineType
EngagementProjectCategory I_EngmntProjAssgmtToSessionUsr EngagementProjectCategory
CustomerProjectServiceOrg I_EngmntProjAssgmtToSessionUsr EngagementProjectServiceOrg
Customer I_EngmntProjAssgmtToSessionUsr Customer
ProjectVisibility I_EngmntProjAssgmtToSessionUsr ProjectVisibility
EngagementProjectStage I_EngmntProjAssgmtToSessionUsr EngagementProjectStage
ProjectProfileCode I_EngmntProjAssgmtToSessionUsr ProjectProfileCode
EngagementProjectType I_EngmntProjAssgmtToSessionUsr EngagementProjectType
EngmntProjectHeaderCompanyCode I_EngmntProjAssgmtToSessionUsr EngmntProjectHeaderCompanyCode
EngagementProjectCostCenter I_EngmntProjAssgmtToSessionUsr EngagementProjectCostCenter
ProfitCenter I_EngmntProjAssgmtToSessionUsr ProfitCenter
IsMyProject I_EngmntProjAssgmtToSessionUsr IsMyProject
ControllingArea I_EngmntProjAssgmtToSessionUsr ControllingArea
LastChangeDateTime I_EngmntProjAssgmtToSessionUsr LastChangeDateTime
_EngagementProject I_EngmntProjectUnitDataVersion _EngagementProject
_EngagementProjectResource I_EngmntProjectUnitDataVersion _EngagementProjectResource
_EngagementProjectServiceOrg I_EngmntProjectUnitDataVersion _EngagementProjectServiceOrg
_EngagementProjFinancialPlan I_EngmntProjectUnitDataVersion _EngagementProjFinancialPlan
_EngmntProjResourceType I_EngmntProjectUnitDataVersion _EngmntProjResourceType
_EngmtProjFinPlanVersion I_EngmntProjectUnitDataVersion _EngmtProjFinPlanVersion
_UnitOfMeasure I_EngmntProjectUnitDataVersion _UnitOfMeasure
_WorkPackage I_EngmntProjectUnitDataVersion _WorkPackage 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PWRKPKGUKPI'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
//@EndUserText.label: 'Project Actuals'

define view P_WorkPackageUnitKPI
  as select from I_EngmntProjAssgmtToSessionUsr as A
    inner join   I_EngmntProjectUnitDataVersion as B on A.EngagementProject = B.EngagementProject
{

  key B.EngagementProject,
  key B.WorkPackage,
  key B.EngagementProjFinPlanUUID,
  key B.WorkPackageUUID,
  key B.EngmtProjFinPlanVersion,
  key B.EngagementProjectResourceType,
  key B.EngagementProjectResource   as WorkPackageUnit,
  key B.ResourceDemandUUID,
      B.BillingControlCategory,
      B.EngagementProjectServiceOrg,
      B.Currency,
      B.PlndCostAmt,
      B.UnitOfMeasure               as WorkPackageUnitUoM,
      B.PlndEffortQty               as PlanUnitQuantity,
      B.PlndRevnAmt,
      B.EngmntProjPlanLineType,
      A.EngagementProjectCategory,
      A.EngagementProjectServiceOrg as CustomerProjectServiceOrg,
      A.Customer,
      A.ProjectVisibility,
      A.EngagementProjectStage,
      A.ProjectProfileCode,
      A.EngagementProjectType,
      A.EngmntProjectHeaderCompanyCode,
      A.EngagementProjectCostCenter,
      A.ProfitCenter,
      A.IsMyProject,
      A.ControllingArea,
      A.LastChangeDateTime,

      B._EngagementProject,
      B._EngagementProjectResource,
      B._EngagementProjectServiceOrg,
      B._EngagementProjFinancialPlan,
      B._EngmntProjResourceType,
      B._EngmtProjFinPlanVersion,
      B._UnitOfMeasure,
      B._WorkPackage

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENGMNTPROJASSGMTTOSESSIONUSR",
"I_ENGMNTPROJECTUNITDATAVERSION"
],
"ASSOCIATED":
[
"I_ENGAGEMENTPROJECT",
"I_ENGAGEMENTPROJECTRESOURCE",
"I_ENGAGEMENTPROJECTSRVCORG",
"I_ENGAGEMENTPROJFINANCIALPLAN",
"I_ENGMNTPROJRESOURCETYPE",
"I_ENGMTPROJFINPLANVERSION",
"I_UNITOFMEASURE",
"I_WORKPACKAGE"
],
"BASE":
[
"I_ENGMNTPROJECTUNITDATAVERSION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More