CXCV_DDL_TCX00

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 CXCV_DDL_TCX00.
-- 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: CXCV_V_TCX00

CREATE VIEW CXCV_DDL_TCX00 AS
SELECT
  tcx00.werks AS werks,
  tcx00.auftg AS auftg,
  tcx00.aufta AS aufta,
  tcx00.vagrp AS vagrp,
  tcx00.line_term AS line_term,
  cast( '000' as rathr preserving type ) AS rathr,
  cast( '' as apls2 ) AS apls2,
  cast( '' as termx_rate preserving type ) AS term2,
  cast( '' as kapkx_rate preserving type ) AS kapk2,
  tcx00.dadj1 AS dadj1,
  tcx00.dadj2 AS dadj2,
  tcx00.dadj3 AS dadj3,
  tcx00.term_auto AS term_auto,
  tcx00.matfrueh AS matfrueh,
  tcx00.breaks AS breaks,
  tcx00.prod_dates AS prod_dates,
  tcx00.auf_shift AS auf_shift,
  tcx00.redst_max AS redst_max,
  tcx00.red_art AS red_art,
  tcx00.redvs_s1 AS redvs_s1,
  tcx00.redvs_s2 AS redvs_s2,
  tcx00.redvs_s3 AS redvs_s3,
  tcx00.redvs_s4 AS redvs_s4,
  tcx00.redvs_s5 AS redvs_s5,
  tcx00.redvs_s6 AS redvs_s6,
  tcx00.term_kper AS term_kper,
  tcx00.cmact AS cmact
FROM tcx00 AS TCX00
;