| 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 | | |