Skip to Content
0
Former Member
May 15, 2009 at 05:21 AM

Primary key foreign key remove problem

62 Views

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