SAP IBP - Get List of atributes in VBA

[osullo]

Hi,

I'm running SAP IBP. I was wondering is there is a way, using VBA, to recieve a list of the values of attributes shown in a planning view.

Let say I have a planning view that is filtered by certain criteria, and the results will show Product Number and the projected stock of each one as a key figure. I would like to obtain an array of the product numbers shown in the results using VBA.

Is that possible with the IBP API (In fact i dont know if that even exists)? or do i have to do a basic VBA that will do it after the results are shown in the planning view?

Thank you.

[piyush_parekh · Accepted solution]

Hi,

You can use OData service to extract MDT records. However, this option is not recommended for mass data extraction!!

https://help.sap.com/viewer/feae3cea3cc549aaa9d9de7d363a83e6/2005/en-US/77e394ba87cb4b3b9860c98a3f4d...

There is also an OData service available to extract attributes and filters in a planning view which you can then further use as filters to extract data from above API. However, it is mentioned that this service (planning view template attributes/filters) is restricted for non-productive use. I would suggest to reach out to SAP to get a clarity on the 2nd API.

Regards,

Piyush

[former_member194529]

Hi Luis,

There is no such standard API available to fulfill your exact request. Sure, developing custom VBA code on your own is a possibility in case you implement it and enable its support.

Best,

Ivan