DFKKREV07

Report on Tax on Sales/Purchases (clearing time) | #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
GBETH Total amount in local currency
AUGBH Clearing amount in local currency with +/- sign
EXBEL_BETRH Total amount for an official document in local currency
💲 Transaction Currency (TWAER):
BETRW Amount in Transaction Currency with +/- Sign
GBETW Total amount in transaction currency
AUGBW Clearing Amount in Transaction Currency (With +/- Sign)
EXBEL_BETRW Total amount of an official document in transaction currency
💲 Document currency of open item (FKKCL.ORIWA):
AUGBO Clearing Amount in Open Item Currency
Column Name Description
Column Name Description
TBDAT Posting Date Trigger Document
TLDAT Document Date For Trigger Document
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
XREFS Reference To Other Taxes Show values
XSATZ Record Triggered In Reporting Table 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
Clearing Reason DFKKREV07.AUGRD == TFK001A.AUGRD
Company Code
  • DFKKREV07.MANDT == T001.MANDT
  • DFKKREV07.BUKRS == T001.BUKRS
County Code
  • County Code
  • ?
  • Region (State, Province, County)
  • DFKKREV07.MANDT == T005E.MANDT
  • DFKKREV07.COUNC == T005E.COUNC
  • DFKKREV07.[column in domain "LAND1"] == T005E.LAND1
  • DFKKREV07.REGIO == T005E.REGIO
Distribution Type for Employment Tax
  • Company Code
  • Distribution Type for Employment Tax
Business Partner Number
  • Business Partner Number
  • Client
  • DFKKREV07.GPART == BUT000.PARTNER
  • DFKKREV07.MANDT == BUT000.CLIENT
Activity Code for Gross Income Tax
  • Activity Code for Gross Income Tax
  • ?
  • DFKKREV07.MANDT == J_1AGICD.MANDT
  • DFKKREV07.GRICD == J_1AGICD.J_1AGICD
  • DFKKREV07.[column in domain "LAND1"] == J_1AGICD.LAND1
General ledger account
  • ?
  • Client
  • General ledger account
  • DFKKREV07.[column in domain "KTOPL"] == SKA1.KTOPL
  • DFKKREV07.MANDT == SKA1.MANDT
  • DFKKREV07.HKONT == SKA1.SAKNR
Client DFKKREV07.MANDT == T000.MANDT
Region (State, Province, County)
  • ?
  • Region (State, Province, County)
  • DFKKREV07.MANDT == T005S.MANDT
  • DFKKREV07.[column in domain "LAND1"] == T005S.LAND1
  • DFKKREV07.REGIO == T005S.BLAND
Report Classification
Transaction Currency
  • DFKKREV07.MANDT == TCURC.MANDT
  • DFKKREV07.TWAER == TCURC.WAERS