Questions tagged [sap-hana]

Use this tag for questions where the database platform in use is SAP HANA.

Filter by
Sorted by
Tagged with
1
vote
0answers
18 views

How to add SDC timestamp columns in SAP BW?

I have activated my data source and data is in PSA. I can only load the all. Should I add timestamp columns(For SDC types) in PSA or after DSO? How to do it?
0
votes
0answers
10 views

Can we recover tenant database to another system in SAP HANA?

Let's say we have the backup of the tenant database of system 1, but system 1 is for any reason not available anymore. Can we recover this tenant to completely other system with different system id ...
0
votes
0answers
18 views

How to get the statement that acquired a lock in HANA?

I am reposting my question from SAP SCN, where it was not blessed with an answer. I am trying to write a query or script in HANA that shall provice detailed information about the current locks in the ...
0
votes
0answers
13 views

HANA Catalog Import Issue

I'm trying to import a data dump from HANA Enterprise to HANA Express (VM). I use the web-based DB browser. Having created the a tenant with the same name as my source DB, I'm trying to 'Import ...
0
votes
1answer
226 views

Cannot connect to an Hana database via its ODBC driver

I have not found any documentation about ODBC connection strings for Hana and am trying to connect using the examples in SAP HANA Database Client Interfaces. An attempt to connect via ODBC with the ...
4
votes
2answers
393 views

How are these null values stored in a NOT NULL column?

We are replicating tables from SAP ECC 6.0 on HANA into an Oracle 10g warehouse, using SAP SLT. Since starting this, we have noticed the NOT NULL column definitions from HANA are retained in the ...
1
vote
0answers
552 views

HANA SQL procedure Iteration

Here is my requirement for a SAP HANA 2.0 system. 1) Identify users with not having SAML flag enabled from "SYS."USERS" table. Fields that I need from this table are USER_NAME,EXTERNAL_IDENTITY,...
1
vote
1answer
166 views

Select most recent row for each order

Currently writing a query which will be used to see where abouts on our production line a certain item is by showing what the last completed 'Resource' was. (resources on our system are just different ...
0
votes
1answer
44 views

Data Join with offset

I have below situation: Table1 Field1 Field2 123 test1 234 test2 Table2 Field1 Field2 12345 test2 23245 test3 123945 test6 I want to join these two tables i.e. Table1 and Table2 ...
2
votes
1answer
1k views

Can you use ODBC to extract data directly from SAP HANA S/4 1610?

Trying to get a handle on what's possible and what's not with SAP Hana S/4 1610. My understanding is that one can access the underlying SAP HANA DB via ODBC simply by utilzing the SAP HANA Client ...
1
vote
1answer
33 views

Find addresses shared by more than one customer_id where customer_name is is distinct

I need to return the list of addresses that have more than one customer_ID associated with them, exclude the customer_IDs that have the same customer_name and return the number of time the address ...
2
votes
1answer
5k views

Find columns with different values compared with a reference row

My table, MARC, has more than 200 columns with WERKS (plant) as the key. Most of the entries in MARC have values that come from a reference plant. So, usually, all the 200 columns will contain the ...