Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

发送动态SQL到HANA

Former Member
‎07-02-2014 9:59 AM
0 Kudos

从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.
Labels in this area
Popular Blog Posts