topic Re: how to do this in Application Development and Automation Discussions

how to do this

Former Member — Tue, 14 Nov 2006 06:32:54 GMT

hi,

i have a requirement as below

kunnr sale order

1175 12365

1175 13563

1175 45646

here i have to take first and last row separety and store it in a field....

o/p should be like

1175 12365

1175 45646

thanks

kumar

Re: how to do this

dani_mn — Tue, 14 Nov 2006 06:34:50 GMT

HI,

use the control level events 'AT FIRST' and 'AT LAST' during looping.

Regard,

Re: how to do this

seshatalpasai_madala — Tue, 14 Nov 2006 06:36:14 GMT

HI,

you can use READ TABLE ITAB INTO WA index 1.

and

READ TABLE ITAB INTO WA index sy-tfill.

Regards,

Sesh

Re: how to do this

gopi_narendra — Tue, 14 Nov 2006 06:36:23 GMT

U can use the read statement using index option

describe table itab lines n.

read table itab index 1. <b>this gives u the frist record</b>

read table itab index n. <b>gives the last record</b>

Regards

- Gopi

Re: how to do this

former_member283648 — Tue, 14 Nov 2006 06:37:00 GMT

Hi,

Assuming that your table might contain different sales order nos. you can get the no. of lines of the table using describe command and then read the table with index = 1 and index = no. of lines in the table.

Re: how to do this

Former Member — Tue, 14 Nov 2006 06:37:58 GMT

Initially u need to have the data into internal table according to ur requirement. if you want to sort it then sort it first and then u can use below code.

data: n type i.

data: itab1 type table of itab.

describe table itab lines n.

Read table itab into wa index 1.

append wa into itab1.

Read table itab index n.

append wa into itab1.

Re: how to do this

Former Member — Tue, 14 Nov 2006 06:40:29 GMT

what the solution given is only if i have only one kunnr but ....i am having different kunnrs... if i use at last the second field is coming as *******

how to proceed

thanks

Re: how to do this

Former Member — Tue, 14 Nov 2006 06:46:37 GMT

Hi,

If you need the first and the last record of your internal table.

U can use

READ table itab index 1.

And for the last statement do as below:

Describe table itab lines cnt

READ table itab index cnt.

If you wnat to get the firts and the last record for each kunnr.

The use AT FIRST and AT LAST statements in the LOOP.

Re: how to do this

Former Member — Tue, 14 Nov 2006 06:49:48 GMT

i intented to say at end of.......... not at last

thanks

Re: how to do this

Former Member — Tue, 14 Nov 2006 06:50:11 GMT

Have u tried with the code that I have given

Re: how to do this

Former Member — Tue, 14 Nov 2006 06:55:12 GMT

hi Vibha Deshmukh ,

i have many kunnrs the internal table is like

1175 545646

1175 456464

1175 456465

1145 654564

1145 546546

how to proceed with that

thnaks

Re: how to do this

Former Member — Tue, 14 Nov 2006 07:01:56 GMT

sort itab by kunnr.

Loop at itab.

l_index = sy-tabix.

at first kunnr.

read table itab into wa_itab index l_index.

append wa_itab into itab1.

endat.

at end of kunnr.

read table itab into wa_itab index l_index.

append wa_itab into itab1.

endat.

endloop.

I hope it helps.

Best Regards,

Vibha

*Please mark all the helpful answers