ABAP sql
1.取最大 SELECT SINGLE MAX( begda ) INTO @DATA(lv_max_begda) FROM pa0530.
2.限制行数 UP TO 1 ROWS.
3.FILTER DATA(lt_result) = FILTER #( itab WHERE start_date > '20250101' ).
4..CAST 函数: Data Type Conversion Function
CAST (expression AS data_type)
CAST( 列名/值/表达式 AS 数据类型)
范例:
参数为列名: select CAST(empno as INTEGER) as EMPNO from emp;
参数为值:select CAST('23456' as INTEGER) as "CAST" from DUMMY;
参数为子查询: select CAST((select top 1 empno from emp) as INTEGER) from DUMMY;