Friday 30 March 2018


After the advancement of SAP HANA, the innovation inside the SAP is changing quickly and there has been a change in perspective in the way business applications are created at SAP. The general guideline is basic: "Do as much as you can in the database to get the best execution".

Through HANA, SAP has delivered a high performing multi-faceted tool with rich scientific computational abilities, in-memory equipment, upgraded pressure innovation, geospatial capabilities, Text analytics and predictive analytics, to name a few. With so intense a back-end, the application layer too needed to ever be modified to completely use the enhanced capacities of HANA. CDS Views, AMDPs, and improvements to existing Open SQL are the different accessible solution which help in accomplishing Code Push Down – exchange the information escalated rationale to the database bringing about better execution. AS 7.4 or above is the required rendition of utilization layer on a HANA database for the highlights said all through the report to work.

SAP ABAP on HANA: Introduction

ABAP (development) for SAP HANA refers to all advancements which use the energy of SAP HANA inside ABAP-based applications. In this unique circumstance, the SAP HANA stage is the essential database hidden the ABAP stage. This framework deployment option is supported with AS ABAP 7.4 onwards. The introduction of the SAP HANA stage in the ABAP universe has gotten a move the application programming worldview.

ABAP-managed code push down

Different code pushdown programming methods, with various levels of use of the propelled local SAP HANA capacities, are accessible in the ABAP stage.
SAP suggests the accompanying:
1. Enhanced Search Help (F4 help)
2. SAP List Viewer with Integrated Data
3. Access (ALV with IDA)
4. Open SQL
5. ABAP Core Data Services (CDS)
6. ABAP Managed Database Procedures (AMDP)
7. ABAP CDS table functions

SAP ABAP on HANA

SAP ABAP on HANA


Introduction to CDS Views

CDS is one of the advanced highlights presented by SAP in ABAP released 7.4 SP5. Through CDS, one can characterize define in the ABAP repository from ABAP Development Tools (ADT) utilizing SQL DDL syntax. With a propelled highlight set and domain specific annotation made accessible, CDS offers a basic answer for to acknowledge code push down from ABAP Layer.

SAP ABAP on HANA Online Training

SAP ABAP CDS View

Introduction to AMDP

ABAP managed database strategy is a straightforward ABAP class technique containing database-particular system coding. The code inside the strategy is pushed to the database layer and executed inside the database. In this way critical execution changes of information concentrated procedures can be accomplished by code push-down from the application server to the database server. This diminishes the quantity of information exchanges and the measure of exchanged information between the two servers.

CDS Views in detail

To completely use the high performing abilities of SAP HANA for application advancement, SAP has introduced a new mechanism to carry out data modelling known as core data services(CDS). With CDS, data models are characterized from the application server yet are executed on the database bringing about an ideal code push down. CDS additionally offers abilities past the conventional information displaying devices, including support for conceptual modeling and relationship definitions, built-in functions, and extensions. Initially, CDS was accessible just in the plan time and runtime condition of SAP HANA.

What is CDS?

CDS is a SAP system for characterizing semantically rich rich models, called CDS views. It is characterized utilizing SQL-based information definition language (DDL) which depends on standard SQL with advanced features like associations & annotations. CDS goes past the traditional querying abilities by accomplishing complex computations and manipulation easily.

CDS views are very like the ABAP abap repository views characterized utilizing ABAP layer. Be that as it may, CDS enables characterizing fundamental perspectives to accomplish analytics and aggregation and later extend them to make considerably more perplexing artifacts making it more plausible with the complex business condition. While making a CDS view from ABAP layer, a comparing DB view is made in HANA with the name gave in the CDS editorial editor. This DB view can be gotten to simply like some other data show in HANA database. Additionally, CDS offers consolidating result set of at least two inquiries into a solitary outcome set utilizing UNION operator, capacity to switch on programmed customer dealing with utilizing the comment @ClientDependent: true. Additionally, it empowers taking care of buffering of CDS elements easily.

Advantages of CDS Views:

1. Reusability of database artifacts.
2. Huge Feature Set – Example: Associations.
3. Domain Specific Consumption of Data models – Example: Annotations.
4. Customer taking care of can be accomplished in CDS.

Limitations of CDS Views:

1. Just 1 result set can be come back from a CDS View.
2. Just 1 independent process can be completed at 1 time.

About SAPVITS

Vintage IT Solutions serves best SAP Online Training Courses. We also provide SAP server access, SAP corporate training, and SAP offshore support. SAPVITS brings to you its knowledge and expertise of over 18+ years’ in SAP online training and SAP consultancy. We mainly concentrate on SAP Online Training in Chennai, SAP Online Training in Noida, SAP Online Training in Pune, SAP Online Training in UK.

The SAP ABAP on HANA Course is suitable for Fresher’s and professionals wanting to get highly paid jobs. SAP ABAP on HANA Online Training is available in several approaches. Contact us for more details regarding SAP Online Training in Mumbai.

For more details, contact us:
India +91 992 284 8898
USA +1 678 389 8898
UK +44 141 416 8898