| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000170000 | PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta | 67 | KTOSL | | nvarchar | 3 | 0 | | |
2 | /CCEE/FISITCA | Slovenia: Tax Code Assigments to DMEE File Positions | 6 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
3 | /CCEE/RSFITAX | Convert Tax on sales | 3 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
4 | /CCEE/RSFITCA | Serbia: Tax Code Assigments to DMEE File Positions | 6 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
5 | /CCEE/SIFI_UMSIT | Tax items applied for decrease/increase of input VAT | 8 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
6 | /CEECV/BEFI_VATD | VAT Report Estonia - document processed from RFUMSV00 | 19 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
7 | /CEECV/BVFI_DTTK | Exclude Transaction Key from VAT Declaration | 3 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
8 | /CEECV/BVFI_PVN | Documents for VAT Declaration | 18 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
9 | /CEECV/ROFIRFUMD | RFUMSV00:Asgn.Tax codes to ROspec columns-DEFERRED t.codes | 4 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
10 | /SAPPCE/TDPC78 | Deferred Tax: Single Transfer Postings | 6 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
11 | BBP_PCACC | Procurement Card: Accounting Data | 45 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
12 | BBP_PCMOD | Procurement Card: Modified Statement Data | 47 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
13 | BSEG | Accounting Document Segment | 48 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
14 | BSET | Tax Data Document Segment | 14 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
15 | BSSEG | Accounting Document Segment | 37 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
16 | CNV_20100_T030 | CNV backup copy for T030 | 4 | KTOSL | | nvarchar | 3 | 0 | | |
17 | DFKKEPRT | Log for Inconsistent FI-CA Documents | 60 | KTOSL | Transaction key for account determination | nvarchar | 3 | 0 | | |
18 | DFKKOP_DP | Down Payments: Tax Data for Business Partner Item | 13 | KTOSL | Transaction key for account determination | nvarchar | 3 | 0 | | |
19 | FISKC_DOCTYP | Document type by tax codes | 4 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
20 | FISKC_DOCTYPE | Document type by tax codes | 3 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
21 | FISKC_TAXSEC | Tax section Slovakia | 6 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
22 | FISKC_TAXSECTN | Tax section slovakia | 6 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
23 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 37 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
24 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 37 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
25 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 37 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
26 | FUDT_VDOCBSET | Tax Data Document Segment of Verification Document | 14 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
27 | FUDT_VDOCBSETH | Tax Data Document Segment of Verification Document(History) | 14 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
28 | GLPOS_C_CT | FI Document: Entry View | 153 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
29 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 153 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
30 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 153 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
31 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 153 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
32 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 155 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
33 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 155 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
34 | IDPL_SI | Assign Number Range for Internal Invoices to Company Code | 4 | KTOSL | Transaction Key for Internal Invoices | nvarchar | 3 | 0 | | |
35 | J_1UF_VAT_OPTYPE | VAT Declaration Lines 3 and 4 Grouped by Operation Types | 6 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
36 | J_1UF_VAT_OPTYPT | VAT Declaration Lines 3 and 4 Grouped by Operation Types | 7 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
37 | T007B | Tax Processing in Accounting | 2 | KTOSL | Internal processing key | nvarchar | 3 | 0 | | |
38 | T007G | Table no Longer Used -> T007K/L | 4 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
39 | T007K_MY | Table for Grouping Tax Basis Balances for Malaysia | 5 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
40 | T007L_MY | Table for Grouping Tax Balances for Malaysia | 5 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
41 | T007NVV | Deferred taxes. Tax account assignment to non-deductible cod | 3 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
42 | T030 | Standard Accounts Table | 3 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
43 | T030A | Transaction Keys and Assignment to Groups | 1 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
44 | T030B | Standard Posting Keys | 2 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
45 | T030C | Global Standard Account Table | 3 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
46 | T030G | Standard Accounts Table - Business Area Breakdown | 4 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
47 | T030K | Tax Accounts Determination | 3 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
48 | T030R | Rules for Determination of Standard Accounts | 3 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
49 | T030W | Transaction Key Names | 2 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
50 | T033U | Account Determ.for Balance Sheet Transfer Postings | 3 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
51 | TFK_USTPD_KTOSL | Ext. Tax per Document: Derive Transaction Key and Cond. Type | 5 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPAccounting Interface |
52 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 65 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
53 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 65 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPActual CostingMaterial Ledger |
54 | CKMVFM_BSEG_OUT | Display of FI Documents, Transaction CKMVFM, SAP Note 912984 | 22 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
55 | TCKMLBNKS | Assignment of Other Account Key if Not to Activate | 4 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPAlternative Valuation Run |
56 | CKMLAVRDOCIT | Lines for Cumulation Posting Document | 35 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPBasic Functions |
57 | T059K | Withholding tax code and processing key | 4 | KTOSL | Internal processing key | nvarchar | 3 | 0 | | |
TOPCollectionsDisbursements |
58 | VVSCPOS | Payment Plan Item | 103 | KTOSL | Transaction key for account determination | nvarchar | 3 | 0 | | |
TOPContract Accounts Receivable and Payable |
59 | DFKKARREPCONTST | ARGENTINA: Legal report sales tax control table | 4 | KTOSL | Internal processing key | nvarchar | 3 | 0 | | |
60 | DFKKFMBGAINFO | Tax Information for Public-Owned Commercial Operations | 19 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
61 | DFKKMOPK | Items in contract account document | 37 | KTOSL | Transaction key for account determination | nvarchar | 3 | 0 | | |
62 | DFKKOPK | Items in contract account document | 37 | KTOSL | Transaction key for account determination | nvarchar | 3 | 0 | | |
63 | DFKKORDERPOS | Requests: Items | 56 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
64 | DFKKQSR | Individual Records for Withholding Tax Report | 24 | KTOSL | Transaction key for account determination | nvarchar | 3 | 0 | | |
65 | DFKKREP06 | Tax Report Data (Invoicing Time or Triggered) | 26 | KTOSL | Transaction key for account determination | nvarchar | 3 | 0 | | |
66 | DFKKREP06_S | Tax Report Data - Shadow Table for Posting Date | 26 | KTOSL | Transaction key for account determination | nvarchar | 3 | 0 | | |
67 | DFKKREP07 | Tax Report Data (Clearing Time) | 32 | KTOSL | Transaction key for account determination | nvarchar | 3 | 0 | | |
68 | DFKKSUM | Posting totals from FI-CA | 29 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
69 | TEARREPCONTST | ARGENTINA: Legal report sales tax control table | 3 | KTOSL | Internal processing key | nvarchar | 3 | 0 | | |
70 | TFK007M | Maximum Tax | 5 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
71 | TFK009 | Definition of Report Time / Type of Sales / Purchase Taxes | 4 | KTOSL | Tax Item Type | nvarchar | 3 | 0 | | |
72 | TFK009_AR | ARGENTINA: Legal reporting time / grouping | 3 | KTOSL | Internal processing key | nvarchar | 3 | 0 | | |
73 | TFK011 | Definition of Report Time / Type for Other Taxes | 4 | KTOSL | Tax Item Type | nvarchar | 3 | 0 | | |
74 | TFKTAXMIN | Minimum Amounts for Taxes | 4 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPData Transfer |
75 | PPDIT | Transfer to Accounting: Lines in HR IDOCs | 7 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPExchanges |
76 | OIA07 | Logical Inventory Valuation Segment Table | 5 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
77 | OIA08 | LIA Document: Item Data | 32 | KTOSL | Fee accounting process key | nvarchar | 3 | 0 | | |
78 | TOIAB | IS-OIL Exchange - Posting keys | 2 | KTOSL | Fee accounting process key | nvarchar | 3 | 0 | | |
79 | TOIAE | Purchase Fee Account Assignment | 6 | KTOSL | Fee accounting process key | nvarchar | 3 | 0 | | |
80 | TOIAF | Sales Fee Account Assignment | 6 | KTOSL | Fee accounting process key | nvarchar | 3 | 0 | | |
81 | TOIAH | Check Table for Fee Accounting Process Strings | 3 | KTOSL | Fee accounting process key | nvarchar | 3 | 0 | | |
82 | TOIAHT | Fee Account Assignment Descriptions | 4 | KTOSL | Fee accounting process key | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
83 | /CCEE/FISITAX | Convert Tax on sales | 3 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
84 | /CCEE/YUFI_RFUMS | RFUMSV00: Assignment of Tax codes to serbian columns | 3 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
85 | /CEECV/ROFIRFUMS | RFUMSV00: Assignment of Tax codes to RO-specific columns | 4 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
86 | /CEECV/ROFITAX | Convert Tax on sales | 3 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
87 | /CEECV/ROFIUMSV | Tax Balances per Comp.Code, Tax Code and Process.Key | 7 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
88 | ACCTIT | Compressed Data from FI/CO Document | 22 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
89 | BFIT_A | FI Subsequent BA/PC Adjustment: G/L Account Items | 11 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
90 | DEFTAX_ITEM | Data for Deferred Taxes | 6 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
91 | T007M | Table for Grouping Taxes for BW | 4 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
92 | T030U | Account Determ.for Balance Sheet Transfer Postings | 4 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPFunds Management-Specific Postings |
93 | FMBGACORRS | History for Input Tax Adjustments PCOs | 14 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
94 | FMBGADCTAX | Data from Backdated Tax Calculation for PCOs | 14 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPGeneral Ledger Accounting |
95 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 14 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
96 | FAGL_RTRACK1 | Summary: Company Code Currently Affected by Reorg. and KTOSL | 6 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
97 | T8G16 | Allocation: internal key - item category (SAP) | 3 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPGL transfer |
98 | BKKC02 | General Ledger: Posting Totals for FI | 17 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPIncentive and Commission Management ICM |
99 | CACSCD_DOCCD_TI | Settlement to FS-CD: Reference Tax Information | 5 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
100 | CACSFI_DOCFI_TI | Settlement to FI: Reference Tax Information | 6 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
101 | CACSHR_DOCHR_TI | Settlement to PY: Reference Tax Information | 5 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
102 | CACS_DOCFI_T | Data Transfer: FI Document (Tax Item) | 9 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPInformation System |
103 | T007K | Table for Grouping Tax Basis Balances | 5 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
104 | T007L | Table for Grouping Tax Balances | 5 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
105 | T044L | Sorted List of Open Items | 7 | KTOSL | Account determination for sorted list | nvarchar | 3 | 0 | | |
106 | UMSV | Tax Balances per Comp.Code, Tax Code and Process.Key | 7 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPInvoicing |
107 | DBERDL | Print Document Line Items | 10 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
108 | DBERDZ | DB Table: Individ. Lines - Print Document | 5 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
109 | ERDTS | Additional Charges and Taxes of a Print Document | 7 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
110 | ERDZ_SHORT | Internal Table for Individual Print Doc.Lines -Extract Data | 5 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPInvoicing in Contract Accounts Receivable and Payable |
111 | DFKKINVBILL_T | Tax Items of Billing Document | 12 | KTOSL | Transaction key for account determination | nvarchar | 3 | 0 | | |
112 | DFKKINVDOC_I | Items of Invoicing Document | 37 | KTOSL | Transaction key for account determination | nvarchar | 3 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
113 | JVPO1 | JVA: Plan Line Items | 129 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
114 | JVSO1 | JV LI Table with Objects for JVTO1 | 65 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPLocal Currency Changeover |
115 | EWUMMFI | EMU: transfer table for clearing entries MM-FI | 16 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPLocalization |
116 | BASE_TYPE_IT | Assign Base Amount Type | 4 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
117 | ES340_OPRKEY | Operation Key in Model - 340 | 5 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
118 | IDES_SI | Assign Number Range for Self Invoices to Company Code | 5 | KTOSL | Transaction Key for Self Invoices | nvarchar | 3 | 0 | | |
119 | J_1ATAXID | Tax Class | 3 | KTOSL | Internal processing key | nvarchar | 3 | 0 | | |
120 | J_1ATPKOF | Assignment of official code to processing key | 3 | KTOSL | Internal processing key | nvarchar | 3 | 0 | | |
121 | J_1ATXMIN | Minimum amount per tax processing key | 3 | KTOSL | Internal processing key | nvarchar | 3 | 0 | | |
122 | J_1IT030K | India Tax account determination ( T030K + BWMOD ) | 3 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
123 | J_3RUMSV | Tax Balances per Comp.Code, Tax Code and Process.Key+ client | 7 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
124 | RFIDPTAAV | Pro-Rata Asset Acquisition Value | 24 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
125 | RFIDPTPRTK | Define Trans. Key | 4 | KTOSL | Account key | nvarchar | 3 | 0 | | |
126 | T007K_LU | Table for Grouping Tax Basis Balances Luxembourg | 5 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
127 | T007L_IT | Grouping Tax Balances Italy Black List | 5 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
128 | T007L_LU | Table for Grouping Tax Balances Luxembourg | 5 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
129 | T007_IT | Retail Value-Added Tax Settings | 4 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPReal Estate Management |
130 | VITAXD | Tax Shares per Real Estate Account Assignment | 47 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
131 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 39 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPTransaction Manager |
132 | AT210 | Rules for Determining a Taxes for CFM postings | 11 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPTravel Expenses |
133 | PTRV_DOC_IT | Transfer Travel -> FI/CO: Lines of TRV interm. document | 6 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
134 | PTRV_DOC_TAX | Transfer Travel -> FI/CO: Tax lines of TRV document | 6 | KTOSL | Transaction Key | nvarchar | 3 | 0 | | |
TOPTreasury |
135 | FLQASSET | Liquidity Calculation - Settings for FI Mechanisms | 7 | KTOSL | Liquidity Calculation: Account Key for Material Account | nvarchar | 3 | 0 | | |