Posts

CDS: CDS Performance Analysis

Image
  CDS Performance Analysis: CDS Views operate on the  code pushdown framework  where the data intensive calculations/aggregations are done in the DB layer (as opposed to the traditional application layer), which provides a  boost  to performance. Everyones expectation is that with the code pushdown the magic should happen every time. The performance should always be better if not optimized. But friends in real project scenarios, everything is not a happy path.  There have been instances where the query does not provide the expected performance uplift.  In this multi-part series, we will first look at analyzing the performance of the underlying query and then articulate different ways to  tune  it. The internet is flooded with Core Data Services, but you will hardly find any good tutorials or series on Optimization and Performance Tuning of ABAP Core Data Services. Hopefully, this series will help our SAP Fraternity.  Basics First. ABAP C...
Post a Comment
Read more

SAP ODATA : Query Options & HTTP Status Code

Image
Query Options & HTTP Status Code: CRUD  is the jargon used in OData for the below  Operations. Since we are at Part XI of SAP Netweaver Gateway and OData Services Tutorial , we all know it and we do not want to elaborate more. HTTP Method Description GET The GET method is used for FETCHing information from the server using a URI. Requests using GET only retrieves data and would have no other effect on the data. POST A POST request is used for CREATing data in the server (SAP Backend). PUT A PUT request is used for UPDATing data in the server (SAP Backend). DELETE A DELETE request is used for REMOVing data from the server (SAP Backend). OData Query Options Query Options  means what are the  additional parameters/syntaxes can we add to the OData Service URI to perform extra work . These options are the links we prepare and send from front end (SAPUI) client system. Filter, Orderby, Expand or our simple Format are some of the commonly used Query Options. T...
Post a Comment
Read more

AMDP: AMDP – ABAP Managed Database Procedure

Image
  AMDP – ABAP Managed Database Procedure: AMDP – ABAP Managed Database Procedure ABAP Managed Database Procedures or AMDP. Another jargon. Does it sound bombastic? I was scared when I heard it for the first time.   . But when you ponder a little deeper, the concept is in the name itself.  AMDP is Database Procedure which is Managed by ABAP.  It is not a database thing. It is governed and managed by ABAP. So, ABAPers are bound to love and use it to the fullest.    Like CDS Views, only ABAP transports (ABAP Class/Method) of AMDP needs to be transported and we need not worry about the corresponding underlying HANA artifacts.  Both CDS and AMDP fall in Top-Down Approach of HANA, which are recommended by SAP. We need to be in ABAP system which is on release 7.4 SP05 and higher and HANA is the primary database. By now you have guessed correctly, AMDP works only with HANA as the primary database.  But AMDP is conceptually designed to work in any dat...
Post a Comment
Read more

CDS: Expose CDS Views as OData Service through Annotation

Image
  Expose CDS Views as OData Service through Annotation: If you are following our series on  SAP ABAP on HANA  then you would be familiar with  CDS Views . If not, then please check our  HANA ABAP Part IV  where we introduced  Core Data Services  and Part V where we took a  Deep Dive into CDS Views . Also, if you have been taking the advantage of our  SAP Netweaver Gateway and OData Services Tutorial  series, you would know that  SEGW  is the t-code to create OData Projects and eventually publish an OData Service. But would you not be surprised if we say, you can create your OData Projects without going to SEGW transaction?  Today, we would show you how you can  expose CDS View as OData Services with just some Annotations  (i.e SQL code). Introduction We have substantially explored the CDS views with major functionalities.  CDS provides another magical strength to the users to expose the views as OData s...
Post a Comment
Read more