C_ProjectBillingRequestTP_2

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_2.
-- 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_2 AS
SELECT
  ProjectBillingRequestUUID,
  ProjectInternalID,
  ProjectBillingRequestStatus,
  ProjBillgReqApprovalStatus,
  ProjectBillingRequestType,
  SalesDocument,
  ProjectBillingCategory,
  ProjBillgReqLastChgdBy,
  ProjBillgReqLastChgdAtDteTme,
  ProjBillgReqCreatedBy,
  ProjBillgReqCreatedAtDteTme,
  DocumentCurrency,
  ProjectBillingRequest,
  Project,
  _CustomerToBusinessPartner.Customer AS Customer,
  _CustomerToBusinessPartner._Customer.CustomerName AS CustomerName,
  virtual WBSElementExternalID : abap.char( 24 ) AS char24,
  virtual BillingPlanUsageCategoryName : abap.char( 60 ) AS char60,
  virtual ProfitCenterName : abap.char( 30 ) AS char30,
  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
FROM R_ProjectBillingRequestTP
LEFT OUTER JOIN C_ProjBillgElmntForPrjBlgReq AS _ProjBillgElmntForPrjBlgReq ON ProjectBillingRequestUUID = _ProjBillgElmntForPrjBlgReq.ProjectBillingRequestUUID  -- association [0..*]
LEFT OUTER JOIN C_WrittenOffPrjBlgElmEntrDets AS _WrittenOffPrjBlgElmEntrDets ON ProjectBillingRequestUUID = _WrittenOffPrjBlgElmEntrDets.ProjectBillingRequestUUID  -- association [0..*]
;