| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAppropriation Requests |
1 | IMAK | Appropriation requests - general data | 41 | USR02 | User field 3 (10 characters) | nvarchar | 10 | 0 | | |
2 | TAIF9 | Value table for user fields | 3 | USR02 | User field 3 (10 characters) | nvarchar | 10 | 0 | | |
3 | TAIF9T | Value table for user fields | 4 | USR02 | User field 3 (10 characters) | nvarchar | 10 | 0 | | |
TOPConstruction Equipment Management |
4 | J_3GBELK | Document File - Header Data | 81 | USR02 | User field with 10 characters | nvarchar | 10 | 0 | | |
5 | J_3GBELP | Document Data - Item Data | 114 | USR02 | User field with 10 characters | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
6 | PLLPO | Task list - operation/activity | 130 | USR02 | User field with 10 characters | nvarchar | 10 | 0 | | |
TOPInvestment Programs |
7 | IMPR | Investment Program Positions | 38 | USR02 | User field 3 (10 characters) | nvarchar | 10 | 0 | | |
TOPMaintenance History |
8 | HIVG | PM order history - operations | 56 | USR02 | User field with 10 characters | nvarchar | 10 | 0 | | |
TOPMaster Data Distribution |
9 | /ISDFPS/TL1 | Task List - Operation/Activity | 130 | USR02 | User field with 10 characters | nvarchar | 10 | 0 | | |
TOPOperative Structures |
10 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 47 | USR02 | 3rd user-defined field 10 digits -WBS element | nvarchar | 10 | 0 | | |
TOPProduction Orders |
11 | AFVU | DB structure of the user fields of the operation | 7 | USR02 | User field with 10 characters | nvarchar | 10 | 0 | | |
TOPProject Summarization |
12 | PSERB | Inheritance data, Project System | 25 | USR02 | 3rd user-defined field 10 digits -WBS element | nvarchar | 10 | 0 | | |
TOPReal Estate Management |
13 | S402 | Business entities | 26 | USR02 | User-defined field 1 for 10 characters | nvarchar | 10 | 0 | | |
14 | S404 | Properties | 25 | USR02 | User-defined field 1 for 10 characters | nvarchar | 10 | 0 | | |
15 | S405 | Building | 29 | USR02 | User-defined field 1 for 10 characters | nvarchar | 10 | 0 | | |
16 | S406 | Rental units | 34 | USR02 | User-defined field 1 for 10 characters | nvarchar | 10 | 0 | | |
17 | S407 | Rental agreements | 46 | USR02 | User-defined field 1 for 10 characters | nvarchar | 10 | 0 | | |
18 | VIRPS405 | Building | 29 | USR02 | User-defined field 1 for 10 characters | nvarchar | 10 | 0 | | |
19 | VIRPS406 | Rental units | 34 | USR02 | User-defined field 1 for 10 characters | nvarchar | 10 | 0 | | |
20 | VIRPS407 | Rental agreements | 46 | USR02 | User-defined field 1 for 10 characters | nvarchar | 10 | 0 | | |
TOPRouting |
21 | PLPO | Task list - operation/activity | 130 | USR02 | User field with 10 characters | nvarchar | 10 | 0 | | |
TOPSales |
22 | /CBAD/CONTRACT_H | Advanced Order Processing and Billing: Header Data | 25 | USR02 | 2nd user field for 20 characters | nvarchar | 20 | 0 | | |
23 | /CBAD/CONTRACT_I | Advanced Order Processing and Billing: Item Data | 24 | USR02 | 2nd user field for 20 characters | nvarchar | 20 | 0 | | |
24 | VBLB | Sales document: Release order data | 44 | USR02 | Additional data field 2 for delivery schedules | nvarchar | 35 | 0 | | |
TOPShipping |
25 | LIPSPO | LIPS Reference Data Purchase Order | 21 | USR02 | Additional data field 2 for delivery schedules | nvarchar | 35 | 0 | | |
26 | LIPSRF | LIPS Reference Data | 19 | USR02 | Additional data field 2 for delivery schedules | nvarchar | 35 | 0 | | |
TOPSimulation |
27 | VSAFVU_CN | Version: User fields in operation in order | 8 | USR02 | User field with 10 characters | nvarchar | 10 | 0 | | |
28 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 48 | USR02 | 3rd user-defined field 10 digits -WBS element | nvarchar | 10 | 0 | | |
TOPTemplates |
29 | PRPSS | Standard WBS Element (WBS element) - Master Data | 47 | USR02 | 3rd user-defined field 10 digits -WBS element | nvarchar | 10 | 0 | | |
TOPTreasury |
30 | VZSORT | Sort values for object | 7 | USR02 | User field with 10 characters | nvarchar | 10 | 0 | | |