| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /IXOS/DL46ERP_02 | Customizing für PLM import | 2 | USR | User | nvarchar | 12 | 0 | | |
2 | /IXOS/DL46ERP_03 | Customizing for PLM scanning | 2 | USR | User | nvarchar | 12 | 0 | | |
3 | /PERSONAS/USRAPP | Dummy table for User-/AppId-Lockobject /PERSONAS/E_USER | 2 | USR | User Name | nvarchar | 12 | 0 | | |
4 | /UI2/CACHE | Cache for storing query results (collections and entities) | 3 | USR | User Name | nvarchar | 12 | 0 | | |
5 | /UI2/CACHE_MAP | Maps cache id to URl and URL parameters | 2 | USR | User Name | nvarchar | 12 | 0 | | |
6 | BBPD_CMS_DOC_USR | Users that can access the documents | 3 | USR | User Name | nvarchar | 12 | 0 | | |
7 | DMC_COMPARE | Table for compare result for table | 25 | USR | User Name | nvarchar | 12 | 0 | | |
8 | DMC_COMPARE_DIF | Table for keys of rows with differences | 8 | USR | User Name | nvarchar | 12 | 0 | | |
9 | DMS_TBL_LOCKED | Maintain Lock Field Status | 5 | USR | User | nvarchar | 1 | 0 | | |
10 | GHO_OD_PRSNLZTN | Obselete : Personlization for UOM application | 3 | USR | User Name | nvarchar | 12 | 0 | | |
TOPAccounting - General |
11 | TFC_INST_USR | User-Dependent Data: Fast Close | 4 | USR | User Name | nvarchar | 12 | 0 | | |
12 | TFC_TEMPL_USR | User-Dependent Data: Fast Close | 4 | USR | User Name | nvarchar | 12 | 0 | | |
TOPBusiness Server Pages |
13 | SSCOOKIE | Business Server Pages (BSP) DB Table Server-Side Cookies | 5 | USR | | nvarchar | 64 | 0 | | |
TOPClinical System |
14 | N1DCS_USR | IS-H*med: DCS: Quick Entry: Settings for User | 3 | USR | DCS: User for Quick Entry Settings | nvarchar | 12 | 0 | | |
15 | N1DCS_USR_RANGE | IS-H*MED: DCS: Quick Entry User Settings (Ranges) | 3 | USR | DCS: User for Quick Entry Settings | nvarchar | 12 | 0 | | |
16 | N1MEDS_USRFAV | Medication: User Favorites | 3 | USR | User Name in User Master Record | nvarchar | 12 | 0 | | |
17 | N1MEDS_USRPREF | Medication: User-Specific Presettings | 3 | USR | User Name in User Master Record | nvarchar | 12 | 0 | | |
18 | N1VIEW_017_PERS | i.s.h.med: Personal Setting for View Type 017 | 5 | USR | User Name in User Master Record | nvarchar | 12 | 0 | | |
TOPConsolidation |
19 | TF080 | List Directory of MCDX | 10 | USR | Last changed by | nvarchar | 12 | 0 | | |
20 | TF261 | CG/CU: Detail Status of Tasks - Data Monitor | 11 | USR | Last changed by | nvarchar | 12 | 0 | | |
21 | TF262 | History of Data Entry Layouts | 8 | USR | Last changed by | nvarchar | 12 | 0 | | |
22 | TF271 | CG/CU: Detail Status of Tasks - Consolidation Monitor | 11 | USR | Last changed by | nvarchar | 12 | 0 | | |
TOPCross-Application Components |
23 | J_8A3CUST | user customizing - Old Version, don't use | 2 | USR | User Name in User Master Record | nvarchar | 12 | 0 | | |
24 | J_8A3LOG | logtable - Old Version, don't use | 2 | USR | Changed by | nvarchar | 12 | 0 | | |
25 | J_8A3MERK | memorize last selection - Old Version, don't use | 2 | USR | Changed by | nvarchar | 12 | 0 | | |
26 | J_8A3T0002 | logtable | 2 | USR | Changed by | nvarchar | 12 | 0 | | |
27 | J_8A3T0005 | user customizing | 2 | USR | User Name in User Master Record | nvarchar | 12 | 0 | | |
28 | J_8A3T0006 | memorize last selection | 2 | USR | User Name | nvarchar | 12 | 0 | | |
29 | J_8A3T0008 | technical customizing 5.x | 2 | USR | Changed by | nvarchar | 12 | 0 | | |
30 | J_8A3T0020 | Customizing for Workitem text | 2 | USR | User Name | nvarchar | 12 | 0 | | |
31 | J_8A3TECHN | technical customizing - Old Version, don't use | 2 | USR | Changed by | nvarchar | 12 | 0 | | |
TOPCustomer Enhancements |
32 | MODWRD | Key words of changed DE | 4 | USR | Last changed by | nvarchar | 12 | 0 | | |
TOPDatabase Interface, Database Platforms |
33 | MIGREXTAB | Exception Table for DDL Generation | 4 | USR | Field of length 16 | nvarchar | 16 | 0 | | |
TOPDocument Builder |
34 | /IPRO/TCUSTELM | Document Builder Custom Elements | 6 | USR | User field with 20 characters | nvarchar | 20 | 0 | | |
35 | /IPRO/TDOCMNT | Document Builder Documents | 5 | USR | Created by | nvarchar | 20 | 0 | | |
36 | /IPRO/TDOCUSR | Users that can access the document | 3 | USR | User Name | nvarchar | 12 | 0 | | |
37 | /IPRO/TEDHIST | Contains edit history data | 8 | USR | User field with 20 characters | nvarchar | 20 | 0 | | |
38 | /IPRO/TTEMPL | Document Builder Templates | 7 | USR | Created by | nvarchar | 20 | 0 | | |
39 | /IPRO/TUPDATELOG | update report table to store the log | 4 | USR | Created by | nvarchar | 20 | 0 | | |
40 | /IPRO/TUSRELM | User element table | 4 | USR | User | nvarchar | 12 | 0 | | |
41 | /IPRO/TUSRSTYL | This table defines a user style | 5 | USR | User field with 20 characters | nvarchar | 20 | 0 | | |
42 | /IPRO/TUSRTMPL | Table of user template data | 6 | USR | Created by | nvarchar | 20 | 0 | | |
TOPFinancials Basis |
43 | UBC_TB_CUR | Max./Min. Amounts per User and Currency | 3 | USR | User | nvarchar | 12 | 0 | | |
44 | UBC_TB_GUID | GUID for USER, ORG. WI_ID | 3 | USR | User | nvarchar | 12 | 0 | | |
45 | UBC_TB_NOTES | Table for Notes | 4 | USR | User | nvarchar | 12 | 0 | | |
46 | UBC_TB_STRUSR | User Sequence | 5 | USR | User | nvarchar | 12 | 0 | | |
47 | UBC_TB_USR | User per Organizational Unit | 3 | USR | User | nvarchar | 12 | 0 | | |
TOPGoods Receipt Process |
48 | BORGR_USR_GROUP | Goods Receipt Automotive: Groups for User | 2 | USR | User Name in User Master Record | nvarchar | 12 | 0 | | |
TOPGraphic |
49 | GFWCUAXU | GFW Customizing: Axis (Customer Data) | 4 | USR | User Name | nvarchar | 12 | 0 | | |
50 | GFWCUDAU | GFW Customizing: Plot Area (Customer Data) | 4 | USR | User Name | nvarchar | 12 | 0 | | |
51 | GFWCUDCU | GFW Customizing: Display Context (Customer Data) | 4 | USR | User Name | nvarchar | 12 | 0 | | |
52 | GFWCUDIU | GFW Customizing: Chart (Customer Data) | 4 | USR | User Name | nvarchar | 12 | 0 | | |
53 | GFWCUDSU | GFW Customizing: Data Table (Customer Data) | 4 | USR | User Name | nvarchar | 12 | 0 | | |
54 | GFWCUGRU | GFW Customizing: Grid (Customer Data) | 4 | USR | User Name | nvarchar | 12 | 0 | | |
55 | GFWCUITU | GFW Customizing: Item (Customer Data) | 4 | USR | User Name | nvarchar | 12 | 0 | | |
56 | GFWCUPOU | GFW Customizing: Point (Customer Data) | 4 | USR | User Name | nvarchar | 12 | 0 | | |
57 | GFWCUSCU | GFW Customizing: Scale (Customer Data) | 4 | USR | User Name | nvarchar | 12 | 0 | | |
58 | GFWCUVAU | GFW Customizing: Value Series (Customer Data) | 4 | USR | User Name | nvarchar | 12 | 0 | | |
TOPInspection |
59 | MSR_D_USER_GROUP | Assignment of Users to User Groups | 2 | USR | User Name in User Master Record | nvarchar | 12 | 0 | | |
TOPManufacturer Part Number |
60 | ADPIC_MIGO_USR | Customizing Settings for MIGO | 3 | USR | User for MIGO Customizing | nvarchar | 12 | 0 | | |
TOPMedia Product Sales and Distribution |
61 | JKSDUSERGROUP | Assignment of Users to User Groups | 4 | USR | User Name in User Master Record | nvarchar | 12 | 0 | | |
62 | TJKSDLOCKNUMBER | Maximum Number of Locks Allowed for an Application | 3 | USR | User Name in User Master Record | nvarchar | 12 | 0 | | |
TOPPostprocessing Office |
63 | /SAPPO/WLUSER | Assignment of User/Organizational Unit to Worklist | 6 | USR | User | nvarchar | 12 | 0 | | |
TOPScripting |
64 | CRMD_IC_FAVCAT | Favorite Categories | 2 | USR | User Name in User Master Record | nvarchar | 12 | 0 | | |
65 | CRMD_IC_FAVCATT | Favorite Category Text Table | 2 | USR | User Name in User Master Record | nvarchar | 12 | 0 | | |
66 | CRMD_IC_FAVORS | Table for maintaining my Favorites | 2 | USR | User Name in User Master Record | nvarchar | 12 | 0 | | |
TOPSpecification 2 |
67 | SPCMGLOH4 | H4-Codes SPEC2000M | 4 | USR | User Nation Code | nvarchar | 3 | 0 | | |
TOPTransport Management System |
68 | TMSQASTEPZ | TMS QA: Approval Steps - Timestamp of Last Change | 1 | USR | TMS QA: User Who Last Changed QA Settings | nvarchar | 12 | 0 | | |