FACVD_CLROI_01

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 FACVD_CLROI_01.
-- 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 FACVD_CLROI_01 AS
SELECT
  open_items.bukrs AS bukrs,
  open_items.gjahr AS gjahr,
  open_items.belnr AS belnr,
  open_items.buzei AS buzei,
  cast( '' as fdc_accdoc_tmp_doc_id ) AS tmpid,
  open_items.h_blart AS h_blart,
  open_items.h_bldat AS h_bldat,
  open_items.h_budat AS h_budat,
  open_items.h_hwaer AS h_hwaer,
  open_items.gsber AS gsber,
  open_items.dmbtr AS dmbtr,
  open_items.dmbtr_shl AS dmbtr_shl,
  open_items.hkont AS hkont,
  open_items.kna1_begru AS kna1_begru,
  open_items.knb1_begru AS knb1_begru,
  open_items.koart AS koart,
  open_items.konko AS konko,
  open_items.kunnr AS kunnr,
  open_items.lfa1_begru AS lfa1_begru,
  open_items.lfb1_begru AS lfb1_begru,
  open_items.lifnr AS lifnr,
  open_items.netdt AS netdt,
  open_items.pswsl AS pswsl,
  open_items.sgtxt AS sgtxt,
  open_items.shkzg AS shkzg,
  open_items.rebzg AS rebzg,
  open_items.rebzj AS rebzj,
  open_items.rebzz AS rebzz,
  open_items.rebzt AS rebzt,
  open_items.skb1_begru AS skb1_begru,
  open_items.h_waers AS h_waers,
  open_items.h_hwae2 AS h_hwae2,
  open_items.h_hwae3 AS h_hwae3,
  open_items.wrbtr AS wrbtr,
  open_items.wrbtr_shl AS wrbtr_shl,
  open_items.dmbe2 AS dmbe2,
  open_items.dmbe3 AS dmbe3,
  open_items.xzahl AS xzahl,
  open_items.zuonr AS zuonr,
  open_items.kidno AS kidno,
  open_items.adrnr AS adrnr,
  open_items.butxt AS butxt,
  open_items.name1 AS name1,
  open_items.umsks AS umsks,
  open_items.umskz AS umskz,
  open_items.pyamt AS pyamt,
  open_items.pycur AS pycur,
  open_items.h_bktxt AS h_bktxt,
  open_items.h_xblnr AS h_xblnr,
  open_items.h_xblnr_alt AS h_xblnr_alt,
  open_items.h_awtyp AS h_awtyp,
  open_items.vbund AS vbund,
  open_items.zlspr AS zlspr,
  open_items.buzei_sender AS buzei_sender,
  open_items.concat_bseg_key AS bseg_key,
  open_items.vbeln AS vbeln,
  open_items.j_1tpbupl AS j_1tpbupl,
  open_items.ebeln AS ebeln,
  open_items.ebelp AS ebelp,
  open_items.vbel2 AS vbel2,
  open_items.posn2 AS posn2,
  open_items.filkd AS filkd,
  open_items.xref1 AS xref1,
  open_items.xref2 AS xref2,
  open_items.xref3 AS xref3,
  open_items.vname AS vname,
  open_items.recid AS recid,
  open_items.egrup AS egrup,
  open_items.bupla AS bupla,
  open_items.hbkid AS hbkid,
  open_items.hktid AS hktid,
  open_items.zlsch AS zlsch,
  cast ( '' as farp_ltext_003t ) AS blart_ltext,
  open_items.fcsl AS fcsl,
  open_items.rfccur AS rfccur,
  open_items.kkber AS kkber,
  open_items.btype AS btype,
  promise_to_pay_attr_assoc.promised_for AS promised_for,
  promise_to_pay_attr_assoc.promised_by AS promised_by,
  promise_to_pay_attr_assoc.promised_on AS promised_on
FROM FACVD_CLROI_02 AS open_items
LEFT OUTER JOIN FACVD_CLRPP_01 AS promise_to_pay_attr_assoc ON promise_to_pay_attr_assoc.fin_invoice_key = open_items.concat_bseg_key  -- association [0..1]
;