Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Refreshing Tables...

Former Member
0 Likes
854

Hi,

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

Thanks.

Regards,

Tushar.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
820

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

hith

Sunil Achyut

7 REPLIES 7
Read only

RichHeilman
Developer Advocate
Developer Advocate
0 Likes
820

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

Read only

Former Member
0 Likes
821

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

hith

Sunil Achyut

Read only

0 Likes
820

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

Read only

0 Likes
820

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

Read only

0 Likes
820

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.

Read only

0 Likes
820

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

Read only

0 Likes
820

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

regards,

Clemens