Structure/Primary-Key change in database table on RAP ABAP

[ruchirsaxena]

Hi,

I am trying to change the structure & Primary Key of a database table in ADT (ReSTful ABAP). However, I get errors like

1. Structure change at field level (convert table ZTG_USERS)

2. Primary key change not permitted for value table ZTG_USERS

The first error comes with Quick Fixes as well :

1. Adjust and Activate database table; convert data

2. Adjust and Activate database table; delete data

3. Create Append structure for ztg_users

4. Delete table on database.

I tried the first 2 fixes, but although it shows as activation successful, it is not actually successfullz activated and still gives the error.

There is an SAP note available which is not possible on Cloud ABAP : SAP Notes - SAP for Me

Since there are more objects on top of the DB table, and since this could be a common issue, wherein changes to DB table at a later stage might be required, please let me know if a solution exists.

TIA.

[ruchirsaxena · Accepted solution]

I found a temporary solution on my own to this.

Since I had a lot of development made on top of the concerned tables, the solution is to:

1. remove any possible dependencies including foreign keys and/or associations.

2. Remove any data. Quick Fix for the same might not work.

3. In case, removing dependencies might not be right away possible with easy effort, then create a duplicate table table and then change.

4. Activation of objects built on top might also face the issue issue, and Activate All may not right away work still, so follow the first 3 steps again,

BR,

Ruchir

[former_member828275]

Hello Ruchir,

thank you for your question. Unfortunately there is no general answer to this question, so we would like to ask you to open a ticket and use component BC-DWB-AIE. This enables us to analyze the issue and provide a correction if necessary.

Thank you and best regards,

Alexander