| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPConstruction Equipment Management |
| 1 | /SAPCEM/EMTLADMA | Default Activity Type for Material | 7 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 2 | /SAPCEM/LGLADEF | Default Activity Type for PBE Report | 5 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 3 | /SAPCEM/PIBLART | Price Info.: Doc.Types Used for Price Dtrmntn per AvtySetTyp | 2 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 4 | /SAPCEM/PIVARLV | Activity Types Relevant to a Variant | 3 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 5 | /SAPCEM/PT03 | Plannig Board: Graphical Element Type per Activity Type | 3 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 6 | J_3GABEST | Current Stocks | 7 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 7 | J_3GABGRF | Removal Sequence - Activity Types | 5 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 8 | J_3GABGRFMAT | Removal Sequence for Materials | 5 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 9 | J_3GBELP | Document Data - Item Data | 74 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 10 | J_3GEMPFBFART | Assign Inventory Mgmt Type to Rcpnt Type/Actvty Type | 3 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 11 | J_3GEMTLAD | Assignment Recipient Types-Activity Types Default | 6 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 12 | J_3GEQUMP | Assignment of Measuring Point to Equipment | 3 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 13 | J_3GFRISTBTLA | Deadline Logic per Document Type, Trans. Type and Acty Type | 4 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 14 | J_3GHBEST | Historical Stock | 8 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 15 | J_3GKALSM | Pricing Procedure Determination | 6 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 16 | J_3GLABET | Activity Types/Limits per Document Category | 5 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 17 | J_3GLAMTART | Activity Types per Material Type | 3 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 18 | J_3GLASE | Allowed Activity Types per Document Type | 3 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 19 | J_3GLEIART | Activity Types | 2 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 20 | J_3GLVARTT | Activity Type Texts | 3 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 21 | J_3GTBEST | Temporary Stock | 10 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 22 | J_3GVBRP | CEM Additional Data for VBRP | 6 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 23 | J_3GVBRP_Z | Frozen Data from VBRP Conversion | 6 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 24 | J_3GZVBAP | Backup Table for CEM Data in Rel. 3.0 | 6 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| TOPDistributor-Reseller-Management |
| 25 | S491 | CEM Construction Site Stock Value | 11 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 26 | S491E | S491 - Structure Information | 6 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| TOPIndustry Solution Engineering Construction |
| 27 | A278 | ETM Material / Activity Type | 5 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 28 | A279 | ETM Goods Recipient/Material/Activity Type | 6 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 29 | C498 | Doc. Category/Condition Type/Own-Ext./Actvty Type/Acc. Key | 8 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 30 | C499 | Doc. Cat./Cond. Type/Own-Ext./Acty Type/Ctlg Group/Acc. Key | 8 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 31 | KOT4012 | Condition Table for Price List Determination | 7 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
| 32 | KOTJ012 | Document Category/Recipient/Material Group/Activity Type | 7 | J_3GLVART | Activity Type | nvarchar | 4 | 0 | | |
