DATA EXTRACTION

[Former Member]

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

[sjeevan]

Did you consider building a query using SQ01/SQ02?

[svs_sap]

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]

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.

[svs_sap]

Hi

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

[Former Member]

hiiiiiii,

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

[ppqm1]

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

[ppqm1]

pls close this  thread

[Former Member]

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]

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.