P_Comfpopenbillingplan

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_Comfpopenbillingplan.
-- 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: PCOMFPOPENBP

CREATE VIEW P_Comfpopenbillingplan AS
SELECT
  P_Comfpbilling.dliid AS dliid,
  P_Comfpbilling.SalesOrder AS SalesOrder,
  P_Comfpbilling.SalesOrderItem AS SalesOrderItem,
  P_Comfpbilling.BillingDate AS BillingDate,
  P_Comfpbilling.OrganizationDivision AS OrganizationDivision,
  P_Comfpbilling.ReferenceObjectID AS ReferenceObjectID,
  case when (P_Comfpbilling.dlinr = ' ') then 'OPEN' else ' ' end as status AS dlinrthenOPENelseendasstatus
FROM P_Comfpbilling
LEFT OUTER JOIN ad01dli AS _ad01 ON P_Comfpbilling.ReferenceObjectID = _ad01.objnr  -- association [0..1]
LEFT OUTER JOIN ad01dli AS _ad02 ON P_Comfpbilling.dliid = _ad02.cpd_dliid  -- association [0..1]
;