I_ProjectBillingElementTP

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_ProjectBillingElementTP.
-- 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: IPRJBLGELMTP

CREATE VIEW I_ProjectBillingElementTP AS
SELECT
  ProjectBillingElement.ProjectBillingElementUUID AS ProjectBillingElementUUID,
  ProjectBillingElement.BillingWBSElementInternalID AS BillingWBSElementInternalID,
  ProjectBillingElement.DocumentCurrency AS DocumentCurrency,
  ProjectBillingElement.BilledRevenueAmtInDocCrcy AS BilledRevenueAmtInDocCrcy,
  ProjectBillingElement.WrittenOffRevenueAmtInDocCrcy AS WrittenOffRevenueAmtInDocCrcy,
  ProjectBillingElement.ProjBillgElmntCreatedByUser AS ProjBillgElmntCreatedByUser,
  ProjectBillingElement.ProjBillgElmntCreatedAtDteTme AS ProjBillgElmntCreatedAtDteTme,
  ProjectBillingElement.ProjBillgElmntLastChgdByUser AS ProjBillgElmntLastChgdByUser,
  ProjectBillingElement.ProjBillgElmntLastChgdAtDteTme AS ProjBillgElmntLastChgdAtDteTme,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  _EnterpriseProjectElement._Project.ProjectInternalID AS ProjectInternalID,
  _ProjBillgElmntSalesDets.BillingPlan AS BillingPlan,
  _WBSElement.ProfitCenter AS WBSElementProfitCenter,
  _ProjBillgElmntSalesDets._SalesOrderItem.CappedNetAmount AS CappedNetAmount,
  _EnterpriseProjectElement.ProjectUUID AS ProjectUUID,
  _EnterpriseProjectElement._Project.ControllingArea AS ControllingArea,
  _EnterpriseProjectElement._Project.Project AS Project,
  _EnterpriseProjectElement._Project.ProfitCenter AS ProfitCenter,
  _EnterpriseProjectElement._Project.ProcessingStatus AS ProcessingStatus,
  _EnterpriseProjectElement._Project.ProjectStartDate AS ProjectStartDate,
  _EnterpriseProjectElement._Project.ProjectEndDate AS ProjectEndDate,
  _EnterpriseProjectElement._Project.EnterpriseProjectServiceOrg AS EngagementProjectServiceOrg,
  _ProjBillgElmntSalesDets._SalesOrder.SoldToParty AS Customer,
  _ProjBillgElmntSalesDets.UserID AS UserID,
  _TmpProjectBillingRequest.ProjectBillingRequest AS ProjectBillingRequest,
  _TmpProjectBillingRequest.ProjectBillingRequestUUID AS ProjectBillingRequestUUID,
  _ProjBillgElmntSalesDets._SalesOrderItem.BillingBlockStatus AS BillingBlockStatus,
  _ProjBillgElmntSalesDets._SalesOrderItem._SalesOrder.TotalBlockStatus AS TotalBlockStatus,
  _ProjBillgElmntSalesDets.DueBillingDate AS BillingPlanBillingDate,
  _ProjBillgElmntSalesDets.SalesOrder AS SalesOrder,
  _ProjBillgElmntSalesDets.SalesOrderItem AS SalesOrderItem,
  _ProjBillgElmntSalesDets._SalesDocItemBillPlan AS _SalesDocItemBillPlan,
  _ProjBillgElmntSalesDets._SalesOrderItem AS _SalesOrderItem,
  _ProjBillgElmntSalesDets._SalesDocItemBillPlan.BillingPlanUsageCategory AS BillingPlanUsageCategory,
  ProjectBillingElement._WBSElement AS _WBSElement,
  _EnterpriseProjectElement._Project AS _EnterpriseProject
FROM I_ProjectBillingElement AS ProjectBillingElement
INNER JOIN I_WBSElementBasicData AS _WBSData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CUSTPROJSLSORDITMBYUSER AS _CUSTPROJSLSORDITMBYUSER ON _CUSTPROJSLSORDITMBYUSER.WBSElement = ProjectBillingElement.BillingWBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN I_MyProjectBillingElements AS _MyProjectBillingElements ON _MyProjectBillingElements.BillingWBSElementInternalID = ProjectBillingElement.BillingWBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN P_ProjBillgElmntSalesDets AS _ProjBillgElmntSalesDets ON BillingWBSElementInternalID = _ProjBillgElmntSalesDets.BillingWBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_EnterpriseProject AS _EnterpriseProject ON ProjectInternalID = _EnterpriseProject.ProjectInternalID  -- association [1..1]
LEFT OUTER JOIN I_EnterpriseProjectElement AS _EnterpriseProjectElement ON BillingWBSElementInternalID = _EnterpriseProjectElement.WBSElementInternalID AND _EnterpriseProjectElement.WBSElementIsBillingElement = 'X'  -- association [1..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON BillingWBSElementInternalID = _SalesOrderItem.WBSElementInternalID  -- association [1..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON salesorder = _SalesOrder.SalesOrder  -- association [1..1]
LEFT OUTER JOIN I_SalesDocItemBillingPlan AS _SalesDocItemBillPlan ON billingplan = _SalesDocItemBillPlan.BillingPlan  -- association [1..1]
LEFT OUTER JOIN I_ProjectBillingDocDetails AS _ProjectBillingDocDetails ON BillingWBSElementInternalID = _ProjectBillingDocDetails.WBSElementInternalID  -- association [1..*]
LEFT OUTER JOIN I_TmpProjectBillingRequest AS _TmpProjectBillingRequest ON ProjectBillingElementUUID = _TmpProjectBillingRequest.ProjectBillingElementUUID AND _TmpProjectBillingRequest.ProjectBillingRequestStatus = 'C'  -- association [1..1]
LEFT OUTER JOIN I_ProjectBillingRequestItemTP AS _ProjectBillingRequestItemTP ON ProjectBillingElementUUID = _ProjectBillingRequestItemTP.ProjectBillingElementUUID  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON profitcenter = _ProfitCenterText.ProfitCenter AND ControllingArea = _ProfitCenterText.ControllingArea AND projectstartdate <= _ProfitCenterText.ValidityEndDate AND projectstartdate >= _ProfitCenterText.ValidityStartDate AND _ProfitCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterName ON WBSElementProfitCenter = _ProfitCenterName.ProfitCenter AND ControllingArea = _ProfitCenterName.ControllingArea AND projectstartdate <= _ProfitCenterName.ValidityEndDate AND projectstartdate >= _ProfitCenterName.ValidityStartDate AND _ProfitCenterName.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProjectBillingElmntDueDate AS _ProjBillingDueDate ON BillingWBSElementInternalID = _ProjBillingDueDate.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_PrjBlgElmEntrForPrepayment AS _PrjBlgElmEntrForPrepayment ON ProjectBillingElementUUID = _PrjBlgElmEntrForPrepayment.ProjectBillingElementUUID AND _PrjBlgElmEntrForPrepayment.PlndPrepaymentAmtInProjCrcy > 0  -- association [0..*]
LEFT OUTER JOIN I_EngagementProjectSrvcOrgText AS _ServiceOrganizationText ON _ServiceOrganizationText.EngagementProjectServiceOrg = EngagementProjectServiceOrg AND _ServiceOrganizationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_ProjectBillingElement AS _Extension ON ProjectBillingElementUUID = _Extension.ProjectBillingElementUUID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBillingElementEntryTP AS _ProjectBillingElementEntry ON /* condition not available in parsed metadata */  -- association [0..*]
;