topic Re: Regarding Drill Down Reports... in Application Development and Automation Discussions

Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 08:19:32 GMT

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

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 08:25:27 GMT

try to refresh the internal table work area

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 08:33:10 GMT

after the call transaction

refresh SELFIELD .

santhosh

Re: Regarding Drill Down Reports...

former_member69765 — Fri, 01 Dec 2006 08:43:48 GMT

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

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 09:16:16 GMT

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^

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 11:28:07 GMT

Hi Naveen,

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

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 11:30:25 GMT

Hi Guys,

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

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 11:31:23 GMT

remove the itab name here , it will work

WHEN 'AUFNR1'.

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 11:31:43 GMT

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

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 11:39:22 GMT

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

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 11:45:13 GMT

try this...

selfield-refresh = 'X'.

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 11:53:50 GMT

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

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 11:57:26 GMT

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

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 11:58:02 GMT

If u r double clicking ,then

use this

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

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 12:06:35 GMT

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.

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 12:10:00 GMT

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

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 12:17:36 GMT

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

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 12:20:26 GMT

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

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 12:22:07 GMT

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

Re: Regarding Drill Down Reports...

Former Member — Fri, 01 Dec 2006 12:26:20 GMT

Ya its going...