SAP Licenses in the Saviynt Database

[TimoR]

Hi,

we import accounts from SAP and those accounts will get an integer value for APPLICENSETYPE, for example 4.

When we view that account in Saviynt, the text field for App License Type displays "SAP E11 Test" instead of the value 4 that is in the database.

Which table in the database holds this information? I could not find out how the value 4 gets translated to "SAP E11 Test" in our case.

Can you help me out?

Thanks!

[Raghu]

@TimoR  you  means APPLICENSETYPE column which table associated asking ? it will be in Accounts table.

https://docs.saviyntcloud.com/bundle/EIC-Database-Schema-Reference/page/Content/Database-Schema-Refe...

[TimoR]

Thank you, yes I know it is in the accounts table. In the schema it is shown as foreign key, but it is not shown to which table that foreign key is mapped:

And this is my question: in which table can I look up the attributes of the app license?

[Raghu]

in document not provided full info , may be have access SAP table through get info, required column data

[rushikeshvartak]

• Unfortunately its not supported to pull actual name of license 

[TimoR]

OK, but those licenses have names in Intelligence -> License Management.

Can you tell me where to find those in the database?

[rushikeshvartak]

select CDHDRKEY,CLIENT,DOCUMENT,LANG,OBJCLASS,OBJECTVALUE,TCODE,UPDATEDATE d,UPDATETYPE,UPDATEUSER from Cdhdr

[TimoR]

Sorry, that query does not work. The cdhdr table is empty on our systems.

[rushikeshvartak]

Does not work or no data ?

• select * from applicense

[TimoR]

The query "select CDHDRKEY,CLIENT,DOCUMENT,LANG,OBJCLASS,OBJECTVALUE,TCODE,UPDATEDATE d,UPDATETYPE,UPDATEUSER from Cdhdr" returns no data.

The query "select * from applicense" returns an error:
Error : SELECT command denied to user 'ssmdau' for table 'applicense'

[rushikeshvartak · Accepted solution]

check from analytics - Preview option