Questions tagged [sap-hana]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
32 views

How to install HANA DB on Oracle Linux 7?

I want to know how to install SAP HANA DB 2.0 on Oracle Linux 7 including downloading, installing and the first connection establishing to the system from network. I've spent a few hours to find out ...
2
votes
1answer
61 views

What is a Compressed Prefix B+-Tree (CPBTree) in SAP HANA?

I'm studying the SAP HANA main memory database. There is an index called CPBTree in it. In its documentation, it is described as follows: CPB+-tree stands for Compressed Prefix B+-Tree; this index ...
0
votes
0answers
52 views

MS SQL Linked Server to HANA 2.0 - error 10 authentication failed

I have some trouble setting up a linked server to a SAP HANA database. On the SQL-Server machine (SQL-Server 2019) i installed the ODBC drivers and set up a 64 System DSN. When I click on the "Test ...
0
votes
0answers
11 views

Getting full (purpose, usage) Table names in SAP Hana

Each table in SAP Hana has a purpose, for example, BSEG is Accounting Document Segment and BKPF is Accounting Document Header. Is there anything in Hana (along the lines of Select * From Tables) or a ...
0
votes
0answers
21 views

Sql Server with S4 HANA linked server queries with table variables [duplicate]

This is a relatively simple question that may not have an answer, but I have a SQL 2017 instance that has a Linked S4 HANA server connected through the HDODBC drivers. I have done many OPENQUERY ...
0
votes
2answers
46 views

SQL server DAC connection to mssqlsystemresource database

I have a problem while connecting to the mssqlsystemresource database. When I try to connect with DAC connection (without restarting SQL server with -m option) it works, but I can't use the ...
0
votes
1answer
24 views

Select with a preffered where condition, but if missing use another

I have the following select in SAP HANA DB: SELECT name, text, lang FROM texts WHERE name IN ('name1', 'name2', 'name2') AND lang IN ( 'S', 'E' ) INTO TABLE @DATA(lt_texts). It will select ...
0
votes
1answer
2k 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
764 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
1k 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
195 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
80 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
2k 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
35 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
6k 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 ...