Read Table

[Former Member]

Whats the significance between the two Read Statements:

READ TABLE it_tab WITH KEY matnr = 'mat001'.

and

READ TABLE it_tab WITH TABLE KEY matnr = 'mat001'.

Are there any performance significance between the two statements.

Points will be rewarded

[Former Member]

hi arman,

i think there will not be any performance diff between the two statements...

With Regards,

S.Barani

[Former Member]

using 'with key' you can read based on any field of table

using 'with table key' you have to read based on key fields of table

and obvisioulsy with table key is better, because of the unique ness of record.

Thanks & Regards

Amarender Reddy B

[Former Member]

Hi ,

For the two statements the second one will perform better

READ TABLE it_tab WITH TABLE KEY matnr = 'mat001'.

as in the first case you are not reading it into a workarea for the

search to be specific but in second case it is based on table key.

Modify the first statement as read table it_tab into wa_tab with key matnr = 'mat001'.

Asha

[Former Member]

hi,

READ TABLE it_tab WITH KEY matnr = 'mat001'. sincre it uses buffer tables.So whenever data has to be read it can be fetched from buffer tables.instead of every time reading from table hence having high performance than using table.

s

Reward with points if helpful.

Message was edited by:

Vinutha YV