09-26-2012 9:49 PM
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
09-26-2012 11:03 PM
09-27-2012 5:42 AM
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
Regards,
Sharat
09-27-2012 12:54 PM
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.
09-27-2012 1:04 PM
Hi
you have posted the question in wrong forum, please transfer the question to ABAP forum.
09-27-2012 8:35 PM
hiiiiiii,
please tell me how can i transfer this question to ABAP forum.There is no transfer option on this screen.
10-02-2012 10:24 PM
10-02-2012 10:25 PM
10-03-2012 1:07 PM
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
10-03-2012 1:14 PM
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.