topic How do i write select in Application Development and Automation Discussions

How do i write select

Former Member — Mon, 28 Apr 2008 16:21:43 GMT

Hi all,

I am declaring the internal table like below

data : begin of it_mska occurs 0.

include structure mska.

data : prctr like marc-prctr.

data : end of it_mska.

I want join the MSKA and MARC. But I want all the fields from MSKA and prctr from MARC.

help me in this .

regards,

Ajay

Re: How do i write select

Former Member — Mon, 28 Apr 2008 16:27:20 GMT

You'll want to add some WHERE clauses, but this should get you in the ball game


TABLES: mara, marc.

DATA : BEGIN OF it_mska OCCURS 0.
        INCLUDE STRUCTURE mska.
DATA : prctr LIKE marc-prctr.
DATA : END OF it_mska.


SELECT * INTO CORRESPONDING FIELDS OF TABLE it_mska
  FROM mara AS a
  JOIN marc AS b ON a~matnr = b~matnr.

Re: How do i write select

Former Member — Mon, 28 Apr 2008 16:31:30 GMT

Hi,

do this way ....


data : begin of it_mska occurs 0.
include structure mska.
data : end of it_mska.

data : begin of it_marc occurs 0,
     matnr like marc-matnr,
     werks like marc-werks,
     prctr like marc-prctr,
   end of it_marc.

data : begin of it_final occurs 0.
include structure mska.
data : prctr like marc-prctr.
data : end of it_final.

select * from mska into table it_mska where <conditions>.
if sy-subrc = 0.
endif.

if not it_mska[] is initial.
  select matnr werks prctr from marc into it_marc 
     for all entries of it_mska
     where matnr = it_mska-matnr and
              werks = it_mska-werks.
  if sy-subrc = 0.
    sort it_marc by matnr werks.
  endif.
endif.
 
loop at it_mska.
  read table it_marc with key matnr = it_mska-matnr 
                                          werks = it_mska-werks.
  if sy-subrc = 0.
    move-corresponding it_marc to it_final.
    move-corresponding it_mska to it_final.
    append it_final.
    clear it_final.
 endif.
endloop.

Re: How do i write select

Former Member — Mon, 28 Apr 2008 16:38:25 GMT

Hi Ajay,

TABLES: mara, marc.

DATA : BEGIN OF it_mska OCCURS 0.

INCLUDE STRUCTURE mska.

DATA : prctr LIKE marc-prctr.

DATA : END OF it_mska.

Select *

into corresponding fields of table it_mska

from MSKA as S

LEFT OUTER JOIN MARC AS p ON s_{matnr = p}matnr

AND s_{werks = p}werks..

<REMOVED BY MODERATOR>

Thanks & Regards,

Khan.

Edited by: Alvaro Tejada Galindo on Apr 28, 2008 12:48 PM