Posts

Showing posts with the label cds views

CDS Views Of SAP HANA For Beginners With Example.

Image
Creating HANA views (Attribute, Analytic and Calculation) involve creating HANA artifacts in the HANA database layer (from SAP HANA Modeler Perspective). These views are then consumed in our ABAP reports either through ADBC, or external views. Hence it is a BOTTOM-UP approach. Such Bottom-Up approach is not recommended because of the difficulty in creating and transporting the HANA artifacts (through Delivery Unites). In case any underlying HANA artifact is not included in the transport (via Delivery Unit and Transport Container), then there will not be any errors at the time of releasing the Transport. For this reason, SAP recommended TOP-DOWN approach. The TOP-DOWN approach is equivalent to creation of HANA views, is CDS (Core Data Services) Views. These are created from ABAP perspective, can be saved directly in a TR and consumed in ABAP reports through open SQL. Creating CDS Views: In the following example, we will create a CDS view that takes as input the Client, a Target ...

SAP ABAP - How To Select Data From CDS View In ECC - HANA

Image
IN HANA Migration Project i.e. when Clients or customers are migrating from ECC to HANA, we often face a problem on a few tables that are not directly accessible anymore. Here we show a simple solution to select data from CDS view in ECC system. One can only see the CDS view in display mode in ECC system. CDS view can be edited only via Eclipse tool. Before HANA DDIC Table (Tcode : SE11)  Program (SE38):  The below program  as shown below is selecting data from DDIC table GLTO Ater HANA In SAP HANA, the same DDIC table GTL0 has been transformed to SQL view, where it is selecting data from V_GLTO_INT2 view, this view has been generated while activating V_GLT0 CDS view in ADT Eclipse (you can find the code of this CDS view at last). Double click on the DDL Source GLT0_DDL , it will take you to the source code of the CDS View One cannot edit the CDS view in ECC, this can only be edited using ADT in Eclipse, as it has been created in ADT. Now ...