| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAppropriation Requests |
| 1 | IMAK | Appropriation requests - general data | 43 | USR04 | User field 5 for quantity - IM | decimal | 13 | 3 | | |
| TOPConstruction Equipment Management |
| 2 | J_3GBELK | Document File - Header Data | 83 | USR04 | User field for quantity (length 10.3) | decimal | 13 | 3 | | |
| 3 | J_3GBELP | Document Data - Item Data | 116 | USR04 | User field for quantity (length 10.3) | decimal | 13 | 3 | | |
| TOPCross-Application Components |
| 4 | PLLPO | Task list - operation/activity | 132 | USR04 | User field for quantity (length 10.3) | decimal | 13 | 3 | | |
| TOPInvestment Programs |
| 5 | IMPR | Investment Program Positions | 40 | USR04 | User field 5 for quantity - IM | decimal | 13 | 3 | | |
| TOPMaintenance History |
| 6 | HIVG | PM order history - operations | 58 | USR04 | User field for quantity (length 10.3) | decimal | 13 | 3 | | |
| TOPMaster Data Distribution |
| 7 | /ISDFPS/TL1 | Task List - Operation/Activity | 132 | USR04 | User field for quantity (length 10.3) | decimal | 13 | 3 | | |
| TOPOperative Structures |
| 8 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 49 | USR04 | 1st user-defined field for quantity(length 10,3) WBS element | decimal | 13 | 3 | | |
| TOPProduction Orders |
| 9 | AFVU | DB structure of the user fields of the operation | 9 | USR04 | User field for quantity (length 10.3) | decimal | 13 | 3 | | |
| TOPReal Estate Management |
| 10 | S402 | Business entities | 33 | USR04 | User Field 1 for Set (Length 12,3) | decimal | 15 | 3 | | |
| 11 | S404 | Properties | 33 | USR04 | User Field 1 for Set (Length 12,3) | decimal | 15 | 3 | | |
| 12 | S405 | Building | 37 | USR04 | User Field 1 for Set (Length 12,3) | decimal | 15 | 3 | | |
| 13 | S406 | Rental units | 42 | USR04 | User Field 1 for Set (Length 12,3) | decimal | 15 | 3 | | |
| 14 | S407 | Rental agreements | 58 | USR04 | User Field 1 for Set (Length 12,3) | decimal | 15 | 3 | | |
| 15 | VIRPS405 | Building | 37 | USR04 | User field 1 for set (length 10,3) | decimal | 13 | 3 | | |
| 16 | VIRPS406 | Rental units | 42 | USR04 | User field 1 for set (length 10,3) | decimal | 13 | 3 | | |
| 17 | VIRPS407 | Rental agreements | 58 | USR04 | User field 1 for set (length 10,3) | decimal | 13 | 3 | | |
| TOPRouting |
| 18 | PLPO | Task list - operation/activity | 132 | USR04 | User field for quantity (length 10.3) | decimal | 13 | 3 | | |
| TOPSales |
| 19 | /CBAD/CONTRACT_H | Advanced Order Processing and Billing: Header Data | 27 | USR04 | 1st user defined field for quantities | decimal | 13 | 3 | | |
| 20 | /CBAD/CONTRACT_I | Advanced Order Processing and Billing: Item Data | 26 | USR04 | 1st user defined field for quantities | decimal | 13 | 3 | | |
| 21 | VBLB | Sales document: Release order data | 46 | USR04 | Additional data field 4 for delivery schedules | nvarchar | 10 | 0 | | |
| TOPScheduling |
| 22 | KBEZ | Add. data for table KBED (for indiv. capacities/splits) | 17 | USR04 | User field for quantity (length 10.3) | decimal | 13 | 3 | | |
| TOPShipping |
| 23 | LIPSPO | LIPS Reference Data Purchase Order | 23 | USR04 | Additional data field 4 for delivery schedules | nvarchar | 10 | 0 | | |
| 24 | LIPSRF | LIPS Reference Data | 21 | USR04 | Additional data field 4 for delivery schedules | nvarchar | 10 | 0 | | |
| TOPSimulation |
| 25 | VSAFVU_CN | Version: User fields in operation in order | 10 | USR04 | User field for quantity (length 10.3) | decimal | 13 | 3 | | |
| 26 | VSKBEZ_CN | Version: Additional data for table KBED (ind. capacities) | 18 | USR04 | User field for quantity (length 10.3) | decimal | 13 | 3 | | |
| 27 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 50 | USR04 | 1st user-defined field for quantity(length 10,3) WBS element | decimal | 13 | 3 | | |
| TOPTemplates |
| 28 | PRPSS | Standard WBS Element (WBS element) - Master Data | 49 | USR04 | 1st user-defined field for quantity(length 10,3) WBS element | decimal | 13 | 3 | | |
| TOPTreasury |
| 29 | VZSORT | Sort values for object | 9 | USR04 | User field for quantity (length 10.3) | decimal | 13 | 3 | | |
