| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKEPRT | Log for Inconsistent FI-CA Documents | 54 | TATYP | Transaction Class of Document | nvarchar | 1 | 0 | | |
2 | P2RA_DFRT | Payroll Result for Other Payroll Periods | 7 | TATYP | Usage Type in Payroll Run | nvarchar | 4 | 0 | | |
3 | TSTE | Invalid will not be used anymore | 2 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
4 | TSTL | Taxes: Valid Tax Categories for Each Country | 4 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
5 | TSTMT | Taxes: Material: Texts (Obsolete, Superseded by TSKMT) | 3 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
TOPAdvertising Management |
6 | TJJ35 | IS-M/AM: Vendor Tax Classification | 2 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
7 | TJJ36 | IS-M/AM: Tax Indicator for Vendor - Texts | 3 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
8 | TJJAJ | IS-M/AM: Standard Settings, Media Sales Agent Settlement | 11 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
TOPAustria |
9 | T5AU0 | Usage Types of Simulation Results | 2 | TATYP | Usage Type in Payroll Run | nvarchar | 4 | 0 | | |
10 | T5AU0T | Usage Types of Simulation Results (Text Table) | 3 | TATYP | Usage Type in Payroll Run | nvarchar | 4 | 0 | | |
TOPBasic Functions |
11 | FEBEP | Electronic Bank Statement Line Items | 106 | TATYP | Transaction | nvarchar | 4 | 0 | | |
TOPBilling |
12 | KNVI | Customer Master Tax Indicator | 4 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
13 | KNVL | Customer Master Licenses | 4 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
TOPCentral Part of Product Master |
14 | CRMC_TAX_MAP_BP | BP Tax Classification of Conditions: Mapping R/3 <-> CRM | 6 | TATYP | Tax Category (Sales Tax, Federal Sales Tax,...) | nvarchar | 4 | 0 | | |
TOPContract Accounts Receivable and Payable |
15 | DFKKKO | Header Data in Open Item Accounting Document | 32 | TATYP | Transaction Class of Document | nvarchar | 1 | 0 | | |
16 | DFKKMKO | Header data for sample contract accounting document | 32 | TATYP | Transaction Class of Document | nvarchar | 1 | 0 | | |
TOPCustomer Master |
17 | TB072_CM | Tax Classification: Mapping R/3 <-> CRM | 6 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
TOPElectronic Bank Statement |
18 | FEB_TATYP | Transaction | 1 | TATYP | Transaction | nvarchar | 4 | 0 | | |
19 | FEB_TATYP_C | Transaction - Customer Adjustment | 2 | TATYP | Transaction | nvarchar | 4 | 0 | | |
20 | FEB_TATYP_T | Transaction Text | 1 | TATYP | Transaction | nvarchar | 4 | 0 | | |
21 | FEB_TATYP_TC | Transaction Text - Customer Adjustment | 2 | TATYP | Transaction | nvarchar | 4 | 0 | | |
TOPMaster Data |
22 | TJG67 | IS-M: Preset Tax Code for Customer | 4 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
TOPMaterial Master |
23 | STEU_TMP | File for Incorrect Data in Direct Input | 8 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
24 | TSKM | Material Taxes | 2 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
25 | TSKMT | Taxes: Materials: Texts | 3 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
TOPWord Processing |
26 | TSKD | Customer Taxes | 2 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
27 | TSKDT | Customer Taxes: Texts | 3 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |