底层取数逻辑借助了SADL:
从下图能看出,该ALV的数据展示还是离不开SAP GUI的支持,本质上还是dynpro编程:
使用ADBC(ABAP Database Connectivity)进行数据读取。
关于ADBC和JDBC的比较,参考Jerry这篇博客。
通过CL_SADL_SQL_STATEMENT方法的调试,能查到运行时执行的SQL表达式:
SELECT COUNT( * ) AS "COUNT" FROM "ZFATINF" AS "ZFATINF" WITH PARAMETERS( 'LOCALE' = 'EN' )
SELECT "ZFATINF"."CLSNAME" AS "CLSNAME", "ZFATINF"."METHOD_COUNT" AS "METHOD_COUNT" FROM "ZFATINF" AS "ZFATINF" ORDER BY "ZFATINF"."CLSNAME" ASC, "ZFATINF"."METHOD_COUNT" ASC LIMIT ? OFFSET ? WITH PARAMETERS( 'LOCALE' = 'CASE_INSENSITIVE' )
要获取更多Jerry的原创文章,请关注公众号"汪子熙":