topic Re: read table in Application Development and Automation Discussions

read table

Former Member — Mon, 05 Oct 2009 13:39:49 GMT

i want to read a table with where condition

since reading with where condition is not possible we have to use with key

so if the fields are not primary key as to be used for where conditions. so can we use with key addition to the same

for eg

red table It_itab into wa_itam

with field1 = value1

and field2 = value 2

so if the field 1 and field 2 are not primary key so can we use with key addition and what is the impact or any other way to read the table withouth primary key

regards

Arora

Re: read table

ThomasZloch — Mon, 05 Oct 2009 13:43:23 GMT

Reading a table without primary key means LOOP AT.

Thomas

Re: read table

Former Member — Mon, 05 Oct 2009 13:46:46 GMT

yes thomas that is what i mean

so if i have where condition of some value to match..the read statement and i want to read for that where conditino value but the fields are not primary key then what is the bst way to read the particular record?

Re: read table

Former Member — Mon, 05 Oct 2009 15:00:25 GMT

In case the two fields make the record unique in the internal table, you better do a READ TABLE.

In case you have multiple records, you do first a sort on the 2 fields ands afterwards a loop.