Change BPC work status using VBA code in AO Workbook

[Elangovan]

Hi,

Is there a way to change the work status using the VBA code / Macro?. I have a scenario where the user needs to click the a button to change the work status rather than using the ribbon option.

[former_member186338]

What BPC system you are talking about? Standard or embedded?

[Elangovan]

Hi Vadim,

Trying to do this in BPC Optimized for S4/HANA

[former_member186338]

elaaxe

Just to confirm - the model is embedded? Because it's possible to create standard model with BPC Optimized for S4/HANA

[Elangovan]

I apologize for the ambiguity. Am trying to do this in an embedded model. There are two work status Submit and Approve. The user should be able to set the work status by clicking on Buttons rather than using change work status option in Analysis tab. We are trying to do this only for improving the user experience.

[former_member186338 · Accepted solution]

"Is there a way to do the same in Standard model of BPC optimized for s4/hana?"

With standard model you can run a Data Manager package from VBA button. The package will execute custom logic badi to change work status.

Look at the end of my old blog:

https://blogs.sap.com/2014/01/17/bpc-nw-75-work-status-setting-from-excel-vba/

[former_member186338]

No way to do it for BPC embedded!

[Elangovan]

Is there a way to do the same in Standard model of BPC optimized for s4/hana?