key in table

[Former Member]

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?

[Former Member]

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?

[Former Member]

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

[Former Member]

Thanks Javed,

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

[RichHeilman]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

Rob