I_EngmntProjRsceSup

DDL: I_ENGMNTPROJRSCESUP SQL: IEPROJRSCESUP Type: view COMPOSITE
23 Fields 1 Data Sources 1 Associations

Resource Supplies

I_EngmntProjRsceSup is a Composite CDS View that provides data about "Resource Supplies" in SAP S/4HANA. It reads from 1 data source (P_ENGMNTPROJRSCESUP) and exposes 23 fields with key fields WorkPackage, ResourceDemand, ResourceSupply, Version. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_ENGMNTPROJRSCESUP P_ENGMNTPROJRSCESUP from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_PersnWrkAgreementDet _PersonWorkAgreementDet P_ENGMNTPROJRSCESUP.EmploymentInternalID = _PersonWorkAgreementDet.PersonWorkAgreement

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IEPROJRSCESUP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
EndUserText.label Resource Supplies view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY WorkPackage WorkPackage Plan Item
KEY ResourceDemand ResourceDemand Resource Demand
KEY ResourceSupply ResourceSupply Resource Supply
KEY Version Version XML Vers.
EngagementProject EngagementProject Engmnt Project ID
DeliveryOrganization DeliveryOrganization
WorkforcePersonUserID WorkforcePersonUserID User ID
Country2DigitISOCode Country2DigitISOCode Country/Region
KeyDate KeyDate Maturity Key Date
PersonWorkAgreement _PersonWorkAgreementDet PersonWorkAgreement Personnel No.
UnitOfMeasure UnitOfMeasure Unit Protected Qty
Currency Currency Valuation Crcy
EngagementProjectType EngagementProjectType
EngagementProjectCategory EngagementProjectCategory
EngagementProjectServiceOrg EngagementProjectServiceOrg Service Org.
ProjectVisibility ProjectVisibility
ProjectProfileCode ProjectProfileCode Project Profile
EngmntProjectHeaderCompanyCode EngmntProjectHeaderCompanyCode
EngagementProjectCostCenter EngagementProjectCostCenter
ProfitCenter ProfitCenter Profit Center
Quantity Quantity Value
SupplyCostAmt SupplyCostAmt
SupplyRevnAmt SupplyRevnAmt

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_EngmntProjRsceSup.
-- 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: IEPROJRSCESUP

CREATE VIEW I_EngmntProjRsceSup AS
SELECT
  WorkPackage,
  ResourceDemand,
  ResourceSupply,
  Version,
  EngagementProject,
  DeliveryOrganization,
  WorkforcePersonUserID,
  Country2DigitISOCode,
  KeyDate,
  _PersonWorkAgreementDet.PersonWorkAgreement AS PersonWorkAgreement,
  UnitOfMeasure,
  Currency,
  EngagementProjectType,
  EngagementProjectCategory,
  EngagementProjectServiceOrg,
  ProjectVisibility,
  ProjectProfileCode,
  EngmntProjectHeaderCompanyCode,
  EngagementProjectCostCenter,
  ProfitCenter,
  Quantity,
  SupplyCostAmt,
  SupplyRevnAmt
FROM P_ENGMNTPROJRSCESUP
LEFT OUTER JOIN I_PersnWrkAgreementDet AS _PersonWorkAgreementDet ON P_ENGMNTPROJRSCESUP.EmploymentInternalID = _PersonWorkAgreementDet.PersonWorkAgreement  -- association [0..*]
;

Learn More