Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results forΒ 
Search instead forΒ 
Did you mean:Β 

select data from many tables

former_member810309
Participant

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

1 ACCEPTED SOLUTION

Jeansy
Active Contributor

Hi,

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

CTSPROJ_F4<br>

Kind regards
Jens

9 REPLIES 9

FredericGirod
Active Contributor

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
Active Contributor

Hi,

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

CTSPROJ_F4<br>

Kind regards
Jens

jzaehringer you always have the perfect answer !

Jeansy
Active Contributor
0 Kudos

Thank you, frdric.girod πŸ™‚

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

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

regards

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
Active Contributor

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
Active Contributor
0 Kudos

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

Sandra_Rossi
Active Contributor

See examples in ABAP documentation SELECT - join