Is there a way to import data from SAP in global table?

Question

question

Ankita P asked Sep 17, '18 Joerg Vogel edited Sep 18, '18

Is there a way to import data from SAP in global table?

How to import data from an excel file stored in a shared network drive?

Software Version:

FlexSim 18.2.0

import data data import

· 2

Joshua S commented · Sep 17, 2018 at 07:47 PM

You can export data from SAP into excel format I believe, then import it into Flexsim using the Excel importing tool. Search "Excel" in the user manual in Flexsim for more information on how to import files from Excel into Flexsim. Are you currently having problems with importing your excel file from the shared network drive?

0 ·

Ankita P Joshua S commented · Sep 18, 2018 at 05:11 AM

Yes, I am facing issues there as well.

If the drive is not mapped in the system, the network path specified in Flexsim gets preceded by the local path where the Flexsim model is saved. And it throws Excel Read Error.

And if I map the drive in local system, then also Flexsim is throwing Excel Read Error.

0 ·

Answer 1 · 2018-09-18T06:16:18Z

Joerg Vogel answered Sep 18, '18 Joerg Vogel edited Sep 18, '18

Please read and adapt the information on your system

SAP help business warehouse connection (Live Data Connection to SAP BW via HTTP Server (SAP Data Center))

in combination with JSON in FlexSim

read and write json data.

Please don't contact me on this directly again, I am not an SAP expert not even a user nor am I a data interface expert.

Answer 2 · 2018-09-18T06:02:52Z

Joerg Vogel answered Sep 18, '18

Please copy the file to a local directory. You can try to this within FlexSim or a batch file. You copy your data from the local copy. You prevent difficulties concerning 2 or more people try to access the shared resource.

question