topic Re: Refreshing Tables... in Application Development and Automation Discussions

Refreshing Tables...

Former Member — Wed, 09 Aug 2006 18:55:57 GMT

Hi,

How can I refresh (delete complete data) in custom tables that I created in R/3 ?

Thanks.

Regards,

Tushar.

Re: Refreshing Tables...

RichHeilman — Wed, 09 Aug 2006 18:57:16 GMT

You can use transaction SE14 to quickly delete all records from your custom table.

Go to SE14, enter table name hit enter. Select the radiobutton for "Delete Data" and click "Activate and Adjust". You table will then be cleared.

Regards,

Rich Heilman

Re: Refreshing Tables...

Former Member — Wed, 09 Aug 2006 19:00:29 GMT

Select all the records in an internal table and use delete from internal table.

hith

Sunil Achyut

Re: Refreshing Tables...

Former Member — Wed, 09 Aug 2006 19:01:36 GMT

What do I need to do if I need to refresh SIS and LIS structures ?

Re: Refreshing Tables...

RichHeilman — Wed, 09 Aug 2006 19:03:36 GMT

I believe that you can do the same thing. The corresponding tables start with "S" and then the number. I have never done this for an LIS structure though.

REgards,

Rich Heilman

Re: Refreshing Tables...

Former Member — Wed, 09 Aug 2006 19:08:51 GMT

Hi,

I am wondering that structure gets data at runtime and there is no question of refresh or delete the data from it. So if SIS and LIS structures are actually tables then why they are reffered as structures ?

Thanks.

Tushar.

Re: Refreshing Tables...

RichHeilman — Wed, 09 Aug 2006 19:10:50 GMT

Yes, they are transparent tables. The term "Structures" in this case, referrs to the reporting tool and not the underlying technology. Really, these are referred to as InfoStructures.

Regards

Rich Heilman

Re: Refreshing Tables...

Clemenss — Sat, 14 Oct 2006 13:26:17 GMT

DELETE FROM <table name> WHERE MANDT = SY-MANDT CLIENT SPECIFIED.

regards,

Clemens