P_Comfpbilling

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 P_Comfpbilling.
-- 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: PCOMFPBILL

CREATE VIEW P_Comfpbilling AS
SELECT
  _BillingPlan.dliid AS dliid,
  _BillingPlan.vbeln AS SalesOrder,
  _BillingPlan.posnr AS SalesOrderItem,
  _BillingPlan.billdate AS BillingDate,
  _SalesOrder.spart AS OrganizationDivision,
  case when (_SalesOrder.ps_psp_pnr is not null) then (_Project.pspnr) else concat(concat('VB', _BillingPlan.vbeln), _BillingPlan.posnr ) end as ReferenceObjectID AS posnrendasReferenceObjectID,
  cast (' ' as ad01dlinr) AS dlinr
FROM /cpd/pws_rcb_bpf AS _BillingPlan
LEFT OUTER JOIN vbap AS _SalesOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN prps AS _Project ON /* join condition not captured in parsed metadata */
;