Deleting Table using LSMW

[Former Member]

Hi,

Requirement: The contents for ZTAB will be sent from the legacy system with full data everytime and not the delta. To update the table each time, I need to replace the earlier content with the new content. I need to do this using LSMW. I have couple of questions for the same.

Is it possible to use LSMW to delete all the talbe entries in LSMW? If yes, Can someone guide me with the steps to do it?

I did the recording for the same by deleting the table contents. But not knowing how to proceed as I dont need to specify any fields, nor relations. Also it keeps prompting me to specify file which is not required if I am using it for deleting table entries.

And is it possible to use a logic somewhere to delete the table completely before I update the table with new entries each time using LSMW?

Please help me with this.

Thanks,

[Former Member]

Hi Anjana,

What transaction are you using to delete the entries. Are you deleting the entries directly in the database table or using a table view to delete these entries.

Also, looking at the requirement, I would be inclined to build a program instead of using a LSMW to make the changes. However, if you need help with the LSMW, let me know the answers to the above queries and I will try to think of something that can be done to achieve this.

-Akshay

[Former Member]

Thanks Akshay.

I am currently using sm31 to delete the entries. And using the same transaction to upload the data to the table.

You can also suggest me any other way of achieving this. I would be interested to know.

Thanks, Anjana

[Former Member]

Hi Anjana,

Yes, it's possible to delete entries of database table thru LSMW, likewise for entring data in databse tables. When specifiying file you have to provide all those numbers which you want to delete & u have to provide that file which will work...

Good Luck,

Ravin

[Former Member]

You can easily delete the data of a whole table using TCODE SE14.

[Former Member]

Thanks Andy. This transaction was very helpful.

Anjana