cancel
Showing results for 
Search instead for 
Did you mean: 

Sytem tables in HANA 2.0 SPS00 >

fulvioval
Explorer
0 Kudos

Hi guys, I need little help here.

I`m converting old cvs from HANA 1.0 SPS 11 to HANA 2.0 SPS05 and some use system views like

SYS.DUMMY
_SYS_XS.JOBS
SYS.M_EXPENSIVE_STATEMENTS.

My double is where system tables is stored in HANA 2.0?

Thanks in advanced.

Accepted Solutions (0)

Answers (1)

Answers (1)

atul
Active Contributor
0 Kudos

Hi Fulvio,

"System views are located in the SYS schema. In a system with tenant databases, every database has a SYS schema with system views that contain information about that database only. "

For more detail find

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20cbb10c75191014b47ba845bf...

Best Regards,

Atul

fulvioval
Explorer
0 Kudos

Thanks Atul.

I found these tables in a querie "SELECT * FROM TABLES" but How can I know if they are in HANA 2.0 native? Because this query return tables from old XS Classic repository. My ideia is migrate all cvs to avoid XS Classic deprecated in next major release.

I bite confused how this things are separated...