How to delete append strucure

[Former Member]

How to delete append strucure from data base table

[ferry_lianto]

Hi,

1. Go to SE11

2. Enter your append structure name.

3. Press delete

4. It will delete this append,

also in the original table/structure

where it is used, AUTOMATICALLY.

5. Go to SE14 to adjust the database table.

Regards,

Ferry Lianto

[Former Member]

hi,

i want to clarify some thing regarding delete append structure, it is not just like normal structure or table, first u should goto the place where append structure is used & then first delete the fields then activate the structure then it says where it is used then press ok ,

then goto se11 data dictionary then enter the append structure name then only press delete button otherwise if u do the thing mentioned in your replay it will create shortdump for the tables where it is used.

then goto the table where it is used then goto utilities then press database utility(i.e se14) then press activate & adjust data base(i.e any changes done in R/3 dictionary will equally effect in database).

[Former Member]

Hi Phani,

You can goto SE11, give the Append structure name and can just press Delete button.

Next you'll get a pop-up message which says that your append structure will be deleted and the Main table to which the append structure was added will be re-activated.

Just press delete and your append structure will be deleted.

Regards,

Nagendra

[Former Member]

1 Open the append structures

2 Choose the structure you want to delete

3 Delete all the fields from this append structure

4 now go to se14 and addjust the table

Note: append statement will stay in the tabel , but all the flelds will be removed , provided no data is present in them, also do not forget to activate table , but append structure will show errors while activating

iggnore that

award points if helpful

[Former Member]

hi

First go to SE11

Enter your Append structure name in DATA TYPE TAB.

Click on Delete or SHIFT+F2.

It will Delete Append Structure from all the database table where it's used.

Go TO SE14 and Adjust the Database tables.

Rewards if useful

Thank You

Nikunj Shah