spdd activity

[Former Member]

Hi guys,

I am doing an upgrade from 4.6c to ecc6.0. while doing SPDD activity, i comapred USR30 table in ecc6.0 with 4.6c. In 4.6c the table is maintained as pool -table , but in upgrded version ecc6.0 sap suggested to maintain it as transparent table. So i did reset to original. But while activiting the object by basis people, they are unable to do that. We are getting error as 'Table type change. Convert data'. We have no data in that table.

Any pointers regarding this are very helpful.

Thanks in advance

[former_member434229]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

You might be able to get it to activate with SE14, db adjust. But, a question....Pool and Cluster tables are an enormous pain, left over from days when DBMS had physical limits on number of tables...Why would you want to have the overhead of maintaining these tables as opposed to the simplicity of maintaining, reading, etc., Transparent Tables? I don't understand why you'd revert to the Pool/Cluster. In some instances, you'll find that companies have spent considerable amounts of money to have SAP come in and covert these tables (and the code) to transparent tables...

[Former Member]

Hi,

We also had a similar situation wherein the table category had changed.

So, we reset the table by "Reset to original" and then continued with post SPDD Activity.

Try to activate the table after completely SPDD activity or i guess the table will get activated in the DDIC_ACTIVATION phase after SPDD is completed.

Hope this helps.

[Former Member]

Hi,

Are you doing the SPDD in the shadow instance?

The manually activation on the shadow system in the SPDD pahse is NOT

POSSIBLE.

On the shadow system only the data dictionary will be activated,the

nametab and the database objects will be adjusted and activated in

later phases by Sapup on the standard instance.

If you try to activate the table in SE11, the database/nametab

adjustment will be started and it returns an error, because in the

shadow instance no db-object exists for the table, so no alter table is

possible.

You can adjust the DDIC-definition in the SPDD/SE11 and you can save it.

After that in the ACT_700 phase the DDIC-object will be activated by

Sapup.

Please read the note

398100 Shadow instance during upgrade section:

The functions of the shadow instance are limited. The system only allow

accesses to the table contents of Basis tables. You cannot change the

structure of Basis tables or DDL statements. The corresponding function

in transaction se11 have been deactivated. Online activations

,conversions, MoveNametabs and imports (except for putstep HAI) are not

possible.

Regards,

Victor