and more in a single search tool across platforms. Read the announcement here. |
04/25/2024 02:25 AM
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!
Solved! Go to Solution.
04/25/2024 02:31 AM
@TimoR you means APPLICENSETYPE column which table associated asking ? it will be in Accounts table.
04/25/2024 02:40 AM
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?
04/25/2024 02:58 AM - edited 04/25/2024 03:02 AM
in document not provided full info , may be have access SAP table through get info, required column data
04/25/2024 09:09 PM
04/25/2024 11:15 PM
OK, but those licenses have names in Intelligence -> License Management.
Can you tell me where to find those in the database?
04/29/2024 09:45 PM
select CDHDRKEY,CLIENT,DOCUMENT,LANG,OBJCLASS,OBJECTVALUE,TCODE,UPDATEDATE d,UPDATETYPE,UPDATEUSER from Cdhdr
04/29/2024 11:30 PM
Sorry, that query does not work. The cdhdr table is empty on our systems.
04/30/2024 09:05 PM
Does not work or no data ?
05/01/2024 11:54 PM
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'
05/02/2024 09:12 PM - edited 05/02/2024 09:13 PM
check from analytics - Preview option