| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM006 | Data staging - Equip List Set - Classifications - Cmplx Tab | 14 | ZAEHL | Sort Item | smallint | 5 | 0 | | |
2 | /SMERP/STG_PM011 | Data staging - Func Loc. LSet - Classifications - Cmplx Tab | 14 | ZAEHL | Sort Item | smallint | 5 | 0 | | |
3 | KSSK_CONV | Allocation Table: Object to Class | 7 | ZAEHL | Sort Item | smallint | 5 | 0 | | |
4 | SGT_PLKOS | Task list - header - Segmentation | 5 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
5 | T731 | Key Figures in Info Library (Transport Table) | 12 | ZAEHL | Counter of the calls in the Logistics Information Library | nvarchar | 8 | 0 | | |
6 | T731P | Info Set Assignment in LIL (Transport Table) | 3 | ZAEHL | Current item | nvarchar | 3 | 0 | | |
7 | TCLD | Characteristic Data from Standard | 4 | ZAEHL | Counter for material | nvarchar | 2 | 0 | | |
8 | TCY16 | Variable overview - column definition | 3 | ZAEHL | Counter for terms in a column definition for the var. overv. | nvarchar | 3 | 0 | | |
9 | TVGZU | View Control: Special Table Access | 4 | ZAEHL | Counter in control tables | nvarchar | 2 | 0 | | |
10 | ZPS12 | Project system: Text symbol assign. Standard netw/Routing | 6 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
11 | ZPS12F | Project system: Text symbol assign. Standard netw/Routing | 7 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
12 | ZPS13 | Proj.system: Text symbol assign. proced. std.netw./wrk ctr | 6 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPAdvertising Management |
13 | JHTAP | IS-M/AM: Settlement Run Log | 7 | ZAEHL | Counter in control tables | nvarchar | 2 | 0 | | |
TOPBasic Data |
14 | MKAL_AEND | Change History of Production Version (Recipes Only) | 5 | ZAEHL | Count parameters | nvarchar | 4 | 0 | | |
TOPBasic Functions |
15 | TVGMO | View Control: Exceptions for Move-Corresponding | 4 | ZAEHL | Counter in control tables | nvarchar | 2 | 0 | | |
TOPBatches |
16 | TCHW2 | Units of Measurement for Batch-Specific Units of Measure | 5 | ZAEHL | Numerator for a ratio | int | 10 | 0 | | |
TOPCAD Integration |
17 | USRCOBJ | Object Filters for Exploding Product Structures | 3 | ZAEHL | Counter | int | 10 | 0 | | |
TOPClasses |
18 | KSSK | Allocation Table: Object to Class | 7 | ZAEHL | Sort Item | smallint | 5 | 0 | | |
19 | TCLAO | Several Objects in one Class Type | 10 | ZAEHL | Classification: Sort Item | nvarchar | 2 | 0 | | |
TOPComputer Aided Process Planning |
20 | PLPH | CAPP: Sub-operations | 6 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPControlling |
21 | CPZPBACK | Production Reporting Points Periodic Totals Values (Temp) | 5 | ZAEHL | Counter for Reporting Points | nvarchar | 8 | 0 | | |
22 | CPZPTEMP | Production Reporting Points Periodic Totals Values (Temp) | 5 | ZAEHL | Counter for Reporting Points | nvarchar | 8 | 0 | | |
23 | QRP_CPZP | Reporting Points - Total Values per Date | 6 | ZAEHL | Counter for Reporting Points | nvarchar | 8 | 0 | | |
TOPCost Object |
24 | PZPE | Line Items for Measuring Point Update | 8 | ZAEHL | Counter key | nvarchar | 4 | 0 | | |
25 | PZPP | Production Measuring Points: Period Values | 4 | ZAEHL | Counter key | nvarchar | 4 | 0 | | |
26 | PZPS | Production Measuring Point for Totals Record | 4 | ZAEHL | Counter key | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
27 | MMAPL | Allocation of task lists to materials | 8 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
28 | PDS_OPER | PDS Data for Operations and Dependent Data | 10 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
29 | PLLPO | Task list - operation/activity | 5 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPDistribution Requirements Planning |
30 | PLPLAN_PARAM | BOM-dependent planning parameter | 5 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPDocument Management System |
31 | DRAO | Originals for documents | 7 | ZAEHL | Counter key | nvarchar | 4 | 0 | | |
32 | DRAOZ | Additional Files for DMS Originals | 8 | ZAEHL | Counter key | nvarchar | 4 | 0 | | |
TOPEarly Warning System |
33 | MCY1 | Objects: Early Warning | 4 | ZAEHL | Natural Number | int | 10 | 0 | | |
34 | MCYB | Objects: Early Warning | 3 | ZAEHL | Natural Number | int | 10 | 0 | | |
35 | MCYC | Key Figures: Early Warning | 3 | ZAEHL | Natural Number | int | 10 | 0 | | |
36 | MCYD | Early Warning: Groups of Exceptions | 3 | ZAEHL | Natural Number | int | 10 | 0 | | |
37 | MCYE | Early Warning: Trend Analysis Requirements | 3 | ZAEHL | Natural Number | int | 10 | 0 | | |
38 | MCYM | Objects: Early Warning | 3 | ZAEHL | Natural Number | int | 10 | 0 | | |
TOPEnvironment |
39 | LKSSK | Allocation Table: Object to Class | 7 | ZAEHL | Sort Item | smallint | 5 | 0 | | |
TOPFlow Manufacturing |
40 | LDLBC | Takts/no. of ind. capacities per line segment line balance | 4 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
41 | LDLBT | Line hierarchy entry and exit takts | 3 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
42 | LDLH | Line hierarchy header | 3 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
43 | LDLP | Line hierarchy items | 4 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
44 | LDMDR | Line Hierarchy Material-Dependent Rates | 4 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPGeneral status management |
45 | TJ49 | Table for Selection Conditions per SELID | 3 | ZAEHL | Counter used to differentiate between data base entries | nvarchar | 4 | 0 | | |
TOPIndustry-Specific Component Automotive |
46 | MHIS_UNPACKED | Copy of DB table MHIS (Data category INT4 replaced by NUMC) | 4 | ZAEHL | Maintenance Package Number | nvarchar | 2 | 0 | | |
TOPInformation System |
47 | MCAFVGV | Versions: Order Procedure | 7 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
48 | MCSFIS | R/2 SFIS Data: Old | 70 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPInspection Planning |
49 | PLMK | Inspection plan characteristics | 7 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
50 | PLMW | MAPL-Dependent Charac. Specifications (Inspection Plan) | 8 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPIntegrated Product and Process Engineering |
51 | CMIG_MAPPING | Mapping Table (Classic PP and iPPE Objekt Key) | 14 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPLogistics Execution |
52 | /DSD/PE_PHYSICAL | Header structure of SyncBO 'PhysicalUnit' for pricing engi | 5 | ZAEHL | Numerator for conversion to SI unit | int | 10 | 0 | | |
TOPLogistics Information Library |
53 | MCLI | Key Figures in Information Library | 12 | ZAEHL | Counter of the calls in the Logistics Information Library | nvarchar | 8 | 0 | | |
54 | MCLIP | Info Set Assignment in LIL | 3 | ZAEHL | Current item | nvarchar | 3 | 0 | | |
TOPMaintenance History |
55 | HIKO | Order master data history | 27 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
56 | HIVG | PM order history - operations | 10 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPMaintenance Notifications |
57 | QMIH | Quality message - maintenance data excerpt | 38 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPMaintenance Program Definition |
58 | MPDCYCLE | MPD: Cycle Data for Maintenance Document Items | 28 | ZAEHL | Maintenance Package Number | nvarchar | 2 | 0 | | |
TOPMaintenance Task Lists |
59 | EAPL | Allocation of task lists to pieces of equipment | 7 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
60 | MHIS | Maintenance plan history | 4 | ZAEHL | Maintenance Package Number | nvarchar | 2 | 0 | | |
61 | MMPT | Cycle definitions and MeasPoints for MaintPlan | 13 | ZAEHL | Maintenance Package Number | nvarchar | 2 | 0 | | |
62 | PLWP | Allocation of maintenance packages to task list operations | 8 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
63 | T351P | Maintenance packages | 3 | ZAEHL | Maintenance Package Number | nvarchar | 2 | 0 | | |
64 | T351P_OLD | Old Version of Maintenance Packages | 3 | ZAEHL | Maintenance Package Number | nvarchar | 2 | 0 | | |
65 | TAPL | Allocation of task lists to functional locations | 7 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPMaster Data Distribution |
66 | /ISDFPS/TL1 | Task List - Operation/Activity | 5 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPMaster Recipe |
67 | PLFT | Process Instructions | 7 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
68 | PLFV | PI Characteristics/Sub-Operation Parameter Values | 8 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPMaterial Master |
69 | MERRDAT_TMP | File for Incorrect Data in Direct Input | 3 | ZAEHL | 10 digit number | nvarchar | 10 | 0 | | |
70 | MFHM_TMP | File for Incorrect Data in Direct Input | 9 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
71 | MVHM | MRP material version | 6 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPNetwork and Activity |
72 | MLST | Milestone | 3 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
73 | PLAB | Relationships | 11 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
74 | TCNTM03 | Assignment of date type/milestone to group | 5 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPPeriodical Sales and Distribution |
75 | JFFS | IS-M/SD: Error Log for Collective Billing Doc.Processing | 6 | ZAEHL | Counter in control tables | nvarchar | 6 | 0 | | |
76 | JFXJFFSDL | IS-M: Backup Transfer Internal Table XJFFS | 8 | ZAEHL | Counter in control tables | nvarchar | 2 | 0 | | |
77 | JLFS | IS-M/SD: Error Log for Collective Settlement Processing | 6 | ZAEHL | Counter in control tables | nvarchar | 6 | 0 | | |
TOPPlant Maintenance |
78 | Z9I_STK_VORGANG | Terminkontrolle Stillstandsplanung: Relevante Vorgänge | 12 | ZAEHL | Interner Zähler | nvarchar | 8 | 0 | | |
79 | Z9MIANF | Stillstanndsplanung - Daten für Anfragen | 10 | ZAEHL | Interner Zähler | nvarchar | 8 | 0 | | |
80 | Z9MISTP | Stillstandsplanung | 7 | ZAEHL | Interner Zähler | nvarchar | 8 | 0 | | |
TOPProcess Order |
81 | AFFT | Order - Process Instructions | 11 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
82 | AFFV | Order - Process Instruction Values | 13 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPProduct Cost by Period |
83 | CEZP | Reporting Points Line Items | 9 | ZAEHL | Counter for Reporting Points | nvarchar | 8 | 0 | | |
84 | CHZP | Reporting Points - Change History | 7 | ZAEHL | Counter for Reporting Points | nvarchar | 8 | 0 | | |
85 | CPZP | Reporting Points - Periodic Totals Values | 5 | ZAEHL | Counter for Reporting Points | nvarchar | 8 | 0 | | |
TOPProduct Cost Planning |
86 | KEKO | Product Costing - Header Data | 67 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPProduct Lifecycle Management |
87 | DIWPS_CR | Work Package Cross-Reference Notification | 12 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
88 | DIWPS_RV_CR | Revision: Cross-Reference Notification | 9 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPProduction Campaign |
89 | PCMO1 | Pegged production campaign: material | 3 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
90 | PCMO2 | Pegged production campaign: requirements | 3 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
91 | PCMO3 | Pegged production campaign: recipe | 3 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
92 | PCMO4 | Production campaign pegged reqmt resource network | 3 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
93 | PCMP | Production campaign item | 3 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPProduction Orders |
94 | AFFL | Work order sequence | 8 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
95 | AFKO | Order Header Data PP Orders | 60 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
96 | AFVC | Operation within an order | 10 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPProduction ResourcesTools |
97 | CRFH | CIM production resource/tool master data | 4 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPQM Control in Procurement |
98 | QINF | QM-info record for material and vendor | 3 | ZAEHL | Internal Counter for DB Objects | nvarchar | 6 | 0 | | |
TOPQuality Inspection |
99 | QALS | Inspection lot record | 71 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
100 | /BEV3/CHCIVBFS | Error Log Collective Run CH Docs. Using Create Invoice | 8 | ZAEHL | Counter in control tables | nvarchar | 2 | 0 | | |
TOPRepetitive Manufacturing |
101 | T437U | Control Table for Further Processing of Goods Receipts | 5 | ZAEHL | Help counter | nvarchar | 3 | 0 | | |
TOPReporting |
102 | MCKZSF | Key figures for key figure view | 4 | ZAEHL | Sequence Number | nvarchar | 2 | 0 | | |
103 | MCRMK | LIS selection versions: Characteristics | 3 | ZAEHL | Sequence Number | nvarchar | 2 | 0 | | |
104 | MCRSV_USR | Selection version: Assigned distribution lists or users | 3 | ZAEHL | Sequence Number | nvarchar | 2 | 0 | | |
TOPResourcen Management |
105 | MRTRST_HDR | RMS-MRTRS : MR Transformation Header | 24 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
106 | MRTRST_POP_REL | RMS-MRTRS : General Recipe Operation to Master Recipe Phase | 5 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
107 | MRTRST_PST_REL | RMS-MRTRS: General Recipe Stage to Master Recipe Operation | 5 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
108 | MRTRST_QM_REL | RMS-MRTRS : QM of GR Element to QM of MR Element | 7 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
109 | MRTRST_SEC_REL | RMS-MRTRS: Equipment Requirement to Secondary Resource | 5 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPResults Recording |
110 | QAMV | Characteristic specifications for inspection processing | 120 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPRouting |
111 | MAPL | Assignment of Task Lists to Materials | 8 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
112 | PLAS | Task list - selection of operations/activities | 7 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
113 | PLFH | Task list - production resources/tools | 5 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
114 | PLFL | Task list - sequences | 6 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
115 | PLKO | Task list - header | 5 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
116 | PLMZ | Allocation of bill of material items to operations | 5 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
117 | PLPO | Task list - operation/activity | 5 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPScheduling |
118 | KBED | Capacity Requirements Records | 40 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPShipping |
119 | VBFS | Error Log for Collective Processing | 6 | ZAEHL | Counter in control tables | nvarchar | 2 | 0 | | |
TOPSimulation |
120 | VSAFFL_CN | Version: Order sequences PP orders | 9 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
121 | VSAFKO_CN | Version: Order header data for PP orders | 61 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
122 | VSAFVC_CN | Version: Operation in order | 11 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
123 | VSHIST_NP | Tranfer history for network | 3 | ZAEHL | Counter: Transfer objects | nvarchar | 8 | 0 | | |
124 | VSHIST_NV | Tranfer history for network activity | 4 | ZAEHL | Counter: Transfer objects | nvarchar | 8 | 0 | | |
125 | VSHIST_OK | Transfer history material components | 5 | ZAEHL | Counter: Transfer objects | nvarchar | 8 | 0 | | |
126 | VSHIST_OR | Transfer history order | 3 | ZAEHL | Counter: Transfer objects | nvarchar | 8 | 0 | | |
127 | VSHIST_OV | Transfer history activity | 4 | ZAEHL | Counter: Transfer objects | nvarchar | 8 | 0 | | |
128 | VSHIST_PD | Transfer history project definition | 3 | ZAEHL | Counter: Transfer objects | nvarchar | 8 | 0 | | |
129 | VSHIST_PR | Transfer history WBS element | 3 | ZAEHL | Counter: Transfer objects | nvarchar | 8 | 0 | | |
130 | VSKBED_CN | Version: Capacity requirement records | 41 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
131 | VSMLST_CN | Version: Milestone | 4 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | |
TOPUnits of Measurement |
132 | T006 | Units of Measurement | 11 | ZAEHL | Numerator for conversion to SI unit | int | 10 | 0 | | |
TOPVariant Configuration |
133 | CUCO | Additional Data for Configurable Objects | 4 | ZAEHL | Internal counter | nvarchar | 4 | 0 | | |
134 | IBVALUEC | CBASE: Redundant Object Doc. on Value Changes for Instance | 4 | ZAEHL | Numerator for conversion to SI unit | int | 10 | 0 | | |
135 | KRIF | Richie Riffle | 3 | ZAEHL | Internal counter for alternative access path | nvarchar | 4 | 0 | | |
TOPWork Center |
136 | KAPE | Capacity unit of measure allocation | 5 | ZAEHL | Numerator for conversion to SI unit | int | 10 | 0 | | |