| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | CNVTDMS_05_EIKP | Collected Header Document Numbers for TDMS_Time-EIKP | 3 | EXNUM | EXNUM for EIKP | nvarchar | 10 | 0 | | |
| TOPAdvertising Management |
| 2 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 67 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
| TOPBasic Functions |
| 3 | EIEI | Foreign Trade: Export/Import Communication Data | 2 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
| 4 | EIKP | Foreign Trade: Export/Import Header Data | 2 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
| 5 | EIPO | Foreign Trade: Export/Import: Item Data | 2 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
| 6 | EIUV | Foreign Trade: Incompletion Log for Foreign Trade Data | 3 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
| 7 | EIZO | FT: Exp/Imp ident. of goods, pres. of goods for cust.declar. | 2 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
| TOPBilling |
| 8 | VBRK | Billing Document: Header Data | 56 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 9 | DFKKTAXEX | Table of FI-CA Tax Exemptions | 7 | EXNUM | Number of Exemption Licence | nvarchar | 15 | 0 | | |
| 10 | DFKKTAX_EXEMPT | Table of FI-CA Tax Exemptions | 7 | EXNUM | Number of exemption certificate | nvarchar | 15 | 0 | | |
| TOPData Retention Tool |
| 11 | TXW_S_EKKO | Retrieve EKKO from archive | 20 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
| 12 | TXW_S_LIKP | Retrieve LIKP from archive | 16 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
| 13 | TXW_S_MKPF | Retrieve MKPF from archive | 23 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
| 14 | TXW_S_VBRK | Retrieve VBRK from archive | 33 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
| TOPInventory Management |
| 15 | MKPF | Header: Material Document | 24 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
| TOPLocalization |
| 16 | J_1IEXCDTL | Excise invoice line item details | 7 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
| 17 | J_1IEXCHDR | Excise invoice header detail | 10 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
| 18 | J_1IGRXREF | Goods Receipt to Excise Invoice Coss Reference | 5 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
| 19 | J_1IGRXSUB | GR reference to subcontracting challans | 5 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
| 20 | J_1IKONV | Excise recalculated conditions | 6 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
| 21 | J_1IQRDEP | Quarterly Returns Depot structure | 7 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
| 22 | J_1IRG23D | RG23D register for the depot | 15 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
| 23 | J_1I_INBDELV | INBOUND DELIVERY DETAILS FROM sus | 4 | EXNUM | Official Excise Document Number | nvarchar | 10 | 0 | | |
| TOPLogistics - General |
| 24 | WBHK | Trading Contract: Header Data | 32 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
| TOPPurchasing |
| 25 | EKKO | Purchasing Document Header | 55 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
| TOPShipping |
| 26 | LIKP | SD Document: Delivery Header Data | 61 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | | |
