SELECT bug in abap

szabina123 — Fri, 20 Oct 2023 07:00:45 GMT

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.

Re: SELECT bug in abap

szabina123 — Fri, 20 Oct 2023 07:05:09 GMT

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.

Question Re: SELECT bug in abap in Additional Q&A

SELECT bug in abap

Re: SELECT bug in abap