R_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 R_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: RPRJBLGELMTP

CREATE VIEW R_ProjectBillingElementTP AS
SELECT
  ProjectBillingElement.ProjectBillingElementUUID AS ProjectBillingElementUUID,
  ProjectBillingElement.BillingWBSElementInternalID AS BillingWBSElementInternalID,
  ProjectBillingElement.DocumentCurrency AS DocumentCurrency,
  ProjectBillingElement.BilledRevenueAmtInDocCrcy AS BilledRevenueAmtInDocCrcy,
  ProjectBillingElement.WrittenOffRevenueAmtInDocCrcy AS WrittenOffRevenueAmtInDocCrcy,
  ProjectBillingElement.ProjBillingProfile AS ProjBillingProfile,
  ProjectBillingElement.ProjectBillingCategory AS ProjectBillingCategory,
  ProjectBillingElement.ProjBillgElmntCreatedByUser AS ProjBillgElmntCreatedByUser,
  ProjectBillingElement.ProjBillgElmntCreatedAtDteTme AS ProjBillgElmntCreatedAtDteTme,
  ProjectBillingElement.ProjBillgElmntLastChgdByUser AS ProjBillgElmntLastChgdByUser,
  ProjectBillingElement.ProjBillgElmntLastChgdAtDteTme AS ProjBillgElmntLastChgdAtDteTme,
  cast( _EnterpriseProjectElement.ProjectElement as ps_posid_edit preserving type ) AS WBSElementExternalID,
  _ProjBillgElmntSalesDets.BillingPlan AS BillingPlan,
  _ProjBillgElmntSalesDets.SalesOrder AS SalesOrder,
  _ProjBillgElmntSalesDets.SalesOrderItem AS SalesOrderItem,
  _ProjBillgElmntSalesDets.TransactionCurrency AS TransactionCurrency,
  _EnterpriseProjectElement.ProfitCenter AS WBSElementProfitCenter,
  cast('' as fis_prctr_hrynid_50) AS ProfitCenterHierarchyNode,
  _ProjBillgElmntSalesDets.CappedNetAmount AS CappedNetAmount,
  _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,
  _TmpProjectBillingRequest.ProjectBillingRequest AS ProjectBillingRequest,
  _TmpProjectBillingRequest.ProjectBillingRequestUUID AS ProjectBillingRequestUUID,
  _ProjBillgElmntSalesDets.BillingBlockStatus AS BillingBlockStatus,
  _ProjBillgElmntSalesDets._SalesOrder.TotalBlockStatus AS TotalBlockStatus,
  _ProjBillgElmntSalesDets._SalesOrder.OverallBillingBlockStatus AS OverallBillingBlockStatus,
  _ProjBillgElmntSalesDets.BillingBlockReason AS BillingBlockReason,
  _ProjBillgElmntSalesDets._SalesOrder.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  _ProjBillgElmntSalesDets.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  _EnterpriseProjectElement._Project.EnterpriseProjectServiceOrg AS EngagementProjectServiceOrg,
  _DueBillingDate.DueBillingDate AS DueBillingDate,
  _DueBillingDate.UserID AS UserID,
  _PrjBlgElmOverduePrepayment.PrjBlgElmPlndPrepaymentIsOvrd AS PrjBlgElmPlndPrepaymentIsOvrd,
  _PrjBlgElmPrepaymentAmount.PlndPrepaymentAmtInProjCrcy AS PlndPrepaymentAmtInProjCrcy,
  _ProjBillgElmntSalesDets._SalesDocItemBillPlan AS _SalesDocItemBillPlan,
  _ProjBillgElmntSalesDets._SalesOrderItem AS _SalesOrderItem,
  _ProjBillgElmntSalesDets._SalesOrder AS _SalesOrder,
  ProjectBillingElement._WBSElement AS _WBSElement
FROM I_ProjectBillingElement AS ProjectBillingElement
LEFT OUTER JOIN I_EnterpriseProjectElement AS _EnterpriseProjectElement ON BillingWBSElementInternalID = _EnterpriseProjectElement.WBSElementInternalID  -- association [1..1]
LEFT OUTER JOIN P_ProjBillgElmntSalesDets2 AS _ProjBillgElmntSalesDets ON ProjectBillingElementUUID = _ProjBillgElmntSalesDets.ProjectBillingElementUUID  -- association [1..1]
LEFT OUTER JOIN P_ProjectBillingElmntDueDate3 AS _DueBillingDate ON ProjectBillingElementUUID = _DueBillingDate.ProjectBillingElementUUID  -- association [1..1]
LEFT OUTER JOIN I_TmpProjectBillingRequest AS _TmpProjectBillingRequest ON ProjectBillingElementUUID = _TmpProjectBillingRequest.ProjectBillingElementUUID  -- association [0..1]
LEFT OUTER JOIN I_PrjBlgElmOverduePrepayment AS _PrjBlgElmOverduePrepayment ON ProjectBillingElementUUID = _PrjBlgElmOverduePrepayment.ProjectBillingElementUUID  -- association [0..1]
LEFT OUTER JOIN I_PrjBlgElmPrepaymentAmount AS _PrjBlgElmPrepaymentAmount ON ProjectBillingElementUUID = _PrjBlgElmPrepaymentAmount.ProjectBillingElementUUID  -- association [0..1]
LEFT OUTER JOIN I_PrjBlgElmBllbleRevnAmt AS _PrjBlgElmBllbleRevnAmt ON ProjectBillingElementUUID = _PrjBlgElmBllbleRevnAmt.ProjectBillingElementUUID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBillingDocDetails AS _ProjectBillingDocDetails ON BillingWBSElementInternalID = _ProjectBillingDocDetails.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjectBillingRequestItemTP AS _ProjectBillingRequestItemTP ON ProjectBillingElementUUID = _ProjectBillingRequestItemTP.ProjectBillingElementUUID  -- association [0..*]
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 [1..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  -- 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 R_ProjectBillingElementEntryTP AS _ProjectBillingElementEntry ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ProjBillgElmObjectLinkTP AS _ProjBillgElmObjectLink ON /* condition not available in parsed metadata */  -- association [0..1]
;