DFKKREV06

Report for Tax on Sales/Purchases (bill. time or triggered) | #transactional | Component: Contract Accounts Receivable and Payable
Column Name Description
MANDT FK Client
OPBEL FK Number of a FI-CA Document
OPUPK Item Number in FI-CA Document
GPART FK Business Partner Number
VINFO Detailing Assignment In Tax Report
MZPKT Report Time For Sales/Purchase Tax Show values
MUMFA Scope Of Data For Sales/Purchase Tax Explanation Show values
TZAHL Counter For Identifying Respective Partial Payment Item
Column Name Description
💲 Local Currency Key (HWAER):
BETRH Amount In Local Currency With +/- Signs
EXBEL_BETRH Total amount for an official document in local currency
💲 Transaction Currency (TWAER):
BETRW Amount in Transaction Currency with +/- Sign
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
Column Name Description
MZPKT Report Time For Sales/Purchase Tax Show values
MUMFA Scope Of Data For Sales/Purchase Tax Explanation Show values
APPLK Application Area Show values
XNABE Special Entry in Tax Reporting Table Show values
XSTOR Document Has Been Reversed Show values
Column Name Description Domain name
SDATA Additional Data for Tax Report CHAR140
XBLNR Official Document Number EXBEL_KK
Master Data Relations Join Conditions
Company Code
  • DFKKREV06.MANDT == T001.MANDT
  • DFKKREV06.BUKRS == T001.BUKRS
County Code
  • County Code
  • ?
  • Region (State, Province, County)
  • DFKKREV06.MANDT == T005E.MANDT
  • DFKKREV06.COUNC == T005E.COUNC
  • DFKKREV06.[column in domain "LAND1"] == T005E.LAND1
  • DFKKREV06.REGIO == T005E.REGIO
Distribution Type for Employment Tax
  • Company Code
  • Distribution Type for Employment Tax
Business Partner Number
  • Business Partner Number
  • Client
  • DFKKREV06.GPART == BUT000.PARTNER
  • DFKKREV06.MANDT == BUT000.CLIENT
Activity Code for Gross Income Tax
  • Activity Code for Gross Income Tax
  • ?
  • DFKKREV06.MANDT == J_1AGICD.MANDT
  • DFKKREV06.GRICD == J_1AGICD.J_1AGICD
  • DFKKREV06.[column in domain "LAND1"] == J_1AGICD.LAND1
General ledger account
  • ?
  • Client
  • General ledger account
  • DFKKREV06.[column in domain "KTOPL"] == SKA1.KTOPL
  • DFKKREV06.MANDT == SKA1.MANDT
  • DFKKREV06.HKONT == SKA1.SAKNR
Client DFKKREV06.MANDT == T000.MANDT
Region (State, Province, County)
  • ?
  • Region (State, Province, County)
  • DFKKREV06.MANDT == T005S.MANDT
  • DFKKREV06.[column in domain "LAND1"] == T005S.LAND1
  • DFKKREV06.REGIO == T005S.BLAND
Report Classification
Transaction Currency
  • DFKKREV06.MANDT == TCURC.MANDT
  • DFKKREV06.TWAER == TCURC.WAERS