[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

SAP

535

Solutions

810

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

SAP B1 - Dunning Wizard - the default reports are PLD - I'm using Crystal Reports and have created a report however I'm not sure what parameter SAP B1 uses from the dunning wizard screen to pass to Crystal.  So, does anybody know which database field I need to use for the DocEntry@ parameter?  The report runs in crystal but in the dunning wizard screen I get an error 'No matching records found' RITM ODBC -2028 Message 131-183
0
PMI ACP® Project Management
LVL 12
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

Regarding Power BI On Premise Gateway:

The Login User created on the SAP BW server\database  which will login into the server\database from the on premise gateway.

What is this configuration required of the SAP BW server\database gateway user which the Gateway will login into to create the bridge.
0
I had this question after viewing Append all database values in Parameter not bringing in all data..

I have been trying to append values for site (customer site names) and it is bringing in (on estimate) the first 1000 sites in the database.  If I create an "ALL" selection and run the report it does bring in all sites.  Basically when appending I can see up to values beginning with 'H', but running "ALL" bring up to 'Z'.

It is a standard parameter
Crystal report version is SAP Crystal Reports 2016 Support Pack 5 Version 14.2.5.2618
I am currently in Evaluation to see if we can make use of the system before purchasing!  Not sure if this has an effect.

I have so far attempted:
Creating the parameter in a fresh report but same result
Setting the parameter to dynamic has the same limited number of selections
I have gone into registry and created a new key - LOV, with the string MaxRowsetRecords and set as 1000000.

I have come to the end of any other solutions?

Any help is much appreciated!
0
Hi Experts

Could you explain in what aspects a SAP PowerBuilder app interacts with SAP ERP (MM/ PP/ FI/ CO/ SD...)?

Is it used like ABAP to customize the SAP use?

Or PowerBuilder owned by SAP (an Sybase dev platform before) is just an aparted product.

Thanks in advance!
0
Hello,

I need your advice please  to validate a solution for up to date  a file exchange between MarketPlace MIRAKL and SAP.
Mirakl does not give us the possibility to connect via sftp (user, mdp, port or other ).

However, If we use the CURL (client URL request library) technology to send requests and retrieve orders that are entered into our stores and repatriate them to SAP.
The connection is via https and in the script it will be used an API key that is unique and generate from our MIRAKL account. In this API key we have a user and a password, which makes the connection secure.

About security, the solution is secure (safe) or not and we advise me to implement this solution?

Best regards,
0
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
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
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
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
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
Rowby Goren Makes an Impact on Screen and Online
LVL 12
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

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
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
sap sql connection webserices how to read
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
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
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.

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

535

Solutions

810

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
>