| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBasic Data |
| 1 | MKAL | Production Versions of Material | 36 | PRDAT | Date of last check of production version | nvarchar | 8 | 0 | | |
| TOPCATT Computer Aided Test Tool |
| 2 | CATA | CATT: General Test Procedure Data | 56 | PRDAT | Test date | nvarchar | 8 | 0 | | |
| 3 | CATQ | CATT - inspection indicator history | 2 | PRDAT | Test date | nvarchar | 8 | 0 | | |
| 4 | CATW | CATT test status | 4 | PRDAT | Test date | nvarchar | 8 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 5 | DFKKDEFREV_HEAD | Header Table (Event-Based Deferred Revenues) | 23 | PRDAT | Check Date for Selection in Adjustment Run | nvarchar | 8 | 0 | | |
| 6 | DFKKPPD | Promises to Pay Amounts per Date | 3 | PRDAT | Payment Date Promised | nvarchar | 8 | 0 | | |
| 7 | DFKKPPD_PAY | Promise to Pay Debit Memo Amounts per Date | 3 | PRDAT | Payment Date Promised | nvarchar | 8 | 0 | | |
| 8 | DFKKPPD_PAY_HIS | Promise to Pay Debit Memo Amounts per Date | 3 | PRDAT | Payment Date Promised | nvarchar | 8 | 0 | | |
| 9 | DFKKREPT | Receipt Documents | 6 | PRDAT | Print Date | nvarchar | 8 | 0 | | |
| 10 | DPAYH | Payment program - data for payment | 96 | PRDAT | Payment Date Promised | nvarchar | 8 | 0 | | |
| TOPFunctions for U.S. Federal Government |
| 11 | FMFG_VEKPO | JFMIP: Pending PO Line Item Changes Table | 12 | PRDAT | Date of last forecast | nvarchar | 8 | 0 | | |
| TOPInventory Controlling |
| 12 | PROP | Forecast parameters | 19 | PRDAT | Date of last forecast | nvarchar | 8 | 0 | | |
| TOPMaterial Master |
| 13 | MPOP_TMP | File for Incorrect Data in Direct Input | 21 | PRDAT | Date of last forecast | nvarchar | 8 | 0 | | |
| 14 | MVOP | Material data material versions | 18 | PRDAT | Date of last forecast | nvarchar | 8 | 0 | | |
| TOPOff-Cycle |
| 15 | T52OCG | Off-Cycle: Indicators for Batch: Payroll, Subsequent Program | 18 | PRDAT | Processing date | nvarchar | 8 | 0 | | |
| 16 | T52OCMP | Off-Cycle Flag for Mass Processing | 12 | PRDAT | Processing date | nvarchar | 8 | 0 | | |
| TOPPayroll General Parts |
| 17 | T51G1 | Off-Cycle Batch Table | 9 | PRDAT | Processing date | nvarchar | 8 | 0 | | |
| TOPPersonnel Administration |
| 18 | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | 29 | PRDAT | Earliest personal retroactive accounting date | nvarchar | 8 | 0 | | |
| TOPPurchasing |
| 19 | EINE | Purchasing Info Record: Purchasing Organization Data | 38 | PRDAT | Price Valid Until | nvarchar | 8 | 0 | | |
| 20 | EKPO | Purchasing Document Item | 74 | PRDAT | Date of Price Determination | nvarchar | 8 | 0 | | |
| TOPTools |
| 21 | PA0415 | HR Master Record: Infotype 0415 | 28 | PRDAT | Earliest personal retroactive accounting date | nvarchar | 8 | 0 | | |
| TOPTransfer Postings |
| 22 | J_1AAWAYBL | Way Bills for asset movements | 45 | PRDAT | Printing date for asset accounting way bill | nvarchar | 8 | 0 | | |
