| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | DFKK_ACCADJ | Adjustment Postings when Implementing Acct Assgmt Chars | 2 | KEY_DATE | Key Date for Analysis of Open Items | nvarchar | 8 | 0 | | |
| 2 | DFKK_NEWACCADJ | Obsolete: See DFKK_ACCADJ | 2 | KEY_DATE | Key Date for Analysis of Open Items | nvarchar | 8 | 0 | | |
| 3 | T706_CITYCD_CHG | Replacement/Combination of Community Code Numbers, Date-Dep. | 3 | KEY_DATE | End Date | nvarchar | 8 | 0 | | |
| 4 | TRCCT_CURRCHANGE | Currency changeover | 5 | KEY_DATE | Currency Changeover Key Date | nvarchar | 8 | 0 | | |
| 5 | VIXCITCADAO | Temporary architectural object data | 3 | KEY_DATE | Date | nvarchar | 8 | 0 | | |
| 6 | VIXCITCADLOG | Logging table for Splitting/Merging of Cadaster Data | 3 | KEY_DATE | Processing Date | nvarchar | 8 | 0 | | |
| 7 | VIXCITCADMSR | Temporary measurement data | 3 | KEY_DATE | Date | nvarchar | 8 | 0 | | |
| 8 | VIXCITCADRO | Temporary rental object data | 3 | KEY_DATE | Date | nvarchar | 8 | 0 | | |
| 9 | PIQPROC_DH | Activity Documents: Document Header | 5 | KEY_DATE | Activity Key Date (General) | nvarchar | 8 | 0 | | |
| TOPBank Customer Accounts |
| 10 | BKKSO | BCA: Standing Orders | 10 | KEY_DATE | Key date | nvarchar | 2 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 11 | DFKK_BALANOTE | Balance Confirmation - Check Table | 11 | KEY_DATE | Key Date for Balance Notification | nvarchar | 8 | 0 | | |
| 12 | DFKK_DUEGRID | OI - Reclassifications | 2 | KEY_DATE | Key Date for Analysis of Open Items | nvarchar | 8 | 0 | | |
| 13 | DFKK_HBALANOTE | Balance Confirmation - Run Table | 5 | KEY_DATE | Key Date for Balance Notification | nvarchar | 8 | 0 | | |
| 14 | DFKK_RECLASS | OI - Reclassifications | 2 | KEY_DATE | Key Date for Analysis of Open Items | nvarchar | 8 | 0 | | |
| TOPElectronic Data Interchange |
| 15 | WRF_PRICAT_TRIG | Price Catalog Inbound: Trigger Table for Scheduled Data | 5 | KEY_DATE | Primary Update Date Set Online | nvarchar | 8 | 0 | | |
| TOPInterestCharge Calculation |
| 16 | BKKM2 | Account Time Periods | 7 | KEY_DATE | Key date | nvarchar | 2 | 0 | | |
| TOPJapan |
| 17 | PTJPFWS_ITEMDATA | (Obsolete) Request Item Data for Flexible Work Schedule JP | 10 | KEY_DATE | Start Date | nvarchar | 8 | 0 | | |
| 18 | T7JPCP_FORMSPC | Define Form Specification | 8 | KEY_DATE | Key Date for Data Retrieving | nvarchar | 2 | 0 | | |
| 19 | TPTJPFWS_ITEMDAT | Request Item Data for Flexible Work Schedule JP | 9 | KEY_DATE | Start Date | nvarchar | 8 | 0 | | |
| TOPPosition Budgeting and Control |
| 20 | HRFPM_COLUMN_CON | Buffer for Columns in HRPBCM | 9 | KEY_DATE | System Date | nvarchar | 8 | 0 | | |
| TOPPublic Sector Contract Accounts Receivable and Payable |
| 21 | DFMCA_BRF400 | BRF : Parameters for Facts of Property Tax | 11 | KEY_DATE | BRF: Key Date for Property Tax | nvarchar | 20 | 0 | | |
| TOPTransaction Manager |
| 22 | IDCFM_DATA_SEC | Valuation-Area-Independent Data for Securities | 2 | KEY_DATE | Position Value Date | nvarchar | 8 | 0 | | |
| 23 | IDCFM_FRIM_DATA | Impairment Main Data | 10 | KEY_DATE | Key Date for Valuation | nvarchar | 8 | 0 | | |
| 24 | IDCFM_FRIM_DEXP | Impairment: BAdI Example Values: Expected & Expert Values | 10 | KEY_DATE | Key Date for Valuation | nvarchar | 8 | 0 | | |
| 25 | TRDTT_DATA_ADMIN | Legacy Data Transfer Admin. Entries Business Transactions | 2 | KEY_DATE | Position Value Date | nvarchar | 8 | 0 | | |
| 26 | TRDTT_DATA_SEC | Valuation-Area-Independent Data for Securities | 2 | KEY_DATE | Position Value Date | nvarchar | 8 | 0 | | |
| 27 | TRDTT_IGTDATA_SE | Intragroup Transaction (IGT) Data for Securities | 2 | KEY_DATE | Position Value Date | nvarchar | 8 | 0 | | |
| 28 | TRDTT_VADATA_FUT | Valuation-Area-Dependent Data for Futures | 2 | KEY_DATE | Position Value Date | nvarchar | 8 | 0 | | |
| 29 | TRDTT_VADATA_OTC | Valuation-Area-Dependent Data for MM, FX, OTC Derivatives. | 2 | KEY_DATE | Position Value Date | nvarchar | 8 | 0 | | |
| 30 | TRDTT_VADATA_SEC | Valuation-Area-Dependent Data for Securities | 2 | KEY_DATE | Position Value Date | nvarchar | 8 | 0 | | |
| 31 | TRGC_MIGR2 | Migration: Key Date of Data Transfer per Company Code | 3 | KEY_DATE | Migration: Key Date of Data Transfer | nvarchar | 8 | 0 | | |
| 32 | TRLIT_AD_MIGRATE | Accrual/Deferral: Log Data of Migration to EP 2: | 7 | KEY_DATE | Accrual/Deferral Key Date | nvarchar | 8 | 0 | | |
| 33 | TRLIT_AD_TRANS | Accrual/Deferral Business Transactions (Documentation avail) | 9 | KEY_DATE | End of Calculation Period | nvarchar | 8 | 0 | | |
| 34 | TWSPV | Security Prices for Special Valuation | 5 | KEY_DATE | Field of type DATS | nvarchar | 8 | 0 | | |
| TOPTransfer to Financial Accounting |
| 35 | TLVT_MANUAL_VAL | Book Values for Manual Valuation of Positions | 2 | KEY_DATE | Key Date for Valuation | nvarchar | 8 | 0 | | |
| 36 | TRILT_DTRANS | Derived Business Transactions in the Income Ledger | 8 | KEY_DATE | Date of a Business Transaction in the Income Ledger | nvarchar | 8 | 0 | | |
| 37 | TRLT_INIT_IGT_SE | Initialization Values for Intragroup Transactions | 2 | KEY_DATE | System Date | nvarchar | 8 | 0 | | |
| 38 | TRLT_INIT_TRANS | List of Initializing Business Transactions | 13 | KEY_DATE | Treasury Ledger Date | nvarchar | 8 | 0 | | |
| 39 | TRLT_INIT_VAL_FU | Initialization Values for TRL Futures Positions | 2 | KEY_DATE | System Date | nvarchar | 8 | 0 | | |
| 40 | TRLT_INIT_VAL_HR | Init.Hedging Rel.:Mapping to Hedging Rel.in New Company Code | 9 | KEY_DATE | Treasury Ledger Date | nvarchar | 8 | 0 | | |
| 41 | TRLT_INIT_VAL_LO | Initialization Values for TRL Positions: Loans | 2 | KEY_DATE | System Date | nvarchar | 8 | 0 | | |
| 42 | TRLT_INIT_VAL_SE | Initialization Values for TRL Positions: Securities | 2 | KEY_DATE | System Date | nvarchar | 8 | 0 | | |
| 43 | VALT_SP_VAL_SEC | Security Prices and NPV for Special Valuation | 10 | KEY_DATE | Key Date for Valuation | nvarchar | 8 | 0 | | |
| TOPTranslation Tools |
| 44 | LXE_DURA | Problem Messages | 3 | KEY_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
