Skip to Content
0
Nov 27, 2017 at 10:28 AM

HANA 2.0 SP1 - MDC - View SYS_DATABASES.M_LICENSE mssing

762 Views

Dear all,

as per SAPs documentation there should be a View within the SYSTEMDB (for HANA MDC Setups) called

SYS_DATABASES.M_LICENSE

However it seems as if some HANAs do have this view and others do not. Has anybody come across this issue?

HANA1

version: 2.00.020.00.1500920972

SELECT VIEW_NAME FROM VIEWS WHERE SCHEMA_NAME = 'SYS_DATABASES' and VIEW_NAME LIKE '%LICENSE%'
VIEW_NAME
"M_LICENSE"
"M_LICENSES"
"M_LICENSE_MEASUREMENTS"
"M_LICENSE_MEASUREMENT_STATISTICS"

HANA2

version 2.00.010.00.1491294693

SELECT VIEW_NAME FROM VIEWS WHERE SCHEMA_NAME = 'SYS_DATABASES' and VIEW_NAME LIKE '%LICENSE%'
"M_LICENSE_MEASUREMENTS"
"M
_LICENSE_MEASUREMENT_STATISTICS"

Is it possible that this view is only available with SP2?

Cheers and thanks in advance,

Jochen