P_EngmntProjDemands

DDL: P_ENGMNTPROJDEMANDS SQL: PENGPROJDMND Type: view CONSUMPTION
26 Fields 3 Data Sources

Engagement Project Demands

P_EngmntProjDemands is a Consumption CDS View that provides data about "Engagement Project Demands" in SAP S/4HANA. It reads from 3 data sources (I_EngmntProjAssgmtToSessionUsr, I_EngmntProjDmndHdr, I_EngmntProjectPlnDataVersion) and exposes 26 fields with key fields ResourceDemandUUID, FiscalYear, FiscalPeriod, EngmntProjPlanLineType, ResourceSupply.

Data Sources (3)

SourceAliasJoin Type
I_EngmntProjAssgmtToSessionUsr EngagementProject from
I_EngmntProjDmndHdr EngagementProjectDemandHdr inner
I_EngmntProjectPlnDataVersion EngmntProjectPlnDataVersion inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PENGPROJDMND view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Engagement Project Demands view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ResourceDemandUUID I_EngmntProjectPlnDataVersion ResourceDemandUUID Demand Key
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY EngmntProjPlanLineType EngmntProjPlanLineType Line type
KEY ResourceSupply ResourceSupply Resource Supply
EngagementProjectServiceOrg I_EngmntProjAssgmtToSessionUsr EngagementProjectServiceOrg Service Org.
EngagementProjectCategory EngagementProjectCategory
ProjectProfileCode ProjectProfileCode Project Profile
EngmntProjectHeaderCompanyCode EngmntProjectHeaderCompanyCode Receiver Company Code
EngagementProjectCostCenter EngagementProjectCostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
ProjectVisibility ProjectVisibility
IsMyProject IsMyProject
EngagementProject I_EngmntProjectPlnDataVersion EngagementProject Engmnt Project ID
EngagementProjectName EngagementProjectName
EngagementProjectStage EngagementProjectStage
WorkPackage I_EngmntProjectPlnDataVersion WorkPackage Plan Item
EngagementProjectResource EngagementProjectResource Resource ID
ResourceDemand ResourceDemand Resource Demand
Currency I_EngmntProjectPlnDataVersion Currency Valuation Crcy
UnitOfMeasure UnitOfMeasure Unit Protected Qty
DemandStartDate DemandStartDate Valn start date
DemandEndDate DemandEndDate Valn End date
DemandStaffingStatus DemandStaffingStatus Workflow Status
_EngagementProjectResource _EngagementProjectResource
_PlanSkillTags _PlanSkillTags

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 P_EngmntProjDemands.
-- 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: PENGPROJDMND

CREATE VIEW P_EngmntProjDemands AS
SELECT
  EngmntProjectPlnDataVersion.ResourceDemandUUID AS ResourceDemandUUID,
  FiscalYear,
  FiscalPeriod,
  EngmntProjPlanLineType,
  ResourceSupply,
  EngagementProject.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  EngagementProjectCategory,
  ProjectProfileCode,
  EngmntProjectHeaderCompanyCode,
  EngagementProjectCostCenter,
  ProfitCenter,
  ProjectVisibility,
  IsMyProject,
  EngmntProjectPlnDataVersion.EngagementProject AS EngagementProject,
  EngagementProjectName,
  EngagementProjectStage,
  EngmntProjectPlnDataVersion.WorkPackage AS WorkPackage,
  EngagementProjectResource,
  ResourceDemand,
  EngmntProjectPlnDataVersion.Currency AS Currency,
  UnitOfMeasure,
  DemandStartDate,
  DemandEndDate,
  DemandStaffingStatus
FROM I_EngmntProjAssgmtToSessionUsr AS EngagementProject
INNER JOIN I_EngmntProjDmndHdr AS EngagementProjectDemandHdr ON /* join condition not captured in parsed metadata */
INNER JOIN I_EngmntProjectPlnDataVersion AS EngmntProjectPlnDataVersion ON /* join condition not captured in parsed metadata */
;

Learn More