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