topic Re: Refresh Drill down report screen in Application Development and Automation Discussions

Refresh Drill down report screen

Former Member — Mon, 26 Jun 2006 05:55:27 GMT

Hi,

I have a report that lists number of sales Order(Blocked, Incomplete) in two seperate lines. If you click(using AT LINE-Selection) on either of the line depending on whether you click on Blocked Sales Order/ Incomplete Sales Order a detailed report is displayed in an ALV format with the respective data. If I make changes to the sales order the ALV list is refreshed, but when I'm back on the summary screen I get the old summary displayed. If I use the routine to display the summary in the AT LINE-SELECTION section I get the new summary report. But then I need to hit BACK twice to get back to the initial selection screen.

Is there a way out to solve this that I do not have to hit BACK button twice.

Thanks,

ALAM.

Re: Refresh Drill down report screen

Former Member — Mon, 26 Jun 2006 06:00:07 GMT

HI alam,

1. what i understood is

a) 2 lines using WRITE Statement

b) Detail ALV on double-click on above

2. Problem is,

a) is not getting refreshed after coming back from b)

3. What u can do is

control the BACK button

(with your own fcode, and your own toolbar

by copying STANDARD TOOLBAR from SALV function group)

4. So u will be able to TRAP the back button,

and then using SY-LSIND

manage the contenets of a)

regards,

amit m.

Re: Refresh Drill down report screen

Former Member — Mon, 26 Jun 2006 06:04:24 GMT

use,

RS_SELFIELD-REFRESH = 'X'.

write the above statement in YOUR USER COMMAND FORM routine.

here is the part of my code, which is doing updating the table & then again i am fetching the data .

FORM F_USER_COMMAND_MODIFY USING R_UCOMM LIKE SY-UCOMM

RS_SELFIELD TYPE SLIS_SELFIELD.

DATA : L_ANSWER TYPE C.

IF R_UCOMM = C_FC_SAVE.

*--User Selected SAVE button.

LOOP AT IT_ZBCAR50_TEMP.

*--Check the entered values are valid or not.

IF NOT ( IT_ZBCAR50_TEMP-STATUS = 'A' OR

IT_ZBCAR50_TEMP-STATUS = 'C' OR

IT_ZBCAR50_TEMP-STATUS = 'E' ).

*--User Entered invalid value for STATUS field,so Display Error Msg

MESSAGE E000 WITH 'Invalid value '''

IT_ZBCAR50_TEMP-STATUS

''' for Status in the Record # '

SY-TABIX.

ENDIF.

ENDLOOP.

*--Modify ZBCAR50 Table with the changed values.

MODIFY ZBCAR50 FROM TABLE IT_ZBCAR50_TEMP.

IF SY-SUBRC = 0 .

COMMIT WORK AND WAIT.

*--Display message with Success in Updating database

MESSAGE I000 WITH SY-DBCNT

' Record(s) has been Updated'.

CLEAR :

IT_ZBCAR50,

IT_ZBCAR50[].

*--Get Data again from database.

<b> PERFORM GET_DATA. "here again i am fetching from Databse</b>

ELSE.

*--Error occured

MESSAGE I000 WITH 'Error occured in Modifying the database'.

ENDIF.

ENDFORM. "F_USER_COMMAND_MODIFY