SAP

516

Solutions

778

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

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
Free Tool: Site Down Detector
LVL 12
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

sap sql connection webserices how to read
0
I can not see the multiple select button in SAP.  What do I need to do to make them available.
0
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.
0
The below query is regarding the Credit and Invoice tables in SAP but gives me either only Credit information for items I don't want or gives me a lot of extra information that I don't want either.  Can anyone assist with the last line of this query? I am unsure what I need to correct. I have tried the words 'and' and 'or' and both give me false info.
(
({?Division} = 'A') or
({?Division} = 'M' and {OCRD.QryGroup3} = 'Y') or
({?Division} = 'C' and {OCRD.QryGroup1} = 'Y')
) and
{NBS_Invoice_Credit.PostDate} >={?StartDate} and
{NBS_Invoice_Credit.PostDate} <= {?EndDate} and
 ({INV1.TargetType} in [-1, 14, 15] or {RIN1.TargetType} in [14 ])
0
I have an question if there is a possibility to load SAP ASE database  dump from ASE server running on HP-UX to Linux.
I found a tech-note on sap help, but it haven't directly answered my question.
Dumping and Loading Databases Across Platforms

Did someone perform successfully such type of restore between these two platforms?
0
Hi ,

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

I am only looking at login specifications.

Thank you,
0
I have a list of SAP manufactures  numbers and I need to find the suppliers associated with them.

How do I do this in SAP
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
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
FC PORT: 2 PORT
Cpu : 3 number 4830 in each host
Esxi.6
Vcenter .6.5 vcsa
Storage : vnx 5400& vnx 5200
Core Switch :3750
Server farm swtches : 48 port 2950 l2 switches
0
The 14th Annual Expert Award Winners
LVL 7
The 14th Annual Expert Award Winners

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

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
0
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.
0
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
0
Hello,
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
MACRO-TEST-2018-Global-Comp-Audit-P.xlsm
0
Dears,
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        …
0
SAP BEX Analyser only opens Excel formatted sheet partly in Black and white instead of Full colour?
0
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-LIBRARY error:
        ct_connect(): user api layer: internal Client Library error: Read from the server has timed out.
0
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'
0
SAP BEX Analyser only opens Excel formatted sheet partly in Black and white instead of Full colour?
BEX-erro.JPG
0
Cloud Class® Course: Microsoft Office 2010
LVL 12
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

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]
SAPB1issue.JPG
0
I would like to know if there is a report I can run in SAP to show me the project codes opened per WBS and each end date. We want to monitor the opening of codes, so instead of the individual asking for the code once it has disappeared from their time sheet we want to run a report to flag up any codes due to expire in 2 weeks time then we can ensure the end date is changed.
0
dears, I use reorg rebuild index to maintain indexes on table with data lock ,

but what can I use with allpages locking table? how to maintain its indexes, then update statistics??

kindly help
0
I have replication server. REP 15.7.1
From last 2 weeks the replication delay is more.
When we check we can see some bulk insert happen and Identity_burn_max error for 2 tables.
So we just restart the thread and fixing the issue.
We need to fix it permanently.
I suspect identity_burn_max is the problem.
I checked the two tables in database. Both are empty.
Not sure why identify_burn_max error occurs for empty tables.

Is there any way to fix the issue permanently.

1. num_mutexes is greater than num_threads
2. dsi_bulk_copy is OFF -
3. sqt_max_cache_size is 20971520
4. dsi_large_xact_size is 100
5. dsi_max_xacts_in_group is 20
0
Samsung DS5014S Landline phone

I have a Samsung OfficeServ DS-5014S with the message light flashing, even though there are no messages pending  does anyone have any ideas how to reset
0
Hi

Is there any issue if we setup 'abort tran on log full' for primary database? Does sybase try to kill repagent process in case replication marker is blocking the transaction? Kindly advise.

thanks
Chan
0

SAP

516

Solutions

778

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
>