Skip to Content
0
Former Member
May 07, 2008 at 12:15 PM

How can i write the below code using "For all entries"

32 Views

Hi

How can we write the below code using "for all entries" and need to avoid joins...

Please help

SELECT aaufnr aobjnr aauart atxjcd a~pspel

agstrp awerks carbpl cwerks

INTO TABLE t_caufv

FROM caufv AS a

INNER JOIN afih AS b

ON aaufnr = baufnr

INNER JOIN crhd AS c

ON bgewrk = cobjid

AND c~objty = 'D'

WHERE ( a~pspel = space

OR a~txjcd = space

OR NOT a~objnr IN

( select OBJNR from COBRB AS e

WHERE objnr = a~objnr ) )

AND a~werks IN s_plant

AND a~auart IN s_wtype

AND NOT a~objnr IN

( select OBJNR from JEST AS d

WHERE objnr = a~objnr

AND ( dstat = 'A0081'OR dstat = 'A0018' )

AND d~inact 'X' ).

Reward points for all helpfull answers

Thanks

Ammi.