[Webinar] Streamline your web hosting managementRegister Today







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

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
Free Tool: SSL Checker
LVL 11
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hi everyone
We are going to put our SAP vm servers in best mode of virtualization and i am also want to follow the vmware best practice to have more effiency and prrformance especially for my Production vm server:
Here is my equipments :
2 Hp Dl580G7
Ram : 448 Gig
Physical NIC : 8 port 1G
Cpu : 3 number 4830 in each host
Vcenter .6.5 vcsa
Storage : vnx 5400& vnx 5200
Core Switch :3750
Server farm swtches : 48 port 2950 l2 switches
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


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]").caretPosition = 0
Please provide me link on official SAP download site to download SAP IDES for Windows 2012 server. I need to practice Basis etc.
Dear, is there a way to prove that Sybase replication server was running in  a past date, and replicated database was synchronized with the production.
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,
Dears, I have sybase replication server 15.7
I ran sysadmin hibernate_on to be able to purge queues, now I try to run sysadmin_off but the server became hung and not reactive , even after  restarting the sybase service .

please advice how can I re-active the server and finish its hibernation mode
I need a macro that will move the following columns from the TC Download to the HR Region Download

D      SAP Person ID
G      Job Family
H      Job Code
I      Job Title
J      Current Salary Grade
P      Country Desc
Q      Current Planning Salary - Annual
S      Local Currency
W      Mid
AF      Equity Increase
AJ      Promotion Increase
AM      Total Budget %
AN      Total Increase
AP      %Total Increase
AQ      New Salary
AZ      New Job Code
BA      New Salary Grade
BE      New Job Family
BF      New Min
BH      New Mid
BJ      New Max
BL      Employee Bonus Eligibility
BM      FIP Rating
BQ      Select GEBP Tier Level
CF      Discipline Description
CI      SBE
CJ      SBU
DB      New Job Title
DC      Salary Notes
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.
kindly note I ran sp_sysmon and this is a partt from it:

Data Cache Management

  Cache Statistics Summary (All Caches)
                                  per sec      per xact       count  % of total
                             ------------  ------------  ----------  ----------
Large I/Os Denied due to
        Pool < Prefetch Size          0.2           0.0           9      11.8 %
        Pages Requested
        Reside in Another
        Buffer Pool                   0.4           0.1          25      32.9 %

    Total Task Switches:           5949.2         807.6      356950

  Task Context Switches Due To:
    Voluntary Yields                 16.0           2.2         960       0.3 %
    Cache Search Misses              19.4           2.6        1162       0.3 %
    Exceeding I/O batch size          0.0           0.0           0       0.0 %
    System Disk Writes                1.3           0.2          76       0.0 %
    Logical Lock Contention           0.2           0.0          10       0.0 %
    Address Lock Contention           0.0           0.0           0       0.0 %
    Latch Contention                  0.0           0.0           0       0.0 %
    Physical Lock Transition          0.0           0.0           0       0.0 %
    Logical Lock Transition           0.0           0.0           0       0.0 %
    Object Lock Transition            0.0           0.0        …
[Webinar] Kill tickets & tabs using PowerShell
LVL 11
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

SAP BEX Analyser only opens Excel formatted sheet partly in Black and white instead of Full colour?
Dear Team,

Following is the error is received in the ASE errorlog,

Error: 12301, Severity: 20, State: 1
00:0002:00000:00211:2017/12/13 17:57:16.79 server  Internal error: the index (id = 2) and the data for row (26710892, 25) in table 'BUT000', database 4 are inconsistent; data is marked deleted but index is not. Aborting the transaction.

After that not able to connect dataserver, below is the error,

--Server is up and running but i'm getting below error Read from the server has timed out.

$isql -U -S -P
        ct_connect(): user api layer: internal Client Library error: Read from the server has timed out.
Here is the solution for that question,  

select sysuser.user_name,table_name,systableperm.*
from systable,systableperm,sysuser
where stable_id=systable.table_id
and systableperm.grantee=sysuser.user_id
and sysuser.user_name='put_user_name_here'
Hello everyone
any way to export the SAP "ksb1" into excell ?
SAP BEX Analyser only opens Excel formatted sheet partly in Black and white instead of Full colour?
SAP BEX Analyser only opens Excel formatted sheet partly in Black and white instead of Full colour?
LVL 26

Expert Comment

by:Brian B
Hi Cesar. You have entered this as a post, but it looks like you are asking for help. To get the best response from the Experts, you should probably re-submit this as a question using the "ask a question" button at the top of the page, or this link: https://www.experts-exchange.com/askQuestion.jsp

If you do ask a question, please post the link to it back here so others can find your question and help you more quickly.

Please see here for further details: http://support.experts-exchange.com/customer/portal/articles/756544-how-to-succeed-at-ee-as-an-asker
After providing the user name and password , while enabling the submit button after 2sec, system throws an error as internal error (-1102) occurred [Message 131-183]
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.
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.
The 14th Annual Expert Award Winners
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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


Thank you in advance

Javier W. Barbieri
Lima, Peru
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


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

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

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.


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






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