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