SAP HANA Use of selection of all columns with renaming of fields. This is handy in case you have to do all field select

SELECT jcds~*,

tj02t~*

FROM jcds INNER JOIN tj02t

ON jcds~stat = tj02t~istat

WHERE tj02t~spras = @sy-langu

INTO TABLE @DATA(lt_status)

UP TO 1000 ROWS.

IF sy-subrc = 0.

cl_demo_output=>display_data(

EXPORTING

value = lt_status

name = 'New AGE SQL : 9' ).

ENDIF.

 

 

 

Serkan AKKAVAK
Computer Engineer
ABAP Developer & SAP S/4 HANA Logistics Consultant
Contact : serkurumsal@yandex.com