SAP ABAP Table IDWTFIDOCLEAN (Withholding Tax Data from FI Documents)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷ FI-LOC (Application Component) Localization
⤷ ID-FI-WT (Package) Withholding Tax reporting
⤷ FI-LOC (Application Component) Localization
⤷ ID-FI-WT (Package) Withholding Tax reporting
Basic Data
Table Category | INTTAB | Structure |
Structure | IDWTFIDOCLEAN | Table Relationship Diagram |
Short Description | Withholding Tax Data from FI Documents |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
2 | BUPLA | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | Business Place | * | |
3 | PARTNO_TYPE | WT_PARTNO_TYPE | WT_PARNO_TYPE | CHAR | 1 | 0 | Type of partner number | ||
4 | PARTNERNO | PARTNERNO | CHAR | 35 | 0 | Partner ID | |||
5 | WT_REVERSED | REVERSED | XFELD | CHAR | 1 | 0 | Indicator: Document reversed? | ||
6 | WT_PERIOD | WT_REPPERIOD | NUMC | 2 | 0 | Reporting Period | |||
7 | WITHT | WITHT | WITHT | CHAR | 2 | 0 | Indicator for withholding tax type | * | |
8 | WT_WITHCD | WT_WITHCD | WT_WITHCD | CHAR | 2 | 0 | Withholding tax code | * | |
9 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
10 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
11 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
12 | ITEM_SOURCE | WT_ITEM_SOURCE | WT_ITEM_SOURCE | CHAR | 1 | 0 | Data source of item | ||
13 | ITEM_REF | WT_ITEM_REF | WT_ITEM_REF | CHAR | 24 | 0 | Reference to WT item | ||
14 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
15 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
16 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
17 | PARTNER_SEQ_NB | PARTNER_SEQ_NB | NUMC | 6 | 0 | Partner sequential number on Withholding Tax lists | |||
18 | WT_SHORT_ADDR | AD_LINE_S | CHAR80 | CHAR | 80 | 0 | One-line short form of formatted address | ||
19 | WT_BASMAN | WT_BASMAN | XFELD | CHAR | 1 | 0 | Indicator: Withholding tax base amount entered manually | ||
20 | WT_AMNMAN | WT_AMNMAN | XFELD | CHAR | 1 | 0 | Indicator: Withholding tax amount entered manually | ||
21 | WT_OPEN_ITEM | WT_OPEN_ITEM | CHAR | 4 | 0 | Item status ( open, paid ...) | |||
22 | WT_NEWWT | WT_NEWWT | XFELD | CHAR | 1 | 0 | Indicator: Extended withholding tax active | ||
23 | WT_POSTM | WT_POSTM | WT_POSTM | CHAR | 1 | 0 | Posting time | ||
24 | QSREC | WT_QSREC | WT_QSREC | CHAR | 2 | 0 | Type of recipient | * | |
25 | HWAER | WT_HWAER | WAERS | CUKY | 5 | 0 | Reporting currency ( local or alternative ) | * | |
26 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
27 | DMBTR | WT_DMBTR | WERT8 | CURR | 15 | 2 | Gross amount in Reporting Currency | ||
28 | WRBTR | WT_WRBTR | WERT8 | CURR | 15 | 2 | Amount in Document Currency | ||
29 | WT_QSSHH | WT_BASE_AMT | WERTV8 | CURR | 15 | 2 | Withholding Tax Base Amount in Reporting Currency | ||
30 | WT_QSSHB | WT_BS1 | WERTV8 | CURR | 15 | 2 | Withholding tax base amount in document currency | ||
31 | WT_QBSHH | WT_TAX_AMT | WERTV8 | CURR | 15 | 2 | Withholding Tax Amount in Reporting Currency | ||
32 | WT_QBSHB | WT_WT1 | WERTV8 | CURR | 15 | 2 | Withholding tax amount in document currency | ||
33 | WT_QSFHH | WT_EXMP_AMT | WERTV8 | CURR | 15 | 2 | Amount exempt from withholding tax (in reporting currency) | ||
34 | WT_QSFHB | WT_EXMP1 | WERTV8 | CURR | 15 | 2 | Amount exempt from withholding tax in document currency | ||
35 | WT_NETHH | WT_NET | WERTV8 | CURR | 15 | 2 | Net amount = Invoice amount - withholding tax amount in LC | ||
36 | WT_NETHB | WT_NET1 | WERTV8 | CURR | 15 | 2 | Net amount = Invoice amount - w/hold.tax amount in doc.crcy | ||
37 | WT_TAXHH | WT_HWSTE | WERT8 | CURR | 15 | 2 | Tax Amount in Reporting Currency | ||
38 | WT_TAXHB | WT_FWSTE | WERT8 | CURR | 15 | 2 | Tax Amount in Document Currency | ||
39 | WT_AMEXCLVAT | WT_EXCLVAT | WERTV8 | CURR | 15 | 2 | Net amount 2 = Invoice amount - VAT ( in Reporting currency) | ||
40 | WT_AMEXCLVAT1 | WT_EXCLVAT1 | WERTV8 | CURR | 15 | 2 | Net amount = Invoice amount - VAT in doc.crcy | ||
41 | WT_AMRBASE | WT_RBASE | WERTV8 | CURR | 15 | 2 | WT base amount excluding taxes ( in reporting currency) | ||
42 | WT_AMRBASE1 | WT_RBASE1 | WERTV8 | CURR | 15 | 2 | WT base amount excluding taxes (doc. cur) | ||
43 | WT_AMREXMP | WT_REXMP | WERTV8 | CURR | 15 | 2 | Amount Exempt from WH Tax - VAT (in Reporting Currency) | ||
44 | WT_AMREXMP1 | WT_REXMP1 | WERTV8 | CURR | 15 | 2 | Amount Exempt from WH Tax - VAT (in Document Currency) | ||
45 | WT_XDMBTR | WT_FREE_DMBTR | WERT8 | CURR | 15 | 2 | Free amount field for country specific | ||
46 | WT_XWRBTR | WT_FREE_DMBTR | WERT8 | CURR | 15 | 2 | Free amount field for country specific | ||
47 | WT_XDMBTR1 | WT_FREE_DMBTR | WERT8 | CURR | 15 | 2 | Free amount field for country specific | ||
48 | WT_XWRBTR1 | WT_FREE_DMBTR | WERT8 | CURR | 15 | 2 | Free amount field for country specific | ||
49 | WT_XDMBTR2 | WT_FREE_DMBTR | WERT8 | CURR | 15 | 2 | Free amount field for country specific | ||
50 | WT_XWRBTR2 | WT_FREE_DMBTR | WERT8 | CURR | 15 | 2 | Free amount field for country specific | ||
51 | WT_PAYBH | WT_PAYBH | WERT8 | CURR | 15 | 2 | Payment amount in local currency | ||
52 | WT_PAYBB | WT_PAYBB | WERT8 | CURR | 15 | 2 | Payment amount in document currency | ||
53 | SKNTO | WT_SKNTO | WERT8 | CURR | 15 | 2 | Cash discount amount in local currency | ||
54 | WSKTO | WT_WSKTO | WERT8 | CURR | 15 | 2 | Cash discount amount in document currency | ||
55 | WT_SLFWTPD | WT_SLFWTPD | XFELD | CHAR | 1 | 0 | Indicator: Entry posted as self-withholding tax | ||
56 | WT_GRUWTPD | WT_GRUWTPD | XFELD | CHAR | 1 | 0 | Indicator: Entry posted as "Grossing up" | ||
57 | WT_OPOWTPD | WT_OPOWTPD | XFELD | CHAR | 1 | 0 | Indicator: Entry posted as a debit/credit | ||
58 | CTNUMBER | CTNUMBER | CHAR10 | CHAR | 10 | 0 | Withholding Tax Certificate Number | ||
59 | WT_WTEXMN | WT_EXNR | CHAR15 | CHAR | 15 | 0 | Exemption certificate number | ||
60 | WT_QSZRT | WT_EXRT | PRZ32 | DEC | 5 | 2 | Exemption rate | ||
61 | WT_ISSDT | CTISSUEDATE | DATUM | DATS | 8 | 0 | Issue or Print Date of Withholding Tax Certificate | ||
62 | WT_POSIN | WT_POSIN | WT_POSIN | CHAR | 1 | 0 | Posting indicator | ||
63 | XREF2 | XREF2 | CHAR12 | CHAR | 12 | 0 | Business partner reference key | ||
64 | XREF3 | XREF3 | CHAR20 | CHAR | 20 | 0 | Reference key for line item | ||
65 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
66 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
67 | BLART | BLART | BLART | CHAR | 2 | 0 | Document type | * | |
68 | KOART | KOART | KOART | CHAR | 1 | 0 | Account type | ||
69 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
70 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
71 | VORGN | VORGN | VORGN | CHAR | 4 | 0 | Transaction Type for General Ledger | ||
72 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
73 | AUGBL | AUGBL | BELNR | CHAR | 10 | 0 | Document Number of the Clearing Document | ||
74 | AUGDT | AUGDT | DATUM | DATS | 8 | 0 | Clearing Date | ||
75 | WT_PAYDT | WT_PAYDT | DATE | DATS | 8 | 0 | Payment date | ||
76 | UMSKS | UMSKS | UMSKS | CHAR | 1 | 0 | Special G/L Transaction Type | ||
77 | UMSKZ | UMSKZ | UMSKZ | CHAR | 1 | 0 | Special G/L Indicator | * | |
78 | ZUMSK | DZUMSK | UMSKZ | CHAR | 1 | 0 | Target Special G/L Indicator | * | |
79 | BSCHL | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | * | |
80 | XZAHL | XZAHL | XFELD | CHAR | 1 | 0 | Indicator: Is Posting Key Used in a Payment Transaction? | ||
81 | XCPDD | XCPDD | XFELD | CHAR | 1 | 0 | Indicator: Address and Bank Data Set Individually | ||
82 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
83 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
84 | REBZG | REBZG | BELNR | CHAR | 10 | 0 | Number of the Invoice the Transaction Belongs to | ||
85 | REBZJ | REBZJ | GJAHR | NUMC | 4 | 0 | Fiscal Year of the Relevant Invoice (for Credit Memo) | ||
86 | REBZZ | REBZZ | BUZEI | NUMC | 3 | 0 | Line Item in the Relevant Invoice | ||
87 | REBZT | REBZT | REBZT | CHAR | 1 | 0 | Follow-On Document Type | ||
88 | SECCO | SECCO | SECCO | CHAR | 4 | 0 | Section Code | * | |
89 | KURSF | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
90 | WT_GROUP1 | WT_GROUP | CHAR10 | CHAR | 10 | 0 | Grouping criterion | ||
91 | WT_FREE1 | WT_FREE | CHAR | 10 | 0 | Free for country specific field | |||
92 | ZFBDT | DZFBDT | DATUM | DATS | 8 | 0 | Baseline date for due date calculation | ||
93 | QSCOD | QSCOD | CHAR4 | CHAR | 4 | 0 | Official Withholding Tax Code |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |