database table - change in primary key

[former_member632991]

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 <b>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. </b>

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

[former_member632991]

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 <b>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. </b>

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

[Former Member]

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

[Former Member]

Hello,

USe the Tcode SE14 and adjust the table.

There itself the table will be activated.

Regards,

Vasanth

[former_member632991]

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

<b>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. </b>

Regards,

Sonika

[Former Member]

Hello,

Once again adjust the table in SE14.

<b>Activate ad adjust database table</b>

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

VAsanth

[former_member632991]

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

[Former Member]

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!