Skip to Content

SAP IBP - Get List of atributes in VBA

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jun 18, 2020 at 01:40 PM

    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/77e394ba87cb4b3b9860c98a3f4df47e.html

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 29, 2020 at 09:03 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.