topic Re: Internal Table in Application Development and Automation Discussions

Internal Table

Former Member — Mon, 09 Apr 2007 12:55:24 GMT

Hi Experts,

I have internal table like this

Doc_no Doc_name Doc_ver

K01 swuu 01

M01 mmuq 01

S01 ssqq 01

S01 ssqq 02

S01 ssqq 03

While displaying all the data’s are coming.But I wants to display

Document with the current version.

In this case S01 ssqq 03 this is the document with the current verison.

kindly put some light on this, Thanks in advance.

Cheers...

Santosh

Re: Internal Table

alex_m — Mon, 09 Apr 2007 12:58:28 GMT

Sort ur internal table by Doc_no Doc_name Doc_ver

loop at internal table and

at end of Doc_ver,

write the output.

Endloop.

Re: Internal Table

Former Member — Mon, 09 Apr 2007 13:00:53 GMT

sort the table and then use at control

at end of Doc_name

format color COL_HEADING on,

write Doc_no Doc_name Doc_ver

format color off.

endat.

Re: Internal Table

Former Member — Mon, 09 Apr 2007 13:01:46 GMT

HI..

<b>loop at itab where Doc_ver = '03'.

write: / itab-Doc_no ,

itab-Doc_name,

itab-Doc_ver.

endloop.</b>

Re: Internal Table

Former Member — Mon, 09 Apr 2007 13:06:08 GMT

Hi there. Another option is to sort descending and then use the first record. This should be a little faster. Example:

SORT itab by Doc_no DESCENDING Doc_name Doc_ver DESCENDING.

LOOP AT itab.

write: / "Current version: ", itab-Doc_no, ' ', itab-Doc_name, ' ', itab-Doc_ver.

EXIT.

ENDLOOP.

- April King

Re: Internal Table

Former Member — Mon, 09 Apr 2007 13:06:43 GMT

Hi..,

data wa_current_version like line of itab.

data w_version like itab-doc_ver vallue '00'.

loop at itab .

if itab-doc_ver gt w_version .

w_version = itab-doc_ver.

wa_current_version = itab.

endif.

endloop.

here wa_current_version contains the record with version '03'.

reward if it helps u..

sai ramesh