C_EngmtProjStaffedData

DDL: C_ENGMTPROJSTAFFEDDATA SQL: CEPSTAFDATA Type: view CONSUMPTION

Engagement Project Staffed Data

C_EngmtProjStaffedData is a Consumption CDS View that provides data about "Engagement Project Staffed Data" in SAP S/4HANA. It reads from 1 data source (I_EngmntProjectSupplyData) and exposes 7 fields with key fields EngagementProjectUUID, EngagementProjFinPlanUUID, EngagementProject.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_EngmntProjectSupplyData I_EngmntProjectSupplyData from

Parameters (2)

NameTypeDefault
P_FiscalPeriod co_perio
P_FiscalYear gjahr

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CEPSTAFDATA view
EndUserText.label Engagement Project Staffed Data view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY EngagementProjectUUID I_EngmntProjectSupplyData EngagementProjectUUID
KEY EngagementProjFinPlanUUID I_EngmntProjectSupplyData EngagementProjFinPlanUUID
KEY EngagementProject
UnitOfMeasure I_EngmntProjectSupplyData UnitOfMeasure
PlndEffortQty
_EngagementProject I_EngmntProjectSupplyData _EngagementProject
_UnitOfMeasure I_EngmntProjectSupplyData _UnitOfMeasure 
@AbapCatalog.sqlViewName: 'CEPSTAFDATA'
@EndUserText.label: 'Engagement Project Staffed Data'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.authorizationCheck:#CHECK
define view C_EngmtProjStaffedData
  with parameters
    P_FiscalPeriod : co_perio,
    P_FiscalYear   : gjahr


  as select from I_EngmntProjectSupplyData
{
  key I_EngmntProjectSupplyData.EngagementProjectUUID  as EngagementProjectUUID,
  key I_EngmntProjectSupplyData.EngagementProjFinPlanUUID,
  key I_EngmntProjectSupplyData._EngagementProject.EngagementProject,
      @Semantics.unitOfMeasure: true
      I_EngmntProjectSupplyData.UnitOfMeasure,
      @Semantics.quantity.unitOfMeasure:'UnitOfMeasure'
      sum(I_EngmntProjectSupplyData.PlndEffortQty)     as PlndEffortQty,
      /* Associations */
      I_EngmntProjectSupplyData._EngagementProject,
      I_EngmntProjectSupplyData._UnitOfMeasure

}
where
          I_EngmntProjectSupplyData.EngmtProjFinPlanVersion = '1'
  and(
          FiscalYear                                        < $parameters.P_FiscalYear
    or(
          FiscalYear                                        = $parameters.P_FiscalYear
      and FiscalPeriod                                      <= $parameters.P_FiscalPeriod
    )
  )
group by
  I_EngmntProjectSupplyData.EngagementProjectUUID,
  I_EngmntProjectSupplyData._EngagementProject.EngagementProject,
  I_EngmntProjectSupplyData.EngagementProjFinPlanUUID,
  I_EngmntProjectSupplyData.UnitOfMeasure
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENGAGEMENTPROJECT",
"I_ENGMNTPROJECTSUPPLYDATA"
],
"ASSOCIATED":
[
"I_ENGAGEMENTPROJECT",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_ENGMNTPROJECTSUPPLYDATA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More