topic Re: DELETE statement behaving strange in Application Development and Automation Discussions

DELETE statement behaving strange

Former Member — Wed, 25 Oct 2006 12:55:57 GMT

I have a doubt.

I am using a DELETE itab from itab statement in between my LOOP-ENDLOOP .

Now, if I declare my itab with the syntax :-

Data: BEGIN of itab occurs 0,

...

END of itab.

Then the above DELETE statement works fine but

when I declare my itab as:

DATA: itab type / like standard table of say MARA with header line.

then the program gives me a dump at the DELETE statement.

Can anyone please tell me the difference and the reason for it.

Thank you

Re: DELETE statement behaving strange

Former Member — Wed, 25 Oct 2006 12:58:23 GMT

use

DELETE <b>TABLE</b> itab WITH TABLE KEY k1 = v1 ... kn = vn.

DELETE TABLE itab [FROM wa].

Re: DELETE statement behaving strange

Former Member — Wed, 25 Oct 2006 13:00:45 GMT

hi soni ,

since the itab structure and the mara structure is diff .

so this problem ..

regards,

vijay

Re: DELETE statement behaving strange

Former Member — Wed, 25 Oct 2006 13:02:30 GMT

Hi Chandrasekhar.

Thanks for your response.

I got the point but when we declare an internal table with the statement

DATA: Begin of itab

...

End of itab...

It means that the internal table is a standard internal table only...Isnt it?and if I am not wrong then the system will automatically consider data objects of type C , as its key fields .

Thanks

Re: DELETE statement behaving strange

Former Member — Wed, 25 Oct 2006 13:02:49 GMT

Hi Chandrasekhar.

Thanks for your response.

I got the point but when we declare an internal table with the statement

DATA: Begin of itab occurs 0,

...

End of itab...

It means that the internal table is a standard internal table only...Isnt it?and if I am not wrong then the system will automatically consider data objects of type C , as its key fields .

Thanks

Re: DELETE statement behaving strange

Former Member — Wed, 25 Oct 2006 13:05:30 GMT

Hi Vijay..

Assume that both the structures are same.

Thanks

Re: DELETE statement behaving strange

Former Member — Wed, 25 Oct 2006 13:50:37 GMT

We can't really help without knowing some of the details of the dump. Could you post them please?

Rpb