Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

idmv_value_basic vs idmv_value_basic_active

Hi Experts,

I don't know if its an issue or my understanding is wrong.

select attrname,searchvalue from idmv_value_basic_active where mskey = 12345 => fetches me 16 rows

select attrname,searchvalue from idmv_value_basic where mskey = 12345 => fetches me 45 rows

I thought idmv_value_basic and idmv_value_basic_active to fetch me same data for a given user.

I would like to know the difference between the views and why no of attributes is less than other for same user?

System details:

Version: IDM 7.2 SP9

Database level: Patch 7

Runtime patch: Patch 4

Database: MS SQL 2012

Please let me know if more information is required. TIA

Kind regards,


Not what you were looking for? View more on this topic or Ask a question