IDWTFIDOCLEAN SAP (Withholding Tax Data from FI Documents) Structure details

Dictionary Type: Structure
Description: Withholding Tax Data from FI Documents




ABAP Code to SELECT data from IDWTFIDOCLEAN
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
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BUPLABusiness Place BUPLACHAR4Assigned to domainJ_1BBRANCH
PARTNO_TYPEType of partner number WT_PARTNO_TYPECHAR1WT_PARNO_TYPE
PARTNERNOPartner ID PARTNERNOCHAR35
WT_REVERSEDIndicator: Document reversed? REVERSEDCHAR1XFELD
WT_PERIODReporting Period WT_REPPERIODNUMC2
WITHTIndicator for withholding tax type WITHTCHAR2Assigned to domainWITHT
WT_WITHCDWithholding tax code WT_WITHCDCHAR2Assigned to domainWT_WITHCD
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
ITEM_SOURCEData source of item WT_ITEM_SOURCECHAR1WT_ITEM_SOURCE
ITEM_REFReference to WT item WT_ITEM_REFCHAR24WT_ITEM_REF
BUDATPosting Date in the Document BUDATDATS8DATUM
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
PARTNER_SEQ_NBPartner sequential number on Withholding Tax lists PARTNER_SEQ_NBNUMC6
WT_SHORT_ADDROne-line short form of formatted address AD_LINE_SCHAR80CHAR80
WT_BASMANIndicator: Withholding tax base amount entered manually WT_BASMANCHAR1XFELD
WT_AMNMANIndicator: Withholding tax amount entered manually WT_AMNMANCHAR1XFELD
WT_OPEN_ITEMItem status ( open, paid ...) WT_OPEN_ITEMCHAR4
WT_NEWWTIndicator: Extended withholding tax active WT_NEWWTCHAR1XFELD
WT_POSTMPosting time WT_POSTMCHAR1WT_POSTM
QSRECType of recipient WT_QSRECCHAR2Assigned to domainWT_QSREC
HWAERReporting currency ( local or alternative ) WT_HWAERCUKY5Assigned to domainWAERS
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
DMBTRGross amount in Reporting Currency WT_DMBTRCURR15(2) WERT8
WRBTRAmount in Document Currency WT_WRBTRCURR15(2) WERT8
WT_QSSHHWithholding Tax Base Amount in Reporting Currency WT_BASE_AMTCURR15(2) WERTV8
WT_QSSHBWithholding tax base amount in document currency WT_BS1CURR15(2) WERTV8
WT_QBSHHWithholding Tax Amount in Reporting Currency WT_TAX_AMTCURR15(2) WERTV8
WT_QBSHBWithholding tax amount in document currency WT_WT1CURR15(2) WERTV8
WT_QSFHHAmount exempt from withholding tax (in reporting currency) WT_EXMP_AMTCURR15(2) WERTV8
WT_QSFHBAmount exempt from withholding tax in document currency WT_EXMP1CURR15(2) WERTV8
WT_NETHHNet amount = Invoice amount - withholding tax amount in LC WT_NETCURR15(2) WERTV8
WT_NETHBNet amount = Invoice amount - w/hold.tax amount in doc.crcy WT_NET1CURR15(2) WERTV8
WT_TAXHHTax Amount in Reporting Currency WT_HWSTECURR15(2) WERT8
WT_TAXHBTax Amount in Document Currency WT_FWSTECURR15(2) WERT8
WT_AMEXCLVATNet amount 2 = Invoice amount - VAT ( in Reporting currency) WT_EXCLVATCURR15(2) WERTV8
WT_AMEXCLVAT1Net amount = Invoice amount - VAT in doc.crcy WT_EXCLVAT1CURR15(2) WERTV8
WT_AMRBASEWT base amount excluding taxes ( in reporting currency) WT_RBASECURR15(2) WERTV8
WT_AMRBASE1WT base amount excluding taxes (doc. cur) WT_RBASE1CURR15(2) WERTV8
WT_AMREXMPAmount Exempt from WH Tax - VAT (in Reporting Currency) WT_REXMPCURR15(2) WERTV8
WT_AMREXMP1Amount Exempt from WH Tax - VAT (in Document Currency) WT_REXMP1CURR15(2) WERTV8
WT_XDMBTRFree amount field for country specific WT_FREE_DMBTRCURR15(2) WERT8
WT_XWRBTRFree amount field for country specific WT_FREE_DMBTRCURR15(2) WERT8
WT_XDMBTR1Free amount field for country specific WT_FREE_DMBTRCURR15(2) WERT8
WT_XWRBTR1Free amount field for country specific WT_FREE_DMBTRCURR15(2) WERT8
WT_XDMBTR2Free amount field for country specific WT_FREE_DMBTRCURR15(2) WERT8
WT_XWRBTR2Free amount field for country specific WT_FREE_DMBTRCURR15(2) WERT8
WT_PAYBHPayment amount in local currency WT_PAYBHCURR15(2) WERT8
WT_PAYBBPayment amount in document currency WT_PAYBBCURR15(2) WERT8
SKNTOCash discount amount in local currency WT_SKNTOCURR15(2) WERT8
WSKTOCash discount amount in document currency WT_WSKTOCURR15(2) WERT8
WT_SLFWTPDIndicator: Entry posted as self-withholding tax WT_SLFWTPDCHAR1XFELD
WT_GRUWTPDIndicator: Entry posted as 'Grossing up' WT_GRUWTPDCHAR1XFELD
WT_OPOWTPDIndicator: Entry posted as a debit/credit WT_OPOWTPDCHAR1XFELD
CTNUMBERWithholding Tax Certificate Number CTNUMBERCHAR10CHAR10
WT_WTEXMNExemption certificate number WT_EXNRCHAR15CHAR15
WT_QSZRTExemption rate WT_EXRTDEC5(2) PRZ32
WT_ISSDTIssue or Print Date of Withholding Tax Certificate CTISSUEDATEDATS8DATUM
WT_POSINPosting indicator WT_POSINCHAR1WT_POSIN
XREF2Business partner reference key XREF2CHAR12CHAR12
XREF3Reference key for line item XREF3CHAR20CHAR20
BLDATDocument Date in Document BLDATDATS8DATUM
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
KOARTAccount Type KOARTCHAR1KOART
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
VORGNTransaction Type for General Ledger VORGNCHAR4VORGN
SGTXTItem Text SGTXTCHAR50TEXT50
AUGBLDocument Number of the Clearing Document AUGBLCHAR10ALPHABELNR
AUGDTClearing Date AUGDTDATS8DATUM
WT_PAYDTPayment date WT_PAYDTDATS8DATE
UMSKSSpecial G/L Transaction Type UMSKSCHAR1UMSKS
UMSKZSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ
ZUMSKTarget Special G/L Indicator DZUMSKCHAR1Assigned to domainUMSKZ
BSCHLPosting Key BSCHLCHAR2Assigned to domainBSCHL
XZAHLIndicator: Is the posting key used in a payment transaction? XZAHLCHAR1XFELD
XCPDDIndicator: Address and bank data set individually XCPDDCHAR1XFELD
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
REBZGNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
REBZJFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
REBZZLine Item in the Relevant Invoice REBZZNUMC3BUZEI
REBZTFollow-On Document Type REBZTCHAR1REBZT
SECCOSection Code SECCOCHAR4Assigned to domainSECCOSECCO_ABA
KURSFExchange rate KURSFDEC9(5) EXCRTKURSF
WT_GROUP1Grouping criterion WT_GROUPCHAR10CHAR10
WT_FREE1Free for country specific field WT_FREECHAR10
ZFBDTBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
QSCODOfficial Withholding Tax Code QSCODCHAR4CHAR4

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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!