txw_j_with_ddl

Join von BSAK und WITH_ITEM für DART | view: TXW_J_WITH | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: BKPF, BSAK_BCK, BSEG, WITH_ITEM
Column Name Description
Column Name Description
wt_qsshh Withholding Tax Base Amount (Local Currency)
wt_qsshb Withholding Tax Base Amount in Document Currency
wt_qssh2 Withholding Tax Base Amount in Second Local Currency
wt_qssh3 Withholding Tax Base Amount in Third Local Currency
wt_qsshhc Withholding Tax Base Amount in Local Crcy for Calculation
wt_qsshbc Withholding Tax Base Amount in Document Crcy for Calculation
wt_qssh2c WTax Base Amount in 2nd Local Currency for Calculation
wt_qssh3c Withholding Tax Base Amount in 3rd Local Currency for Calc.
wt_qbshh Withholding Tax Amount in Local Currency
wt_qbshb Withholding Tax Amount in Document Currency
wt_qbsh2 Withholding Tax Amount in Second Local Currency
wt_qbsh3 Withholding Tax Amount in Third Local Currency
wt_qbshha Withholding Tax Auxiliary Amount in Local Crcy for Reversal
wt_qbshhb Withholding Tax Auxiliary Amt 2 in Local Crcy for Reversal
wt_qsfhh Amount Exempt from Withholding Tax in Local Currency
wt_qsfhb Amount Exempt from Withholding Tax in Document Currency
wt_qsfh2 Amount Exempt from Withholding Tax in 2nd Local Currency
wt_qsfh3 Amount Exempt from Withholding Tax in 3rd Local Currency
wt_wdmbtr Withholding Tax Amount Already Withheld in Local Currency
wt_wwrbtr Withholding Tax Amount Already Withheld in Document Currency
wt_wdmbt2 Withholding tax amount already withheld in 2nd local curr.
wt_wdmbt3 Withholding Tax Amt Already Withheld in 3rd Local Currency
wt_qbuihh Withholding Tax Amount Entered Manually in Local Currency
wt_qbuihb Withholding Tax Amount Entered Manually in Document Currency
wt_qbuih2 Withholding Tax Amount Entered Manually in 2nd Local Curr.
wt_qbuih3 Withholding Tax Amount Entered Manually in 3rd Local Curr.
wt_accbs Accumulated Withholding Tax Base Amount in Local Currency
wt_accwt Accumulated Withholding Tax Amount in Local Currency
wt_accwta Accumulated Auxiliary WTax Amount in Local Currency
wt_accwtha Accumulated Auxiliary WTax Amount in Local Currency
wt_accbs1 Accumulated Withholding Tax Base Amount in Local Currency
wt_accwt1 Accumulated Withholding Tax Amount in Local Currency
wt_accwta1 Accumulated Auxiliary WTax Amount in Local Currency
wt_accwtha1 Accumulated Auxiliary WTax Amount in Local Currency
wt_accbs2 Accumulated Withholding Tax Base Amount in Local Currency
wt_accwt2 Accumulated Withholding Tax Amount in Local Currency
wt_accwta2 Accumulated Auxiliary WTax Amount in Local Currency
wt_accwtha2 Accumulated Auxiliary WTax Amount in Local Currency
j_1af_wt_repbs Withholding tax base amount in local currency for reporting
j_1bwht_bs Withholding Tax Base Amount from Nota Fiscal
j_1bwhtaccbs Accumulated withholding tax real base amount(local currency)
j_1bwhtaccbs1 Accumulated withholding tax real base amount(local currency)
j_1bwhtaccbs2 Accumulated withholding tax real base amount(local currency)
j_1iclramt Amount of EWT for which certificate is received from Custome
j_1isuramt Surcharge amount
Column Name Description
Column Name Description
augdt Clearing Date
ctissuedate Issue or Print Date of Withholding Tax Certificate
j_1iintchdt Challan Date
j_1icertdt Certificate Date
bs_augdt Clearing Date
Column Name Description
wt_basman Indicator: Withholding Tax Base Amount Entered Manually Show values
wt_amnman Indicator: Withholding Tax Amount Entered Manually Show values
wt_stat Line Item Status Show values
koart Account type Show values
wt_slfwtpd Indicator: Entry Posted as Self-Withholding Tax Show values
wt_gruwtpd Indicator: Entry Posted as "Grossing Up" Show values
wt_opowtpd Indicator: Entry Posted as Debit/Credit Show values
wt_givenpd Indicator: Withholding Tax Amount Entered Manually with Payt Show values
wt_downc Indicator: Entry Belongs to a Down Payment Clearing Item Show values
wt_resitem Indicator: Entry Belongs to a Residual Item Show values
wt_calc Withholding Tax Already Calculated/Determined? Show values
j_1iewtrec Record type for EWT transactions-India Show values
bs_xzahl Indicator: Is Posting Key Used in a Payment Transaction? Show values
Column Name Description Domain name
belnr Document Number of an Accounting Document BELNR
gjahr Fiscal Year GJAHR
buzei Number of Line Item Within Accounting Document BUZEI
wt_wtexmn Exemption Certificate Number CHAR25
wt_acco Vendor/Customer Account Number CHAR10
augbl Document Number of the Clearing Document BELNR
wt_qszrt Exemption Rate PRZ32
text15 Text (15 characters) TEXT15
qsatz Withholding Tax Rate PRZ34
ctnumber Withholding Tax Certificate Number CHAR10
wt_logsys Logical System in Which the Withholding Tax Was Calculated LOGSYS
j_1bwhtrate Tax Rate J_1BTXRATE
j_1iintchln Challan Number J_1IINTCHLN
j_1ibuzei Number of Line Item Within Accounting Document BUZEI
j_1irebzg Document No. of the Invoice to Which the Transaction Belongs BELNR
bs_bukrs Company Code BUKRS
bs_augbl Document Number of the Clearing Document BELNR
bs_lifnr Account Number of Supplier LIFNR
bs_gjahr Fiscal Year GJAHR
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Company Code
  • Client
  • TXW_J_WITH_DDL.BS_BUKRS == T001.BUKRS
  • TXW_J_WITH_DDL.BUKRS == T001.BUKRS
  • TXW_J_WITH_DDL.MANDT == T001.MANDT
