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: 

DATA EXTRACTION

Former Member
0 Kudos

HOW CAN WE EXTRACT DATA FROM MULTIPLE TABLES WITH USING SELECT STATEMENT ,WITHOUT USING JOIN IN ABAP?

Moderator message: please no theoretical exam-type questions, search for information, do not post in all upper case.

Message was edited by: Thomas Zloch

9 REPLIES 9

sjeevan
Active Contributor
0 Kudos

Did you consider building a query using SQ01/SQ02?

svs_sap
Active Contributor
0 Kudos

Hi

Use SAP Query method to extract data by joining table if you do not want to go for ABAP development.

Refer below links

http://help.sap.com/saphelp_46c/helpdata/en/d2/cb4145455611d189710000e8322d00/content.htm

Refer file to know the steps with example on how to do it

http://scn.sap.com/docs/DOC-29146

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/6018c1ae-8c44-2d10-6ea9-c3fad2c82...

Regards,

Sharat

Former Member
0 Kudos

SELECT * FROM  < 2nd source table name > INTO CORRESPONDING FIELDS OF <Destination table name>.

* SELECT * FROM < 1st source table name > INTO CORRESPONDING FIELDS OF <Destination table name >  WHERE  < Primary key field name >  =  < Destination Table Name > - <Primary key field name >.

*  APPEND < Destination Table Name >.

*  ENDSELECT.

*ENDSELECT.

0 Kudos

Hi

you have posted the question in wrong forum, please transfer the question to ABAP forum.

0 Kudos

hiiiiiii,

   please tell me how can i transfer this question to ABAP forum.There is no transfer option on this screen.

0 Kudos

Try  sharing  option on ur right hand corner serach option ( ABAP)

0 Kudos

pls close this  thread

Former Member
0 Kudos

Hi Pabitra,

This discussion was moved to ABAP Development space. Selecting the correct space is important to ensure it gets the right visibility and replies from other SCN users.

Regards,

Oxana

gouravkumar64
Active Contributor
0 Kudos

Hi,

Pabitra

try like this

with out JOIN


select vbeln erdat ......... from vbak

into table it_vbak

where .....

if it_vbak is not initial

select vbeln  posnr  from vbap

for all entries in it_vbak

where vbeln = it_vbak-vbeln......

endif.

Thanks

Gourav.