select data from many tables

[former_member810309]

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

[FredericGirod]

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

[Jeansy]

Hi,

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

CTSPROJ_F4<br>

Kind regards
Jens

[FredericGirod]

jzaehringer you always have the perfect answer !

[Jeansy]

Thank you, frdric.girod 🙂

[former_member810309]

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

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

regards

[FredericGirod]

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

[raymond_giuseppi]

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

[Sandra_Rossi]

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

[Sandra_Rossi]

See examples in ABAP documentation SELECT - join