Change pointer table

BDCP2

Background job tables

TBTCO and TBTCP

Export and import in shared memory

EXPORT WA_VAR1 TO SHARED MEMORY INDX(mu) ID 'MEMORYNAME'

Same for import

IMPORT WA_VAR1 FROM SHARED MEMORY INDX(mu) ID 'MEMORYNAME'

HANA Views

Attribute View: Select one master table and one text table and join and display

Analytical: create a view by joining two table with numeric fields and with some calculation added.

Calculated view:

HANA analytic Privilege

To provide the access for a view or table to a specific user - Right clock on the package and select Analytical Privilege

Stored Procedures(like function module):   we can define the procedure(with native sql) and we can call in out program by required input and output parameters

to call any procedure we haveto start with _SYS_BIC( all the abap objects will be saved here)   .


We can create the Interface for the stored procedure and we can use that as a in ABAP program and we can directly call the procedure in the program without any Native sql, but here the database should be HANA database.

Go to ABAP stack and go to package
right click on package
Select other ABAP repository object
search with PROXY
click on database procedure proxy
click a name for your proxy and select the proxy required and complete it
It will generate an interface for this which we can use in program


  DATA: lt_cust_early TYPE TABLE OF if_ha400_early_and_late=>et_early,
        lt_cust_late  TYPE TABLE OF if_ha400_early_and_late=>et_late.


  CALL DATABASE PROCEDURE ha400_early_and_late
               EXPORTING
                    iv_number = pv_number
               IMPORTING
                     et_early = lt_cust_early
                     et_late  = lt_cust_late.

  ct_cust_early = lt_cust_early.
  ct_cust_late  = lt_cust_late.  

HANA Certification

the below link shows about HANA certification

https://training.sap.com/de/en/courses-and-curricula/hana

To access HANA data from the excel report

1) we have to instal HANA CLIENT in system
2) Then go to excel -> data - > from other sources -> From data connection wizard -> other/ advanced and then press next -> SAP HANA MDX provider and press next
3) Enter the HOST details and connect to HANA STUDIO