topic Re: explain select statemtent in Application Development and Automation Discussions

explain select statemtent

Former Member — Mon, 24 Nov 2008 10:11:18 GMT

Hi,

Please explain me below select statement.

SELECT s~aufnr

s~bismt

s~gmein

s~plnbez

FROM ZMat AS s

INTO TABLE it_afko

FOR ALL ENTRIES IN it_mara

WHERE plnbez EQ it_mara-matnr

AND exists ( SELECT a~aufnr FROM aufk AS a JOIN jest AS b ON

a_{objnr = b}objnr

WHERE a_{aufnr EQ s}aufnr

AND a~werks EQ p_werks)

Regards,

Suresh

Former Member — Mon, 24 Nov 2008 10:14:16 GMT

hi,

SELECT s~aufnr

s~bismt

s~gmein

s~plnbez

FROM ZMat AS s

INTO TABLE it_afko

FOR ALL ENTRIES IN it_mara

WHERE plnbez EQ it_mara-matnr

AND exists ( SELECT a~aufnr FROM aufk AS a JOIN jest AS b ON

a_{objnr = b}objnr

WHERE a_{aufnr EQ s}aufnr

AND a~werks EQ p_werks)

Getting the entries from Zmat only if the entry corresponding to the aufnr exist in the aufk and jest tables.

Former Member — Mon, 24 Nov 2008 10:24:37 GMT

Hi,

The above query specifies that it will select data from the table ZMat

if the data for the below query i.e getting data from AUFK and Jest will exist on the given condition

SELECT a~aufnr FROM aufk AS a JOIN jest AS b ON

a_{objnr = b}objnr

WHERE a_{aufnr EQ s}aufnr

AND a~werks EQ p_werks.

Hope it helps u.

Thanks & Regards