Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

what if we have only two key fileds out of three.

hi

if my table has 3 key fields,

i need to get a value which is not a key field

if i have only two keyvalues,

ie. key1

key2

but i dont have key3.

if i put a select query with only two key fields, would it still be fetching unique records.

Tags:
Former Member
Former Member replied
if my table has 3 key fields,
i need to get a value which is not a key field

No problem...If you got the key fields, you can gather any field which is not key itself...

if i have only two keyvalues,
ie. key1
key2

but i dont have key3.

Should be ok, but you could get some performance issues...

if i put a select query with only two key fields, would it still be fetching unique records.

Of course...In the DB you got 3 key fields...So If you select using just 2 of them your going to get the data but it's going to take longer and of course, you're going to get more data...Because the third it's not being used...

Greetings,

Blag.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question