| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPContract Accounts Receivable and Payable |
| 1 | DFKKDEFREV_HEAD | Header Table (Event-Based Deferred Revenues) | 25 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
| 2 | DFKKDEFREV_POS | Line Item Table (Event-Based Deferred Revenues) | 58 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
| 3 | DFKKDEFREV_TRIG | Trigger Table - Amounts (Event-Based Deferred Revenues) | 17 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
| TOPDB2 for OS39 |
| 4 | DB2CCDL_OUTTS | DSNACCDL: History of output table | 10 | QTY_UNIT | Unit of primary and secondary allocation (Format CHAR9) | nvarchar | 9 | 0 | | |
| TOPDistributor-Reseller-Management |
| 5 | /SAPHT/DRMBUDL | Bill Up Due List | 56 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
| 6 | /SAPHT/DRMCONEXT | DRM Ship and debit agreement extracts | 34 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
| 7 | /SAPHT/DRMDETL | DRM Audit Trail | 13 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
| 8 | /SAPHT/DRMFIFINV | DRM Inventory Reconciliation FIFO Inventory | 6 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
| 9 | /SAPHT/DRMHEAD | DRM FIFO Header | 26 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
| 10 | /SAPHT/DRMINVSUM | DRM Inventory Summary | 23 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
| 11 | /SAPHT/DRMPPDL | Price Protection Due List | 16 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
| 12 | /SAPHT/DRMR3XN | DRM relevant ERP Transactions | 24 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
| 13 | /SAPHT/DRMREPINV | DRM Inventory Reconciliation Reported Inventory | 5 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
| 14 | /SAPHT/DRMSDDL | Ship and Debit Due List | 73 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
| 15 | /SAPHT/DRMSTAG | DRM Staging Area | 23 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
| TOPFinancials Basis |
| 16 | UBC_TB_CEDATA | Cost Events | 13 | QTY_UNIT | Unit | nvarchar | 3 | 0 | | |
| 17 | UBC_TB_CESTYP | Cost Event Subtypes | 5 | QTY_UNIT | Unit | nvarchar | 3 | 0 | | |
| TOPInvoicing in Contract Accounts Receivable and Payable |
| 18 | DFKKINVBILL_I | Billing Document Items | 44 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | |
| TOPSales and Distribution |
| 19 | ZZDEA_QTY | DEA quantity limits per customer and material | 7 | QTY_UNIT | Unit of Measure | nvarchar | 3 | 0 | | |
