topic Re: DATA EXTRACTION in Application Development and Automation Discussions

DATA EXTRACTION

Former Member — Wed, 26 Sep 2012 20:49:29 GMT

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

Re: DATA EXTRACTION

sjeevan — Wed, 26 Sep 2012 22:03:45 GMT

Did you consider building a query using SQ01/SQ02?

Re: DATA EXTRACTION

svs_sap — Thu, 27 Sep 2012 04:42:48 GMT

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-c3fad2c82880?QuickLink=index&overridelayout=true

Regards,

Sharat

Re: DATA EXTRACTION

Former Member — Thu, 27 Sep 2012 11:54:54 GMT

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.

Re: DATA EXTRACTION

svs_sap — Thu, 27 Sep 2012 12:04:52 GMT

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

Re: DATA EXTRACTION

Former Member — Thu, 27 Sep 2012 19:35:36 GMT

hiiiiiii,

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

Re: DATA EXTRACTION

ppqm1 — Tue, 02 Oct 2012 21:24:44 GMT

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

Re: DATA EXTRACTION

ppqm1 — Tue, 02 Oct 2012 21:25:12 GMT

pls close this thread

Re: DATA EXTRACTION

Former Member — Wed, 03 Oct 2012 12:07:57 GMT

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

Re: DATA EXTRACTION

gouravkumar64 — Wed, 03 Oct 2012 12:14:39 GMT

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.