delete ztable structure

[Former Member]

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

[Former Member]

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

[Former Member]

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

[former_member787646]

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

[Former Member]

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

[Former Member]

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

[former_member787646]

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?) .