topic delete ztable structure in Application Development and Automation Discussions

delete ztable structure

Former Member — Mon, 11 Aug 2008 02:12:54 GMT

Frns,

Previously i write a program for delete table entries from ztable,

but they asking me to delete even ztable structure also.

pls suggest me.

thanx

Rams

Re: delete ztable structure

Former Member — Mon, 11 Aug 2008 03:13:09 GMT

Hi Rams,

Check with different variants for the Delete .

I believe the one you are looking is

Delete ITab

Effect

Deletes one or more lines from an internal table.

Note

If you delete lines within a LOOP ... ENDLOOP block, the deletion affects subsequent loop passes.

Variant 1

DELETE itab.

Effect

Deletes the current entry from an internal table in a LOOP. You can only use this variant with index tables (standard or sorted tables).

return code is set to 0.

Once you have deleted the current entry of an internal table in a LOOP, the effect of subsequent changes to the current entry without specifying the INDEX cannot be guaranteed, and the behavior may change in future releases.

This is the first delete, use the delete according to the requirement and do check the same while debugging, I guess during the runtime they want you to delete all entries for a specific key.

Mohinder

Re: delete ztable structure

Former Member — Mon, 11 Aug 2008 04:33:57 GMT

Hi ...

actually my requirement is to write a program to delete ztable ( entire structure from Database ) through exicutable report.

once i delete the ztable , it should no more under Data dictanory.

Pls suggest me with relavant clues.

Thanx

Rams

Re: delete ztable structure

former_member787646 — Mon, 11 Aug 2008 04:48:35 GMT

Hi,

Create a BDC recording using TCode "SHDB" and Enter the table name to delete. See the parameters you have to pass in the recording and replicate the same in your report program.

Hope this helps.

Murthy

Re: delete ztable structure

Former Member — Mon, 11 Aug 2008 06:00:57 GMT

Hi murthy..

deleting a table thru SHDB( recording ).. i'm not getting ur idea..

pls can u give clear discription..

is't possible delete a ztable by recording .

Regards

Rams

Re: delete ztable structure

Former Member — Mon, 11 Aug 2008 06:10:21 GMT

Dear Rams,

Go SHDB.Give the se11 and recording name.Strart recording then it ll go at se11 screen then give ztable name.and press delete btn.then press save button and go back it ll show u all recording.then check sap prog which make at recording time according to ur requirement.

Thanks,

jaten

Re: delete ztable structure

former_member787646 — Mon, 11 Aug 2008 06:19:22 GMT

Hi,

Jaten Sangal expalined in detail what i told to do so. I think you understand his post.

If not then get back to me (Have you ever done BDC programming?) .