deleting rows from internal table using where condition

[Former Member]

Hi,

I'm trying to delete records from an internal table based on a condition.

But i'm getting "field specification missing " error.

DELETE it_excel WHERE ( ( valid_from between wa_tab-valid_from and wa_tab-valid_to )

                                         OR ( valid_to  BETWEEN wa_tab-valid_from AND wa_tab_valid_to ) ) .

Pls help with the possible solution..

[Former Member]

Hi Mohanraj,

There is an incorrect statement in this query.

DELETE it_excel WHERE ( ( valid_from between wa_tab-valid_from and wa_tab-valid_to )

                                         OR ( valid_to  BETWEEN wa_tab-valid_from AND wa_tab_valid_to ) ) .

Check for the underlined word in the above statement. It should be wa_tab-valid_to. You have used underscore instead of ( - ).

[Former Member]

Hi,

Field Specification missing error comes when we try to access a field which has not been defined.

As Satish suggested, write wa_tab-valid_to instead of wa_tab_valid_to

[Former Member]

Hi Mohan,

In your second where condition wa_itab(-)valid_to the hyphen is mistyped as underscore.

Regards,

DN.