SELECT bug in abap

[szabina123]

Hey Abappers:)
I have an urgent question , i am a beginner. i need some datas from 2 different tables (actually more, but i start with 2 tables) so..here it is... and the bug is: Select isnt available... 😞 Why not? I tried with inner join too before....same bug
TYPES: BEGIN OF ty_union,

infocube TYPE rsdcube-infocube,
objvers TYPE rsdcube-objvers,
txtsh TYPE rsdcubet-txtsh,
END OF ty_union.

DATA: it_cubes_union TYPE TABLE OF ty_union.

SELECT rsdcube~infocube AS infocube,
rsdcube~objvers AS objvers,
rsdcubet~txtsh AS txtsh
INTO TABLE @it_cubes_union
FROM RSDCUBE

UNION

SELECT rsdcubet~infocube AS infocube,
rsdcubet~objvers AS objvers,
rsdcubet~txtsh AS txtsh
FROM RSDCUBET.

[szabina123]

This is the right code
TYPES: BEGIN OF ty_final,

infocube TYPE rsdcube-infocube,
objvers TYPE rsdcube-objvers,
txtsh TYPE rsdcubet-txtsh,
END OF ty_final.

DATA: wa_final TYPE ty_final,
it_final TYPE TABLE OF ty_final.


SELECT rsdcube~infocube
rsdcube~objvers
rsdcubet~txtsh

INTO TABLE it_final
FROM RSDCUBE INNER JOIN RSDCUBET
ON rsdcube~infocube = rsdcubet~infocube.
*SORT
LOOP AT it_final INTO wa_final.

ENDLOOP.