nx hd3d visual reporting reads erp sap data

GEA Farm Technologies

Review of implementation Matthias Ahrens – Technical Solutions Architect 100164 BU Dairy & Farm Equipment - BU-Support 2014-11-10

NX HD3D Visual Reporting reads SAP ERP data

GEA Farm Technologies 2 2014-11-10 / NX HD3D Visual Reporting reads SAP data / M. Ahrens

• Extend the utilization of the HD3D visual reporting capabilities of the SIEMENS PLM NX 3D CAD system.

• Embrace business relevant ERP data, managed inside SAP system, into the scope of information sources for HD3D.

• Provide visual analysis capabilities for project relevant business date to engineers and project managers to support faster and smarter decision process.

• Establish NX HD3D Visual Reporting tool as extension to spreadsheet based reporting processes.

• Within the product development process support the transition step from early concepts designs into first lot serial production.

Intent of implementation


• The system landscape of the GEA segment Farm Technologies consists of a strong SAP backbone, which is utilized to manage and guide all ERP relevant data and processes.

• To support early product development phases a 4Tier Teamcenter PLM backbone is in place with a connection to NX as CAD authoring tool.

• Entire architecture is spawning multiple departments across various global locations.

The system landscape

SAP T4S Teamcenter 8.3

NX 7.5

Product design: Mainly plant neutral Production execution: plant specific


• In comparison to other processes (e.g. ETO) the GEA Farm Technologies is running a product development process, which is starting parallel to the autonomous product execution process.

• The product development process ends with adopting the new product into the standard catalogue of product offerings.

The process landscape

Product development process

Production execution process


• During the product development process exists a phase where the design and leadership will leave the CAD / PDM framework and will handed over to the ERP framework.

• In this stage technical date like drawings and Bill Of Materials have to be handed over and have to be synchronized.

• From that point on the ERP is leading and every change has to be processed according to ERP requirements.

• The regular review of ERP and other business data is important to get accurate information for faster and smarter decisions.

The PDM (PLM) – ERP handshake

Early Concepts

Rel

evan

ce

Final Production

Area of interest for implementation of HD3D Visual Reporting & SAP Data Lookup inside NX CAD


• ERP Information, which are of interest during the phase of handshake • Plant specific material status • Plant specific procurement type • MRP group • In-house production time • Vendor • …

Project relevant information inside ERP


• Two major architectural concepts were evaluated to feed HD3D Visual Reporting tool inside NX CAD. a) Routing of SAP data via Runtime Properties with the T4S interface into the

Teamcenter PLM framework and make them available for NX CAD. b) Generate an additional SAP Data Lookup tool in VB.NET, which gathers

SAP data and add them temporarily to the NX CAD assembly component.

Comparison of technical concepts

SAP T4S TC NX SAP T4S TC NX

UG Open

Concept a) Concept b) Advantages: Standard tools Disadvantages: High stress on T4S interface by permanent runtime property gathering. Processes sap data lookup on component level.

Advantages: Full customizable! Less stress on T4S interface! Can be applied on demand! Processes numerous data lookups in one shot. Disadvantages: Custom programming


• An additional, customized SAP Data Lookup application for NX was created inside UGOpen, which is utilizing SAP RFC calls to gather data directly from SAP ERP and populating component attributes.

Technical solution: Concept b)


• The application was design with UGOpen to get NX look and feel.

Technical solution: SAP Data Lookup application


• The application creates temporarily component attributes.



• These component attributes can be used in HD3D Visual Reporting.



• As lookup key a part attribute is used, which contains the SAP Material ID, which is more common used in terms of ERP processes.

• By the SAP Data Lookup application and another customized application, which can use EXCEL spreadsheets as source, the data visualization scope of HD3D was expanded.

HD3D Visual Reporting source information


• By the capability to gather nearly every relevant ERP information, stored inside SAP, and other project related information, which are managed by EXCEL spreadsheets, the HD3D visual reporting application of NX becomes a cross domain spawning business data visualization tool.

HD3D Visual Reporting as information dashboard


• There were no SOAP or other web based SAP connectors available. • A technical challenge was the difference in the application

architectures. SAP client is 32 Bit while NX is 64 Bit.

SAP Data Lookup: Technical challenges

UGOpen VB .NET DLL

.XLSM with

SAPLOGON

SAP Data Lookup RFC

MS EXCEL Interop.


• A macro enabled EXCEL workbook, referencing a SAP Logon control object, is called by the NX UGOpen VB.NET application.

• The SAP RFC function “RFC_READ_TABLE” is utilized and the query options are defined in the UGOpen VB.NET application script.

SAP Data Lookup: Technical solution

16 2014-01-13 / PLM Implementation at GEA FT / M. Ahrens

nx hd3d visual reporting reads erp sap data

Engineering

nx hd3d visual reporting

erp gea farm technologies

nx cad gea farm technologies

erp relevant data

sap system

reporting processes

gea segment farm technologies

business data