IDWTFIDOCLEAN SAP (Withholding Tax Data from FI Documents) Structure details
Description: Withholding Tax Data from FI Documents
Related tables to IDWTFIDOCLEAN
Access table IDWTFIDOCLEAN
Structure field list including key, data, relationships and ABAP select examples
IDWTFIDOCLEAN is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Withholding Tax Data from FI Documents" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_IDWTFIDOCLEAN TYPE IDWTFIDOCLEAN.
The IDWTFIDOCLEAN table consists of various fields, each holding specific information or linking keys about Withholding Tax Data from FI Documents data available in SAP. These include BUPLA (Business Place), PARTNO_TYPE (Type of partner number), PARTNERNO (Partner ID), WT_REVERSED (Indicator: Document reversed?).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP IDWTFIDOCLEAN structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
BUPLA | Business Place | BUPLA | CHAR | 4 | Assigned to domain | J_1BBRANCH | |||
PARTNO_TYPE | Type of partner number | WT_PARTNO_TYPE | CHAR | 1 | WT_PARNO_TYPE | ||||
PARTNERNO | Partner ID | PARTNERNO | CHAR | 35 | |||||
WT_REVERSED | Indicator: Document reversed? | REVERSED | CHAR | 1 | XFELD | ||||
WT_PERIOD | Reporting Period | WT_REPPERIOD | NUMC | 2 | |||||
WITHT | Indicator for withholding tax type | WITHT | CHAR | 2 | Assigned to domain | WITHT | |||
WT_WITHCD | Withholding tax code | WT_WITHCD | CHAR | 2 | Assigned to domain | WT_WITHCD | |||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
ITEM_SOURCE | Data source of item | WT_ITEM_SOURCE | CHAR | 1 | WT_ITEM_SOURCE | ||||
ITEM_REF | Reference to WT item | WT_ITEM_REF | CHAR | 24 | WT_ITEM_REF | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
PARTNER_SEQ_NB | Partner sequential number on Withholding Tax lists | PARTNER_SEQ_NB | NUMC | 6 | |||||
WT_SHORT_ADDR | One-line short form of formatted address | AD_LINE_S | CHAR | 80 | CHAR80 | ||||
WT_BASMAN | Indicator: Withholding tax base amount entered manually | WT_BASMAN | CHAR | 1 | XFELD | ||||
WT_AMNMAN | Indicator: Withholding tax amount entered manually | WT_AMNMAN | CHAR | 1 | XFELD | ||||
WT_OPEN_ITEM | Item status ( open, paid ...) | WT_OPEN_ITEM | CHAR | 4 | |||||
WT_NEWWT | Indicator: Extended withholding tax active | WT_NEWWT | CHAR | 1 | XFELD | ||||
WT_POSTM | Posting time | WT_POSTM | CHAR | 1 | WT_POSTM | ||||
QSREC | Type of recipient | WT_QSREC | CHAR | 2 | Assigned to domain | WT_QSREC | |||
HWAER | Reporting currency ( local or alternative ) | WT_HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
DMBTR | Gross amount in Reporting Currency | WT_DMBTR | CURR | 15(2) | WERT8 | ||||
WRBTR | Amount in Document Currency | WT_WRBTR | CURR | 15(2) | WERT8 | ||||
WT_QSSHH | Withholding Tax Base Amount in Reporting Currency | WT_BASE_AMT | CURR | 15(2) | WERTV8 | ||||
WT_QSSHB | Withholding tax base amount in document currency | WT_BS1 | CURR | 15(2) | WERTV8 | ||||
WT_QBSHH | Withholding Tax Amount in Reporting Currency | WT_TAX_AMT | CURR | 15(2) | WERTV8 | ||||
WT_QBSHB | Withholding tax amount in document currency | WT_WT1 | CURR | 15(2) | WERTV8 | ||||
WT_QSFHH | Amount exempt from withholding tax (in reporting currency) | WT_EXMP_AMT | CURR | 15(2) | WERTV8 | ||||
WT_QSFHB | Amount exempt from withholding tax in document currency | WT_EXMP1 | CURR | 15(2) | WERTV8 | ||||
WT_NETHH | Net amount = Invoice amount - withholding tax amount in LC | WT_NET | CURR | 15(2) | WERTV8 | ||||
WT_NETHB | Net amount = Invoice amount - w/hold.tax amount in doc.crcy | WT_NET1 | CURR | 15(2) | WERTV8 | ||||
WT_TAXHH | Tax Amount in Reporting Currency | WT_HWSTE | CURR | 15(2) | WERT8 | ||||
WT_TAXHB | Tax Amount in Document Currency | WT_FWSTE | CURR | 15(2) | WERT8 | ||||
WT_AMEXCLVAT | Net amount 2 = Invoice amount - VAT ( in Reporting currency) | WT_EXCLVAT | CURR | 15(2) | WERTV8 | ||||
WT_AMEXCLVAT1 | Net amount = Invoice amount - VAT in doc.crcy | WT_EXCLVAT1 | CURR | 15(2) | WERTV8 | ||||
WT_AMRBASE | WT base amount excluding taxes ( in reporting currency) | WT_RBASE | CURR | 15(2) | WERTV8 | ||||
WT_AMRBASE1 | WT base amount excluding taxes (doc. cur) | WT_RBASE1 | CURR | 15(2) | WERTV8 | ||||
WT_AMREXMP | Amount Exempt from WH Tax - VAT (in Reporting Currency) | WT_REXMP | CURR | 15(2) | WERTV8 | ||||
WT_AMREXMP1 | Amount Exempt from WH Tax - VAT (in Document Currency) | WT_REXMP1 | CURR | 15(2) | WERTV8 | ||||
WT_XDMBTR | Free amount field for country specific | WT_FREE_DMBTR | CURR | 15(2) | WERT8 | ||||
WT_XWRBTR | Free amount field for country specific | WT_FREE_DMBTR | CURR | 15(2) | WERT8 | ||||
WT_XDMBTR1 | Free amount field for country specific | WT_FREE_DMBTR | CURR | 15(2) | WERT8 | ||||
WT_XWRBTR1 | Free amount field for country specific | WT_FREE_DMBTR | CURR | 15(2) | WERT8 | ||||
WT_XDMBTR2 | Free amount field for country specific | WT_FREE_DMBTR | CURR | 15(2) | WERT8 | ||||
WT_XWRBTR2 | Free amount field for country specific | WT_FREE_DMBTR | CURR | 15(2) | WERT8 | ||||
WT_PAYBH | Payment amount in local currency | WT_PAYBH | CURR | 15(2) | WERT8 | ||||
WT_PAYBB | Payment amount in document currency | WT_PAYBB | CURR | 15(2) | WERT8 | ||||
SKNTO | Cash discount amount in local currency | WT_SKNTO | CURR | 15(2) | WERT8 | ||||
WSKTO | Cash discount amount in document currency | WT_WSKTO | CURR | 15(2) | WERT8 | ||||
WT_SLFWTPD | Indicator: Entry posted as self-withholding tax | WT_SLFWTPD | CHAR | 1 | XFELD | ||||
WT_GRUWTPD | Indicator: Entry posted as 'Grossing up' | WT_GRUWTPD | CHAR | 1 | XFELD | ||||
WT_OPOWTPD | Indicator: Entry posted as a debit/credit | WT_OPOWTPD | CHAR | 1 | XFELD | ||||
CTNUMBER | Withholding Tax Certificate Number | CTNUMBER | CHAR | 10 | CHAR10 | ||||
WT_WTEXMN | Exemption certificate number | WT_EXNR | CHAR | 15 | CHAR15 | ||||
WT_QSZRT | Exemption rate | WT_EXRT | DEC | 5(2) | PRZ32 | ||||
WT_ISSDT | Issue or Print Date of Withholding Tax Certificate | CTISSUEDATE | DATS | 8 | DATUM | ||||
WT_POSIN | Posting indicator | WT_POSIN | CHAR | 1 | WT_POSIN | ||||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
BLART | Document Type | BLART | CHAR | 2 | Assigned to domain | BLART | BAR | ||
KOART | Account Type | KOART | CHAR | 1 | KOART | ||||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
HKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
VORGN | Transaction Type for General Ledger | VORGN | CHAR | 4 | VORGN | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 10 | ALPHA | BELNR | |||
AUGDT | Clearing Date | AUGDT | DATS | 8 | DATUM | ||||
WT_PAYDT | Payment date | WT_PAYDT | DATS | 8 | DATE | ||||
UMSKS | Special G/L Transaction Type | UMSKS | CHAR | 1 | UMSKS | ||||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | Assigned to domain | UMSKZ | |||
ZUMSK | Target Special G/L Indicator | DZUMSK | CHAR | 1 | Assigned to domain | UMSKZ | |||
BSCHL | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
XZAHL | Indicator: Is the posting key used in a payment transaction? | XZAHL | CHAR | 1 | XFELD | ||||
XCPDD | Indicator: Address and bank data set individually | XCPDD | CHAR | 1 | XFELD | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | BUZEI | ||||
REBZT | Follow-On Document Type | REBZT | CHAR | 1 | REBZT | ||||
SECCO | Section Code | SECCO | CHAR | 4 | Assigned to domain | SECCO | SECCO_ABA | ||
KURSF | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF | |||
WT_GROUP1 | Grouping criterion | WT_GROUP | CHAR | 10 | CHAR10 | ||||
WT_FREE1 | Free for country specific field | WT_FREE | CHAR | 10 | |||||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
QSCOD | Official Withholding Tax Code | QSCOD | CHAR | 4 | CHAR4 |
Key field | Non-key field |
How do I retrieve data from SAP structure IDWTFIDOCLEAN using ABAP code?
As IDWTFIDOCLEAN is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on IDWTFIDOCLEAN as there is no data to select.How to access SAP table IDWTFIDOCLEAN
Within an ECC or HANA version of SAP you can also view further information about IDWTFIDOCLEAN and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects