Delete all fields from CI_COBL Include and making CI_COBL empty to its initial state.

[former_member452047]

Dear Experts,

We created CI_COBL include with one customer field in our development system as per a requirement from functional where they needed it on FB60 screen (values to be updated in BSEG and BKPF).

Later, they came up with another approach and this custom field is no more required. now I'm facing difficulties in removing this custom field from CI_COBL include and making CI_COBL empty to its initial state(Since its the only field in the CI_ Include).

When we created the CI_ include with single customer field it got included in multiple standard tables. Now we afraid of if we delete it there might be standard tables which may get partially active hence create problems with standard Tcodes (might produce dumps).

Request you all, kindly suggest right approach to revert the changes done in standard table through CI_COBL include. So that we can restore CI_COBL to its initial empty state.

Thank you so much in advance for your help and support.

Warm Regards,

Vishal Chauhan

[raymond_giuseppi]

Did you (correctly) use OXK3 to create the field, if yes call the transaction in expert mode, in menu look for delete option. If you called it call OXK1 again. Once done, removing of a field no longer used shouldn't raise any problem.

Regards,

Raymond

[former_member252826]

Hello.

With transaction SE11 you are able to delete the structure.  Enter CI_COBL in the Data Type-Field and press the Delete-Button. You will receive a warning, that it is used. If you goon, it will be deleted. In the structures which are using the CI_COBL it will be shown with length = 0, like it was, before you used it.

Regards,

Peer

[former_member225688]

Hello Peer We tried deleting the CI_COBL from SE11. It gives success message however the include structure is still available . And what about the tables associted with it . Will the field from those table will also be deleted ??

Please suggest its urgent.

Regards

Dnyaneshwar Lande

+91-7757042742

[former_member252826]

Hello

I don't know, why the structure is available after delete. Maybe there is an authorisation-problem.

If the structure is deleted, the fields will be removed from all the tables, using this structure. So you have to be careful.

Regards, Peer.

[former_member225688]

Hello Peer,

Yes we want to remove all the fields from all the dependent structures and tables. However the structure is now Partly active.

Do you see this as a reason for structure not gone ?

May be first we will need to activate the Structure and then again try deleting same.

Please share your thoughts on same. This is critical for us.

Regards,

Dnyaneshwar Lande

[former_member252826]

Hello.

If the structure is partly active there was a problem in some (one or more) tables. You have to look at the activation-protocol for more information, what exactly is the problem. The system needs to lock the tables for activating. If one table is permanently locked by an other transaction, it is not possible to activate it. That is the most common problem in this case. Locked Tables you can see in transaction SM12.

If you know, which table has a problem, you can also try to activate this table separately.

I hope, this will help you.

Regards, Peer

[former_member225688]

Hello Peer,

We already have adjusted and activated the related tables via SE14. Now all the dependent tables are activated. Now only problem is we have not yet activated the structure CI_COBL its in Partly active status. If we try to activate that then again we will make other tables partly active.

So I need to understand if i try to activate the structure and then delete will it be deleted ?  As i don't want to take second chance as it will make system unstable.

So your inputs are appreciated.

Regards,

Dnyaneshwar Lande

[former_member252826]

Hello.

Sorry, but I can't give you an answer. I tried to delete it on one of out Test-Systems without any problem and it never was partly active. You should have a System to do a test before. That would be more save. The less activity is on the system, the better the chance, that it will work

Regards, Peer.

[former_member225688]

Thanks Peer for the information. We will try to get the structure activated and then will try to delete same. 

Will also follow the same path. Thank You again . I cannot reward points as i have not opened up this thread. Regret for same.

[pashasapcha]

thanks alot Peer. I was struggling with deleting the CI_include from ESSR table which I have created. Going into se11 and deleting the structure worked for me and it took it s original shape that was before. The table got activated automatically.
Thanks alot.