| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM007 | Data staging - Equip List Set - Char Values - complex table | 15 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
2 | /SMERP/STG_PM012 | Data staging - Func Loc LSet - Char Values - complex table | 15 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
3 | AUSP_CONV | Characteristic Values | 8 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
4 | CNV_10400_ATWRT | Found values for identified ATINNs per table | 5 | ATWRT | Characteristic value /copy of ATWRT | nvarchar | 30 | 0 | | |
TOPABAP List-Based PI Sheet |
5 | COFIV | PI Sheet: Signature for Deviation | 9 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
6 | COFVP | PI Sheet: Process Instruction Characteristics | 6 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
7 | COMEP | PI Sheet: Message Characteristics | 4 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
8 | COVLP | PI Sheet: Current Variable Values | 5 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPAssortment |
9 | WRF_APC_PAVAR | Planned Article Variants | 10 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPAssortment Maintenance |
10 | TWGR | Size interval to calculation factor assignment | 6 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPCharacteristics |
11 | CAWN | Characteristic values | 5 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPClasses |
12 | AUSP | Characteristic Values | 8 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
13 | CLSELSTATISTICS | Statistics for Optimizing Object Search | 6 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPComputer Aided Process Planning |
14 | VMETVOR | Data base for CAPP rules | 10 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPCross-Application Component CA Enhancements |
15 | MILL_CLPROFP | Profile for Selection by Characteristics: Items | 7 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPData Collection |
16 | S127 | Open Variants - Basis 2 | 12 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
17 | S127E | S127 - Structural information | 5 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
18 | S128 | Open Variants - SIS | 11 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
19 | S128E | S128 - Structural information | 6 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
20 | S129 | Open Variants - Planning | 12 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
21 | S129E | S129 - Structural information | 7 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPDigital Signature |
22 | TC74 | Digital Signature for PI Sheet | 12 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPEnvironment, Health and Safety |
23 | EHQMT_CODE2 | EH&S-QM: Assignment of Characteristic Values to Codes | 2 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
24 | EHQMT_MAIN1 | EH&S-QM: Subs. Value Assignmt Types for Insp. Plan Creation | 20 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPInstalled Base |
25 | IBSYMBOL | IB: Characteristic Value Assignment | 4 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPLogistics - General |
26 | HBSCNB | Configuration <-> condition indexing | 4 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
27 | HBSFSP | Help dummy table | 12 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
28 | WYT2M | Vendor-Dependent Characteristic Value Conversion | 5 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPMaintenance Program Definition |
29 | MPDEFFECT | MPD effectivity data | 6 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPMaster Recipe |
30 | PLFV | PI Characteristics/Sub-Operation Parameter Values | 19 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPMaterial Categories |
31 | /ISDFPS/MPO_PROT | Log of Data Transfers into MPO | 19 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPMaterial Groups |
32 | WMWP | Value Scale: Item Data | 4 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPMaterial Master |
33 | WRF_CHARVAL | Characteristic Values with Customer Fields | 3 | ATWRT | Characteristic Value (Seasonal Procurement) | nvarchar | 18 | 0 | | |
34 | WRF_CHARVALT | Foreign-Language Texts for Characteristic Values | 3 | ATWRT | Characteristic Value (Seasonal Procurement) | nvarchar | 18 | 0 | | |
TOPObject Dependencies |
35 | CUXREF | Object Dependency Cross References | 8 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPProcess Management |
36 | COFV | Process Management: Process Instr. Charact. in Ctrl Recipe | 6 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
37 | COME | Process Management: Message Characteristics | 4 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
38 | COMER | Process Message Record: Message Characteristics | 4 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
39 | TC50C | Characteristics for Process Messages / Process Instructions | 8 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
40 | TC50E | Process Management: Process Characteristics | 8 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
41 | TC60 | PP-PI: Assignment of PI Characteristics to Operator Cockpit | 9 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
42 | TCB11 | Assignment of Characteristics to Predefined Messages | 7 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPProcess Order |
43 | AFFV | Order - Process Instruction Values | 17 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPProduct Lifecycle Management |
44 | DIWPS_CA | Characteristics for Work Package | 6 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
45 | DIWPS_RV_CA | Revision: Characteristics for Work Package | 6 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPProduct Safety |
46 | TCGRULPOSMREST | EHS: Easy Expert Set of Rules, Characteristic Restrictions | 61 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPSoftware Management |
47 | S427 | Variant Config.2---IBASE | 11 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
48 | S427E | S427 - Structural information | 6 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPVariant Configuration |
49 | CDCND | Configuration: Direct Conditions Data Type:CHAR | 4 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
50 | IBVALUEC | CBASE: Redundant Object Doc. on Value Changes for Instance | 6 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
51 | MACOND | Configuration: Manually Assigned Conditions | 5 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPVehicle Management System |
52 | VLCSEARCHCHAR | VELO : Search Fields (Char.) Vehicle Search (for Profile) | 6 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPVendor Master |
53 | WYT2 | Vendor-dependent char. value conversion | 4 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |
TOPWaste Management |
54 | TEWAUPOSADMISBLE | Permissable Waste/Waste Fraction for Subitem | 7 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | | |