banner ads

How To Create ABAP CDS View with Inner Join on HANA | CDS view Using Inner Join in sap abap | ABAP cds view with Inner Join.

Core Data Services with Inner Join.

Hello Friends in this article we are going to learn about how to create simple ABAP CDS View with inner join on HANA. Here I have shown you step by step Procedure for ABAP CDS View Creation With Inner join.

CDS view with Inner Join in sap abap.

A CDS view is defined for existing database tables and views, or for other CDS views in ABAP Dictionary, using the ABAP CDS statement DEFINE VIEW. A CDS view serves to define the structure of an SQL view and represents a projection onto one or several Dictionary tables or Dictionary views. Inner join or join will Selects all entries which exists in both tables which meet ON condition.

  Click here to watch full Practicle Video session on CDS View with Join.

Steps to create CDS view with Inner Join in hana.

      1)   Right Click on your favorite packages and select new and click on Other ABAP repository Object.

2) In the New ABAP Repository object window search for DDL source object select  the DDL Source and Click Next

1    3)   In the New DDL Source window  enter Name and Description of the CDS View and Click on enter.

 4) Select transport request as per your requirement. Here we are storing cds view in local package so we are not selecting any transport here then Click on next.

5) In templates window select define view with join and click on finished.

1    6) Cds View editor open with predefined code which you need to edit as per data source name and sql view name.

1        7) Change the Sql View name as ‘ZV_IN_JOIN’ and data source name as Shown in the below screenshot.

8) Add some fields from /sapapo/t445likt table in order to create CDS View.

9) Then Click on check and Activate program to create CDS View.

10) After activation of CDS View click on RUN and select ABAP application and click on Ok and you can see outout of created CDS View.

11) Final output of the CDS with Inner join.

Congrats ! Now you know how to create CDS View With Inner join..

Please practice more on this topic and see how does CDS view work with inner join using different table available in SAP..

Thank you for reading. 😊

No comments