SAP ECC如何调用HANA

测试例子如下:

DATA: GO_ALV_DISPLAY TYPE REF TO IF_SALV_GUI_TABLE_IDA.
DATA: GT_VISIBLE_FIELD TYPE IF_SALV_GUI_TYPES_IDA=>YT_FIELD_NAME.
DATA: GW_FIELDS LIKE LINE OF GT_VISIBLE_FIELD.
DATA: GS_PERSISTENCE_KEY TYPE IF_SALV_GUI_LAYOUT_PERSISTENCE=>YS_PERSISTENCE_KEY.
DATA: GT_FIELD_NAME TYPE IF_SALV_GUI_TYPES_IDA=>YTS_FIELD_NAME.
DATA: GW_FIELD_NAME LIKE LINE OF GT_FIELD_NAME.

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
  SELECT-OPTIONS: S_BILLNU FOR VBELN.
SELECTION-SCREEN END OF BLOCK B1.

TRY.

 GO_ALV_DISPLAY = CL_SALV_GUI_TABLE_IDA=>CREATE( 'VIEW_NAME' ).
 DATA(GO_COLLECTOR) = NEW CL_SALV_RANGE_TAB_COLLECTOR( ).
 GO_COLLECTOR->ADD_RANGES_FOR_NAME( IV_NAME = 'VBELN_IN' IT_RANGES = S_BILLNU[] ).
 GO_COLLECTOR->GET_COLLECTED_RANGES( IMPORTING ET_NAMED_RANGES = DATA(GT_NAME_RANGES) ).
 GO_ALV_DISPLAY->SET_SELECT_OPTIONS( IT_RANGES = GT_NAME_RANGES ).

