topic Re: alv display in Application Development and Automation Discussions

alv display

Former Member — Tue, 29 Jul 2008 06:42:23 GMT

hi,

i have 5 fields in my internal table to display.(date n1 n2 n3 n4 n5)

n1 n2... are basically counters.

i am getting records like this 200807 1 0 0 0 0.

i may get the similar records.

but finaly i need to disply the total count i.e if i have 2 records output will be 200807 2 0 0 0 0.

please help me in this issue..

pradeep

Re: alv display

peter_ruiz2 — Tue, 29 Jul 2008 06:45:57 GMT

Hi,

1. sort your table by field 2 ascending

2. use describe table to get the number of records in table

3. retrieve the last record.

here is an example

SORT itab BY n2.

DESCRIBE TABLE itab LINES ld_lines.

READ TABLE itab INDEX ld_lines.

regards,

Peter

Re: alv display

Former Member — Tue, 29 Jul 2008 06:48:40 GMT

Hi,

you can implement your alv with sub totals on date field then all the corresponding values have been added and displayed in the sub totals column. For this you can create one work area of type 'slis_sortinfo_alv' and internal table of type SLIS_T_SORTINFO_ALV

then

gx_sort-fieldname = 'DATE'.

gx_sort-up = 'X'.

gx_sort-subtot = 'X'.

APPEND gx_sort TO gt_sort.

Before do this make sure that you have to pass 'X' to the do_sum field in the field catelog for the corresponding field.

and pass this gt_sort to the corresponding it_sort of the import parameter of the FM.

Regards,

Bujji

Re: alv display

Former Member — Tue, 29 Jul 2008 06:49:08 GMT

before passing the internal table to reuse_alv_grid_dispaly

do this

describe table itab lines v_line.

loop at itab

itab-n1 = v_line

itab-n2 = sy-tabix

modify itab

endloop

try with this, reward points if helpful

Re: alv display

Former Member — Tue, 29 Jul 2008 06:49:16 GMT

loop at itab where n2 = 2.
write:"print now.
endloop.

Re: alv display

Former Member — Tue, 29 Jul 2008 07:11:09 GMT

Hi Guys,

I think the requirement of pradeep is to print a counter in the 2nd column of the ALV. It is not to print when it reaches a certain number.

Regards,

Sai

Re: alv display

Former Member — Tue, 29 Jul 2008 07:19:39 GMT

Hi Pradeep,

here in the situation what u can do is...

1: loop at the internal table and check for the same records if u get same records on particular field then append those into new internal table suppose itab1 and rest of the records into another itab2.

2: use collect statement on itab1.

3: finally merge the two tables itab1 after collect and itab2 into final_itab and then pass it to FM.

Thanks & Regards

Ashu Singh.

Re: alv display

Former Member — Tue, 29 Jul 2008 09:45:42 GMT

hi,

can u plesae explain how to merge the 2 internal table....

Re: alv display

Former Member — Tue, 29 Jul 2008 10:10:19 GMT

Hi,

--sort internal table on date descending order

--read each record and check with next record if it matches increase counter otherwise update another intrnal table to display in ALV.

Refer below code:-

TABLES ZAP_COUNT.

DATA : BEGIN OF ITAB OCCURS 0,

L_DATE LIKE ZAP_COUNT-L_DATE,

N1 LIKE ZAP_COUNT-N1,

END OF ITAB.

DATA: N1 TYPE ZAP_COUNT-N1 VALUE 1,

L_DATE LIKE ZAP_COUNT-L_DATE,

IT_ITAB LIKE ITAB OCCURS 0 WITH HEADER LINE.

SELECT L_DATE N1 FROM ZAP_COUNT INTO TABLE ITAB.

SORT ITAB BY L_DATE DESCENDING.

LOOP AT ITAB.

IF ITAB-L_DATE EQ L_DATE.

N1 = N1 + 1.

ELSE.

IF L_DATE IS NOT INITIAL.

IT_ITAB-N1 = N1.

IT_ITAB-L_DATE = L_DATE.

APPEND IT_ITAB.

N1 = 1.

ENDIF.

L_DATE = ITAB-L_DATE.

ENDLOOP.

IT_ITAB-N1 = N1.

IT_ITAB-L_DATE = L_DATE.

APPEND IT_ITAB.

Reward if useful

Re: alv display

Former Member — Tue, 29 Jul 2008 10:28:35 GMT

Hi Pradeep,

You do in the following way...

suppose u have data in itab .... now what u do is declare itab1 like itab and also declare wa for itab1...

loop at itab into wa.

wa1-name = wa-name.

wa1-address = wa-address.

wa1-dob = wa-dob.

wa1-salary = wa-salary.

collect wa1 into itab1.

here is the small example i have given... now u have the itab1 in which u have records which have common as u told as well as uncommon records.

Just use this logic and i m sure u will get the solution

Thanks & Regards

Ashu Singh.

Re: alv display

Former Member — Tue, 29 Jul 2008 10:29:59 GMT

Hi,

if u get problem then let me know...

Thanks & Regards

Ashu Singh