topic Re: where in Application Development and Automation Discussions

where

Former Member — Thu, 07 May 2009 14:34:33 GMT

Hallo

I want to select with condition 'ZTKE' 'ZTOE' can somebody tell where is my mistake

SELECT a_{vbeln b}posnr

INTO CORRESPONDING FIELDS OF TABLE lt_pspabrech

FROM vbak AS a

INNER JOIN vbap AS b

ON a_{vbeln = b}vbeln

WHERE b~pstyv IN ( 'ZTKE','ZTOE' )

AND a~auart = 'YBTA'.

regards

Re: where

Azeemquadri — Thu, 07 May 2009 14:37:32 GMT

SELECT a_{vbeln b}posnr

INTO CORRESPONDING FIELDS OF TABLE lt_pspabrech

FROM vbak AS a

INNER JOIN vbap AS b

ON a_{vbeln = b}vbeln

WHERE b~pstyv IN ('ZTKE' , 'ZTOE')

AND a~auart = 'YBTA'.

Try the above.

I just added space between the two item cats and removed space between single quote and bracket.

Re: where

Former Member — Thu, 07 May 2009 14:40:33 GMT

Very useful answer Thank you