Fins_acdoca_lines_base

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 Fins_acdoca_lines_base.
-- 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 Fins_acdoca_lines_base AS
SELECT
  a.rldnr AS rldnr,
  a.rbukrs AS rbukrs,
  a.gjahr AS docyear,
  a.belnr AS belnr,
  a.docln AS docln,
  a.rmvct AS rmvct,
  a.vorgn AS vorgn,
  a.vrgng AS vrgng,
  a.bttype AS bttype,
  cast( case a.bttype when 'RFCV' then a.bttype else ( case a.vrgng when '' then a.vorgn when 'COIE' then a.vorgn when 'COIN' then a.vorgn else a.vrgng end ) end as fins_trr_bttype ) AS bttype_tec,
  a.awtyp AS awtyp,
  a.awsys AS awsys,
  a.aworg AS aworg,
  a.awref AS awref,
  a.awitem AS awitem,
  a.budat AS budat,
  a.bldat AS bldat,
  cast(1 as fins_acdoca_lines) AS no_of_lines
FROM acdoca AS a
INNER JOIN finsc_ld_cmp AS v ON /* join condition not captured in parsed metadata */
;