C_EntPrjProfnlSrvcDmndStaffing

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 C_EntPrjProfnlSrvcDmndStaffing.
-- 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 C_EntPrjProfnlSrvcDmndStaffing AS
SELECT
  ProjectDemand.ProjectUUID AS ProjectUUID,
  ProjectDemand.ProjectDemandUUID AS ProjectDemandUUID,
  ProjectDemand.ReferencedObjectUUID AS ReferencedObjectUUID,
  ProjectDemand.ProjectDemandType AS ProjectDemandType,
  WorkDemand.ActivityType AS ActivityType,
  cast( '' as fis_costctractivitytypename ) AS CostCtrActivityTypeName,
  WorkDemand.ProjDmndAssgmtStatus AS DemandStaffingStatus,
  WorkDemand.ProjectElementWorkItem AS WorkItem,
  WorkDemand.ProjDmndRequestedDeliveryOrg AS ProjDmndRequestedDeliveryOrg,
  WorkDemand.ProjDmndBillingControlCategory AS ProjDmndBillingControlCategory,
  _PPM_TaskTypeText.ProjectElementTypeText AS WorkPackageTypeText,
  cast('' as abap.char(60) ) AS BillingControlCategoryText,
  cast('' as abap.char(60) ) AS WorkItemText,
  cast( EntProjElementTP_2.ProjectElement as abap.char(50) ) AS WorkPackage,
  EntProjElementTP_2.ProjectElementDescription AS WorkPackageName,
  EntProjElementTP_2.PlannedStartDate AS WorkPackageStartDate,
  EntProjElementTP_2.PlannedEndDate AS WorkPackageEndDate,
  EntProjElementTP_2.LeadingSalesOrder AS SalesOrder,
  EntProjElementTP_2.LeadingSalesOrderItem AS SalesOrderItem,
  EntProjDmndReqDistrAggrgn.ProjDmndRequestedEffortQty AS ProjDmndRequestedEffortQty,
  EntProjDmndReqDistrAggrgn.ProjDmndReqdEffortCostAmount AS ProjDmndReqdEffortCostAmount,
  sum(_EntProjDmndRsceAssignment.ProjDmndStaffedEffortQty) AS ProjDmndStaffedEffortQty,
  sum(_EntProjDmndRsceAssignment.PrjDmndStaffedEffortCostAmount) AS PrjDmndStaffedEffortCostAmount,
  cast('0.000' as abap.quan( 20, 3 ) ) AS ProjDmndEffortDiffQuantity,
  ProjectDemand.ProjDmndRequestedQuantityUnit AS ProjDmndRequestedQuantityUnit,
  ProjectDemand.ProjectDemandRequestCurrency AS ProjectDemandRequestCurrency,
  _EntProjProfnlSrvcBillgElmnt.WBSElementExternalID AS WBSElementExternalID,
  _EntProjProfnlSrvcBillgElmnt.Product AS ProductID,
  _EntProjProfnlSrvcBillgElmnt.BillingPlanUsageCategoryName AS BillingPlanUsageCategoryName,
  _EntProjProfnlSrvcBillgElmnt.WBSDescription AS WBSDescription,
  _EntProjProfnlSrvcBillgElmnt.WBSElementProfitCenter AS WBSElementProfitCenter,
  _EntProjProfnlSrvcBillgElmnt.ProfitCenterName AS ProfitCenterName,
  ProjectDemand._Project AS _Project,
  ProjectDemand._WorkPackage AS _WorkPackage,
  ProjectDemand._EnterpriseProjectForUser AS _EnterpriseProjectForUser,
  _EntProjProfnlSrvcBillgElmnt._ProfitCenter AS _ProfitCenter
FROM I_ProjectDemandTP AS ProjectDemand
INNER JOIN I_ProjectDemandWorkTP AS WorkDemand ON /* join condition not captured in parsed metadata */
INNER JOIN I_EnterpriseProjectElementTP_2 AS EntProjElementTP_2 ON /* join condition not captured in parsed metadata */
INNER JOIN R_EntProjDmndReqDistrAggrgn AS EntProjDmndReqDistrAggrgn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_EntProjSrvcOrgCntctCard AS _DeliveryOrganization ON _DeliveryOrganization.EnterpriseProjectServiceOrg = ProjDmndRequestedDeliveryOrg  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrgText AS _DeliveryOrganizationText ON ProjDmndRequestedDeliveryOrg = _DeliveryOrganizationText.EngagementProjectServiceOrg  -- association [0..1]
LEFT OUTER JOIN C_EntProjProfnlSrvcBillgElmnt AS _EntProjProfnlSrvcBillgElmnt ON _EntProjProfnlSrvcBillgElmnt.ProjectUUID = ProjectUUID AND _EntProjProfnlSrvcBillgElmnt.SalesOrder = SalesOrder AND _EntProjProfnlSrvcBillgElmnt.SalesOrderItem = SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN C_EntProjDmndRsceAssignment AS _EntProjDmndRsceAssignment ON _EntProjDmndRsceAssignment.ProjectUUID = ProjectUUID AND _EntProjDmndRsceAssignment.ProjectDemandUUID = ProjectDemandUUID  -- association [0..*]
LEFT OUTER JOIN I_PPM_TaskTypeText AS _PPM_TaskTypeText ON _PPM_TaskTypeText.EntProjectElementType = EntProjElementTP_2.EntProjectElementType AND _PPM_TaskTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProjDmndAssgmtStatusText AS _ProjDmndAssgmtStatusText ON _ProjDmndAssgmtStatusText.ProjDmndAssgmtStatus = DemandStaffingStatus AND _ProjDmndAssgmtStatusText.Language = $session.system_language  -- association [0..1]
;