SAP EP – Netweaver Portal » iView eforcement of MDM Role Table and Field Privileges

iView eforcement of MDM Role Table and Field Privileges

July 12, 2009 at 2:25 am

[iview] [iview media] [iview mediapro] [iview mediapro3] [iViews] [Permissions] [Privileges] [Roles]

iView eforcement of MDM Role Table and Field PrivilegesSymptom When working in MDM iViews, MDM table and field privileges enforced policy is stricter then the one in Data Manager Other terms Roles, Permissions, Privileges, iViews Reason and Prerequisites In MDM...
Numbers after decimal point displayed differently- MDM iViewSymptom Formatting of MDM Real, Measurement or Currency field types with 1 or more digits after the decimal point appear to be different when comparing these fields in Item Details Edit mode...
Group-Layout can not be disabled – MDM Search Text iViewSymptom While using MDM 7.1 SP02 Portal iViews in the portal design-time property editor, you are configuring the Search Text iView “Group-Based Layout” property to “No”, however in run-time, the iView ignores...
MDM Result Set iView – How to export records to ExcelSymptom You are trying to export records from MDM Result Set iViews to an Excel file. Other terms Excel, export, iViews, MDM, Result Set Solution Export to Excel functionally can be achieved...
MDM Item Details iView – “Record is protected” messageSymptom When trying to edit a record via MDM Portal Item Details iView you see a message that “Record is protected, record is checked out” and you can not edit it. Trying...
Item Details iView is not refreshed when search changedSymptom When performing a search, Item Details iView is not refreshed, and displays the previous selected record – the last record that was selected in the Result Set by the user Other...
Translation missing for MSS training Activities IviewSymptom Translation missing for MSS training Activities Iview Other terms sap.com/mss~eepro~businessevents, sap.com/mss~eepro~businesseventsdetail, MSS training Activities Iviews and MSS Training Activities details iview. Reason and Prerequisites Program Error Solution The Translation for the...
‘WELCOME_CLAUSE’ is displayed in the portal header iViewSymptom Instead of welcome text and the name of the user at the header iView of the portal, a string ‘WELCOME_CLAUSE’ is displayed. This incorrect behavior can be reproduced on version: -...

Symptom

When working in MDM iViews, MDM table and field privileges enforced policy is stricter then the one in Data Manager
Other terms

Roles, Permissions, Privileges, iViews
Reason and Prerequisites

In MDM iViews, an MDM role’s field and table privileges (Read, Write) are determined as follows: If in the MDM Console, under Admin -> Role -> Tables and Fields tab, the Read-Only property is enabled for the MDM table (e.g. Products) Access column, then ALL fields located under the table node are assumed to be Read-Only, regardless if any of these fields has a Read/Write setting.
In the Data Manager, a field privileges are determined only based on the field access property, regardless of the table access property setting.
This result in the iView enforcing a stricter policy compared to the Data Manager in the case where the table access is set to be Read-only.
Solution

For achieving similar policy in iViews to the Data Manager, in the MDM Console you need to set the MDM tables access in the Tables and Fields tab to Read/Write