SAP

532

Solutions

3

Content

i
The collection of articles, videos, and posts on this topic.

801

Contributors

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

Share tech news, updates, or what's on your mind.

Sign up to Post

Dear Experts,

Could you please have a look this short code part, briefly its target is assigning a button text (from SAP application) to a variable, but if there is no such button then going further:

ErrMes = session.findById("wnd[2]/usr/txtMESSTXT1").Text
Debug.Print ErrMes
If ErrMes Is Nothing Then
    GoTo NoChangeMessage
Else
    ErrMes = session.findById("wnd[2]/usr/txtMESSTXT1").Text
    If InStr(1, ErrMes, "change", vbTextCompare) > 0 Then
    session.findById("wnd[2]/tbar[0]/btn[0]").press
    End If
End If

Open in new window


Actually it has the issue that the ErrMes variable got a value (as Debug.Print shows 'No changes were made' text assigned to it from the button), but then the VBA script stops at line 

If ErrMes Is Nothing Then

Open in new window

with error message:

Run-time error '424'
Object required


Could you please advise what is the nature of the issue there and eventually how to eliminate?

Thanks in advance,
0
3 Comments
Introduction to Web Design
LVL 12
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

Learn More!
I'm trying to get SAP to send a report to Excel 2013 but keep getting the error Missing activeX component  Business Explorer Global Services.

Someone mentioned that this will only work with Excel 2010 , which I find odd, but then again this IS Microsoft!

What can I do other than downgrade excel to get it working?

Excel Version:       Excel  (15.0.5059)       2013
Windows Version:       Windows 7 Service Pack 1 (7601)      
Default Browser:       Internet Explorer (11.0.9600.19101)      
SAP GUI:       720 Patch 15      

Thanks

Pete
0
7 Comments
Dear Experts,

Could you please advise in Python how to get all the attributes/methods of an object?

Actually I need to write a Python code which works together with SAP application and it took almost a week to find in separate Python codes through Google, that there are 'Info' and 'SystemName' attributes for the "SAPGui" object.

This code so works already with showing the system name of that connection in SysName variable:

import win32com.client

SapGui = win32com.client.GetObject("SAPGUI")
print(SapGui)
Appl = SapGui.GetScriptingEngine
print(Appl)
Connection = Appl.Children(0)
print(Connection)
Session = Connection.Children(0)
print(Session)
CollCon = SapGui.GetScriptingEngine.Children(0)
print(CollCon)

SysName = Connection.Children(0).Info.SystemName
print(SysName)

Open in new window


Now it can be even in one line:

FullAttr = win32com.client.GetObject("SAPGUI").GetScriptingEngine.Children(0).Children(0).Info.SystemName
print(FullAttr)

Open in new window


And here comes my question concretely - what is the way to find these attributes like Info and SystemName in Python for such outside application? I am using Spyder for writing Python code and the default tool which brings a list after pressing '.' for the object, it does not work for such outside application
Attribute finder in Spyder
Thanks in advance,
0
3 Comments
I have several fields i wish to concatenate and display as a single string within a detail section.  

a. Is there a limit on the number of fields that can be concatenated?
b. Is there a limit on the length of the resulting string?

When I run the report in SAP BusinessObjects XI 3.1 I get the following cryptic error when I try to go to the next page.
message: Syntax error
description: Syntax error
number: -2146827286
name: SyntaxError

However; when the report is ran in Crystal Reports 2008 it works fine.
0
2 Comments
Hi,

How to call windows exe file in ASP.NET Application which has been hosted in IIS.?

The exe does, fetching records from SAP and keep it in local folder.

I have been facing the below issues.

1) I am not able to call the exe file in ASP.NET file.
2) I am not able to connect SAP through ASP.NET which is hosted in IIS.

Can any one give idea/suggestion, how to proceed above scenario...?
0
8 Comments
Hi,

Our team is facing frequent disconnection while working on SAP kernel "connection partner broken" error.

WSAE:CONNRESET: connection reset by peer.

Error No: 10054

We are using IPsec tunnel between these two sites over public Internet cloud. Could you urgently suggest if there is any parameter to be checked at our firewalls (model Cisco ASA) where VPN configured.  

Anticipating favorable reply soon.

Regards

Srini
0
0 Comments
Dear EE,

We have licensed EAServer 6.3.1 software available.

Now we want to relocate our EAServer machine from one location to another. (Geographic relocation).

Please help us to confirm whether same EAServer license will work or we have to request SAP for another license.

As per our understanding EAServer license is bind with Server MAC Address.

Do we need to maintain same server name and ip address etc ?

Thanks
0
2 Comments
Is there any software that can record desktop screen. I am working on a SAP project which requires picking data 1 by 1 from the excel file and then  going to SAP field and thus saving it.
0
14 Comments
Running SAP Business One 9.2 on Windows 2012 R2 attached with HANA DB. Is there a global setting or parameter we can adjust so that the SAP system can force log out the user who is idle for certain period of time? The administration or license utility menu don't have such setting.
0
4 Comments
hi,

