Refresh current SEM-BPS layout

[Former Member]

Hi,

I have a need to refresh the current SEM-BPS layout after executing a planning sequence.

How do i do that?

the problem is,

A planning sequence reposts current layout data & the data disappers from the layout but the document icons still appear in the layout. (these are just virtual icons meaning it doesn't let me to delete/edit the document. If i click on these icons, nothing happens but the icons just appears)

I switched the layout (another button in the folder) after executing this planning sequence & again came back to the 1st layout & the icons are gone.

So, I'm anticipating that refreshing the current layout should solve this problem.

Appreciate any kind of help.

[gerd_schoeffl · Accepted solution]

Hi,

I guess the problem lies in the way the Excel macros transmit the data from the BPS sheet to your sheet. The best way to handle the problem is to insert a delete operation in you VBA coding before the new data is transferred to the second sheet. What I mean is in the macro SAPAfterDataPut you first delete all data in the second sheet (including the icons) and then transfer everything to the second sheet.

You cannot trigger a "restart" of the Excel layout via a planning function. If you are in a layout and trigger a planning function the system notices that the same layout should be shown and thus does not restart the Excel (for performance reasons). If you switch to another layout then the Excel application is stopped and a new Excel is started. There is no way to influence this behavior without doing a system modification.

Best regards,

Gerd Schoeffl

SAPNetWeaver BI RIG EMEA

[Former Member · Accepted solution]

Thanks a lot Gerd,

that helps a lot.

I had took care of this with better VB code in SAPAfterDataPut.