Use of MATLOC_SET function in APO macrobuilder

[Former Member]

I am using the APO macrobuilder.

In a macro, I am calculating a quantity in a key figure cell.

I want to use this quantity to update a field on the APO product master.

There is the standard MATLOC_SET function available, but how do I specify that I want to use the key figure cell as the 'field value' to be used in the function?

Any advice appreciated...

[former_member187488 · Accepted solution]

Hi,

You can just use the macro builder's 'CELL' item as the paramter, or you use 'ROW' item controlled by the iteration definition.

Best Regards,

Ada

[m_manimaran]

Hi,

Another possibility is to get the value of the cell in a variable using LAYOUTVARIABLE_SET(), then calling this value in the MATLOC_SET() using the function LAYOUTVAR_VALUE().

Regards,

Manimaran M.