Skip to Content
avatar image
Former Member

HELP IN DELETE

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' ) ).

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 08, 2007 at 02:59 PM

    Hi,

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

    Regards

    Sudheer

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 08, 2007 at 02:56 PM

    DELETE lt_vbak WHERE VBTYP = 'L'

    AND AUART NE 'ZDR'

    AND AUART NE 'ZDR9'

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 08, 2007 at 02:54 PM

    hi,

    try it like

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

    gavas.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Oct 08, 2007 at 03:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded