Data extraction from auxillary key figure

Hi,

In our project we are using CTM for SNP planning.

Stock on hand projected is calculated using macros.

The client wants the stock on hand project number for reporting purpose.

Is there a way to run macro job to calculate the stock on hand value and then extract the value in custom table.

If anyone have worked on similar requirement can you please share the approach.

Thanks,

Sanjog