How to consume Attribute Views in ABAP on HANA

0
4459

[adsenseyu2]

Hello everyone, in this ABAP on HANA tutorial, we will learn how to consume Attribute Views in ABAP on HANA. Lets get started.

Prerequisites

  1. You should have installed SAP HANA Studio in your local machine.
  2. You should have connected to HANA system with your HANA DB Credentials.
  3. You should have Attribute View created in HANA Repository.Please read our previous tutorial on how to create Attribute View.
  4. You should have created ABAP project in Eclipse IDE.

Step-By-Step Procedure

1. Right Click on your package and choose New → Other ABAP Repository Object.

New ABAP Repository Object
New ABAP Repository Object

2. In the New ABAP Repository Object window, search by “dictionary” and choose Dictionary View under Dictionary folder and hit OK.

New Dictionary View
New Dictionary View

3. In the New Dictionary View window, enter Name, Description and choose External View radio button and enter our attribute view name we created in our previous tutorial.
Tip : To search for attribute view name you can use Browse button or press Cntrl+space (Content Assist Available).

Dictionary View Details
Dictionary View Details

4. In Selection of Transport Request window, choose the transport request in which you want to save the program and hit Finish button.Here we are saving the program in $TMP package so transport request not required.

Selection of Transport Request5. External View will be created successfully.Click on activate button Activate to activate the external view created.

Activate External View
Activate External View

6. Congrats, you have successfully created a Dictionary View(External View) for a HANA Attribute View. Now we need to call this dictionary view ZEV_EMP_INFO in our ABAP program using Open SQL statement.

[adsenseyu1]

7. Before calling the view in an abap program, we do a quick and easy test to access the data.Go to SE16N(Data Browser) enter ZEV_EMP_INFO and Execute.

External View in SE16N

8. Create a sample ABAP Program ZDEMO_HANA_VIEW in your package. To know how to create an ABAP program click here. Copy and paste the below code into the abap program.

REPORT zdemo_hana_view.

*-- Internal declaration for Dictionary View
DATA: lt_emp_info TYPE TABLE OF zev_emp_info,
      lo_salv     TYPE REF TO cl_salv_table.


*-- Open SQL statement to access Dictionary View
SELECT * FROM zev_emp_info
         INTO TABLE lt_emp_info.

*.. ALV Display
  cl_salv_table=>factory(
      IMPORTING
        r_salv_table   = lo_salv
      CHANGING
        t_table        = lt_emp_info ).

      lo_salv->display( ).

9. Save and activate the program and execute the report.

Output

Output

Congrats, you have successfully know how to consume Attribute Views in ABAP on HANA.

Please stay tuned to us for more ABAP on HANA Eclipse tutorials.Please feel free to comment and let us know your feedback. You feedback will keep us alive.

Thank you. 🙂

like-128