Read Table syntax

[Former Member]

hi,

Can i do read table with 2 keys?

Regards,

Ronita.

[Former Member]

hI,

oF Course !! Check the syntax of Read statement.

Thank you.

[Former Member]

Hi,

Yes, you can READ a table with 2 or more keys.

For your reference

READ TABLE pa_gt_actual_prices INTO ls_act_prices

WITH TABLE KEY kokrs = p_kokrs

perio = l_perio

objnr = ls_cssl-objnr

gjahr = p_gjahra.

Regards,

Farheen.

[Former Member]

yha

it wll b

read table it_vbap with key vbeln = it_vbeln posnr = it_posnr.

with regards

Rohan Shetty

[Former Member]

Yes you can.

loop at it1.

Read table itab with key abcd = it1-abcd

fghj = it1-fghj.

if sy-subrc = 0.

do process.

endif.

endloop.

Regards,

Madan.

[Former Member]

hi,

Check this link

Link:

[https://www.sdn.sap.com/irj/sdn/forums].

Regards.

[Former Member]

Check in SAP help or SDN .

read table <tab1> into <ls> with key

WHERE variable1 = value1

Binary search.

and

Read table itab with key variable1 = value1 variable2 = value2.....

thanks

Jagadeesh.G

[Former Member]

Hi Ronita,

Yes in the read statement we can use more than one key. Pls find the below syntax of the same.

read table it_circle into wa_circle 
with key circle_id = cid
             circle_name = cname
             circle_customer = cust.

Pls reward if useful.

Thanks,

Sirisha.

[mohammedsarvar_ka]

Hi Sirisha,

Is it possible to add same key field with two input field in an read statement ?

readtable it_circle into wa_circle 
withkey circle_id = cid or 
             circle_id = cid1
             circle_customer = cust

[JamesG]

hi mohammedsarvar.ka

you can't use same key.

[Former Member]

• with work area

Read table it_tab into wa_tab with key

key1 = wa_xyz-key1

key2 = wa_xyz-key2.

if sy-subrc = 0.

Perform your logic here.

endif.

• with field symbols

Read table it_tab assigning <fs_tab> with key

key1 = wa_xyz-key1

key2 = wa_xyz-key2.

if sy-subrc = 0.

Perform your logic here.

endif.

Reward points if helpful

Regards

Bikas

[Former Member]

Hi Ronita De,

We can read an internal table with two keys.....

READ TABLE IT_KNA1

INTO WA_KNA1

WITH KEY KUNNR = P_KUNNR

LAND1 = C_LAND1.

IF SY-SUBRC = 0.

write: / 'Read is SUCCESS'.

ENDIF.

thanks & regards

Kishore Kumar Maram