topic Re: getting a particular record-regarding in Application Development and Automation Discussions

getting a particular record-regarding

Former Member — Thu, 22 Mar 2007 08:14:56 GMT

consider i am having an internal table consisting of100 records.is there any options in ABAP to get a particular record with index value of say 40.

thanks in advance

Re: getting a particular record-regarding

Former Member — Thu, 22 Mar 2007 08:16:16 GMT

READ TABLE ITAB INDEX 40

Max

Re: getting a particular record-regarding

Former Member — Thu, 22 Mar 2007 08:16:48 GMT

yes

read table itab index 40.

regards

shiba dutta

Re: getting a particular record-regarding

Former Member — Thu, 22 Mar 2007 08:17:24 GMT

hi,

do this way

READ TABLE IT_MARA INDEX 40.

Regards,

Santosh

Re: getting a particular record-regarding

Former Member — Thu, 22 Mar 2007 08:18:47 GMT

i want to use it in a select query

Re: getting a particular record-regarding

Former Member — Thu, 22 Mar 2007 08:20:31 GMT

read table itab index 40.

if sy-subrc = 0.

select * from where field = itab-field.

endif.

Re: getting a particular record-regarding

Former Member — Thu, 22 Mar 2007 08:21:00 GMT

read table itab index 40.

if sy-subrc = 0.

select * from where field = itab-field.

endif.

Re: getting a particular record-regarding

Former Member — Thu, 22 Mar 2007 08:21:33 GMT

sorrry i m not enough clear abt your requirement..

you can use it like this..

suppose your itab contains field matnr.

read table itab index 40.

select single matnr into mara-matnr from mara where matnr = itab-matnr.

pls clearly say abt your requirement..

regards

shiba dutta

Re: getting a particular record-regarding

Former Member — Thu, 22 Mar 2007 09:29:22 GMT

Follow the following steps:

Step 1: Sort itab by key-fields.

Step 2: Read table itab index 40.

Step 3: Now your 40th record is in the header line.

So you can use it now like below:

if sy-subrc = 0.

select * from where field = itab-field.

endif.

Message was edited by:

RAMA PAMMI