Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

table

Former Member
0 Kudos

hi all,

Can you delete the fields from database table?

1 ACCEPTED SOLUTION

JozsefSzikszai
Active Contributor
0 Kudos

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

11 REPLIES 11

JozsefSzikszai
Active Contributor
0 Kudos

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

0 Kudos

hi,

Iam asking about Standard tables?

0 Kudos

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
0 Kudos

HI,

Offcourse you can delete.

Anirban Bhattacharjee

ThomasZloch
Active Contributor
0 Kudos

Yes, and how about you?

Former Member
0 Kudos

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
0 Kudos

Hi Srini,

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

Hope this helps you.

Regards,

Chandra Sekhar

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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

Former Member
0 Kudos

No.Standard tables cannot be deleted from the database

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

deleted....