Automate

Hi - I've been asked if it is possible to read a value, transform it, then upload the transformed value in a single script?

The example scenario is CJ30 (change original budget) where we want to add a fixed uplift on the budget.

1. download the value
2. add a fixed amount to the value (55 in my screenshot example)
3. upload the new transformed value

I've copied and pasted the field BPDY-WERT1 (budget) and set one to upload with transformation and one to download but it's doing the calculation before downloading. In general, is it possible to download, transform and upload from anybody's experience?

------------------------------
Mark Berbezier
SAP Analyst
SEVERN TRENT WATER LIMITED
------------------------------

Just a quick update for this very specific example, we've found a revaluate function in CJ30 / CJ32 under the edit menu which records just fine but still interested if it is possible to read a value, transform it and upload it back!

------------------------------
Mark Berbezier
SAP Analyst
SEVERN TRENT WATER LIMITED
------------------------------

Hi Mark

No, it's not possible - at least in my testing.  I even had the download first, hitting enter, and then did the upload with a formula

It ended up blanking out the budget. The download seems to happen happen after the calculation to upload. 

You'd have to do two steps, and you can chain them so that it's one click to run, but two scripts. Or you can use a query to download them, applying a formula as you extract, and then you can upload.

FYI

Sigrid

------------------------------
Sigrid Kok
*Precisely Software Inc.
------------------------------