Skip to Content

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。 这里提供了一个思路,不一定最优,可以公开讨论 🙂 .

可以调用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.
To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply