Data extraction from auxillary key figure

[Former Member]

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

[Former Member]

As Subash suggests.... create new Z key figures. In your data view create a macro where row ZKey Figure = Row auxiliary key figure.

In your planning area generate/ repair your datasource  to ensure the new key figures are available for downstream extraction to BW cubes etc.

[Former Member]

Hi,

Thanks for the response.

However is there a standard FM to extract the data directly in flat file without requiring to use BW datasource.

Thanks,

Sanjog

[Former Member]

Hi Sanjog,.

Please use BAPI_PBSRVAPS_GETDETAIL2 to extract from LC.

Regards

Rorie

[former_member182607]

Sa jog,

Create ate a time series key figure, add it to the SNP planning area/book/data view and change the macro appropriately. This is what we have done in all implementations.

Thanks,

Subash

[Former Member]

Can you also let me know which FM can be used for extracting data from the TS key figure?

Thanks,

Sanjog

[former_member182607]

Sanjog,

I saw this pretty late...will respond in the next couple of days...

Subash