| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BSEG | Accounting Document Segment | 47 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
2 | BSET | Tax Data Document Segment | 8 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
3 | BSSEG | Accounting Document Segment | 36 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
4 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 36 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
5 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 36 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
6 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 36 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
7 | FUDT_VDOCBSET | Tax Data Document Segment of Verification Document | 8 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
8 | FUDT_VDOCBSETH | Tax Data Document Segment of Verification Document(History) | 8 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
9 | GLPOS_C_CT | FI Document: Entry View | 244 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
10 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 244 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
11 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 244 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
12 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 244 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
13 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 253 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
14 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 253 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
15 | P2CN_TAX | Payroll result: Income Tax (CN) | 16 | TXGRP | Tax rate grouping | nvarchar | 1 | 0 | | |
16 | T7CN10 | Tax Calculation for Casual Worker | 3 | TXGRP | Tax rate grouping | nvarchar | 1 | 0 | | |
17 | T7CN11 | Tax Rate for Additional Tax | 3 | TXGRP | Tax rate grouping | nvarchar | 1 | 0 | | |
TOPChina |
18 | T7CN30 | Tax Withholding Fast Formula | 2 | TXGRP | Tax rate grouping | nvarchar | 1 | 0 | | |
19 | T7CN31 | Special rule category | 3 | TXGRP | Tax rate grouping | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
20 | DFKKMOP | Items in contract account document | 123 | TXGRP | Grouping Key for Tax Items | nvarchar | 6 | 0 | | |
21 | DFKKMOPK | Items in contract account document | 27 | TXGRP | Grouping Key for Tax Items | nvarchar | 6 | 0 | | |
22 | DFKKOP | Items in contract account document | 123 | TXGRP | Grouping Key for Tax Items | nvarchar | 6 | 0 | | |
23 | DFKKOPK | Items in contract account document | 27 | TXGRP | Grouping Key for Tax Items | nvarchar | 6 | 0 | | |
24 | DFKKOP_REP | Open Items from FPO4 | 129 | TXGRP | Grouping Key for Tax Items | nvarchar | 6 | 0 | | |
TOPData Retention Tool |
25 | TXW_S_BSEG | Retrieve BSEG from archive | 79 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
26 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 24 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
TOPIndia |
27 | T7IN0P | Personnel area/subarea grouping for India | 6 | TXGRP | Personnel subarea grouping for Tax | nvarchar | 2 | 0 | | |
28 | T7INT5 | Personnel subarea grouping for Tax | 2 | TXGRP | Personnel subarea grouping for Tax | nvarchar | 2 | 0 | | |
TOPLocalization |
29 | J_1ISER_BSEG | Transaction table having the Invoices with Service Category | 18 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |
TOPMalaysia |
30 | T5LMD | Text for Tax office grouping for Malaysia | 3 | TXGRP | Income tax office grouping for Malaysia | nvarchar | 2 | 0 | | |
31 | T5LMO | Tax office grouping for Malaysia | 2 | TXGRP | Income tax office grouping for Malaysia | nvarchar | 2 | 0 | | |
32 | T5LTO | Tax office table for Malaysia | 5 | TXGRP | Income tax office grouping for Malaysia | nvarchar | 2 | 0 | | |
33 | T5LTP | Employer reference for tax | 4 | TXGRP | Income tax office grouping for Malaysia | nvarchar | 2 | 0 | | |
TOPPhilippines |
34 | T7PH0A | Personnel area and personnel sub area groupings | 6 | TXGRP | Tax grouping | nvarchar | 4 | 0 | | |
35 | T7PHCT | Tax Grouping | 2 | TXGRP | Tax grouping | nvarchar | 4 | 0 | | |
TOPProduct Cost Planning |
36 | TCKH6 | Cost Component Groups - Texts | 4 | TXGRP | Name of Cost Component Group | nvarchar | 20 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
37 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 38 | TXGRP | Group Indicator for Tax Line Items | nvarchar | 3 | 0 | | |