SAP

525

Solutions

797

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 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
Cloud Class® Course: Microsoft Windows 7 Basic
LVL 12
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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
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
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
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
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
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
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
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
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?

ThanksAbap - when trying to debug
0
Cloud Class® Course: Microsoft Exchange Server
LVL 12
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

I can not see the multiple select button in SAP.  What do I need to do to make them available.
0
Need to know if its possible in SAP Plant Maintenance to do a manual call on just ONE maintenance item # on a multi-item maintenance plan. For example, I have a maintenance plan # 1001 that has 99 task list items on it, varying in intervals from daily to annually, and one of those task lists maint items is # 567, I want to manually call just that 567 item to generate a work order tomorrow. I know if I were to create a maintenance plan for every task list, this would not be a problem, but my maintenance plans have many task lists on them and I cannot figure out how to manually call just ONE of them and not any others on that maintenance plan.
thx experts
BobR
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

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,
0
I have a conditional detail section where the condition is : Suppress if Qty = 0
The output I get is as below:
Record Number        Description         Qty
1                                  pencil                   3
3                                  pen                       5
4                                  eraser                  1
.
.
.

Due to suppress condition in detail section the record numbers are not printing properly.

Any work around on the above.
0
Hello everyone
any way to export the SAP "ksb1" into excell ?
thanx
0
I am migrating from an older version to CRS 2013 where I am unable to locate the BVM.  I've gone back in the install package seeing if I missed the install section and didn't see it even in it.  In web searches it shows I should be able to locate it in:  SAP BusinessObjects BI Platform Client Tools, however unable to locate this also.
0
I am having a multiple cross tabs (on page 4 of 4)  in my report displayed below attach image
Issue1.jpgI want to merge the rows for same name list.
As you can see, "Running Time" is repeating twice. I have taken sorting ID to bring the Values in the required format instead of viewing in Alphabetical order.

Below is the location.
https://drive.google.com/open?id=1sH07hjkIqn5JG8G8EsyX6wEe53MzbpDh
0
Weird Behavior...

Hello friends:

I have developed a project using Sybase Power Builder 12.5. The application is using a mysql database and

running on Windows 8. The application works fine but I have found a weird behavior on certain windows. Let's

say, if you click on the "X" icon located at the top right, the window will be closed normally or if you try ALT

+ F4 as we know it will do the same.

This is what happen with certain windows... The final user wanted me to code the ESC key, so when the user hits

that its when the application window will close right away... I just added a simple command button and check on

the property "cancel" on that command and it will execute the script inside that button... for my own cdoulase I

just added the command "CLOSE(PARENT)" inside that script add thats all !! But this is what happens... I hit the

ESC and the application produces an exception and crashes. Any idea what would be the source or origin of this

problem?

Thank you in advance


Javier W. Barbieri
Lima, Peru
0
I have two stored procedures in one report. My main stored procedure is procSSFTP_RPT_WorkAndRestDailyReport and 2nd stored procedure name is procSSFTP_RPT_GetCrewComments.

I want to display "Seafarer name" from my 1st stored procedure and "comments" from 2nd stored procedure.

I have multiple rows for the comments against the single seafarer name.

Instead of showing multiple rows of comments for single "seafarer name", I want to display one comment per "seafarer name".

Attached is the report for your reference

https://drive.google.com/open?id=1nb_DOgTVjFD1d-YdRR8jUX2omN5yO8KV
0
Cloud Class® Course: CompTIA Healthcare IT Tech
LVL 12
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Hi,

I want to increase the width of label border to 1 pt as for now it is only hairline.
The options available in the format section are single border, double, dashed and dotted.

I will be exporting this report to excel, so how to avoid the unwanted spacing of sections?

Attached is the report:
https://drive.google.com/open?id=1YTkq8UP5MtVJqMF_MvIlXkLVZm2DnDUe
0
Dear Experts,

I have the following VBA code which is structured like that the SAP login details are in MainStream(), which calls the XK02_ReconAccount_AQ1() sub to fill the SAP screens through SAP scripting:

Sub MainStream()

login = InputBox("Please provide SAP user")
pass = InputBox("Please enter password")
system = "AQ1"

Set SapGui = GetObject("SAPGUI")
Set Appl = SapGui.GetScriptingEngine
Set Connection = Appl.OpenConnection(system, True)
Set session = Connection.Children(0)

Dim LastRow As Long
Dim StatusBarText As String
Dim StatusBarMessageType As String
With ActiveSheet
    LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
End With

' Modify here the credentials and SAP system

session.findById("wnd[0]/usr/txtRSYST-BNAME").Text = login
session.findById("wnd[0]/usr/pwdRSYST-BCODE").Text = pass
session.findById("wnd[0]").sendVKey 0
session.findById("wnd[0]").maximize

Call XK02_ReconAccount_AQ1

End Sub


Sub XK02_ReconAccount_AQ1()

session.findById("wnd[0]/tbar[0]/okcd").Text = "XK02"
session.findById("wnd[0]").sendVKey 0

ActRow = ActiveCell.Row

For i = 1 To LastRow

session.findById("wnd[0]/usr/chkRF02K-D0210").Selected = True
session.findById("wnd[0]/usr/ctxtRF02K-LIFNR").Text = ActiveCell.Offset(i, 0)
ActiveCell.Offset(i, 0).Interior.ColorIndex = 6
session.findById("wnd[0]/usr/ctxtRF02K-BUKRS").Text = ActiveCell.Offset(i, 1)
ActiveCell.Offset(i, 0).Interior.ColorIndex = 6
session.findById("wnd[0]").sendVKey 0

Open in new window

0
How can I achieve the date in "DD MMM YYYY" format in formula field of Crystal report.

I have one formula, where I am concatenating the Country name with the Date.

It takes the system format when the report is generated.

How can I fix the format to "DD MMM YYYY"

Currently on my system is displaying "DD-MM-YY" and on my colleague's System is s displaying "mm/dd/yyyy"

Attached below is the image and the shareable link for the Crystal Report.
https://drive.google.com/open?id=1YHdKcGzXllrOV0-PHWZ7uxul0IELeBle

AnalysisError.jpg
0
Hi,

I want to replace the Column A with the adjacent Column B if column A data is NULL (dynamically shifting).

For more reference kindly find the attached image
Image1.jpg
0
Good Day All

I have a client who recently migrated from Exchange 2010 to 2016. After decommissioning their old 2010 Exchange server, they are now unable to send mails from SAP as the receive connector is now not on the Exchange 2016 server and needs to be recreated.

I tried recreating it as it was using old screenshots of all the settings. And the SAP has been changed to point now to the 2016 servers IP by the client.

SAP is still unable to send any mails via the Exchange.

Can someone please assist? Is there anything that needs to be restarted from the SAP side after make such a change?
0
Hi,
 
I have two Stored procedures in one crystal report. Both having same parameters.
But when One stored procedure data is NULL then other stored procedure data is not visible on report which has data in it.

If I do Browse Data for another stored procedure which has data then the data is clearly visible in Browse Data Dialogue box but not on  report.

For example, refer the attached report link : https://drive.google.com/open?id=0By-_z66pGEGrb3RtVHd6cTNPLXc
Purchasing_IssuePurchaseOrderReport.rpt
0

SAP

525

Solutions

797

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.

Top Experts In
SAP
<
Monthly
>