| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPABAP List-Based PI Sheet |
| 1 | COTRP | PI Sheet: Process Parameter Texts (Versions) | 7 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| TOPAssortment Maintenance |
| 2 | TWSAI | (Annual) Seasons | 6 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| 3 | TWSAJ | Annual seasons (distribution chain-specific) | 8 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| 4 | WSOF | Module Assignment (SAP Retail) to Plants | 4 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| 5 | WSOH | Assortment Modules SAP Retail | 4 | DATUB | Valid To Date | nvarchar | 8 | 0 | | |
| 6 | WSOP | Modules SAP Retail / Item Data | 4 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| TOPBasic Data |
| 7 | MKAL_AEND | Change History of Production Version (Recipes Only) | 8 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| TOPClasses |
| 8 | AUSP | Characteristic Values | 26 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| 9 | KSSK | Allocation Table: Object to Class | 14 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| TOPCompany Pension Scheme Germany |
| 10 | T5DCV | Entitlement Status | 9 | DATUB | Transfer Data Even if Not Relevant for Valuation | nvarchar | 1 | 0 | | |
| TOPDistribution Requirements Planning |
| 11 | PLPLAN_PARAM | BOM-dependent planning parameter | 8 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| TOPExcise Duty |
| 12 | /BEV2/ED912 | Customer Tax Warehouse | 6 | DATUB | Valid To Date | nvarchar | 8 | 0 | | |
| 13 | /BEV2/ED913 | Vendor Tax Warehouse | 6 | DATUB | Valid To Date | nvarchar | 8 | 0 | | |
| TOPMaster Data |
| 14 | T439G | PPplanning periods: header table | 8 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| TOPObject Dependencies |
| 15 | CUVTLN | Line object of variant table | 9 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| TOPProcess Order |
| 16 | MAKZ | Material cost distribution equivalence numbers | 8 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| TOPProduction ResourcesTools |
| 17 | CRFH | CIM production resource/tool master data | 10 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| TOPPurchasing |
| 18 | AMPL | Table of Approved Manufacturer Parts | 8 | DATUB | Date until which the MPN material may be procured | nvarchar | 8 | 0 | | |
| 19 | AMPL_REJECTION | Rejection of AMPL Row | 8 | DATUB | Date until which the MPN material may be procured | nvarchar | 8 | 0 | | |
| TOPRemaining Beverage - Obsolete Objects |
| 20 | /BEV3/CHSORTK | CH Assortments Header | 5 | DATUB | CH Date Valid To | nvarchar | 8 | 0 | | |
| 21 | /BEV3/CHSORTP | CH Assortments Item | 7 | DATUB | CH Date Valid To | nvarchar | 8 | 0 | | |
| TOPReporting |
| 22 | MCSHIERB | Tree for general hierarchy | 6 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| TOPResourcen Management |
| 23 | MRTRST_QM_REL | RMS-MRTRS : QM of GR Element to QM of MR Element | 12 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| TOPSAP Ambulatory Care Management |
| 24 | N2HM_INDIKKEY | Heilmittelverordnung: Indikationsschlüssel | 5 | DATUB | Datum gültig bis | nvarchar | 8 | 0 | | |
| 25 | N2HM_KPF | ACM: Kopfdaten zum Heilmittelkatalog | 6 | DATUB | Datum gültig bis | nvarchar | 8 | 0 | | |
| TOPVariant Configuration |
| 26 | CUCO | Additional Data for Configurable Objects | 19 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| TOPWaste Management |
| 27 | EWA_EL_WDPPROC | Transaction Within Facility | 11 | DATUB | End Date | nvarchar | 8 | 0 | | |
| 28 | EWA_WA_PCKGDSREG | General Cargo Entry | 21 | DATUB | End Date | nvarchar | 8 | 0 | | |
| 29 | EWA_WA_WEIGHOFFL | Offline Weighing | 77 | DATUB | End Date | nvarchar | 8 | 0 | | |
| 30 | EWA_WA_WEIGHPROC | Weighing Transaction | 59 | DATUB | End Date | nvarchar | 8 | 0 | | |
| TOPWork Center |
| 31 | KAPA | Shift Parameters for Available Capacity | 4 | DATUB | End Date | nvarchar | 8 | 0 | | |
| 32 | KAZY | Interval of Available Capacity | 4 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
| 33 | TC31A | Key for performance efficiency rate | 3 | DATUB | Valid-to date | nvarchar | 8 | 0 | | |
