实例介绍
【实例简介】
HA400 ABAP programing for HANA
Opcn Text is a registered trademark of Opcn Text Corporatio Oraclc and Java arc registered trademarks of Oracle and its affiliates QR Codc is a registered trademark of Denso Wavc Incorporated RIM, BlackBerry, BBM, BlackBerry Curve, BlackBerry Bold, Black Berry Pearl, Black Berry Torch, Black Berry Storm, Black Berry Storm2, Black Berry Play Book, and Black Berry App world are trademarks or registered trademarks of Research in Motion Limited SAVO is a registered trademark of The Savo Group ltd The Skype name is a trademark of Skype or related entities Twitter and Tweet are trademarks or registered trademarks of twitter CNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open group Wi-Fi is a registered trademark of wi-Fi Alliance SAP, R/3, ABAP, BAPL, SAP Net Weaver, Duet, PartnerEdge. By Design, SAP Businessobjects Explorer, Stream Work, SAP HANA, the Business Objects logo, Business Objects, Crystal Reports Crystal Decisions, Web Intelligence, Xcelsius, Sybase, Adaptive Server, Adaptive Server Enterprise iAnywhere, Sybase 365, SQL, Anywhere, Crossgate, 13213 360 and B213 360 Services, m(agic EDDY, Ariba, thc Ariba logo, Quadrcm, b-proccss, Ariba Discovcry, Success Factors, Exccution is the Difference, BizX Mobile Touchbase, It's time to love work again, Success Factors Jam and BadAss Saas, and other Sap products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE in Germany or an SAP affiliate company All other product and service names mentioned are the trademarks of their respective companies Data contained in this document serves informational purposes only. National product specifications may vary. Disclaimer These materials are subject to change without notice. These materials are provided by SAP Se and its affiliated companies("SAP Group")for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in thc cxprcss warranty statcmcnts accompanying such products and scrviccs, if any. Nothing hcrcin should be construed as constituting an additional warrant g201521710362 g201521710362 About This handbook This handbook is intended to complement the instructor-led presentation of this course, and serve as a source of reference. It is not suitable for self-study Typographic Conventions American English is the standard used in this handbook. The following typographic conventions are also used Type Style Description Example text Words or characters that appear on the screen. These include field names, screen titles, pushbuttons as well as menu names, paths, and options Also used for cross-references to other documentation both internal and external Example text Emphasized words or phrases in body text, titles of graphics, and tables EXAMPLE TEXT Names of elements in the system. These include report names, program names, transaction codes, table names, and individual key words of a programming language, when surrounded by body text, for example SELECT and INclude Example text Screen output. This includes file and directory names and their paths, messages, names of variables and parameters, and passages of the source text of a program Example text Exact user entry. These are words and characters that you enter in the system exactly as they appear in the documentation <Example text> Variable user entry. pointed brackets indicate that you replace these words and characters with appropriate entries 2015 SAP SE or an SAP affiliate campany. All rights reserved About this handbook HA400 Icons in Body Text The following icons are used in this handbook. Icon Meaning For more information, tips, or background Note or further explanation of previous point A xception or caution Procedures Indicates that the item is displayed in the instructor's presentation O SAP SE or an SaP affiliate company All rights reserved 2015 Contents Course Overview Course goals ■1 Course Obiectives Unit 1: Introduction SAP HANA Basics and Technical Concepts 3 troduction to ntroduction to ABAP Development Tools(ADT 33 Introduction to the EPM Sample Application. ........... 48 Unit 2: Taking aBaP to SAP HANA 55 SAP HANA as Secondary Database-Access via Open SQL. 57 Preparing for SAP HANA 71 Guided Performance Analysi 92 Performance rules and guidelines for sAP hana 16 Unit 3: Code-to-Data with SAP HANA as Secondary Database 123 Classical Open SQL and its limitations............ 125 ABAP Database Connectivity(ADBC) 131 Native SQL Syntax 135 Working with Views in SAP HANA Studio 156 Consuming SAP HANA Views via Native SQL 165 Working With Database Procedures in SAP HANA Studio.. 180 Calling SAP HANA Procedures in ABAP 186 Unit 4: Code-to-Data with ABAP 7,4.4444444494444444444.201 New Open SQL 202 Core Data services in AbaP .216 Associations in Core data services Unit 5: Code-to-Data with SAP HANA as Primary Database. 251 Core Data Services with Input Parameters 1■ 252 ABAP-Managed Database Procedures :::::日:.. 263 Debugging ABAP-managed Database Procedures 284 Unit 6: SAP HANA Proxy Objects..... ■■■■■■■■■■ 295 Accessing SAP HANA Views via ABAP Dictionary External VⅰeWs 297 2015 SAP SE or an SAP affiliate campany. All rights reserved vi sAp Contents HA400 Calling sAP HANA Procedures via ABAP Database Procedure Proxies 312 Transport of sAP HANA objects ∴326 Unit 7: Advanced Topics ..... 337 Using SAP HANA Full Text Search 338 ABAP List Viewer(ALv)with Integrated Access to SAP HANA 365 Unit 8: Case Study: Optimize a Report on Flight Customer Revenue 387 Creating an Analytic View 388 Unit 9: Appendix: Alternative Exercises 417 xercises based on Flight data model .419 Unit 10: Appendix: Other New ABAP Language Elements. 571 Additional ABAP Language Enhancements 572 O SAP SE or an SaP affiliate company All rights reserved 2015 Course Overview Target Audience This course is intended for the following audiences Developers and development consultants who need to write or review performance-optimized ABAP code for SAP HANA Course Prerequisites Required knowledge HA100 HANA Overview BC400 ABAP Workbench fundamentals BC401 ABAP Objects Experience in ABAP Programing( procedural and object oriented) Open SQl details gjoins, views, aggregations) Recommended Knowledge HA150 SQL Basics for SAP hana Course goals This course will prepare you to Develop and optimize abap applications that access data stored in the sap HANA Database Course objectives After completing this course, you will be able to Understand the technical concepts of SAP HaNa Understand how to optimize classic ABAP for SAP HANA Describe the use of analysis tools for performance optimization(Runtime Analysis, Code Inspector, SQL Trace, SQL Performance Tuning Worklist Understand the SQL performance rules of ABAP for SAP HANA Access SAP HANA from ABAP using native SOL and DBC(ABaP Database Connectivity) Use enhanced Open Sql Use Core data Services in abap to define advanced views 2015 SAP SE or an SAP affiliate campany. All rights reserved ix SAp Course Overview HA400 Call SAP HANa stored procedures in ABAP and embed stored procedures in abap Consume sap hana views in abap Create a simple SAP HANA view O SAP SE or an SaP affiliate company X All rights reserved 2015 【实例截图】
【核心代码】
HA400 ABAP programing for HANA
Opcn Text is a registered trademark of Opcn Text Corporatio Oraclc and Java arc registered trademarks of Oracle and its affiliates QR Codc is a registered trademark of Denso Wavc Incorporated RIM, BlackBerry, BBM, BlackBerry Curve, BlackBerry Bold, Black Berry Pearl, Black Berry Torch, Black Berry Storm, Black Berry Storm2, Black Berry Play Book, and Black Berry App world are trademarks or registered trademarks of Research in Motion Limited SAVO is a registered trademark of The Savo Group ltd The Skype name is a trademark of Skype or related entities Twitter and Tweet are trademarks or registered trademarks of twitter CNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open group Wi-Fi is a registered trademark of wi-Fi Alliance SAP, R/3, ABAP, BAPL, SAP Net Weaver, Duet, PartnerEdge. By Design, SAP Businessobjects Explorer, Stream Work, SAP HANA, the Business Objects logo, Business Objects, Crystal Reports Crystal Decisions, Web Intelligence, Xcelsius, Sybase, Adaptive Server, Adaptive Server Enterprise iAnywhere, Sybase 365, SQL, Anywhere, Crossgate, 13213 360 and B213 360 Services, m(agic EDDY, Ariba, thc Ariba logo, Quadrcm, b-proccss, Ariba Discovcry, Success Factors, Exccution is the Difference, BizX Mobile Touchbase, It's time to love work again, Success Factors Jam and BadAss Saas, and other Sap products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE in Germany or an SAP affiliate company All other product and service names mentioned are the trademarks of their respective companies Data contained in this document serves informational purposes only. National product specifications may vary. Disclaimer These materials are subject to change without notice. These materials are provided by SAP Se and its affiliated companies("SAP Group")for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in thc cxprcss warranty statcmcnts accompanying such products and scrviccs, if any. Nothing hcrcin should be construed as constituting an additional warrant g201521710362 g201521710362 About This handbook This handbook is intended to complement the instructor-led presentation of this course, and serve as a source of reference. It is not suitable for self-study Typographic Conventions American English is the standard used in this handbook. The following typographic conventions are also used Type Style Description Example text Words or characters that appear on the screen. These include field names, screen titles, pushbuttons as well as menu names, paths, and options Also used for cross-references to other documentation both internal and external Example text Emphasized words or phrases in body text, titles of graphics, and tables EXAMPLE TEXT Names of elements in the system. These include report names, program names, transaction codes, table names, and individual key words of a programming language, when surrounded by body text, for example SELECT and INclude Example text Screen output. This includes file and directory names and their paths, messages, names of variables and parameters, and passages of the source text of a program Example text Exact user entry. These are words and characters that you enter in the system exactly as they appear in the documentation <Example text> Variable user entry. pointed brackets indicate that you replace these words and characters with appropriate entries 2015 SAP SE or an SAP affiliate campany. All rights reserved About this handbook HA400 Icons in Body Text The following icons are used in this handbook. Icon Meaning For more information, tips, or background Note or further explanation of previous point A xception or caution Procedures Indicates that the item is displayed in the instructor's presentation O SAP SE or an SaP affiliate company All rights reserved 2015 Contents Course Overview Course goals ■1 Course Obiectives Unit 1: Introduction SAP HANA Basics and Technical Concepts 3 troduction to ntroduction to ABAP Development Tools(ADT 33 Introduction to the EPM Sample Application. ........... 48 Unit 2: Taking aBaP to SAP HANA 55 SAP HANA as Secondary Database-Access via Open SQL. 57 Preparing for SAP HANA 71 Guided Performance Analysi 92 Performance rules and guidelines for sAP hana 16 Unit 3: Code-to-Data with SAP HANA as Secondary Database 123 Classical Open SQL and its limitations............ 125 ABAP Database Connectivity(ADBC) 131 Native SQL Syntax 135 Working with Views in SAP HANA Studio 156 Consuming SAP HANA Views via Native SQL 165 Working With Database Procedures in SAP HANA Studio.. 180 Calling SAP HANA Procedures in ABAP 186 Unit 4: Code-to-Data with ABAP 7,4.4444444494444444444.201 New Open SQL 202 Core Data services in AbaP .216 Associations in Core data services Unit 5: Code-to-Data with SAP HANA as Primary Database. 251 Core Data Services with Input Parameters 1■ 252 ABAP-Managed Database Procedures :::::日:.. 263 Debugging ABAP-managed Database Procedures 284 Unit 6: SAP HANA Proxy Objects..... ■■■■■■■■■■ 295 Accessing SAP HANA Views via ABAP Dictionary External VⅰeWs 297 2015 SAP SE or an SAP affiliate campany. All rights reserved vi sAp Contents HA400 Calling sAP HANA Procedures via ABAP Database Procedure Proxies 312 Transport of sAP HANA objects ∴326 Unit 7: Advanced Topics ..... 337 Using SAP HANA Full Text Search 338 ABAP List Viewer(ALv)with Integrated Access to SAP HANA 365 Unit 8: Case Study: Optimize a Report on Flight Customer Revenue 387 Creating an Analytic View 388 Unit 9: Appendix: Alternative Exercises 417 xercises based on Flight data model .419 Unit 10: Appendix: Other New ABAP Language Elements. 571 Additional ABAP Language Enhancements 572 O SAP SE or an SaP affiliate company All rights reserved 2015 Course Overview Target Audience This course is intended for the following audiences Developers and development consultants who need to write or review performance-optimized ABAP code for SAP HANA Course Prerequisites Required knowledge HA100 HANA Overview BC400 ABAP Workbench fundamentals BC401 ABAP Objects Experience in ABAP Programing( procedural and object oriented) Open SQl details gjoins, views, aggregations) Recommended Knowledge HA150 SQL Basics for SAP hana Course goals This course will prepare you to Develop and optimize abap applications that access data stored in the sap HANA Database Course objectives After completing this course, you will be able to Understand the technical concepts of SAP HaNa Understand how to optimize classic ABAP for SAP HANA Describe the use of analysis tools for performance optimization(Runtime Analysis, Code Inspector, SQL Trace, SQL Performance Tuning Worklist Understand the SQL performance rules of ABAP for SAP HANA Access SAP HANA from ABAP using native SOL and DBC(ABaP Database Connectivity) Use enhanced Open Sql Use Core data Services in abap to define advanced views 2015 SAP SE or an SAP affiliate campany. All rights reserved ix SAp Course Overview HA400 Call SAP HANa stored procedures in ABAP and embed stored procedures in abap Consume sap hana views in abap Create a simple SAP HANA view O SAP SE or an SaP affiliate company X All rights reserved 2015 【实例截图】
【核心代码】
标签：
好例子网口号：伸出你的我的手 — 分享！
相关软件
小贴士
感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见 版权及免责申明
网友评论
我要评论