topic Re: Delete statement for string type internal table in Application Development and Automation Discussions

Delete statement for string type internal table

Former Member — Tue, 26 Jun 2018 08:57:31 GMT

Hi Guys,

I have string type internal table. Now i want to delete the initial values in internal table.

Is it possible to delete using DELETE statement?

Code:

Data gt_tab TYPE STANDARD TABLE OF string.

Delete gt_tab where _____ is initial????

Note: I knew we can delete it through loop statement.

Thanks,

Chella

Re: Delete statement for string type internal table

RaymondGiuseppi — Tue, 26 Jun 2018 09:35:33 GMT

Did you try to use pseudo component TABLE_LINE?

Re: Delete statement for string type internal table

matt — Tue, 26 Jun 2018 09:35:43 GMT

You'll be better off, performance wise, using a SORTED TABLE.

Data gt_tab TYPE SORTED TABLE OF string WITH NON-UNIQUE KEY table_line.
Delete gt_tab where table_line is initial.

Re: Delete statement for string type internal table

matt — Tue, 26 Jun 2018 09:37:04 GMT

If people would get away from using STANDARD tables all the time and start using HASHED and SORTED by default, they'd eventually stumble on TABLE_LINE when they're defining the key.

Re: Delete statement for string type internal table

retired_member — Tue, 26 Jun 2018 09:44:42 GMT

If people read the documentation, they'd find table_line too.

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abenitab_components.htm

Re: Delete statement for string type internal table

matt — Tue, 26 Jun 2018 10:32:05 GMT

Quickly rattle off a question or expend brain power reading... I can't see it catching on.

Re: Delete statement for string type internal table

Former Member — Tue, 26 Jun 2018 13:27:08 GMT

Hi Guys,

Thanks to everyone.

DELETE gt_tab WHERE table_line IS INITIAL. -- This statement itself working fine. But i was used inside perform, it was STANDARD TABLE so It was not allowed.

Thanks,
Chella

Re: Delete statement for string type internal table

matt — Tue, 26 Jun 2018 14:17:08 GMT

Don't use FORMs - they're obsolete.

Re: Delete statement for string type internal table

retired_member — Tue, 26 Jun 2018 15:51:47 GMT

Huh?

Re: Delete statement for string type internal table

Former Member — Mon, 02 Jul 2018 10:50:17 GMT

Thanks for let us know.

Re: Delete statement for string type internal table

matt — Mon, 02 Jul 2018 11:07:43 GMT

It is documented.

Re: Delete statement for string type internal table

matt — Mon, 02 Jul 2018 11:08:43 GMT

To clarify what Horst is saying - There is no reason why using DELETE... on a standard table inside a form would be forbidden.

What you've posted makes no sense.