topic Re: select data from many tables in Application Development and Automation Discussions

select data from many tables

former_member810309 — Fri, 01 Jul 2022 08:26:59 GMT

Hi everyone 🙂

I have a selection screen :

TABLES: e070, e071, e07t, e070create, ctsproject, e070a.<br><br>SELECTION-SCREEN BEGIN OF BLOCK block1 WITH FRAME.<br>  PARAMETERS: p_ot TYPE e070-trkorr,<br>              p_nni TYPE e070-as4user,<br>              p_idpro TYPE ctsproject-externalid.<br>SELECTION-SCREEN END OF BLOCK block1.<br>

plz how i can relate tables to get the right result from the selection-screen with Select .. from ... or instruction " INNER JOIN ".
thanks

Re: select data from many tables

FredericGirod — Fri, 01 Jul 2022 08:29:55 GMT

You will have to find the logical link between table e070 and ctsproject

if you failed to find it by your own, you could make a trace on SE01 or SE10 transaction

Re: select data from many tables

Jeansy — Fri, 01 Jul 2022 08:34:26 GMT

Hi,

you can use the following view that joins both related tables:

CTSPROJ_F4<br>

Kind regards
Jens

Re: select data from many tables

FredericGirod — Fri, 01 Jul 2022 08:39:45 GMT

jzaehringer you always have the perfect answer !

Re: select data from many tables

Jeansy — Fri, 01 Jul 2022 08:41:55 GMT

Thank you, frdric.girod 🙂

Re: select data from many tables

former_member810309 — Fri, 01 Jul 2022 08:44:20 GMT

thank u for your answer, i have to use correctly SELECT ... FROM ...

i don't know if / how i can use INNER ^^

regards

Re: select data from many tables

FredericGirod — Fri, 01 Jul 2022 08:48:59 GMT

You don't need inner join as Jens provide you a View.

Open the view using transaction SE11, and you will see the link between different tables

Re: select data from many tables

RaymondGiuseppi — Fri, 01 Jul 2022 09:29:02 GMT

Analyze those tables with SE11 or trace ST05 sql / SAT abap some standard transactions

For example look at E071.

Display the tab 'Input Help/Check' you should notice a foreign key check with table E070 on field TRKORR

Re: select data from many tables

Sandra_Rossi — Fri, 01 Jul 2022 09:46:47 GMT

For information, you don't need the statement TABLES (it's needed only for transporting implicitly DDIC-bound dynpro fields).

Re: select data from many tables

Sandra_Rossi — Fri, 01 Jul 2022 09:48:39 GMT

See examples in ABAP documentation SELECT - join