topic Re: interactive report in Application Development and Automation Discussions

interactive report

Former Member — Fri, 17 Nov 2006 07:07:40 GMT

hi all,

i have a list output as follows-this list is my basic list.

matno mat descp quantity unit rate total amount

1 iron 50 kg 10 500

2. wood 100kg 20 2000

3. sugar 10kg 25 250

suppoose i click on row 2 then in my secondary list i should get only that line .

how to do it.

Re: interactive report

Former Member — Fri, 17 Nov 2006 07:15:53 GMT

hi sanjeev,

use at line selection.

loop at itab .

write:/ itab-f1, f2 ,f3..

<b>hide itab-matnr</b> ---> in ur basic list ..

endloop.

at line selection --->"after the basic list u need to write here like this 

select  p1 p2 p3 into table jtab from 
           XXXX
           where p1 = itab-matnr "----------->   " this will fetch only that line item ..


 loop at jtab.
write:/ jtab-p1, p2, p3     "------> secondary list ..

endloop.

and in the pf status set F2 = PICK ..

when ever u click the line this will give the functionlity ,,,

regards,

VIjay

Re: interactive report

Former Member — Fri, 17 Nov 2006 07:27:31 GMT

thanks vijay,

after storing the value using hide st.

how can i fetch using get cursor command or read line st.s o that my above reqirement is achieved.

Re: interactive report

Former Member — Fri, 17 Nov 2006 07:47:06 GMT

Hi,

Check this

AT LINE-SELECTION.

GET CURSOR FIELD cf VALUE w_matno.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

input = w_matno

IMPORTING

output = w_matno.

IF cf = 'ITAB-MATNR'.

sy-lsind = 2.

LOOP AT ITAB WHERE matnr EQ w_matnr.

print matno , mat descp , quantity , unit rate , total amount

field values of u r internal table .

endloop.

Re: interactive report

Former Member — Fri, 17 Nov 2006 07:52:32 GMT

hi sreekanth,

thanks for ur reply and for this i have given poits to u also.

but can u tell me that for basic list what is the value of sy-lsind.

whether it is 0 or 1. bcoz u have mention sy-lsind =2 for first sendoray list in ur above reply to me. plz reply it. so that i will be clear.

Re: interactive report

Former Member — Fri, 17 Nov 2006 08:01:49 GMT

Hi,

For basic list sy-lsind value will be 0. Just i have mentioned there sy-lsind eq 2. U can also take sy-lsind value as 1 also.

U can get u r desired o/p, no problem with that.

But dont assign sy-lsind value 0,

For example, if you set SY-LSIND to 0, the system deletes all secondary lists and overwrites the basic list with the current secondary list.

I think u know that .