| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPConstruction Equipment Management |
1 | J_3GABGRF | Removal Sequence - Activity Types | 2 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
2 | J_3GABGRFMAT | Removal Sequence for Materials | 2 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
3 | J_3GBELK | Document File - Header Data | 70 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
4 | J_3GBESART | Inventory Management Type | 2 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
5 | J_3GLABET | Activity Types/Limits per Document Category | 4 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
6 | J_3GVBAP | Additional Data CEM SD Document Item | 14 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
7 | J_3GVBRP | CEM Additional Data for VBRP | 18 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
8 | J_3GVBRP_Z | Frozen Data from VBRP Conversion | 21 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
9 | J_3GZVBAP | Backup Table for CEM Data in Rel. 3.0 | 21 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
TOPIndustry Solution Engineering Construction |
10 | A264 | Customer or Goods Recipient/Document Type | 5 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
11 | A265 | Standard Dummy Customer/Document Type/Material Grp/Material | 5 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
12 | A269 | Equipment Type/Document Type | 5 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
13 | A270 | Euqipment/Document Type | 5 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
14 | A271 | Document Category | 4 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
15 | A272 | Equipment/Standard Dummy Customer/Document Type | 6 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
16 | A277 | Standard Dummy Customer/Document Type/Material Group | 5 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
17 | A495 | Equipment type/standard dummy customer/document category | 6 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
18 | C495 | Document Category/Condition Type/Own-External/Account Key | 5 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
19 | C497 | Document Category/Condition Type/Account Key | 5 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
20 | C498 | Doc. Category/Condition Type/Own-Ext./Actvty Type/Acc. Key | 5 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
21 | C499 | Doc. Cat./Cond. Type/Own-Ext./Acty Type/Ctlg Group/Acc. Key | 5 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
22 | KOT4009 | Condition Table for Price List Determination | 4 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
23 | KOT4012 | Condition Table for Price List Determination | 4 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
24 | KOTJ009 | Document Category | 4 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |
25 | KOTJ012 | Document Category/Recipient/Material Group/Activity Type | 4 | J_3GBLTYP | CEM Document Category | nvarchar | 1 | 0 | | |