I_EngmntProjNumberOfStaffRes

DDL: I_ENGMNTPROJNUMBEROFSTAFFRES SQL: IENGMTPROJNUMRES Type: view COMPOSITE
5 Fields 1 Data Sources

Number of Staffed Resource

I_EngmntProjNumberOfStaffRes is a Composite CDS View that provides data about "Number of Staffed Resource" in SAP S/4HANA. It reads from 1 data source (I_EngmntProjectPlnDataVersion) and exposes 5 fields.

Data Sources (1)

SourceAliasJoin Type
I_EngmntProjectPlnDataVersion EngmntProjSupplyEmployee from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IENGMTPROJNUMRES view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Number of Staffed Resource view

Fields (5)

KeyFieldSource TableSource FieldDescription
EngagementProject I_EngmntProjectPlnDataVersion EngagementProject Engmnt Project ID
WorkPackage I_EngmntProjectPlnDataVersion WorkPackage Plan Item
ResourceDemandUUID I_EngmntProjectPlnDataVersion ResourceDemandUUID Demand Key
ResourceDemand I_EngmntProjectPlnDataVersion ResourceDemand Resource Demand
NumberOfSuppliedEmployees

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_EngmntProjNumberOfStaffRes.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IENGMTPROJNUMRES

CREATE VIEW I_EngmntProjNumberOfStaffRes AS
SELECT
  EngmntProjSupplyEmployee.EngagementProject AS EngagementProject,
  EngmntProjSupplyEmployee.WorkPackage AS WorkPackage,
  EngmntProjSupplyEmployee.ResourceDemandUUID AS ResourceDemandUUID,
  EngmntProjSupplyEmployee.ResourceDemand AS ResourceDemand,
  count( distinct EngmntProjSupplyEmployee.EmploymentInternalID ) AS NumberOfSuppliedEmployees
FROM I_EngmntProjectPlnDataVersion AS EngmntProjSupplyEmployee
;

Learn More