ENDTRY.


  • 1
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Contents Foreword ...................................................................................... 15 Preface .......................................................................................... 17 Introduction ................................................................................. 19 PART I Basic Principles 1 Overview of SAP HANA ................................................ 29 1.1 Software Components of SAP HANA .............................. 29 1.1.1 SAP HANA Database ......................................... 31 1.1.2 SAP HANA Studio ............................................. 31 1.1.3 SAP HANA Client .............................................. 33 1.1.4 SAP HANA Function Libraries ........................... 34 1.1.5 Software for Data Replication ............................ 34 1.1.6 Software for Direct Data Access ........................ 35 1.1.7 Lifecycle Management Components .................. 36 1.2 Basic Principles of In-Memory Technology ..................... 37 1.2.1 Hardware Innovations ....................................... 37 1.2.2 Software Innovations ......................................... 41 1.3 Architecture of the In-Memory Database ....................... 51 1.4 Application Cases for SAP HANA ................................... 53 1.5 How SAP HANA Affects Application Development ........ 56 1.5.1 New Technical Options ..................................... 56 1.5.2 Code Pushdown ................................................ 57 1.5.3 Database as Whitebox ....................................... 59 1.5.4 Required Qualifications for Developers ............. 61 2 Introducing the Development Environment ................. 63 2.1 Overview of Eclipse ....................................................... 63 2.2 SAP’s Eclipse Strategy .................................................... 66 2.2.1 Unbundling of Eclipse and SAP Software ........... 67 2.2.2 Central Update Site ........................................... 67 2.3 Installing the Development Environment ....................... 69 2.3.1 Installing SAP HANA Studio .............................. 69 8 Contents 2.3.2 Installing the ABAP Development Tools for SAP NetWeaver ................................................. 70 2.4 Getting Started in the Development System ................... 72 2.4.1 Basic Principles of Eclipse .................................. 72 2.4.2 ABAP Development Tools for SAP NetWeaver ... 75 2.4.3 SAP HANA Studio ............................................. 85 3 Database Programming Using SAP NetWeaver AS ABAP ........................................................................ 103 3.1 SAP NetWeaver AS ABAP Architecture .......................... 105 3.1.1 Database Interface ............................................ 107 3.1.2 Role of the Database for the ABAP Application Server ............................................. 109 3.1.3 Data Types ........................................................ 110 3.2 ABAP Database Access .................................................. 116 3.2.1 ABAP Data Dictionary ....................................... 117 3.2.2 Open SQL ......................................................... 122 3.2.3 Database Views in the ABAP Data Dictionary .... 132 3.2.4 Database Access via Native SQL ........................ 133 3.2.5 Secondary Database Connections ...................... 139 3.3 Analyzing Database Accesses Using the SQL Trace ......... 143 3.3.1 Statement Transformations ................................ 143 3.3.2 Secondary Connections ..................................... 150 3.3.3 Native SQL ........................................................ 151 3.3.4 Buffer ................................................................ 152 PART II Introduction to ABAP Programming with SAP HANA 4 View Modeling in SAP HANA Studio ........................... 157 4.1 Attribute Views ............................................................. 160 4.1.1 Basic Principles ................................................. 161 4.1.2 Creating Attribute Views ................................... 164 4.1.3 Calculated Fields ............................................... 172 4.1.4 Hierarchies ........................................................ 174 4.1.5 Attribute Views for Time Values ........................ 176 9 Contents 4.1.6 Runtime Artifacts and SQL Access for Attribute Views ................................................. 179 4.2 Analytic Views ............................................................... 180 4.2.1 Basic Principles ................................................. 181 4.2.2 Creating Analytic Views ..................................... 183 4.2.3 Calculated Key Figures ...................................... 186 4.2.4 Currency Conversion and Unit Conversion ........ 187 4.2.5 Runtime Artifacts and SQL Access for Analytic Views .................................................. 191 4.3 Calculation Views .......................................................... 192 4.3.1 Basic Principles ................................................. 193 4.3.2 Graphical Modeling of Calculation Views .......... 195 4.3.3 Implementing Calculation Views via SQLScript .......................................................... 197 4.3.4 Runtime Artifacts and SQL Access for Calculation Views .............................................. 202 4.4 Accessing Column Views via Microsoft Excel .................. 203 4.5 Using SAP HANA Views in ABAP ................................... 205 4.5.1 Access via Native SQL ....................................... 205 4.5.2 External Views in the ABAP Data Dictionary ...... 207 4.5.3 Options for Accessing External Views ................ 210 4.5.4 Recommendations ............................................ 211 5 Programming Options in SAP HANA ............................ 215 5.1 Overview of SQLScript ................................................... 215 5.1.1 Qualities of SQLScript ....................................... 216 5.1.2 Processing SQLScript ......................................... 222 5.2 Implementing Database Procedures ............................... 223 5.2.1 Basic Principles of Database Procedures ............ 223 5.2.2 Creating Database Procedures ........................... 225 5.2.3 Using Variables .................................................. 237 5.2.4 Calculation Engine Plan Operator ..................... 239 5.2.5 Imperative Enhancements ................................. 250 5.2.6 Accessing System Fields .................................... 252 5.2.7 Error Handling ................................................... 254 5.3 Using Procedures in ABAP ............................................. 255 5.3.1 Access Using Native SQL ................................... 256 10 Contents 5.3.2 Defining Database Procedure Proxies ................ 263 5.3.3 Calling Database Procedure Proxies ................... 265 5.3.4 Adjusting Database Procedure Proxies ............... 267 6 Application Transport ................................................... 269 6.1 Basic Principles of the Transport System ......................... 271 6.1.1 Transport in SAP NetWeaver AS ABAP .............. 271 6.1.2 Transport in SAP HANA ..................................... 276 6.2 Combined ABAP/SAP HANA Transport .......................... 285 6.2.1 HANA Transport Container ................................ 286 6.2.2 Enhanced Transport System ............................... 292 7 Runtime and Error Analysis with SAP HANA ............... 293 7.1 Overview of the Tools Available ..................................... 294 7.2 Error Analysis ................................................................. 296 7.2.1 Unit Tests .......................................................... 296 7.2.2 Dump Analysis .................................................. 299 7.2.3 Tracing in SQLScript .......................................... 301 7.2.4 Debugging SQLScript ........................................ 302 7.3 ABAP Code Analysis ...................................................... 305 7.3.1 Checks and Check Variants ................................ 305 7.3.2 Checks in the Development Infrastructure ......... 309 7.3.3 Global Check Runs in the System ...................... 311 7.4 Runtime Statistics and Traces ......................................... 313 7.4.1 Runtime Statistics .............................................. 314 7.4.2 ABAP Trace and ABAP Profiler ........................... 318 7.4.3 SQL Trace ......................................................... 326 7.4.4 Single Transaction Analysis ............................... 330 7.4.5 Explain Plan ...................................................... 331 7.4.6 SAP HANA Plan Visualizer ................................ 333 7.5 System-Wide SQL Analyses ............................................ 337 7.5.1 DBA Cockpit .................................................... 338 7.5.2 SQL Monitor .................................................... 342 7.6 SQL Performance Optimization ...................................... 346
### 回答1: SAP ECC HANA迁移是将企业使用的SAP ECC系统升级至SAP HANA数据库的过程。在这个过程中,需要把原来的系统数据迁移到新的系统中,确保数据的准确性和完整性,并且保持系统连续性,避免数据丢失。 SAP ECC HANA的升级可以带来很多好处,比如: 1.提高系统性能和响应速度,增强数据处理能力; 2.支援更复杂的业务场景和数据分析; 3.简化系统维护,减少人员管理和硬件成本; 4.适应新的数据加密和安全存储方式。 为了实现SAP ECC HANA的迁移,企业应该进行详细的规划和准备工作,建立一个全面的迁移策略,涵盖以下重要步骤: 1.评估迁移的影响范围和可能的风险; 2.确定迁移时间表和资源需求; 3.准备并测试新系统的硬件和软件环境; 4.确保数据和应用程序的兼容性; 5.制定数据迁移计划和确保数据质量; 6.进行迁移测试和验证; 7.培训使用新系统的员工。 总之,SAP ECC HANA迁移是一项复杂的任务,企业需要在执行过程中仔细规划和实施,以确保系统更新不会对业务造成负面影响。同时,企业应该注意在迁移过程中保护数据的安全性和完整性。 ### 回答2: SAP ECC HANA 迁移是将企业资源计划(ERP)软件SAP ECC迁移到SAP HANA平台上的过程。SAP ECCSAP在传统关系数据库上运行的ERP软件,而SAP HANA采用了内存数据库技术,具有更高的性能和更快的数据处理速度。 SAP ECC HANA 迁移是一项复杂的任务,需要经验丰富的专业人员来完成。迁移过程包括分析、设计、测试、实施和验证等多个阶段。在分析阶段,需要评估现有系统与HANA平台的兼容性,以及准备数据迁移计划。在设计阶段,需要确定系统架构、配置、安全设置等。在测试阶段,需要验证系统的稳定性和性能。在实施阶段,需要进行数据迁移和系统交付。最后,在验证阶段,需要验证系统是否达到预期的性能和稳定性。 SAP ECC HANA 迁移具有许多优势,如更快的数据处理速度、更高的数据可靠性和更好的分析能力等。此外,通过利用HANA平台的内存数据库技术,SAP ECC HANA 迁移可以提高企业的效率并减少IT部门的工作量和成本。 总之,SAP ECC HANA 迁移是一项具有挑战性的任务,但通过一个正确的计划和实施过程,企业可以获得巨大的经济和业务优势。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值