topic Re: Refresh problem after call transaction in Application Development and Automation Discussions

Refresh problem after call transaction

Former Member — Wed, 03 Feb 2010 14:26:57 GMT

Hi,

I am building a BDC to a transaction and commiting it. When i hit the database, i get the oder values.

I am not using any select query. Selection is done using FM.

When i call the BDC again, its happening perfectly.

Things i have tried.

1. Changed mode to S, A, L - Nothing worked

2. Used wait up to 4 seconds. - Didnt work

Any other pointers???

Regards,

Niyaz

Re: Refresh problem after call transaction

kesavadas_thekkillath — Wed, 03 Feb 2010 14:42:31 GMT

Hi Your question is not clear.

Please explain clearly.

Re: Refresh problem after call transaction

Former Member — Wed, 03 Feb 2010 14:49:02 GMT

Hi,

I have a report program developed using OOPS.

When i click on refresh button, the changes should be updated in database using call transaction method and the entire ALV needs to be refreshed with updated values.

I have coded like below.



When 'REFRESH'.
                                    Perform save_to_database.

PERFORM save_to_database.
...... build BDC...
call transaction 'IW32' using mode 'N' update 'A' messages lt_messages.
if sy-subrc eq 0.
commit work and wait.
endif.

endform.

Now the above code is executed, the ALV is not refreshed with updated value. Where as when i call perform save_to_database again( twice ), the values are refreshed.

Edited by: Niyaz Ahamed on Feb 3, 2010 3:49 PM

Re: Refresh problem after call transaction

Former Member — Thu, 04 Feb 2010 05:29:12 GMT

Hi Niyaz,

When we are going for standard transactions the most reliable way to do it is by using a BAPI if available.

If any BAPI is available try using it and see the results.

Hope it helps you,

Regards,

Abhijit G. Borkar

Re: Refresh problem after call transaction

jyotheswar_p2 — Thu, 04 Feb 2010 05:36:35 GMT

After the BDC is sucessfull U have to modify the internal table whihc is dispalyed in the ALV and in the PBO event before dispalying the container Use the follwoing mehtod

CALL METHOD cl_gui_alv_grid->refresh_table_display.

Regards

Jyo

Re: Refresh problem after call transaction

Former Member — Thu, 04 Feb 2010 05:41:51 GMT

Hi,

Sometimes a normal committ statement doesnt work.

Instead use a BAPI and check.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

EXPORTING

wait = wait.

Regards,

Thoufique.

Re: Refresh problem after call transaction

Former Member — Thu, 04 Feb 2010 06:12:50 GMT

Hi,

you have to refresh ALV after performing save_to_database. There are refresh methods for both CL_GUI_ALV_GRID, CL_SALV_TABLE.

Regards,

Adrian

Re: Refresh problem after call transaction

Former Member — Thu, 04 Feb 2010 06:50:56 GMT

The problem is not with the ALV refresh. The problem is with the Fm which retrives the data, its still returning old values.

I am using FM CY01_EXTERNAL_INTERNFACE.

Re: Refresh problem after call transaction

Former Member — Thu, 04 Feb 2010 06:59:54 GMT

So set importing parameter RESET_ALL_TABLES_IMP to 'X. Maybe also set FLG_RESET_PROFILES to 'X'. Alternatively call CY01_REFRESH_ALL_TABLES and CY27_INITIALIZE_LIMITED_PLAN after (or before) each call of CY01_EXTERNAL_INTERNFACE.

Adrian

Re: Refresh problem after call transaction

Former Member — Thu, 04 Feb 2010 09:49:32 GMT

Doesnt work. Any other solutions???

Re: Refresh problem after call transaction

Former Member — Thu, 04 Feb 2010 11:59:17 GMT

When i Quit the program completely and execute again, it returns the correct data.

Any idea how to refresh the buffers???

Re: Refresh problem after call transaction

Former Member — Thu, 04 Feb 2010 13:59:06 GMT

It looks like some global variable is still remaining uncleared. I am sorry, but I have no other ideas. Only to debug it by first run and also by second run and find out on which place a program flow differs.

Adrian

Re: Refresh problem after call transaction

sangeetha_sk — Thu, 04 Feb 2010 14:06:36 GMT

Check whether u r clearing & refreshing ur BDCDATA table after your call tranmsaction statemnet.

Re: Refresh problem after call transaction

kesavadas_thekkillath — Thu, 04 Feb 2010 14:12:21 GMT

How are you calling the alv.

can you place the exact structure of code.

saving to database

Displayiung alv.