Regarding Drill Down Reports...

[Former Member]

Hi everybody,

I am doing a drill down for process order.For that i am doing the following code.

FORM USER_COMMAND USING UCOMM LIKE SY-UCOMM SELFIELD TYPE SLIS_SELFIELD.

READ TABLE ITAB_CAUFVD_D INDEX SELFIELD-TABINDEX.

CASE SELFIELD-SEL_TAB_FIELD.

WHEN 'ITAB_CAUFVD_D-AUFNR1'.

SET PARAMETER ID 'ANR' FIELD ITAB_CAUFVD_D-AUFNR1.

CALL TRANSACTION 'COR3' AND SKIP FIRST SCREEN.

ENDCASE.

ENDFORM.

The problem that i face is : only when i log in to the client & when i run the report for the first time, the drill down is working fine.Otherwise it is not working.Only the first no is coming again & again when i click the other nos.

Regards,

Varadharajan.S

[Former Member]

try to refresh the internal table work area

[Former Member]

Hi Naveen,

I tried refreshing the work area also.But it is not working.

[Former Member]

remove the itab name here , it will work

WHEN 'AUFNR1'.

[Former Member]

Hi,

try to set an break-point before the CASE-statement and

look at sy-subrc (for read table) and look if you

have the right index.

regards, Dieter

[Former Member]

The READ TABLE fetches the right index only & when i try using WHEN 'AUFNR1' also it is not working out.

[Former Member]

try this...

selfield-refresh = 'X'.

[Former Member]

I tried using <b>selfield-refresh = 'X'</b> after CALL TRANSACTION statement.But still it is not working.

[Former Member]

hi,

can u paste the code so that we can try on our system. plz check if u have given the callback program as sy-repid.

santhosh

[Former Member]

If u r double clicking ,then

use this

case p_ucomm.
WHEN '&IC1'.  "double click
*write the other code here
   case 'ITAB....'
endcase.

[Former Member]

I have mentioned the callback program as sy-repid only.I have given the code in my first post itself can u plz check it out.

[Former Member]

When i debug the code & check then it is going thru the condition correctly only.I dont think double click will be a problem.

[Former Member]

hi,

can u tell me by debugging if ur set parameter statement is being accesed the second time u are clicking or trying to drill down.

santhosh

[Former Member]

Can u plz explain in detail.I am unable to get ur point.

[Former Member]

hi.

place a break-point at the command set parameter id. alrite..now just tell me if every time u click on the record ur program goes into the debugging mode or not.

santhosh

[Former Member]

Ya its going...

[Former Member]

now when it stops there what is the value of ITAB_CAUFVD_D-AUFNR1 is it the first value or isit the value u are clicking on.

santhosh.

it would be beter if u can paste all the code yar...if its not so confidential.:)

[Former Member]

Ya its the value which is clicked..

[Former Member]

after the call transaction

refresh SELFIELD .

santhosh

[former_member69765]

Ok... What is wrong is these 2 statements --

CASE SELFIELD-SEL_TAB_FIELD.

WHEN 'ITAB_CAUFVD_D-AUFNR1'.

I suppose u are doing so to make sure that the user has clicked on Order No field.

If you see in the debug mode and press F5 on CASE Statement you will know the answer.

Instead u must do this --

case selfield-fieldname.

when 'AUFNR'.

It will work fine. I have tried this.

Hope this helps... If it does plz reward points.

Message was edited by:

Varun Verma

[Former Member]

hi

good

i think your internal table storing the same data and that is reason why it is showing the same data again and again.

debutg the report and check the header value of the internal table from which the data is displaying at the end, if the out out is showing the header data than clear the header and check the difference.

thanks

mrutyun^

[Former Member]

Hi Guys,

I tried every possibilities that u have listed above.But i couldn get thru the problem.