Problem with CO-PA table structures and check table

[Former Member]

Hi Gurus!

I created a custom table ZMDCM_PLNLVLCHK with three fields ZZPLC PLCDESC and EPSC. By mistake the second field PLCDESC is marked as a primary key. I have saved and activated the table.

Now this first field ZZPLC is inserted in many standard table as an append structure. This field also uses my custom table ZMDCM_PLNLVLCHK as a check table in many standard tables.

Now when I try to remove the primary key of field PLCDESC it does not allow me to do so because this custom table is already used as a check table. Now I need to remove the check table relation ship of this field with standard table before removing primary key from the custom table.

What is the transaction or configuration thru which these structures

CE01000

CE71000

CE81000

KOMKAKE

ZFIAP_A_PLI

ZOXD100019

ZOXD100021 CO-PA

and data base tables

CE11000

CE21000

CE41000

CE41000_ACCT

CE41000_KENC

are being created. Is there a way to go and remove check table from these above standard CO-PA structures and tables.

Thanks & Regards

Ramachandran Babu

[Former Member]

Hi Gurus!

I created a custom table ZMDCM_PLNLVLCHK with three fields ZZPLC PLCDESC and EPSC. By mistake the second field PLCDESC is marked as a primary key. I have saved and activated the table.

Now this first field ZZPLC is inserted in many standard table as an append structure. This field also uses my custom table ZMDCM_PLNLVLCHK as a check table in many standard tables.

Now when I try to remove the primary key of field PLCDESC it does not allow me to do so because this custom table is already used as a check table. Now I need to remove the check table relation ship of this field with standard table before removing primary key from the custom table.

What is the transaction or configuration thru which these structures

CE01000

CE71000

CE81000

KOMKAKE

ZFIAP_A_PLI

ZOXD100019

ZOXD100021 CO-PA

and data base tables

CE11000

CE21000

CE41000

CE41000_ACCT

CE41000_KENC

are being created. Is there a way to go and remove check table from these above standard CO-PA structures and tables.

Thanks & Regards

Ramachandran Babu

[Former Member]

hi

go to se14

and type the table table

after saving the table in se11 by uncheck the primary key option

and then

go there (se14) and give adjust and activate to database.

with regards

s.janagar

[Pawan_Kesari]

These table/structures are created when FI functional consultant (usually) create operating concern using trsanaction KEA0.

Its very complex process to design these structure and changes means change in Business requirement. I would suggest you to contact the FI functional consultant before you change these structure.

[Former Member]

Hi Babu,

Make the relevant change of the primary key and activate it will show you error Structure changed first activate and adjust the database, do that by going to SE14 or SE11 table fields screen menu bar->utilities ->database utilities. Give the table name and at the last you can find a push button with activate and adjust the database click that, in the status bar you can see database successfully adjusted.

I think its not a good practice to delete, rather we have the method to overcome from it.

This may resolve your problem .

Cheers!!

[Former Member]

Hi all,

It is not possible to remove primary key using table adjustmnt(SE14) when the table is used as a foreign key by other tables. The only way out is to remove foreign key relation ship from other table and then remove primary key.

Thanks & Regards

Ramachandran Babu

[Former Member]

Solved myself