topic Re: Read Statement in Application Development and Automation Discussions

Read Statement

Former Member — Mon, 23 Oct 2006 18:52:48 GMT

Hello friends,

I have to read a internal table based on it_zzsd-Kunnr.

I am using,

READ TABLE it_knvv WITH KEY kunnr = it_zzsd-kunnr.

However in table it_knvv there are multiple records for a single it_zzsd-kunnr.

I just want to pick the first.

Will the read statement serve my purpose or it wont.

Shejal.

Former Member — Mon, 23 Oct 2006 18:55:04 GMT

Hi,

Yes..READ TABLE will pick the first record that matches the key..

Thanks,

Naren

Former Member — Mon, 23 Oct 2006 19:00:34 GMT

It will pick the first, but that first record will depend on the order in which it is sorted.

Rob

ferry_lianto — Mon, 23 Oct 2006 19:01:37 GMT

Hi,

Yes, you can use READ TABLE statement to select first record when the condition is matching.

Regards,

Ferry Lianto

Former Member — Mon, 23 Oct 2006 19:02:28 GMT

Thanks Everyone.

Shejal.