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