topic Re: issue with table entries in Application Development and Automation Discussions

issue with table entries

Former Member — Mon, 07 May 2007 02:01:36 GMT

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

Re: issue with table entries

Former Member — Mon, 07 May 2007 02:06:04 GMT

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

Re: issue with table entries

Former Member — Mon, 07 May 2007 02:28:37 GMT

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,

Re: issue with table entries

Former Member — Mon, 07 May 2007 04:30:22 GMT

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.

Re: issue with table entries

Former Member — Mon, 07 May 2007 04:31:46 GMT

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.

Re: issue with table entries

Former Member — Mon, 07 May 2007 05:16:19 GMT

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

Re: issue with table entries

Former Member — Mon, 07 May 2007 12:12:43 GMT

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