Retrieving the Old Version of a Standard Table DPR_LOCATION

[Former Member]

Hi All,

I have changed the primary key of a standard table DPR_LOCATION using the acces key.

Now I want to revert to the original version. When I use the Version Management and trying to retrieve the original version I am getting a message that Primary key change not permitted for value table DPR_LOCATION.

Please advise how can I return to the original version provided by SAP.

[tamas_hoznek]

Take a look at note 96295 and see if it helps. It is an old note but may be still of some use.

Another possibility is that your table is defined as a check table and so the system does not let you change the primary key to avoid inconsistencies.

Use the "where used" function to see what tables refer to this one as the check table. You must delete the foreign key references before changing the primary key of the check table.

[Former Member]

Hi Sandy,

Apart from Thomas, Other thing is that if you are adding a key to primary keys of a table which already have data, will allow to add one. But if you want to reduce the number of primary keys from the database table, it will not allow you to do that.

Reason is - when you removing one field from the primary key, existing data will become inconsistent with the new primary key combinatiion, which is not true for the opposite case.

A possible solution for this is to take backup of data of the table and then delete all the data from the database table.

When table will not having any data then it will allow to change the primary key.

then again upload the data by writing a simple upload program or manually if data is very less.

Regards,

Akhil

[Former Member]

Done