table

[Former Member]

hi all,

Can you delete the fields from database table?

[JozsefSzikszai]

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?

ec

[Former Member]

hi,

Iam asking about Standard tables?

[JozsefSzikszai]

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!

[Former Member]

HI,

Offcourse you can delete.

Anirban Bhattacharjee

[ThomasZloch]

Yes, and how about you?

[Former Member]

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

[Former Member]

Hi Srini,

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

Hope this helps you.

Regards,

Chandra Sekhar

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

No.Standard tables cannot be deleted from the database

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

deleted....