HELP IN DELETE

[Former Member]

HI,

i have table lt_vbak and i wont to delete all the recored whare <b>VBTYP = 'L'</b>

and AUART <b>NE</b> 'ZDR' AND 'ZDR9'

i try like that but its not working

regards

DELETE lt_vbak WHERE ( VBTYP = 'L' AND AUART NE ('ZDR' AND 'ZDR9' ) ).

[Former Member · Accepted solution]

Hi,

DELETE lt_vbak WHERE  VBTYP = 'L' AND 
                                      AUART NOT BETWEEN 'ZDR' AND 'ZDR9'.

Regards

Sudheer

[hermanoclaro]

Hi TAL,

Try the code you post this way:

DELETE lt_vbak WHERE VBTYP = 'L' AND ( AUART NE 'ZDR' AND AUART NE 'ZDR9' ). 

Maybe this will work.

Best Regards.

-h

[Former Member]

DELETE lt_vbak WHERE VBTYP = 'L'

AND AUART NE 'ZDR'

AND AUART NE 'ZDR9'

[Former Member]

hi,

try it like

DELETE lt_vbak WHERE VBTYP = 'L' AND AUART NE ('ZDR' AND 'ZDR9' ).

gavas.

[Former Member]

hi gavas

i try like u tell but i have the same erorr like before

Field "('ZDR' AND 'ZDR9' )" is unknown. It is neither in one of the

specified tables nor defined by a "DATA" statement. "DATA" statement.

'ZDR' AND 'ZDR9' are recored in lt_vbak

regards

[Former Member]

DELETE lt_vbak WHERE ( VBTYP = 'L' AND ( AUART NE 'ZDR' AND

AUART NE 'ZDR9' ) ).

Above command should work.

Please make a change in your code and check.

Thanks

ashish