Table / Archive information
The /AUDIC/SE_INFO transaction allows you to determine various information that is relevant for SmartExporter. For example, you can check if a specific user has the authorizations for tables or a Data Request or you can check if he can access the archive.
Figure: Selection parameters of /AUDIC/SE_INFO
| Selections | |
|---|---|
|
Table Name |
Database table(s) |
|
Data Request |
The tables can be read from
|
|
Component ID |
You can also define the tables by specifying SAP® components, e.g. FI*, FI_GL* |
|
Authorization check for user |
Checking the SAP® authorizations for a specific user. Administrators can enter a specific user here to check his authorizations. The Verify RFC authorizations icon allows you to also check the required RFC authorizations for the selected user. |
|
Rowcount in database |
Determines the number of rows in the database for each table. This might lead to a considerable load on the system and result in a long runtime. |
|
Check change recording |
Determines if the change recording for the tables will be done on table level (DBTABLOG) or on application level (CDHDR). |
|
Check SmartExporter auth. |
Determines if the specified user has the required authorizations to access the tables via SmartExporter. |
|
Check archive access |
Determines if data from the tables was archived. |
|
Apply Include/Exclude list |
Not in use |
|
Check archive index |
Checks for archived data that already exists if the archive index is defined and if it is compiled completely. |
|
Archived on or after |
Archives created before the specified date will be excluded from the check. This reduces the data volume to be checked. This may be advisable due to performance reasons. |
|
Check PBS statistics |
If the optional PBS_STATS add-on is installed and data has been archived, this check determines if the PBS statistics are complete. |
|
Check Data Aging (HANA) |
On systems with HANA DB this check determines if Data Aging is configured for the tables. |
|
Group by table |
The results will be grouped by table. |
|
Group by archive object |
The results will be grouped by archiving object. |
|
Table usage for archive class |
Not in use |
|
Tables with mult. usages |
Not in use |
|
Table Name |
Tables for multiple usage Not in use |
Table: Parameters of /AUDIC/SE_INFO
In the following example the authorization profile file AUT800HSS_GDPDU_TABLES_NEWGL.XML from the SmartExporter SAP Components\Templates\ASE Authorization Templates directory of the SAP® Components CD was loaded.
Figure: Example for table or archive information for a specific user.
General information on the tables is displayed.
In the Data Type column an icon indicates if all table columns can be extracted with SmartExporter.
In the Auth. SE16 column an icon indicates if the specified user has the required authorizations for the extraction of the data via SmartExporter.
Click the S_TABU_DIS Authorizations or S_TABU_NAM Authorizations button to show a list of the required authorization values for the selected tables.
Figure: List of the required authorization values for the selected tables