| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | IWP_WP_QUERY_MAP | Query name mapping for generating/copying queries | 1 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
TOPData Basis |
2 | RSIWP_ASSIGN | Assignment of of infoojects per Work Package and Tablefield | 2 | WORK_PACKAGE | Audit Package | nvarchar | 10 | 0 | | |
3 | RSIWP_IPROV | Directory of the infoprovides of a Work Package | 2 | WORK_PACKAGE | Audit Package | nvarchar | 10 | 0 | | |
4 | RSIWP_WP_ASS | assignment of a work package to a user | 3 | WORK_PACKAGE | Audit Package | nvarchar | 10 | 0 | | |
TOPRetention Warehouse |
5 | IWP_AUTH_IOBJ | Definition of Infoobjects to be used for authorization | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
6 | IWP_GEN_CONFIG | Configuration of BI extraction | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
7 | IWP_GEN_SETTINGS | Define Settings for Parallelization | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
8 | IWP_TABLE_DIR | Directory of generated tables for data transfer | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
9 | IWP_WP | Audit Packages | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
10 | IWP_WPT | Work Package Texts | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
11 | IWP_WP_AREA | Areas Assigned to Audit Packages | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
12 | IWP_WP_IOBJ | InfoObjects of an Audit Package | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
13 | IWP_WP_IOBJT | InfoObjects of an Audit Package | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
14 | IWP_WP_IOBJ_ST | Definition structures of an Infoobject | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
15 | IWP_WP_IPRV | InfoProviders of an Audit Package | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
16 | IWP_WP_IPRVT | Text Table: InfoProviders of an Audit Package | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
17 | IWP_WP_JOB | Jobs for the Backgroundprocessing | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
18 | IWP_WP_LOG | Log for Backgroundprocessing | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
19 | IWP_WP_METAURI | Audit Package URI for SN_META | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
20 | IWP_WP_PATH | Paths of an Audit Package | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
21 | IWP_WP_PTH_STRC | Structures of the Pathes of an Audit Package | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
22 | IWP_WP_RELA | Relations and Domain Values of an Audit Package | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
23 | IWP_WP_STRUC | Tables of an Audit Package | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
24 | IWP_WP_STRUCT | Describtion: Tables of an Audit Package | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
25 | IWP_WP_URI | Audit Package URI | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |
26 | IWP_WP_VIEW | Views of an Audit Package | 2 | WORK_PACKAGE | Unique Identifier of an Audit Package | nvarchar | 10 | 0 | | |