demo_cds_sql_functions_string

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 demo_cds_sql_functions_string.
-- 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: DEMO_CDS_STRFUNC

CREATE VIEW demo_cds_sql_functions_string AS
SELECT
  length( char1 ) AS r_length,
  instr( char1, 'CD' ) AS r_instr,
  left( char1, 3 ) AS r_left,
  lower( char1 ) AS r_lower,
  right( char2, 3 ) AS r_right,
  lpad( char1, 10, 'x' ) AS r_lpad,
  rpad( char2, 10, 'y' ) AS r_rpad,
  ltrim( char1, 'A' ) AS r_ltrim,
  rtrim( char1, 'E' ) AS r_rtrim,
  replace( char2, 'GHI', 'XXX' ) AS r_replace,
  upper( char2 ) AS r_upper
FROM demo_expressions
;