P_EngmtProjSuppliedUnsupplied

DDL: P_ENGMTPROJSUPPLIEDUNSUPPLIED Type: view COMPOSITE
17 Fields 2 Data Sources

P_EngmtProjSuppliedUnsupplied is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_EngmntProjectPlnDataVersion, P_EngmntProjAssgmtToUser) and exposes 17 fields.

Data Sources (2)

SourceAliasJoin Type
I_EngmntProjectPlnDataVersion A inner
P_EngmntProjAssgmtToUser B from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPRJSPLYUNSPLYDT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #COMPOSITE view

Fields (17)

KeyFieldSource TableSource FieldDescription
EngagementProject P_EngmntProjAssgmtToUser EngagementProject Engmnt Project ID
WorkPackage I_EngmntProjectPlnDataVersion WorkPackage Plan Item
EngagementProjFinPlanUUID I_EngmntProjectPlnDataVersion EngagementProjFinPlanUUID Engagement Project
WorkPackageUUID I_EngmntProjectPlnDataVersion WorkPackageUUID Work Package UUID
EngmtProjFinPlanVersion I_EngmntProjectPlnDataVersion EngmtProjFinPlanVersion Plan Version ID
EngagementProjectResourceType I_EngmntProjectPlnDataVersion EngagementProjectResourceType ResourceTypeID
FiscalPeriod I_EngmntProjectPlnDataVersion FiscalPeriod Tax period
FiscalYear I_EngmntProjectPlnDataVersion FiscalYear G/L Fiscal Year
EngagementProjectResource I_EngmntProjectPlnDataVersion EngagementProjectResource Resource ID
EmploymentInternalID I_EngmntProjectPlnDataVersion EmploymentInternalID WorkForce Assgmt ID
Confirmed I_EngmntProjectPlnDataVersion EngmtProjEmployeeIsStaffed Confirmation of staffed Employee
WorkItem I_EngmntProjectPlnDataVersion WorkItem Work Item ID
FiscalYearPeriod
BillingControlCategory I_EngmntProjectPlnDataVersion BillingControlCategory Billing Category
EngagementProjectServiceOrg I_EngmntProjectPlnDataVersion EngagementProjectServiceOrg Service Org.
UnitOfMeasure I_EngmntProjectPlnDataVersion UnitOfMeasure Unit Protected Qty
PlndEffortQty I_EngmntProjectPlnDataVersion PlndEffortQty Total Quantity

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_EngmtProjSuppliedUnsupplied.
-- 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.

CREATE VIEW P_EngmtProjSuppliedUnsupplied AS
SELECT
  B.EngagementProject AS EngagementProject,
  A.WorkPackage AS WorkPackage,
  A.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  A.WorkPackageUUID AS WorkPackageUUID,
  A.EngmtProjFinPlanVersion AS EngmtProjFinPlanVersion,
  A.EngagementProjectResourceType AS EngagementProjectResourceType,
  A.FiscalPeriod AS FiscalPeriod,
  A.FiscalYear AS FiscalYear,
  A.EngagementProjectResource AS EngagementProjectResource,
  A.EmploymentInternalID AS EmploymentInternalID,
  A.EngmtProjEmployeeIsStaffed AS Confirmed,
  A.WorkItem AS WorkItem,
  concat(A.FiscalYear, A.FiscalPeriod) AS FiscalYearPeriod,
  A.BillingControlCategory AS BillingControlCategory,
  A.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  A.UnitOfMeasure AS UnitOfMeasure,
  A.PlndEffortQty AS PlndEffortQty
FROM P_EngmntProjAssgmtToUser AS B
INNER JOIN I_EngmntProjectPlnDataVersion AS A ON /* join condition not captured in parsed metadata */
;

Learn More