topic Re: deleting rows from internal table using where condition in Application Development and Automation Discussions

deleting rows from internal table using where condition

Former Member — Tue, 28 May 2013 06:55:53 GMT

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 — Tue, 28 May 2013 07:28:12 GMT

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 — Tue, 28 May 2013 07:39:59 GMT

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 — Tue, 28 May 2013 07:56:58 GMT

Hi Mohan,

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

Regards,

DN.