topic Selection using not the full keys in Application Development and Automation Discussions

Selection using not the full keys

Former Member — Sat, 17 Jun 2006 17:28:45 GMT

Hello Abap experts,

I am new to abap. So, hope you can help me.

I need to select from table where it has 3 keys and 5 data fields.

The record I need to find is such that I have the value of the data field which is unique in the table although a non-key. There will only always be 1 unique value for this field in this table.

At the same time, the problem is, I do not have the last key value to select from the table. But I know it must not be '0'.

Can I still select and find the record that I want from the table?

For example, can I do this:

select * from table where key1 = 'A' AND key2 = 'B' AND key3 <> '0' AND data1 = 100? Can data field be part of a select statement selection condition?

Seeking your advise please.

Mirella

Re: Selection using not the full keys

Former Member — Sat, 17 Jun 2006 17:38:26 GMT

Your where condition can check for any fields in the table and there is no restriction. In your case I would suggest creating an index on the Field4 so that the access time would be fast. Even otherwise since you are using the two keys fields, the access should be fast as SAP creates indexes for the key fields of the table.

hith

Sunil Achyut

Re: Selection using not the full keys

Clemenss — Sat, 17 Jun 2006 17:59:10 GMT

Hi Mirella,

the main function of the index is to make database access fast.

The more components you specify in the where clause, the faster the access will be.

You may use all fields you like in the where clause.

Regards,

Clemens

Re: Selection using not the full keys

Former Member — Sat, 17 Jun 2006 18:11:30 GMT

Hi Mirella

Select statement you have written is correct. To select an unique record, you have to give all the key fields in the where condition with AND.

As you have mentioned that the non-key field have unique records, then you can have this one condition and this will give you the result. You dont have to mention the key fields.

regards

Navneet