topic Re: Regarding select statements in Application Development and Automation Discussions

Regarding select statements

Former Member — Tue, 10 Jul 2007 10:37:58 GMT

Hello experts,

Can we fetch data from two different database tables into one one internal table.

regards,

raman

Re: Regarding select statements

Former Member — Tue, 10 Jul 2007 10:39:44 GMT

Hi Prakash,

Declare the internal table with the fields required from data base tables and get the data into interntal table using SELECT statement with JOINS/FOR ALL ENTRIES.

DATA:

BEGIN OF ITAB OCCURS 0,

MATNR TYPE MARA-MATNR,

WERKS TYPE MARC-WERKS,

END OF ITAB.

SELECT A_{MATNR B}WERKS

FROM MARA AS A

INNER JOIN MARC AS B

INTO TABLE ITAB

ON A_{MATNR = B}MATNR.

Thanks,

Vinay

Re: Regarding select statements

Former Member — Tue, 10 Jul 2007 10:40:20 GMT

Hello,

Check this.


data: begin of itab occurs 0,
         matnr like mara-matnr,
         maktx like makt-maktx,
        end of itab.
select a~matnr b~maktx into table itab from mara as a inner join makt as b on a~matnr = b~matnr where b~spras = sy-langu.

Vasanth

Re: Regarding select statements

Former Member — Tue, 10 Jul 2007 10:49:43 GMT

Hi,

Yes.

You can use SELECT statement with an inner join.

Please check this link for sample code.

http://www.sap-img.com/abap/inner-joins.htm

SELECT a_{field1 a}field2

b_{field3 c}field4 INTO TABLE itab

FROM dbtab1 AS a INNER JOIN

dbtab2 AS b ON b_{codeno = a}codeno

INNER JOIN

dbtab3 AS c ON c_{codeno = b}codeno

WHERE <whereclause>.

Regards,

Priyanka.

Re: Regarding select statements

Former Member — Tue, 10 Jul 2007 11:13:09 GMT

<b>Below is the example of 3 table into one internal table .... using Joins</b>

REPORT  zdemo_alvgrid                 .

TABLES:   mara , mard , makt .

type-pools: slis.                                 "ALV Declarations
*Data Declaration
*----------------
TYPES: BEGIN OF t_Mara,
matnr   like   mara-matnr  ,
meins   like  mara-meins,
werks   like mard-werks  ,
lgort   like mard-lgort ,
labst   like mard-labst ,
maktx  like makt-maktx ,
 END OF t_Mara.

DATA: it_Mara TYPE STANDARD TABLE OF t_Mara INITIAL SIZE 0,
      wa_Mara TYPE t_Mara.

select-options  : p_mat  for  mara-matnr   ,
 p_werks  for   mard-werks ,
 p_lgort  for  mard-lgort.
************************************************************************
*Start-of-selection.
START-OF-SELECTION.

perform data_retrieval.


*&---------------------------------------------------------------------*
*&      Form  DATA_RETRIEVAL
*&---------------------------------------------------------------------*
*       Retrieve data form EKPO table and populate itab it_Mara
*----------------------------------------------------------------------*
form data_retrieval.
select mara~matnr mara~meins  mard~werks mard~lgort  mard~labst  makt~maktx  into  corresponding fields of  table  it_Mara
  from ( ( mara  join  mard  on   mard~matnr  =  mara~matnr   ) join
       makt  on   makt~matnr  =  mard~matnr )  where  mara~matnr in  p_mat
       and  mard~werks  in  p_werks
       and  mard~lgort  in p_lgort  .

loop  at  it_Mara  into  wa_Mara .

write : /  wa_Mara-matnr  ,  wa_Mara-maktx ,  wa_Mara-lgort  ,  wa_Mara-labst ,  wa_Mara-meins .

endloop .


endform.                    " DATA_RETRIEVAL

reward points if it is usefull ....

Girish