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

CREATE VIEW C_ProjectBillingElementTP AS
SELECT
  ProjectBillingElementUUID,
  cast( _EnterpriseProjectElement.ProjectElement as ps_posid_edit preserving type ) AS WBSElementExternalID,
  ProjectBillingRequest,
  ProjectBillingRequestUUID,
  virtual IsActiveEntity : boolean AS virtualIsActiveEntityboolean,
  virtual DraftIsCreatedByMe : boolean AS virtualDraftIsCreatedByMeboolean,
  virtual LastChangedByUser : abap.char( 12 ) AS char12,
  virtual LastChangedByUserDescription : abap.char( 20 ) AS char20,
  virtual LastChangeDateTime : edms_changed_at AS virtualLastChangeDateTimeedms_changed_at,
  virtual HasDraftEntity : boolean AS virtualHasDraftEntityboolean,
  virtual HasActiveEntity : boolean AS virtualHasActiveEntityboolean,
  virtual BillingPlanBillingDate : abap.dats(8) AS dats8,
  DueBillingDate,
  BillingWBSElementInternalID,
  virtual IsMyProjectBillingElement : boolean AS virtualIsMyProjectBillingElementboolean,
  Customer,
  _Customer.CustomerName AS CustomerName,
  _Customer.OrganizationBPName1 AS OrganizationBPName1,
  _Customer.OrganizationBPName2 AS OrganizationBPName2,
  Project AS CustomerProject,
  ShipToParty,
  _ShipToParty.CustomerName AS ShipToPartyName,
  BillToParty,
  _BillToParty.CustomerName AS BillToPartyName,
  PayerParty,
  _PayerParty.CustomerName AS PayerPartyName,
  virtual PartnerFunction : parvw_unv AS virtualPartnerFunctionparvw_unv,
  virtual AdditionalPartnerName : abap.char( 100 ) AS char100,
  virtual AdditionalPartnerDetailText : abap.char( 1333 ) AS char1333,
  ProjectDescription,
  _SalesDocItemBillPlan.BillingPlanUsageCategory AS BillingPlanUsageCategory,
  DocumentCurrency,
  TransactionCurrency,
  BilledRevenueAmtInDocCrcy,
  virtual UnbilledRevnAmtInDocCrcy : abap.curr( 23, 2 ) AS curr232,
  virtual ProjBillgElmntEntrIsCancelled : abap.char( 1 ) AS char1,
  WBSElementProfitCenter AS ProfitCenter,
  _ProfitCenterName.ProfitCenterName AS ProfitCenterText,
  CappedNetAmount,
  WrittenOffRevenueAmtInDocCrcy,
  _SalesOrderItem.SalesDocumentItemText AS WBSElementDescription,
  ServiceOrganizationUnit,
  ResponsibleCostCenter,
  ProfitCenter AS CostCenterProfitCenter,
  EngagementProjectServiceOrg,
  PlndPrepaymentAmtInProjCrcy,
  BillingPlan,
  virtual UICT_SalesOrder : vbeln_va AS virtualUICT_SalesOrdervbeln_va,
  virtual UICT_SalesOrderItem : posnr_va AS virtualUICT_SalesOrderItemposnr_va,
  SalesOrder,
  SalesOrderItem,
  ProjBillgElmntCreatedByUser,
  ProjBillgElmntCreatedAtDteTme,
  ProjBillgElmntLastChgdByUser,
  ProjBillgElmntLastChgdAtDteTme,
  PrjBlgElmPlndPrepaymentIsOvrd,
  virtual ProjBillingReqIsAuthorized : boolean AS virtualProjBillingReqIsAuthorizedboolean,
  ProjBillingProfile,
  ProjectBillingCategory,
  _ServiceOrganizationText.EngmtProjectServiceOrgName AS EngmtProjectServiceOrgName,
  ProjectElementUUID
FROM R_ProjectBillingElementTP
LEFT OUTER JOIN C_ProjBillgCustomerProjectDets AS _ProjBillgCustomerProjectDets ON CustomerProject = _ProjBillgCustomerProjectDets.Project  -- association [1..1]
LEFT OUTER JOIN C_ProjectBillingCustomerCard AS _CustomerContactCard ON Customer = _CustomerContactCard.Customer  -- association [1..1]
LEFT OUTER JOIN C_ProjectBillingCustomerCard AS _ShipToContactCard ON ShipToParty = _ShipToContactCard.Customer  -- association [1..1]
LEFT OUTER JOIN C_ProjectBillingCustomerCard AS _BillToContactCard ON BillToParty = _BillToContactCard.Customer  -- association [1..1]
LEFT OUTER JOIN C_ProjectBillingCustomerCard AS _PayerContactCard ON PayerParty = _PayerContactCard.Customer  -- association [1..1]
LEFT OUTER JOIN C_ProjBillgSlsItmBillgPlnDuDte AS _ProjBillgSlsItmBillgPlnDuDte ON BillingPlan = _ProjBillgSlsItmBillgPlnDuDte.BillingPlan  -- association [1..*]
LEFT OUTER JOIN C_ProjBillingInProcessDetails AS _ProjBillingInProcessDetails ON ProjectBillingElementUUID = _ProjBillingInProcessDetails.ProjectBillingElementUUID  -- association [1..*]
LEFT OUTER JOIN C_ProjBillgElmntPartnerDetails AS _ProjBillgElmntPartnerDetails ON SalesOrder = _ProjBillgElmntPartnerDetails.SalesOrder AND SalesOrderItem = _ProjBillgElmntPartnerDetails.SalesOrderItem  -- association [1..*]
LEFT OUTER JOIN C_HierRuntimeRprstnDplLeafNode AS _ProfitCenterHierLeafNode ON ProfitCenter = _ProfitCenterHierLeafNode.UnivHierarchyBusinessEntity AND ControllingArea = _ProfitCenterHierLeafNode.HierarchyNodeClass AND _ProfitCenterHierLeafNode.ValidityStartDate <= $session.system_date AND _ProfitCenterHierLeafNode.ValidityEndDate >= $session.system_date AND _ProfitCenterHierLeafNode.HierarchyType = '0106'  -- association [0..*]
LEFT OUTER JOIN C_PrjBlgElmEntrForPrepayment AS _PrjBlgElmEntrForPrepayment ON ProjectBillingElementUUID = _PrjBlgElmEntrForPrepayment.ProjectBillingElementUUID  -- association [0..*]
LEFT OUTER JOIN C_ProjectBillingDocDetails AS _ProjectBillingDocDetails ON BillingWBSElementInternalID = _ProjectBillingDocDetails.WBSElementInternalID  -- association [0..*]
;