General Ledger Account
  • Client
  • General Ledger Account
  • ?
  • TXW_J_WITH_DDL.MANDT == SKA1.MANDT
  • TXW_J_WITH_DDL.HKONT == SKA1.SAKNR
  • TXW_J_WITH_DDL.[column in domain "KTOPL"] == SKA1.KTOPL
General Ledger Account
  • Client
  • ?
  • General Ledger Account
  • TXW_J_WITH_DDL.MANDT == SKA1.MANDT
  • TXW_J_WITH_DDL.[column in domain "KTOPL"] == SKA1.KTOPL
  • TXW_J_WITH_DDL.HKONT_OPP == SKA1.SAKNR
Official Withholding Tax Collection Code
  • Client
  • ?
  • Official Withholding Tax Collection Code
Type of Recipient
  • Client
  • ?
  • Type of Recipient
  • Indicator for Withholding Tax Type
  • TXW_J_WITH_DDL.MANDT == T059C.MANDT
  • TXW_J_WITH_DDL.[column in domain "LAND1"] == T059C.LAND1
  • TXW_J_WITH_DDL.QSREC == T059C.QSREC
  • TXW_J_WITH_DDL.WITHT == T059C.WITHT
Indicator for Withholding Tax Type
  • Client
  • ?
  • Indicator for Withholding Tax Type
  • TXW_J_WITH_DDL.MANDT == T059P.MANDT
  • TXW_J_WITH_DDL.[column in domain "LAND1"] == T059P.LAND1
  • TXW_J_WITH_DDL.WITHT == T059P.WITHT
Withholding Tax Code
  • Client
  • ?
  • Indicator for Withholding Tax Type
  • Withholding Tax Code
  • TXW_J_WITH_DDL.MANDT == T059Z.MANDT
  • TXW_J_WITH_DDL.[column in domain "LAND1"] == T059Z.LAND1
  • TXW_J_WITH_DDL.WITHT == T059Z.WITHT
  • TXW_J_WITH_DDL.WT_WITHCD == T059Z.WT_WITHCD