topic select statement in Application Development and Automation Discussions

select statement

Former Member — Mon, 17 Sep 2007 09:22:18 GMT

pls help for a select statement based on these conditions give select statement with inner join concept.

input : MARA(mtart),MARA(matnl),MARC(dispo),EKKO(ekgrp)

output : MARA(matnr).

pls reply soon for any quaries

Re: select statement

Former Member — Mon, 17 Sep 2007 09:26:30 GMT

See sample

SELECT ekko~bukrs

ekko~lifnr

ekko~ebeln

ekko~waers

ekko~bsart

ekko~ekorg

ekko~ekgrp

ekpo~ebelp

ekpo~txz01

ekpo~matnr

ekpo~werks

ekpo~menge

ekpo~meins

ekpo~netpr

ekpo~netwr

INTO TABLE t_itab1 FROM

ekko INNER JOIN ekpo ON ekko_{ebeln = ekpo}ebeln

WHERE ekko~ebeln IN s_ebeln AND

ekko~bukrs IN s_bukrs AND

ekko~lifnr IN s_lifnr AND

ekko~ekorg IN s_ekorg AND

ekko~ekgrp IN s_ekgrp AND

ekpo~matnr IN s_matnr.

SELECT mara~matnr

mara~ernam

mara~mtart

mara~matkl

mara~meins

mara~ernam

marc~werks

marc~xchar

makt~maktx

INTO CORRESPONDING FIELDS OF TABLE t_itab1 FROM

( mara INNER JOIN marc ON mara_{matnr = marc}matnr ) INNER JOIN

makt ON mara_{matnr = makt}matnr

WHERE mara~matnr IN s_matnr AND

marc~werks IN s_werks AND

mara~mtart IN s_mtart AND

mara~meins IN s_meins.

Re: select statement

Former Member — Mon, 17 Sep 2007 10:07:50 GMT

hi pandu,

please go through this select stmt.

select mara~matnr

into table <itab>

from mara

join marc

on mara_{matnr eq marc}matnr

join ekko

on marc_{ekgrp eq ekko}ekgrp

where <condition>

<b>Reward points if useful</b>

Chandra