where

[Former Member]

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

[Former Member]

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

[Azeemquadri]

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.

[Former Member]

Very useful answer Thank you