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 Activation

Former Member
0 Kudos

Hi,

Good day experts,

Actually i have to updatethe standard table which is DFKKOP.

I have to add three standard fields to DFKKOP. but in my Company this table plays mojar roll.

I need Suggestions from u. before going to table activation. which type of protactions has to take for table activation.

i hope , first i have to back up the data in to spreed sheets.

and by the Basis-people, Table should be deactive.

then i have to start the table updation.'

i know these things. if any other than that. plz let me know.

Regards,

kk.

5 REPLIES 5

Former Member
0 Kudos

Hi,

Then you can do the table adjustments from the database utility. If you are adding non key fields, then there will not be much problem. Major data loss can happen if you are adding some key field to the table. But as you are taking back up of the data, everything should go fine.

Regards,

Renjith Michael.

0 Kudos

Hi,

Good day experts,

Thank u for reply. i have to add three fields which is two of non-key and one is foriegh key.

plz give me how to do this table activation. bcoz DFkkop has alot of DATA.

With out lossing data how can i do?

plz give me solution.

regards

kk

0 Kudos

Hi,

I think you will be doing the change using the Customer Includes(CI).

While adjusting the table you have the option save existing data. So you will not loose existing data.

Changing non key field also will not have much problems. But my concern is that there will be lot of application dependent on this standard table. All those programs developed based on this will get affected as they will be accessing the table with the known keys only.

Then, you can do the activation as follows:

take the table in se11. goto utilities->database object->database utility->Activate and adjust database

Make sure that the Save Data radio button is selected. This will save the existing data and activate table. Anyway is is good if you take a backup also with the help of BASIS guys.

But I don't recommend this as it is a standard table.

Regards,

Renjith Michael.

Edited by: Renjith Michael on Jan 17, 2008 8:01 PM

0 Kudos

DFKKOP.....This is a huge table and I am sure that there will be humungeos number of records...Can I know the reason for adding the fields and your exact requirement ...I would be able to help you with an alternative...

Regards,

Raghav

0 Kudos

Hi,

Good day experts,

Iam very thankful to u for u suggestions.and this table activation is used for Open item evalutions.

regards,

kk