Possible impacts while adding a key field to existing table

[Former Member]

Hi all,

We have a Z table and is been currently used by many programs... This table has got only one key filed..

I have a situation to add a additional key field to this table... I know that i have to alter the table through the database utility..

Can anyone tell me what would be the possible impacts ?

Reagards,

Krishnakumar

[Former Member]

Hi all,

We have a Z table and is been currently used by many programs... This table has got only one key filed..

I have a situation to add a additional key field to this table... I know that i have to alter the table through the database utility..

Can anyone tell me what would be the possible impacts ?

Reagards,

Krishnakumar

[Former Member]

It's a pretty vague question. The answeres would range form: "no impact at all" to "total loss of data", with "minor to major program changes" in the middle.

Rob

[Former Member]

Hi Rob,

Its pretty vague so i would like to post the question otherway round

1.Is it recommended to add an additional key field to an existing Z table when it is used by other programs?

how to do a quick impact analysis in this case...

Regards,

Krishnakumar

[Former Member]

You would have to do a where used list of the table and then analyze the hit list for starters.

Rob

[Former Member]

Hi Rob,

Is there any other easy way to do other than where used list. What would be the impact?

Is it advisable to add a field?

Regards,

KK

[Former Member]

>

> Hi Rob,
> Is there any other easy way to do other than where used list.   What would be the impact?
> Is it advisable to add a field?
> 
> 
> Regards,
> KK

Sure - instead of that you could just hope that it works (but keep your resume up to date).

What I am trying to say is that there is no easy way. You must do your analysis, then make your changes based on the analysis, then test.

Rob

[Former Member]

HI ,

You can add the New key field but it will give odd results to other program which is using..

But you are telling it is ztable and it is client requirement see the program where it is using..
check does it impact any output changes by adding Key field , If so tell to client about this if
 he accepts go ahead and create the another key field...

Because they are filtering the data according to single key field and deleting duplicates on single key field..

first Goto t-code se14 and adjust the data base and add the mark the key field in Se11 and --

menugo toutilities--adjust the database ..and activate.

Regards,

Prabhuda

Edited by: Prabhu Das on Apr 17, 2009 11:35 PM

[Former Member]

If you are using the ztable in lot of programs then rather than using primary key why dont you create secondary key on the table.

Regards,

Lalit Mohan Gupta.

[Former Member]

Want to close this thread..

[Former Member]

Next time, consider assigning points to those who have helped you.

Rob

[Former Member]

Hi Rob,

I have awarded you points.. But next time when you answer consider answering people

in a diplomatic way...

Regards,

Krishnakumar

[Former Member]

Actually, I thought I was being diplomatic and I didn't mean that you should assign any points to me.

Anyone who takes time out of their day to help someone who is having a problem deserves some sort of recognition I think. That recognotion is in the form of points in here SCN.

Rob

[Former Member]

Hi Rob,

Its okay, I took in a wrong sense.

Thanks a lot for explaining and helping me out.

Have a gooday.

Regards,

KK

[Former Member]

Not a problem.

Points are important to some people here and dishing them out liberally ecourages more answeres.

Rob