issue with table entries

[Former Member]

Hi all,

i HAVE INTERESTING DOUBT.

I HAVE A TABLE WITH DATA WITH 3 PRIMARY KEYS

I HAVE DATA LIKE

FLD1 FLD2 FLD3 FLD4

1 A 2 1

1 A 2 2

SINCLE FLD1,FLD2AND FLD3 ARE PRIMARY KEYS .This record was uploaded from excel file

now what i did is i removed the fld3 as primary key and moved the request .

NOW I HAVE FLD1 AND FLD2 as primary keys

then what happens to above 2 records

can anyone tell me

Thanks

preeti

[Former Member]

primary key entry should be unique so as per your requirement make field4 also primary key then only you can upload the data in the table . otherwise its not possible to upload these two rows.

regards

shiba dutta

[Former Member]

Hi,

If you remove field3 as primary key, you cann't save those 2 records, you only can save 1 record.

And if you already have data in your table like that, i think you will get an error when you remove field3 as primary key.

Regards,

[Former Member]

hai preeti...

you delete the fild row in the table that is you mentioned(third field).

and just activate you cannot activate .

so you go to se14 for database utility.

give your table name in the object and just click edit.

and then click the activate and adjust pushbutton .

you get activated..

this the solution for your question.

thanks,

velu.

[Former Member]

hai preeti...

you delete the fild row in the table that is you mentioned(third field).

and just activate you cannot activate .

so you go to <b>se14 for database utility</b>.

give your table name in the object and just click <b>edit</b>.

and then click the <b>activate and adjust</b> pushbutton .

you get activated..

this the solution for your question.

thanks,

velu.

[Former Member]

Hi abaper,

once you remove your primary key, it will say the error so you should adjust your table using se14.

But once you remove the key nothing will happen in the records.... if you have any doubt in table, send a message i will clear..

Gowri

[Former Member]

Hi all,

i ai adjusted the table and the table got activated.

My question what happens to the data.

the second record shouldn't exist right

what happens to second record

thanks

preeti