从SAP NetWeaver AS ABAP 7.4 SP5开始ABAP 已经很好的与HANA 集成, 从ABAP建立CDS视图的更好支持,从ABAP(Eclipse)工作站建立存储过程ABAP managed Database Procedures (AMDP), 强化了OpenSQL 语法 详见: New ABAP for HANA features in SAP NW 7.4 SP5 。
今天这里介绍如何得到动态的SQL语句从而能更加优化灵活的将运用逻辑下称至HANA。 这里提供了一个思路,不一定最优,可以公开讨论 :smile: .
可以调用FREE_SELECTIONS_RANGE_2_WHERE 这个FM将选择条件转换SQL语句的WHERE条件,再通过ADBC的形式访问HANA。ERE FREE_SELECTIONS_RANGE_2_WHERE
CALL FUNCTION 'FREE_SELECTIONS_RANGE_2_WHERE'
EXPORTING
field_ranges = t_ranges
IMPORTING
where_clauses = lt_where.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |