Hello. I use SAP to extract various information from the screen manually. I would like a help with a script (VBA / SAPGUI) that searches the entries in a worksheet and copies the SAP information and saves it in an excel spreadsheet. can you help me?

I enter a transaction (ZPDIS_MM_BMD), with the contract number (4600xxxxxx), which shows a list of projects, then I choose one in the second column of these processes and I click for more information, then it has the information I need, it is not editable . There are several contracts and each contract has a list of projects.
Steps.pdf

Hi Anyone,

My SAP User suddenly unable to login to the system so login to SAP server to restart the system to temporary solve the issues. Found a lot of errors as in below for your kind advice.    
App Event
Event ID: 1000
Faulting application name: SCNotification.exe, version: 5.0.8239.1000, time stamp: 0x552cebe1
Faulting module name: KERNELBASE.dll, version: 6.3.9600.18666, time stamp: 0x58f32841
Exception code: 0xe0434352
Fault offset: 0x00015608
Faulting process id: 0x6f98
Faulting application start time: 0x01d411cc302080bf
Faulting application path: C:\Windows\CCM\SCNotification.exe
Faulting module path: C:\Windows\SYSTEM32\KERNELBASE.dll
Report Id: 6de281cc-7dbf-11e8-81b8-005056a12199
Faulting package full name:

Event ID: 1026
Application: SCNotification.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.Net.Sockets.SocketException
   at System.Net.Sockets.Socket.DoBind(System.Net.EndPoint, System.Net.SocketAddress)
   at System.Net.Sockets.Socket.Bind(System.Net.EndPoint)
   at System.Net.Sockets.TcpListener.Start(Int32)
   at System.Runtime.Remoting.Channels.ExclusiveTcpListener.Start(Boolean)
   at System.Runtime.Remoting.Channels.Tcp.TcpServerChannel.StartListening(System.Object)
   at System.Runtime.Remoting.Channels.Tcp.TcpServerChannel.SetupChannel()
   at System.Runtime.Remoting.Channels.Tcp.TcpServerChannel..ctor(System.Collections.IDictionary, …

How can I do the following using SAP BusinessObjects Enterprise XI 3.1

a. Publish a Crystal Report. (Done)
b. Schedule the report to run once a month. (Done)
c. Save the report (pdf) to a folder in the root of BOE XI 3.1 (To Do)

The pdf should be available for predesignated group of individuals to view at there leisure.

Is this doable?  Please provide detailed steps to make this happen.

Thanks

sap gui scripting , how do you get the value of a read only field that doesn't show up in the script!

The code from the script I can extract is as follows!

session.findById("wnd[0]").resizeWorkingPane 175,31,false
session.findById("wnd[0]/usr/tabsTABSTR_2100/tabpTRMN/ssubSUBSCR_2100:SAPLCOKO:2110/cmbCAUFVD-TERKZ").setFocus
session.findById("wnd[0]/mbar/menu[4]/menu[0]/menu[2]").select
session.findById("wnd[1]/usr/ssubCUSTSCR1:SAPLXCN1:0900/ctxtCOCI_AUFK-ZZ_VBELN").text = ""
session.findById("wnd[1]/usr/ssubCUSTSCR1:SAPLXCN1:0900/ctxtCOCI_AUFK-ZZ_SCHEDMGR").text = "111"
session.findById("wnd[1]/usr/ssubCUSTSCR1:SAPLXCN1:0900/ctxtCOCI_AUFK-ZZ_SCHEDULER").text = "111"
session.findById("wnd[1]/usr/ssubCUSTSCR1:SAPLXCN1:0900/ctxtCOCI_AUFK-ZZ_DSGNMGR").text = "111"
session.findById("wnd[1]/usr/ssubCUSTSCR1:SAPLXCN1:0900/ctxtCOCI_AUFK-ZZ_DSGNTECH").text = "111"
session.findById("wnd[1]/usr/ssubCUSTSCR1:SAPLXCN1:0900/cmbCOCI_AUFK-ZZBAM_FUNCA").key = "DATA"
session.findById("wnd[1]/usr/ssubCUSTSCR1:SAPLXCN1:0900/ctxtCOCI_AUFK-ZZBAM_ID").text = "www"
session.findById("wnd[1]/usr/ssubCUSTSCR1:SAPLXCN1:0900/txtCOCI_AUFK-ZZBAM_VOL").text = "11121"
session.findById("wnd[1]/usr/ssubCUSTSCR1:SAPLXCN1:0900/txtCOCI_AUFK-ZZBAM_VOL").setFocus
session.findById("wnd[1]/usr/ssubCUSTSCR1:SAPLXCN1:0900/txtCOCI_AUFK-ZZBAM_VOL").caretPosition = 5


The field I need to capture in the uploaded screen capture1 where it says work for others third party!  

I …

Hi Team,

I have downloaded .rtf file from SAP by using Tcode "STAD"

How I can Analyse/Read STAD log file (.rtf format) using excel Macro?

I'm trying to find the lib reference for access 2013 for SAPGUI.  
In tool-reference I need the SAP scripting API and it says to look for the Sapfewse.ocx file
in the program/sap folder , but its not there and I can't find a download link anywhere.
I'm wondering if it was replaced by another api !  
I tried on the SAP site and can't find it there either.

Any suggestions as to where to get it .

Thanks

Pete

hi,

I have been asked to document a process the credit check process in SAP.   Specifically a custom ABAP program called: "Z_ BYPASS _ ORDER _ CREDIT_ CHECK".
I am not very experienced in ABAP but I do have experience in programming in general with visual studio.

I would like to be able to debug this program and see what is happening but I am unable to do so (see screenshot below:).

My question:

1. Is it possible to for me to debug this "Z_ BYPASS _ ORDER _ CREDIT_ CHECK" routine? if so, how?

Thanks

Running some hourly query using sybase client in my linux machine.

Getting Out of memory error

*** OutOfMemoryError ***
Request type=3


,containsODBCEscapeSequence=false,cachingHint=2,warning=null,error=null,errorMessage=null,resultsProcessor=sybase.isql.Console]
Exception in thread "Image Fetcher 0" java.lang.OutOfMemoryError: Java heap space
        at sun.java2d.loops.GraphicsPrimitiveMgr.register(Unknown Source)


Please check this error and help me.

Hi ,

Is there any technical specification document on how to integrate with ARIBA for automation.

I am only looking at login specifications.

Thank you,

Hey guys,

I am working with SAP and excel on daily basis. Part of the job is copy paste data frome excel to sap.

I've created macro that helps me to do that. The problem is macro copying pasting data only cel by cell.

I need to copy paste by 25 cells.

Any suggestions how can adjust my script so I can copy every 25 values and paste them?
Script is attached

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
 
Set xclapp = CreateObject("Excel.Application")
Set xclwbk = xclapp.Workbooks.Open("C:\.....\test.xlsm")
set xclsht = xclwbk.Sheets("Sheet1")
 
for i = 2 to xclapp.ActiveCell.SpecialCells(11).Row
 for j = 1 to xclapp.ActiveCell.SpecialCells(11).Column
  if j=1 then SKU =  xclsht.Cells(i,j).Value

 next

session.findById("wnd[0]").resizeWorkingPane 254,39,false
session.findById("wnd[0]/usr/tblSAPMV13GTCTRL_FAST_ENTRY/ctxtKOMGG-PMATN[0,0]").text = SKU
session.findById("wnd[0]/usr/tblSAPMV13GTCTRL_FAST_ENTRY/ctxtKOMGG-PMATN[0,0]").setFocus
session.findById("wnd[0]/usr/tblSAPMV13GTCTRL_FAST_ENTRY/ctxtKOMGG-PMATN[0,0]").caretPosition = 0
…

Dear Experts,

Actually writing a code with SAP scripting (a special scripting language for SAP application) in VBA and got to an issue, could you please advise in it?

I would like to assign a content to the variable ErrMes with the following line,

ErrMes = session.findById("wnd[2]/usr/txtMESSTXT1").Text

Select all Open in new window

which is basically a message text on Window 2 in SAP application (wnd[2]), but that might not appear at all in certain scenarios.

Briefly the issue is that if that does not appear in the application then there is nothing to assign to the variable and the VBA code stops. Do you have idea eventually how to handle those exception cases?

Thanks in advance,