FAA_DOC_IT_BCF

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 FAA_DOC_IT_BCF.
-- 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: FAAV_DOC_IT_BCF

CREATE VIEW FAA_DOC_IT_BCF AS
SELECT
  faat_doc_it.bukrs AS bukrs,
  faat_doc_it.anln1 AS anln1,
  faat_doc_it.anln2 AS anln2,
  faat_doc_it.anlgr AS anlgr,
  faat_doc_it.anlgr2 AS anlgr2,
  faat_doc_it.afabe AS afabe,
  faat_doc_it.gjahr AS gjahr,
  faat_doc_it.ldgrp AS ldgrp,
  faat_doc_it.hsl AS hsl,
  faat_doc_it.ksl AS ksl,
  faat_doc_it.osl AS osl,
  faat_doc_it.vsl AS vsl,
  faat_doc_it.rhcur AS rhcur,
  faat_doc_it.rkcur AS rkcur,
  faat_doc_it.rocur AS rocur,
  faat_doc_it.rvcur AS rvcur,
  'AMBU' AS awtyp,
  '999' AS bwasl,
  '00' AS movcat,
  '000' AS poper,
  case when ( slalittype between '07200' and '07209' ) then slalittype else finsts_faa_bcf.slalittype_trgt end as SLALITTYPE AS slalittype_trgtendasSLALITTYPE,
  finsts_faa_bcf.slalittype_srce AS SLALITTYPE_srce,
  faat_plan_values.slalittype AS SLALITTYPE,
  anla.deakt AS deakt
FROM faat_doc_it
INNER JOIN finsts_faa_bcf ON /* join condition not captured in parsed metadata */
INNER JOIN anla ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): faat_plan_values
;