| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Data |
1 | MKAL_AEND | Change History of Production Version (Recipes Only) | 10 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
TOPBills of Material |
2 | CLST | Link class - BOM | 7 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
3 | CSORDER_MAT | Administration of generated materials per sales order | 11 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
4 | CSPRJ_MAT | Management of generated materials to project | 10 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
5 | DOST | Document to BOM Link | 8 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
6 | EQST | Equipment to BOM Link | 8 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
7 | KDST | Sales Order to BOM Link | 10 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
8 | MAST | Material to BOM Link | 10 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
9 | PRST | Project - BOM link | 9 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
10 | PSGR | Master item group | 3 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
11 | PSVR | Master alternative items | 4 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
12 | STAS | BOMs - Item Selection | 12 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
13 | STKO | BOM Header | 13 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
14 | STPO | BOM item | 13 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
15 | STST | Standard BOM Link | 8 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
16 | TPST | Link Between Functional Location and BOM | 8 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
TOPComputer Aided Process Planning |
17 | PLPH | CAPP: Sub-operations | 11 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
18 | VERFK | Process header data | 6 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
19 | VFORK | Formula header data | 6 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
20 | VMETK | Method header data | 12 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
TOPCross-Application Components |
21 | MMAPL | Allocation of task lists to materials | 15 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
22 | PLLPO | Task list - operation/activity | 12 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
TOPEarly Warning System |
23 | MCYA | Early Warning: Exceptions | 4 | ANNAM | Created by | nvarchar | 12 | 0 | | |
TOPEngineering Change Management |
24 | AEDT | Engineering Change Management: Alternative Dates | 6 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
25 | AEEF | ECM: effectivity | 18 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
26 | AEHI | Change hierarchy | 5 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
27 | AENR | Change Master | 8 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
28 | AENV | ECH: Object Types for Change Master | 12 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
29 | AEOI | ECH: Object Management Records for Change Master | 12 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
30 | AEPF | ECM: effectivity | 17 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
31 | AEPREC | Identical object in explosion (header) | 9 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
32 | ECM_ADM | Administrative Data | 4 | ANNAM | Created By | nvarchar | 12 | 0 | | |
33 | TECS | Master Effectivity Object | 4 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
TOPFlow Manufacturing |
34 | LDLBH | Line balance/planned rate header record | 15 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
35 | LDLH | Line hierarchy header | 5 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
TOPLine Maintenance |
36 | /ISDFPS/LM_ACC_H | LM - Accident Header | 10 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
TOPMaintenance |
37 | /ISDFPS/PM_MB_H | PM Maintenance Book - Header | 9 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
TOPMaintenance Task Lists |
38 | EAPL | Allocation of task lists to pieces of equipment | 17 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
39 | PLWP | Allocation of maintenance packages to task list operations | 18 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
40 | TAPL | Allocation of task lists to functional locations | 15 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
TOPMaster Data Distribution |
41 | /ISDFPS/TL1 | Task List - Operation/Activity | 12 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
TOPMaster Recipe |
42 | PLFT | Process Instructions | 12 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
43 | PLFV | PI Characteristics/Sub-Operation Parameter Values | 13 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
TOPNetwork and Activity |
44 | PLAB | Relationships | 27 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
TOPProduct Data Management |
45 | KLFB | Assignment: Class to template | 8 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
TOPProduction ResourcesTools |
46 | CRFH | CIM production resource/tool master data | 12 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
TOPReporting |
47 | MCRSV | Selection versions: Header data | 4 | ANNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | |
48 | MCSHIERK | Header of general hierarchy | 12 | ANNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | |
TOPResourcen Management |
49 | MRTRST_HDR | RMS-MRTRS : MR Transformation Header | 30 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
50 | MRTRST_POP_REL | RMS-MRTRS : General Recipe Operation to Master Recipe Phase | 14 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
51 | MRTRST_PRI_REL | RMS-MRTRS : Equipment Requirement to Primary Resource | 12 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
52 | MRTRST_PST_REL | RMS-MRTRS: General Recipe Stage to Master Recipe Operation | 14 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
53 | MRTRST_QM_REL | RMS-MRTRS : QM of GR Element to QM of MR Element | 23 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
54 | MRTRST_SEC_REL | RMS-MRTRS: Equipment Requirement to Secondary Resource | 15 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
55 | MRTRST_STR_MAT | RMS-MRTRS: Assignment of Stream to Material | 14 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
56 | MRTRST_STR_REL | RMS-MRTRS: Stream with QM to Master Recipe Phase | 11 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
TOPRouting |
57 | MAPL | Assignment of Task Lists to Materials | 15 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
58 | PLAS | Task list - selection of operations/activities | 14 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
59 | PLFL | Task list - sequences | 13 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
60 | PLKO | Task list - header | 12 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
61 | PLMZ | Allocation of bill of material items to operations | 27 | ANNAM | User who created record | nvarchar | 12 | 0 | | |
62 | PLPO | Task list - operation/activity | 12 | ANNAM | User who created record | nvarchar | 12 | 0 | | |