Posts

Showing posts with the label sap hana cds

HANA CDS Views In Simple Words- SAP ABAP ON HANA.

Image
SAP HANA supports SQL as a means to define, read, and manipulate data. On top of SQL, many technologies introduce higher-level models to add semantics and ease consumption, such as OData EDM models, the semantic layer in the BI platform, JPA and enterprise objects in Java, and the business objects frameworks in ABAP. These higher-level models share many commonalities, but are usually specific to their technology. This prevents their re-use across stacks and increases effort for application developers. To address this, SAP introduces a set of domain-specific languages and services, called CDS, for defining and consuming semantically rich data models. The Core data Services (CDS) views are collection of below three domain specific languages and services for consuming semantically rich data models. Data Definition Language (DDL):  The DDL part of CDS can be considered an enhancement of SQL that allows you to define semantically rich database tables and views, often referred to...

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 ...