Skip to Content
0
Oct 14, 2020 at 03:37 PM

Planning sequence - Data not saved when executing through VBA

185 Views

Hello,

my goal is to execute a planning sequence in Analysis for Office through a VBA macro passing parameter values.

If I try to execute the planning sequence via ABAP code I have no problem, but if I try to execute it in AFO I have two different problems.

Problem 1:

If I try to execute the planning sequence using the VBA code below the planning sequence seems to be executed without errors (17 records read) but there aren't records generated or deleted and there aren't logs in BW.

I have seen debugging the planning sequence that the "save_mode" variable is empty. Is it correct or how can I valorise it?

Problem 2:

I want that the variables ZCVPS029, ZCVPD029, ZCVPS007 and ZCVPD007 that I need to pass to the planning sequence are the same of the variables ZCVMS002 and ZCVMS003 selected in the prompt of the workbook AFO.

If I try to execute the planning sequence using the VBA code below, I receive an error (screenshot below).

I've seen that seems that in this way I'm not able to pass the variables (screenshot highlighted).

Could you give me a suggestion?

Thank you

Attachments

u41e5.png (17.9 kB)
hs8gy.png (483.5 kB)
scyfd.png (41.7 kB)
er6l0.png (91.3 kB)
wn2fs.png (83.6 kB)
keteh.png (77.1 kB)
sjw81.png (83.6 kB)
n9ph4.png (41.7 kB)
gsucc.png (91.3 kB)
v3c93.png (77.1 kB)