I need to create an SQL query that is performed by my application on SAP tables.  

The tables are:    
LTBP - Transfer order Item
LTBK - Transfer order header


Here's the existing code:

The following code is the driver for bringing back the open TR’s for the specified material. The is the LTBP (item table):

  sWhere = "SELECT TBNUM, TBPOS, MATNR, CHARG, MENGA, TAMEA, ALTME FROM LTBP WHERE " & _
                sMaterialClause & sBatchClause & " AND " & _
                "LGNUM = '" & mobjUser.Warehouse & "' AND ELIKZ <> 'X'"


New pseudo code:

Add a join to the header table to include the movement types:  101 and 103.
The movement type is in the header table.

  sWhere = "SELECT TBNUM, TBPOS, MATNR, CHARG, MENGA, TAMEA, ALTME FROM LTBP WHERE " & _
                sMaterialClause & sBatchClause & " AND " & _
                "LGNUM = '" & mobjUser.Warehouse & "' AND ELIKZ <> 'X'"    
JOIN TO THE HEADER TABLE (LTBK) field BWLVS (movement type is 101 OR 103)
0
4 Comments
Exploring SharePoint 2016
LVL 12
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

Start Today!
I have a table in Sybase with 500k rows with three columns and I would like write to a csv file using PowerShell IO write steamer using ODBC. Any help is appreciated.
0
1 Comment
My client asks me to create a web application in PHP that will interact with the SAP Business One Database. They say that the database is on the cloud using the Hana database.

Also, I am trying to download the sap Hana client software package trial version but they ask for a password, I enter correct password but the software package did not download and password prompt again appear.

Please guide me how can I create a connection and start web application in PHP that can interact with SAP Business One database. Are the database queries will be the same for the Hana database while writing code in PHP. I am the beginner I am totally confused. I read a number of articles but still confused.

Expert guidance will be appreciated.
0
0 Comments
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
0
9 Comments
Dear EE,

My application is using SAP file in UTF-8 format, for this purpose my application uses a a DLL “Interface_encoding.dll” to convert file into required format.

Some how , same user generates file on same PC and get the different file formats.
1) Sometime it is generated correctly in UTF-8 format
2) Sometime fie is created in UTF-8 BOM format.

Please see that we have checked for DLL registration and it was fine all the time.

Your support is required to find out the possible root cause and resolution.  

Thanks
0
2 Comments
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, …
0
5 Comments
Dear Experts

installing SAP ERP on-premise or on cloud recommended, if we go for on-premise what would be best way for business continuity  and recovery, is it recommended interbranch for DR and recovery or cloud please suggest the best recommended.
0
3 Comments
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
0
6 Comments
I am trying to identify where SAP business objects stores its users and credentials for accessing both the  central management console and the user console. From what I gather the 'universe' pulls data from a SQL Server, but the accounts listed in the central management console are not shown within the actual SQL Server, so I am unsure what the central management console communicates with for authentication. i cant see a specific sap Bi forum so hoping some of the SQL experts also use Bi in their environment.
0
2 Comments
capture1.PNGsap 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 …
0
3 Comments
CompTIA Cloud+
LVL 12
CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Learn More!
I want to convert an existing Sybase code to oracle?
I am very new to oracle, and don't have much knowledge on Sybase.
What approach should I follow?
0
2 Comments
I have a Sybase Anywhere 16 database. I was wondering if there was anyway of see who or when a row or column was last changed. I am thinking there is not but I am not that familiar with Sybase.
0
2 Comments
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?
0
0 Comments
Dear Experts

Our organisation has decided to implement ERP -   our management is convinced with SAP to be chosen however not yet finalized, our objective is to have one unified solution across the organisation at present we are using sales force.com for marketing and sales function,
1. would like to understand does SAP has capability for sales force automation and does it support the integrations like CTI, web, face book, mainly does it allow web API integrations
2, if not SAP please suggest other ERP product which can handle sales force automation and other process, we are in real estate vertical (we do not construct we only sell the flats).
3. what all the measures to be taken to implement ERP,  is CIO needed as the technology is one part, do we require Consultant who has implemented in our vertical and project manager who leads the implementation,
4. please help me with the list for the need of technology and IT head role in detail for this project similary consultants and Project Manager and what are various types of roles to be put in place to choose and start ERP implemtetion who can drive and implement successfully.
5. Please let me know the approach or methodology for implementing the  ERP what top management should do and what all the roles to be created to implement the ERP, thanks
0
3 Comments
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
0
12 Comments
sap sql connection webserices how to read
0
0 Comments

SAP

532

Solutions

3

Content

i
The collection of articles, videos, and posts on this topic.

801

Contributors

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

Advertise Here
Top Experts In
SAP
<
Monthly
>
Hall of FameAnnual Expert Awards
Advertise Here