topic Re: Primary key foreign key remove problem in Application Development and Automation Discussions

Primary key foreign key remove problem

Former Member — Fri, 15 May 2009 05:21:19 GMT

hi expretrs,

I create 5 tables in ddic.

1. zpr_cmp Company Master

2. zpr_dpt Department Master

3. zpr_dsg Designation Master

4. zpr_emp Employee master.

5. zpr_slm Salary Master.

Foreign key reference in zpr_emp from table 1,2 and 3 created and

table zpr_emp has

cmpcd, Company Code

empcd, Employee Code

dptcd , Department Code

dsgcd Designation Code

as key fields.

I have upload data and create module pool and reports.

My problem that hr person say that we want to change deptcd/dsgcd of employee (zpr_emp) and

dptcd and dsgcd is as key fields in zpr_emp when i change the table zpr_emp and remove

two key fields dptcd/dsgcd and active error display.

I also try with se14 (Activate and Adjust database) but error still.

how can i remove key field from zpr_emp and active table without loss data and without any change of

module pool/reports

pl. help

Re: Primary key foreign key remove problem

Sandeep_Panghal — Fri, 15 May 2009 05:32:30 GMT

Hi,

What error you are facing while activating the table?

Rgds,

Sandeep

Re: Primary key foreign key remove problem

Former Member — Fri, 15 May 2009 05:41:27 GMT

Error when activate the table:

TABL ZPR_EMP was not activated

Check table ZPR_EMP (ABAPRSAL/15.05.09/11:24)

Enhancement category for table missing

Primary key change not permitted for value table ZPR_EMP

Old key field SCPCD is now non-key field

Structure change at field level (convert table ZPR_EMP)

Check on table ZPR_EMP resulted in errors

Re: Primary key foreign key remove problem

Former Member — Fri, 15 May 2009 06:15:08 GMT

Hi,

IS there any records in the table? if yes then delete all the records from the table and then make your changes and then check and activate.

Re: Primary key foreign key remove problem

Sandeep_Panghal — Fri, 15 May 2009 06:17:56 GMT

Enhancement category for table missing ==> You can assign enhancement category to the table , goto -> extras-enhancement category

Primary key change not permitted for value table ZPR_EMP

Old key field SCPCD is now non-key field

Structure change at field level (convert table ZPR_EMP)

Delete the records and then change the primary keys and activate and adjust the table

Re: Primary key foreign key remove problem

Former Member — Fri, 15 May 2009 06:27:05 GMT

Error still after deleting data .

TABL ZPR_EMP was not activated

Check table ZPR_EMP (ABAPRSAL/15.05.09/12:10)

Primary key change not permitted for value table ZPR_EMP

Old key field SCPCD is now non-key field

Table ZPR_EMP is modified (Deleted or deleted/created new)

Check on table ZPR_EMP resulted in errors

Re: Primary key foreign key remove problem

Former Member — Fri, 15 May 2009 11:31:35 GMT

Hi Experts,

problem is still pending pl. help;

Re: Primary key foreign key remove problem

Former Member — Mon, 18 May 2009 04:45:43 GMT

Hi,

1. First remove the data from the child table and parent table and remove the foriegn key combination from the table zpcr_emp.

2. Save, check and activate the child and parent tables.

3. Now you can upload the data into zpcr_emp and test the module pool program.

Thanks.

Re: Primary key foreign key remove problem

Former Member — Tue, 19 May 2009 12:51:57 GMT

Hi,

First remove foreign key chk from table zpr_emp for the flds dptcd , Department Code

dsgcd Designation Code

also remove key chk box selection for these flds & delete and add again these 2 flds as u want ;

now chk foreign key box & map to Pkey from their parent table also chk Primary key box ;

finally do se14 ( database utility-adjust data base & activate )

Edited by: devaramaraju on May 19, 2009 3:06 PM

Edited by: devaramaraju on May 19, 2009 3:08 PM

Re: Primary key foreign key remove problem

Former Member — Sat, 23 May 2009 11:55:34 GMT