| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAppropriation Requests |
1 | IMAK | Appropriation requests - general data | 44 | USE04 | User field 5 for unit for quantity field 5 - IM | nvarchar | 3 | 0 | | |
TOPConstruction Equipment Management |
2 | J_3GBELK | Document File - Header Data | 84 | USE04 | User field: Unit for quantity fields | nvarchar | 3 | 0 | | |
3 | J_3GBELP | Document Data - Item Data | 117 | USE04 | User field: Unit for quantity fields | nvarchar | 3 | 0 | | |
TOPCross-Application Components |
4 | PLLPO | Task list - operation/activity | 133 | USE04 | User field: Unit for quantity fields | nvarchar | 3 | 0 | | |
TOPInvestment Programs |
5 | IMPR | Investment Program Positions | 41 | USE04 | User field 5 for unit for quantity field 5 - IM | nvarchar | 3 | 0 | | |
TOPMaintenance History |
6 | HIVG | PM order history - operations | 59 | USE04 | User field: Unit for quantity fields | nvarchar | 3 | 0 | | |
TOPMaster Data Distribution |
7 | /ISDFPS/TL1 | Task List - Operation/Activity | 133 | USE04 | User field: Unit for quantity fields | nvarchar | 3 | 0 | | |
TOPOperative Structures |
8 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 50 | USE04 | 1st user defined field for quantity field unit - WBS element | nvarchar | 3 | 0 | | |
TOPProduction Orders |
9 | AFVU | DB structure of the user fields of the operation | 10 | USE04 | User field: Unit for quantity fields | nvarchar | 3 | 0 | | |
TOPRouting |
10 | PLPO | Task list - operation/activity | 133 | USE04 | User field: Unit for quantity fields | nvarchar | 3 | 0 | | |
TOPScheduling |
11 | KBEZ | Add. data for table KBED (for indiv. capacities/splits) | 18 | USE04 | User field: Unit for quantity fields | nvarchar | 3 | 0 | | |
TOPSimulation |
12 | VSAFVU_CN | Version: User fields in operation in order | 11 | USE04 | User field: Unit for quantity fields | nvarchar | 3 | 0 | | |
13 | VSKBEZ_CN | Version: Additional data for table KBED (ind. capacities) | 19 | USE04 | User field: Unit for quantity fields | nvarchar | 3 | 0 | | |
14 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 51 | USE04 | 1st user defined field for quantity field unit - WBS element | nvarchar | 3 | 0 | | |
TOPTemplates |
15 | PRPSS | Standard WBS Element (WBS element) - Master Data | 50 | USE04 | 1st user defined field for quantity field unit - WBS element | nvarchar | 3 | 0 | | |
TOPTreasury |
16 | VZSORT | Sort values for object | 10 | USE04 | User field: Unit for quantity fields | nvarchar | 3 | 0 | | |