DFKKREP06

Tax Report Data (Invoicing Time or Triggered) | #transactional | Component: Contract Accounts Receivable and Payable
Column Name Description
MANDT FK Client
OPBEL Number of a FI-CA Document
OPUPK Item Number in Contract Account Document
GPART Business Partner Number
VINFO Detailing Assignment In Tax Report
TZAHL Counter For Identifying Respective Partial Payment Item
Column Name Description
💲 Local Currency Key (HWAER):
SBASH Amount Subject to Tax in Local Currency (Tax Base Amount)
SBETH Tax Amount in Local Currency With +/- Sign
GEBTH Total Amount Per Tax Code In Local Currency
EXBEL_BETRH Total amount for an official document in local currency
💲 Transaction Currency (TWAER):
SBASW Amount Subject to Tax in Transaction Currency (Tax Base Amt)
SBETW Tax Amount in Transaction Currency with +/- Sign
GEBTW Total Amount Per Tax Code In Transaction Currency
EXBEL_BETRW Total amount of an official document in transaction currency
Column Name Description
Column Name Description
UBDAT Posting Date Original Document
ULDAT Original Document Date
FAEDN Due date for net payment
VMDAT Planned Report Date For Tax Item
CPUDT Day On Which Accounting Document Was Entered
CPUTM Time of Entry
Column Name Description
APPLK Application Area Show values
KTOSL Transaction key for account determination Show values
XNABE Special Entry in Tax Reporting Table Show values
XSTOR Document Has Been Reversed Show values
XTEIL Document Must be Reread Due to Partial Reset Show values
Column Name Description Domain name
BUKRS Company Code BUKRS
BUPLA Business Place J_1BBRANCH
HKONT General ledger account SAKNR
MWSKZ Tax on sales/purchases code MWSKZ
STRKZ Tax Code for Other Taxes STRKZ_KK
STPRZ Tax rate STPRZ_KK
SDATA Additional Data for Tax Report CHAR140
XBLNR Official Document Number EXBEL_KK
KSCHL Type of Tax Item for Other Tax Codes CHAR4
TXJCD Tax Jurisdiction TXJCD
TXJCO Tax Jurisdiction Code (Entered value) TXJCD
AUBEL Document Number Of Document To Be Triggered OPBEL_KK
NUREL Item Number In Sales/Purchase Tax Report List NUMC10
REFNR Number of a FI-CA Document OPBEL_KK
ORI_OPBEL Tax Reporting: Document Number of Transferred Document OPBEL_KK
ORI_OPUPK Tax Reporting: Item Number of Transferred Tax Item OPUPK_KK
DP_OPUPK Tax Reporting: Item Number of Down Payment (DFKKOP) OPUPK_KK
TAXC_FACTOR Factor for Conversion into Tax Country/Region Currency FINS_T2ANY_CRCY_CONV_FACTOR
Master Data Relations Join Conditions
Client DFKKREP06.MANDT == T000.MANDT
Other Relations Join Conditions
Tax Reporting Country/Region
  • Company Code
  • Tax Reporting Country/Region