C_ProjectBillingRequestTP

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_ProjectBillingRequestTP.
-- 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_ProjectBillingRequestTP AS
SELECT
  ProjectBillingRequestUUID,
  ProjectInternalID,
  ProjectBillingRequestStatus,
  ProjBillgReqApprovalStatus,
  ProjectBillingRequestType,
  SalesDocument,
  ProjectBillingCategory,
  ProjBillgReqLastChgdBy,
  ProjBillgReqLastChgdAtDteTme,
  ProjBillgReqCreatedBy,
  ProjBillgReqCreatedAtDteTme,
  DocumentCurrency,
  ProjectBillingRequest,
  virtual WBSElementExternalID : abap.char( 30 ) AS char30,
  virtual BillingPlanUsageCategoryName : abap.char( 60 ) AS char60,
  Project AS CustomerProject,
  virtual BillingPlanBillingDate : abap.dats( 8 ) AS dats8,
  virtual UtilitiesBillingReason : abap.char( 1 ) AS char1,
  virtual ProjectBillgRequestMessageText : abap.string AS string,
  virtual BilledRevenueAmtInDocCrcy : abap.curr( 23 , 2 ) AS curr232,
  _CustomerToBusinessPartner.Customer AS Customer,
  _CustomerToBusinessPartner._Customer.CustomerName AS CustomerName,
  virtual BillingPlanUsageCategory : abap.char( 2 ) AS char2,
  ProjectStartDate,
  ProjectEndDate,
  ProfitCenter,
  ControllingArea,
  virtual ProjBillingDocRequestListText : abap.char( 300 ) AS char300
FROM R_ProjectBillingRequestTP
LEFT OUTER JOIN C_ProjectBillingCustomerCard AS _CustomerContactCard ON Customer = _CustomerContactCard.Customer  -- association [1..1]
;