topic Re: key in table in Application Development and Automation Discussions

key in table

Former Member — Mon, 23 Jan 2006 18:20:51 GMT

Is it advicable to make all the fields in a table as key? The case is to maintain a control table where 2 fields are required and it should be unique also. is there any thing wrong in doing it?

Re: key in table

Former Member — Mon, 23 Jan 2006 18:31:24 GMT

Well in your scenario, where you have only two fields in tables, and they need to be unique..Yes u can make it. As I also develop a screen in which we have to store two dates as a key in table...

Hope this’ll help you .

Bye

Re: key in table

Former Member — Mon, 23 Jan 2006 18:37:18 GMT

Thanks Javed,

I was checking whether its a good practice to do making all the fields in table as key.

Re: key in table

RichHeilman — Mon, 23 Jan 2006 18:38:42 GMT

I see no problem there, if you had a lot of fields in your table and you tried to make them all keys, you would get an error because there is a limit. No problem here though.

Regards,

Rich Heilman

Re: key in table

Former Member — Mon, 23 Jan 2006 19:04:06 GMT

You can, but why? IF you know all of the key fields, there's nothing that the database can tell you when you select it.

Rob

Re: key in table

Former Member — Mon, 23 Jan 2006 19:15:20 GMT

hi Rob,

I wanted to record whether a particular transaction has occured or not. If ocuured on the same date it should not be allowed once again. So the transaction and date are my only fields and only keys. Is there any SAP tables with all the fields as key.

Re: key in table

Former Member — Mon, 23 Jan 2006 19:25:44 GMT

I figured that out right after I made the post. I don't know of any tables like that, but it shouldn't be a problem. You might want to add the client as the first key field.

Rob

Re: key in table

Former Member — Mon, 23 Jan 2006 20:04:10 GMT

There are lots of SAP tables like this - TB040 for instance.

Rob