41_10-11-25_ABAP_Hana syntax

TOPIC'S COVERED

  • HANA Server Login Issue Investigation
  • ABAP Web Project Overview
  • SAP ECC vs HANA Systems
  • SAP Architecture and Core Data Services
  • Eclipse Server and Data Services
  • SAP CDS Views Efficiency Demonstration
  • CDS Views and Function Modules
  • HANA Coding and Version Control


Summary

HANA Server Login Issue Investigation

Pradeep discussed an issue with logging into the HANA server, which Amand is investigating. The team is waiting for the vendor's response, and Pradeep suggested trying again the next day if the problem persists.

ABAP Web Project Overview

Pradeep provided Meenal with an overview of upcoming purchases and demonstrated how to create a web project in Eclipse using ABAP. He explained the process of writing programs in SC38 and joining tables without coding. Pradeep also mentioned system variables for storing program and landscape information, noting that the BASIS team would create user roles and IDs.

SAP ECC vs HANA Systems

Pradeep explained the similarities and differences between SAP ECC and HANA systems, focusing on user authentication, integration, and development environments. He highlighted that while the user interfaces and icons in HANA Studio (Eclipse-based) are slightly different from SAP ECC, the core functionalities remain the same. Pradeep also mentioned the availability of inbuilt tools, code templates, and syntax checks in HANA Studio, and emphasized that once access is granted, users can begin learning and working with the system.

SAP Architecture and Core Data Services

Pradeep explained the differences between SAP's three-layer architecture (presentation, application, and database layers) and the analyst survey's two-layer structure (application and database layers). He described Core Data Services (CDSVU) as a more flexible alternative to traditional views, allowing for complex coding and business logic without restrictions, and explained how CDSVU can be integrated with OData and used as an interface for third-party data exchange.

Eclipse Server and Data Services

Pradeep explained the functionality of Eclipse server and core data services, including creating data definitions, views, and table functions with parameters. He described how to use automatic code generation and write logic similar to ABAP, but with some differences. Pradeep emphasized that the latest version offers more options than the older version, and he encouraged attendees to ask questions if they had any doubts.

SAP CDS Views Efficiency Demonstration

Pradeep explained the advantages of using CDS Views in SAP, highlighting that data manipulation can be done directly in the database at runtime without the need for internal tables or looping, which makes operations more efficient and reduces time consumption. He demonstrated how to perform operations like aggregation, grouping, filtering, and joining directly in the select statement, emphasizing that this approach supports various types of joins and allows for complex calculations to be executed at the database level.

CDS Views and Function Modules

Pradeep explained the functionality of a function module, including keywords like concatenate, length, and trim, and demonstrated how to use standard commands instead of function modules at the internal table level. He discussed case statements and the process of creating a CDS view, selecting data from an internal table, and displaying output. Pradeep also introduced the concept of extended views, where additional fields can be appended to existing views, and mentioned that they would learn more about AMDP after reviewing the CDSV document.

HANA Coding and Version Control

Pradeep discussed the completion of HANA codings along with CDSV and AMBP by next week, emphasizing the importance of understanding AMDP for the project. He explained version control in SAP, which involves checking the latest code changes and comparing versions, and mentioned that the code is directly written in HANA using OpenSQL and native HANA skills.

Complete and Continue