Skip to Content
0
Former Member
Feb 23, 2006 at 04:54 AM

How do you remove field from being primary key in an SAP table?

633 Views

I created a table in SAP called ZPERS_FUNDING. The fields are

MANDT*

AREA*

SUBAREA*

DEPTCODE*

EFFDATE

DESCR

The astericks indicate the fields that I want in the primary key. I had originally included EFFDATE in the primary key and then realized that I didn't want it there. I removed the EFFDATE field from being a part of the primary key for the table. I saved it, but it wonÂ’t let me activate it. It gives me this error when I try to activate it.

TABL ZPERS_FUNDING was not activated

Check table ZPERS_FUNDING

Old key field EFFDATE is now non-key field

Is there a way to change the primary key, once the table has been saved and activated with it?