Questions tagged [sap]

The tag has no usage guidance.

2
votes
0answers
30 views

Extracting Data from SAP to SQL Server

I am using SSIS packages to extract data from SAP database tables into SQL Server tables. I am using OLEDB source/destination connections to achieve this. The problem now is that a table in SAP has 5 ...
0
votes
0answers
26 views

Sybase database migration from old SAN storage to new SAN storage

I need best practice recommendation regarding Sybase database migration from old SAN storage to new SAN storage.
0
votes
1answer
64 views

downgrade sybase sql anywhere 16 to 12

found an issue with one of our programs what requires me to downgrade to a older version, when i try to load the database over dbsrv i get the error that capability 81 is missing. the database itself ...
1
vote
1answer
408 views

Turn off listener logging in oracle 12c release 2

I am trying to turn off listener logging in oracle 12c R2 (SAP on oracle), but I am getting a TNS-12508 error. I have verified that the listener.ora is owned by the oracle user and I am performing the ...
0
votes
1answer
47 views

SAP BO Freehand SQL date formatting (Oracle db)

My original query worked perfectly via SQL Developer: select * from [table] where DT_CURRENT_DT = '15-OCT-18' However when ran via freehand SQL in SAP BO I got no results. After running the query ...
0
votes
0answers
51 views

SAP PowerDesigner Database error

Since a few days, several of my PowerDesigner users are getting SQL errors each time they try to check in a data model into the repository: '\\SHAREDDRIVE\DATAMODEL_UDS.ldm' - Checking ...
0
votes
1answer
176 views

What is a online atomic mode backup

I am reading the SAP guide administrator of BO, and I am a little confused about some term they use regardless how to perform online or hot backups. Using the same words For hot backups, use the ...
0
votes
1answer
18 views

How to display all entries that have had a box ticked since a particlar date [closed]

Good afternoon, I would be very grateful is someone would be able to offer some assistance to a query I have regarding some SQL I'm needing to implement. In our database we have a range of customers ...
1
vote
1answer
227 views

ip address record in sybase ASE auditing database? [closed]

everone. I installed the sybsecurity database for auditing in sybase ase 15.5. The installation is OK. I configured the audit commands, for example, for auditing the sa user, and other users of the ...
0
votes
1answer
274 views

Change left outer join on SAP Universe Design Tools

I need to create a report with SAP Universe Design Tool but when I try to construct a LEFT JOIN between tables, SAP automatically create a LEFT OUTER JOIN when it executes the query in Web Rich Client....
0
votes
0answers
306 views

How do you extract discount data from SAP?

I'm not a SAP developer. We already have a big SSIS package that pulls data from the SQL Server instance that our SAP installation uses and I need to add discount data to it. I've usually had pretty ...
1
vote
1answer
91 views

Performance difference between single large Application instance vs multiple small Application Instance in Netweaver [closed]

Can anyone please comment on the performance impact of having a single large application server instance vs multiple small application server instance in SAP Netweaver on a single machine.
0
votes
1answer
809 views

SQL Anywhere 12 - exporting data to Excel

Do I need to install MS Office Excel on machine where is SQL Anywhere 12 server for below code to work? Or SA 12 or Windows have MS Excel Driver builtin? SELECT * FROM SalesOrders; OUTPUT USING '...
1
vote
0answers
50 views

MaxDB - Strange behaviour when selecting from a CLOB-Row

I am using "sqlcli" for Linux to write the output of the following query into a file: select clob_field from table (...) in SAPGui (original user input) the contents are displayed as: First line ...
0
votes
1answer
109 views

MobiLink: How to add a new table to synchronisation using Sybase Central and mlagent

How to add a new table to a synchronisation using mlagent configured from Sybase Central. This might be related to this or this question. When doing a change on remote database as described on ...
2
votes
1answer
190 views

MobiLink: How to propagade schema change for a synch profile to remote databases

Once an application is online with a synchronisation profile it might happen, that the profile needs to be changed. E.g. a new index is introduced, columns are added etc. Having the synchronisation ...
1
vote
0answers
36 views

MobiLink: What is the correct approach of presetting values inside database for remote user

When creating a remote database from inside Sybase Central I'm looking for a way to preset some values based on e.g. subscription user. Application is using some kind of configuration table storing ...
1
vote
0answers
43 views

MobiLink: How to export database users to remote database created via Sybase Central

How to configure a Sybase Central MobiLink project in the way, it's also exporting the database users of consolidated database to a remote database? In default it appears to only create dba with ...
0
votes
1answer
203 views

SAP Control Center unable to recognize IQ version string

On a fresh installed SCC with SAP Sybase IQ on localhost I'm getting this error while connecting to localhost running scc agent for IQ. SCC agent localhost:9999 does not know Sybase IQ version ...
0
votes
1answer
61 views

SQLAnywhere: Mobilink upload_fetch_column_conflict​ seems not to be executed

With Sybase Central I've configured a MobiLink test object, where I'm trying to detect a unique constrain violation before uploading. Unfortunately it appears upload_fetch_column_conflict​ seems to ...
0
votes
1answer
1k views

adding fields to 2LIS_12_VCITM datasource in ECC

From what I have read the datasource 2LIS_12_VCITM is built off of the ECC tables LIKP, LIPS, VBUK, and VBUP. I would like to add a couple of fields that are in the LIPS table to this datasource and ...
7
votes
1answer
333 views

What is “SAP on Oracle”

OK, total newb question. What is "SAP on Oracle", exactly. This link is talking about how SAP can run on Oracle (I think). I'm not understanding how this is working. My understanding: SAP is a ...