in SolidWorks, get data from SAP without additional installations

[former_member738644]

Hi,

I'm trying to come up with a way to get data from SAP into SolidWorks, e.g. for each part in an assembly, look up a property like "Prize" in SAP, and use it in SolidWorks.

I'm a noob when it comes to SAP, and I haven't been able to identify the correct search terms to find the right Q&A/help so far, so I apologize if I missed a similar question.

I want to build an Add-In for SolidWorks that doesn't need additional installations like the SAP connector.

The Add-In will be .Net based, probably using C#.

The interaction will be: check if SAP is open and logged in, for a list of item numbers look up and return the list of their property values (might want to look up more than one value per item number), done

Is this possible without additional installations, and how?

Any help is much appreciated, including annoyed references to existing questions/answers.

Thanks!

Stefan

[former_member34]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with our Q&A Tutorial: https://developers.sap.com/tutorials/community-qa.html, as it provides tips for preparing questions that draw responses from our members. Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://www.youtube.com/watch?v=46bt1juWUUM

Many thanks!

[GerhardHimmelsb]

Hi Stefan,

with SAP Engineering Control Center, you can do this out-of-the-box.

There is a mapping from DIR/Material fields to properties inside the CAD files, see config guide, starting page 11.

Hope this helps.

Regards,

Gerhard Himmelsbach

- Product Owner SAP ECTR -

[sdalmaso]

I've made some search about the connection between SAP and Excel - since Solidworks API allow you to use VBA as well you can focus on this type of documentation

https://blogs.sap.com/2006/12/14/read-any-sap-tables-from-excel/

By the way, ECTR is the ready made product - we use it in pair with Inventor but it is quite the same. Of course ECTR gives you not only the "READ" feature, you can also WRITE on SAP.

On the other hand, if you just need to read material price data maybe you shoul work on the VBA - it is not a walk to set up and manage the ECTR project - and it's not for free

Best

Samuele Dalmaso