Question Re: Process Runner in Additional Q&A

Process Runner

Former Member — Tue, 30 Dec 2014 07:59:10 GMT

Hi,

How to run SAP via excel... For example the data needs to be captured from excel and to updated in SAP.

Re: Process Runner

Laszlo_B — Wed, 31 Dec 2014 13:00:24 GMT

Hello Arul,

could you please give more information what exactly is needed to be achieved here?

E.g.: an Excel file needs to be uploaded to the Application Server? Or the data from an Excel file needs to be exported into an SAP Report?

Best regards,

Laszlo

Re: Process Runner

Former Member — Tue, 13 Jan 2015 12:55:42 GMT

Hi Laszlo,

I created a script to capture data from excel and paste it to SAP...It's working fine.

Now i have another question : Can you please give a script to Browse folders in SAP?

For Example : I'm writing a script to create attachment in FB03 and i'm unable to find a code to browsing and selecting a file.

Thanks

Arul

Re: Process Runner

Laszlo_B — Tue, 13 Jan 2015 14:06:52 GMT

Hello Arul,

transaction AL11 makes it possible to browse the folders of an SAP Instance - you can check the coding behind this transaction to see which techniques can be used.

My document http://scn.sap.com/docs/DOC-55795 shows examples how files can be browsed and downloaded from SAP servers.

Perhaps it can also show some ideas how files can be uploaded (by looking for similar programs).

Best regards,

Laszlo

Re: Process Runner

Former Member — Wed, 14 Jan 2015 10:17:05 GMT

Hi,

I need SAP Script to select a file from my C:\ drive?

Re: Process Runner

Laszlo_B — Wed, 14 Jan 2015 10:24:14 GMT

Hello Arul,

you can test the OPEN DATASET command for that.

The URL

ABAP Keyword Documentation

shows information regarding this command.

Best regards,

Laszlo

Re: Process Runner

Former Member — Wed, 14 Jan 2015 11:26:18 GMT

Hi,

I think you don't understand my question

The below is a script and Now I need script only to browse my files.

It's very simple logic.

If Not IsObject(application) Then

Set SapGuiAuto = GetObject("SAPGUI")

Set application = SapGuiAuto.GetScriptingEngine

End If

If Not IsObject(connection) Then

Set connection = application.Children(0)

End If

If Not IsObject(session) Then

Set session = connection.Children(0)

End If

If IsObject(WScript) Then

WScript.ConnectObject session, "on"

WScript.ConnectObject application, "on"

End If

session.findById("wnd[0]").maximize

session.findById("wnd[0]/tbar[0]/okcd").text = "fb03"

session.findById("wnd[0]").sendVKey 0

session.findById("wnd[0]/usr/txtRF05L-BELNR").text = "93000001"

session.findById("wnd[0]").sendVKey 0

session.findById("wnd[0]/titl/shellcont/shell").pressContextButton "%GOS_TOOLBOX"

session.findById("wnd[0]/titl/shellcont/shell").selectContextMenuItem "%GOS_VIEW_ATTA"

-------------------------------------------------------------------------