Skip to Content
author's profile photo Luis Ferrer
0
Luis Ferrer

SAP IBP - Get List of atributes in VBA

Posted on Jun 18, 2020 at 01:00 PM 76 Views

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

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Piyush Parekh
    Piyush Parekh
    Posted on Jun 18, 2020 at 01:40 PM
    0

    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

  • author's profile photo Ivan Andreis
    Ivan Andreis
    Posted on Jul 29, 2020 at 09:03 PM
    0

    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.