Do we need to install sap hana studio to create a simple abap report in hana database when hana is connected as a secondry database or can we write it in ECC which is primary(local databse) and execute in hana database?
this is the simple program :
REPORT YHANA_P3.
TABLES : mara.
DATA : LT_T1 TYPE STANDARD TABLE OF mara,
LWA_T1 LIKE LINE OF LT_T1 .
SELECT * FROM mara CONNECTION ('SAP_HANA_CONNECTION') INTO TABLE LT_T1 .
if sy-subrc = 0.
message 'DATA FETCH FROM marA SUCCESSFUL' TYPE 'I'.
endif.
LOOP AT LT_T1 INTO LWA_T1.
WRITE😕 LWA_T1-matnr.
ENDLOterminates the program saying the referred table dosn't exist.
