topic Re: database table - change in primary key in Application Development and Automation Discussions

database table - change in primary key

former_member632991 — Mon, 11 Jun 2007 15:05:40 GMT

Hi,

i hace created a z table and after that i need to change the primary key of the table.

For that i adjusted the database utility and table get activated.

But when i transported the request, it was not activated there and i had to do that database utility adjustment.

it was activated there but still it is giving dump when i want to see the table contents saying that One of the columns addressed in a table or view

does not exist in the database.

table) exists in the ABAP/4 Dictionary, but not in

the database.

Also in the prog in which i am using the table is giving the dump saying the same errror.

Is there any solution for that?

Regards,

Sonika

Re: database table - change in primary key

Former Member — Mon, 11 Jun 2007 15:15:22 GMT

Hi,

Try these options.

1.Goto transaction SE14 and adjust table and activate it.

2.If u have created a table maintenance generator delete it , create again and activate the table.

Thanks,

Deepti

Re: database table - change in primary key

Former Member — Mon, 11 Jun 2007 15:16:59 GMT

Hello,

USe the Tcode SE14 and adjust the table.

There itself the table will be activated.

Regards,

Vasanth

Re: database table - change in primary key

former_member632991 — Mon, 11 Jun 2007 15:19:43 GMT

Hi,

As i hv mentioned earlier,i hv already tried this, table got activated but when i want ti see the table contents or using the table in program it is giving the dump saying

One of the columns addressed in a table or view

does not exist in the database.

table) exists in the ABAP/4 Dictionary, but not in

the database.

Regards,

Sonika

Re: database table - change in primary key

Former Member — Mon, 11 Jun 2007 15:21:58 GMT

Hello,

Once again adjust the table in SE14.

Activate ad adjust database table

If u have the maintenace view delete it and recreate the same.

VAsanth

Re: database table - change in primary key

former_member632991 — Mon, 11 Jun 2007 15:28:34 GMT

Hi,

Already tried may times but no use.

there is no maintenace view.

Is there any solution for this as we have change dthe primary key of table.

Regards,

Sonika

Re: database table - change in primary key

Former Member — Wed, 25 Jul 2007 09:28:01 GMT

I go to se11 for table LFA1, and click where-used list. After that system show me a lot of choice " Used in" like Programs, Classes/Interfaces...., please knidly let us know use which one that we can finally find the primary key which links to other tables. Thanks!