| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 57 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
2 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 57 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
3 | /XFT/QMPPAPT001 | QM Sampling Header Table | 14 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPConfiguration management |
4 | IBSPCM | IB: Config.Mang.: Specialization | 16 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPCost Object |
5 | FCO_DOC_HEAD | Failure Cost Document Header | 61 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPDefense Forces and Public Security |
6 | /ISDFPS/ZEBAN | Copy of EBAN | 73 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPEngineering Change Management |
7 | AEOI | ECH: Object Management Records for Change Master | 17 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
8 | TCC09 | ECH: Revision Level Sequence | 4 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPEquipment |
9 | EQUI | Equipment master data | 52 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPInstalled Base |
10 | IBSP | IB: Installed Base Component - Enhancement/Specialization | 16 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPInventory Management |
11 | MWZDM07M2 | ZDM07M2 | 36 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
12 | RESB | Reservation/dependent requirements | 119 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPMaintenance Notifications |
13 | QMEL | Quality Notification | 25 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPMaster Data |
14 | MDSM | Simulative dependent requirements | 74 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
15 | MDTB | MRP Table | 54 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
16 | PLAF | Planned Order | 68 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPMaterials Management |
17 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 78 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPProduction Orders |
18 | AFKO | Order Header Data PP Orders | 85 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPPurchasing |
19 | AMPL | Table of Approved Manufacturer Parts | 9 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
20 | AMPL_REJECTION | Rejection of AMPL Row | 9 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
21 | EBAN | Purchase Requisition | 73 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
22 | EKPO | Purchasing Document Item | 96 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
23 | MEREQX | Purchase Requisition Change Parameter | 73 | REVLV | Updated information in related user data field | nvarchar | 1 | 0 | | |
TOPQM Control in Procurement |
24 | QINF | QM-info record for material and vendor | 32 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPQM Control in Sales and Distribution |
25 | QVDM | QM Info Record - QM Control in SD | 5 | REVLV | Not Used at the Moment | nvarchar | 2 | 0 | | |
TOPQuality Inspection |
26 | QALS | Inspection lot record | 101 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPRepetitive Manufacturing |
27 | COMPMOVE | Goods Movement of Components | 109 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
28 | RMIO | Input Structure of Repetitive Manufacturing Confirmation | 25 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPSample Management |
29 | QPRN | Sample drawing of phys. samples | 6 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
30 | QPRS | Master record for phys. samples | 15 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPSerial Numbers |
31 | EQSE | Serial Number Records | 21 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
TOPSimulation |
32 | VSAFKO_CN | Version: Order header data for PP orders | 86 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
33 | VSEBAN_CN | Version: Purchase requisition | 73 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
34 | VSPLAF_CN | Version: Planned order | 68 | REVLV | Revision Level | nvarchar | 2 | 0 | | |
35 | VSRESB_CN | Version: Reservation/Dependent requirements | 120 | REVLV | Revision Level | nvarchar | 2 | 0 | | |