topic Re: table in Application Development and Automation Discussions

table

Former Member — Mon, 14 Jul 2008 11:28:21 GMT

hi all,

Can you delete the fields from database table?

Re: table

JozsefSzikszai — Mon, 14 Jul 2008 11:29:20 GMT

hi,

yes, you can, tcode is SE11. You have to adjust the table afterwards in SE14.

Did you at least try, before posting the question?

Re: table

Former Member — Mon, 14 Jul 2008 11:29:22 GMT

HI,

Offcourse you can delete.

Anirban Bhattacharjee

Re: table

ThomasZloch — Mon, 14 Jul 2008 11:29:43 GMT

Yes, and how about you?

Re: table

Former Member — Mon, 14 Jul 2008 11:31:24 GMT

Hi,

You can Delete from Ztable created by you and other users. But you cannot delete fileds from Standard Table. It is not recommended to delete or any modification in the database table.

After Deletion of the Fields you have to Adjust the ztable in TCode SE14.

Regards

Sumit Agarwal

Re: table

Former Member — Mon, 14 Jul 2008 11:32:02 GMT

Hi Srini,

Yes, you can definitely delete fields of a Database Tables.

Hope this helps you.

Regards,

Chandra Sekhar

Re: table

Former Member — Mon, 14 Jul 2008 11:32:06 GMT

Hi,

If it is SAP Standard table then you nedd Access to Modify those table.

But if it is Ztable then you can Delete fields from Dictionary.

From SE11. Open the Table And Place Cursor ion that Field And Remove it.But in this case You can not delete Key Fields.

And you will lose data.

Regards,

Sujit

Re: table

Former Member — Mon, 14 Jul 2008 11:34:31 GMT

hi,

Iam asking about Standard tables?

Re: table

Former Member — Mon, 14 Jul 2008 11:34:44 GMT

Hello Srinivas,

Ofcourse you can delete then in either SE11 or programatically too.

Programatically...

report yh_sample.
delete from <ztable> .

This deletes all the entries.

You might find this helpful..

http://help.sap.com/saphelp_46c/helpdata/en/d3/2e974d35c511d1829f0000e829fbfe/frameset.htm

You can do it on the standard tables too. But Please dont try it on the standard tables. Not advisable!!

Regards

Indu.

Re: table

Former Member — Mon, 14 Jul 2008 11:35:48 GMT

using se14 u can edit database table and u can delete dbtale..

Re: table

Former Member — Mon, 14 Jul 2008 11:43:07 GMT

No.Standard tables cannot be deleted from the database

whereas user-defined tables in se11 can be updated,modified,

deleted....

Re: table

JozsefSzikszai — Mon, 14 Jul 2008 11:43:40 GMT

you asked about tables. If you ask about standard tables, yes you can do, you'll need object key (from OSS/SAPNet), but this is a thing which you must not do! No, never!