- SAP Community
- Groups
- Interest Groups
- Application Development
- Discussions
- Viewing custom Z tables with blank authorization g...
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Viewing custom Z tables with blank authorization group
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-13-2010 12:14 AM
I'm trying to view all the Z tables without any authorization group (blank) in TDDAT. It only displays Z tables with &NC& or other valid groups we assign. Is there another table I can query to show ALL Z tables without an auth group?
Thanks.
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-13-2010 3:31 AM
Hi John,
I am not aware about any other Table except TDDAT. However to solve your issue try giving Z* as the input and then execute it. This will give you list of all the Z tables whose auth groups are maintained. Now with the help of excel match it with all the Z tables which exist in that system and filter out the data which you want.
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-13-2010 3:31 AM
Hi John,
I am not aware about any other Table except TDDAT. However to solve your issue try giving Z* as the input and then execute it. This will give you list of all the Z tables whose auth groups are maintained. Now with the help of excel match it with all the Z tables which exist in that system and filter out the data which you want.
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-13-2010 3:42 AM
Hi,
as it was mentioned you can use Excel to get your list. You can get list of all tables from SE15. Another way is to use SQ01 to create an outer join between DD02L and TDDAT. Don't forget that if table does not have any record in TDDAT is equal to having record with &NC&.
Cheers
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-13-2010 8:59 AM
> It only displays Z tables with &NC& or other valid groups we assign.
Oops, sorry. Martin had already mentioned this.
&NC& is not a valid group, it is a symbolic group which is the equivalent of a blank for the table - except that a view had been created for it and during that process no authorization group was set either. This also used to be the default, which doesn't really make sense... hence all the values.
If you take a look at FM VIEW_AUTHORITY_CHECK then you will see how it works and which tables are used.
Cheers,
Julius
Edited by: Julius Bussche on Feb 13, 2010 10:01 AM
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-16-2010 4:28 PM
Thanks everyone, I'm closing the thread. The tables that were posted were very helpful.
I'm aware of the &NC& (Not Classified Table) auth group, these are the items we are cleaning up including the blank ones. I should have been clear on my initial post. Thanks again.
Edited by: John Navarro on Feb 17, 2010 4:38 PM
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-17-2010 6:18 PM
> I'm aware of the &NC& (Not Classified Table) auth group, these are the items we are cleaning up including the blank ones.
Exactly that is what I would recommend as well.
I also report missing SU24 DICBERCLS to SAP when I find them for their own transactions.
Cheers,
Julius
- SAP Managed Tags:
- Security
