FAA_SDM_DOCIT_CPPV

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_SDM_DOCIT_CPPV.
-- 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: FAAVDOCITCPPV

CREATE VIEW FAA_SDM_DOCIT_CPPV AS
SELECT
  doc_comp.bukrs AS bukrs,
  doc_comp.anln1 AS anln1,
  doc_comp.anln2 AS anln2,
  doc_comp.gjahr AS gjahr,
  doc_comp.afabe AS afabe,
  doc_comp.poper AS poper,
  doc_comp.slalittype AS slalittype,
  doc_comp.rldnr AS rldnr,
  doc_comp.belnr AS belnr,
  doc_comp.docln AS docln,
  cast( doc_comp.split_number as int4 preserving type ) AS split_number,
  doc_comp.s_poper AS s_poper,
  doc_comp.t_poper AS t_poper,
  doc_comp.poper_d AS poper_d,
  doc_comp.s_movcat AS s_movcat,
  doc_comp.t_movcat AS t_movcat,
  doc_comp.movcat_d AS movcat_d,
  doc_comp.s_hsl AS s_hsl,
  doc_comp.t_hsl AS t_hsl,
  doc_comp.hsl_d AS hsl_d,
  doc_comp.s_ksl AS s_ksl,
  doc_comp.t_ksl AS t_ksl,
  doc_comp.ksl_d AS ksl_d,
  doc_comp.s_osl AS s_osl,
  doc_comp.t_osl AS t_osl,
  doc_comp.osl_d AS osl_d,
  doc_comp.s_vsl AS s_vsl,
  doc_comp.t_vsl AS t_vsl,
  doc_comp.vsl_d AS vsl_d,
  doc_comp.s_rhcur AS s_rhcur,
  doc_comp.t_rhcur AS t_rhcur,
  doc_comp.rhcur_d AS rhcur_d,
  doc_comp.s_rkcur AS s_rkcur,
  doc_comp.t_rkcur AS t_rkcur,
  doc_comp.rkcur_d AS rkcur_d,
  doc_comp.s_rocur AS s_rocur,
  doc_comp.t_rocur AS t_rocur,
  doc_comp.rocur_d AS rocur_d,
  doc_comp.s_rvcur AS s_rvcur,
  doc_comp.t_rvcur AS t_rvcur,
  doc_comp.rvcur_d AS rvcur_d,
  doc_comp.s_anlkl AS s_anlkl,
  doc_comp.t_anlkl AS t_anlkl,
  doc_comp.anlkl_d AS anlkl_d,
  doc_comp.s_ktogr AS s_ktogr,
  doc_comp.t_ktogr AS t_ktogr,
  doc_comp.ktogr_d AS ktogr_d,
  doc_comp.s_mig_source AS s_mig_source,
  doc_comp.t_mig_source AS t_mig_source,
  doc_comp.mig_source_d AS mig_source_d,
  doc_comp.s_recid AS s_recid,
  doc_comp.t_recid AS t_recid,
  doc_comp.recid_d AS recid_d,
  cast( doc_comp.direction as char01 preserving type ) AS direction,
  doc_comp.anlkl AS anlkl,
  doc_comp.movcat AS movcat
FROM FAA_SDM_DOCIT_CP21 AS doc_comp
-- UNION with additional select branch(es): FAA_SDM_DOCIT_CP22
;