v_konv_draft

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 v_konv_draft.
-- 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: V_KONV_DRAFT_CDS

CREATE VIEW v_konv_draft AS
SELECT
  draft_key,
  knumv,
  kposn,
  stunr,
  zaehk,
  kappl,
  kschl,
  cast(substring( kdatu, 1, 8 ) as abap.dats ) AS kdatu,
  cast(substring( krech, 1, 1 ) as abap.char( 1 ) ) AS krech,
  waers,
  kkurs,
  kpein,
  kmein,
  cast( kumza as abap.dec( 5, 0 ) ) AS kumza,
  cast( kumne as abap.dec( 5, 0 ) ) AS kumne,
  kntyp,
  kstat,
  knprs,
  kruek,
  kreli,
  kherk,
  kgrpe,
  koupd,
  kolnr,
  knumh,
  cast(substring( kopos, 2, 2 ) as abap.numc( 2 ) ) AS kopos,
  kvsl1,
  sakn1,
  mwsk1,
  kvsl2,
  sakn2,
  mwsk2,
  lifnr,
  kunnr,
  kdiff,
  cast( kwert as abap.curr( 13, 2 ) ) AS kwert,
  ksteu,
  kinak,
  koaid,
  zaeko,
  kmxaw,
  kmxwr,
  kfaktor,
  kdupl,
  kfaktor1,
  cast(substring( kzbzg, 1, 1 ) as abap.char( 1 ) ) AS kzbzg,
  konms,
  konws,
  kwaeh,
  cast(kwert_k as abap.curr( 13, 2 ) ) AS kwert_k,
  kfkiv,
  kvarc,
  kmprs,
  prsqu,
  varcond,
  cast('0' as abap.dec( 2, 0 ) ) AS stufe,
  cast('0' as abap.dec( 4, 0 ) ) AS wegxx,
  ktrel,
  mdflg,
  txjlv,
  kbflag,
  cast ( '000' as abap.numc(3) ) AS kolnr3,
  cpf_guid,
  kaqty,
  val_zero,
  tax_country
FROM prcd_elem_draft
LEFT OUTER JOIN tcurx AS tcurx_waers ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tcurx AS tcurx_waerk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tcurx AS tcurx_konws ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tcurx AS tcurx_kwaeh ON /* join condition not captured in parsed metadata */
;