DFKKREV07 - Report on Tax on Sales/Purchases (clearing time)

Report on Tax on Sales/Purchases (clearing time) information is stored in SAP table DFKKREV07.
It is part of development package EEREV_REP in software component FI-CA. This development package consists of objects that can be grouped under "Sales Tax Reporting".

Fields for table DFKKREV07

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
OPBEL	Number of a FI-CA Document	X	OPBEL_KK	CHAR	24	DFKKKO
OPUPK	Item Number in FI-CA Document	X	OPUPK_KK	NUMC	8
GPART	Business Partner Number	X	GPART_KK	CHAR	20	BUT000
VINFO	Detailing Assignment In Tax Report	X	VINFO_KK	CHAR	40
MZPKT	Report Time For Sales/Purchase Tax	X	MZPKT_KK	NUMC	4
MUMFA	Scope Of Data For Sales/Purchase Tax Explanation	X	MUMFA_KK	NUMC	2
TZAHL	Counter For Identifying Respective Partial Payment Item	X	TZAHL_KK	NUMC	6
APPLK	Application Area		APPLK_KK	CHAR	2
BUKRS	Company Code		BUKRS	CHAR	8	T001
HKONT	General ledger account		HKONT_KK	CHAR	20	SKA1
XREFS	Reference To Other Taxes		XREFS_KK	CHAR	2
BETRH	Amount In Local Currency With +/- Signs		BETRH_KK	CURR	7
BETRW	Amount in Transaction Currency with +/- Sign		BETRW_KK	CURR	7
GBETH	Total amount in local currency		GBETH_KK	CURR	7
GBETW	Total amount in transaction currency		GBETW_KK	CURR	7
AUGBO	Clearing Amount in Open Item Currency		AUGBO_KK	CURR	7
AUGBH	Clearing amount in local currency with +/- sign		AUGBH_KK	CURR	7
AUGBW	Clearing Amount in Transaction Currency (With +/- Sign)		AUGBW_KK	CURR	7
HWAER	Local Currency Key		HWAER_KK	CUKY	10	*
TWAER	Transaction Currency		TWAER	CUKY	10	TCURC
TBDAT	Posting Date Trigger Document		TBDAT_KK	DATS	16
TLDAT	Document Date For Trigger Document		TLDAT_KK	DATS	16
FAEDN	Due date for net payment		FAEDN_KK	DATS	16
VMDAT	Planned Report Date For Tax Item		VMDAT_KK	DATS	16
SDATA	Additional Data for Tax Report		SDATA_KK	CHAR	280
XBLNR	Official Document Number		EXBEL_KK	CHAR	32
REGIO	Region (State, Province, County)		REGIO	CHAR	6	T005S
COUNC	County Code		COUNC	CHAR	6	T005E
GRICD	Activity Code for Gross Income Tax		J_1AGICD_D	CHAR	4	J_1AGICD
GITYP	Distribution Type for Employment Tax		J_1ADTYP_D	CHAR	4	J_1ADTYP
REPCLS	Report Classification		REPCLS_KK	CHAR	4	TFK_EXTDOC_AR2
AUBEL	Document Number Of Document To Be Triggered		AUBEL_KK	CHAR	24	DFKKKO
XSATZ	Record Triggered In Reporting Table		XSATZ_KK	CHAR	2
REFNR	Number of a FI-CA Document		OPBEL_KK	CHAR	24	DFKKKO
AUGRD	Clearing Reason		AUGRD_KK	CHAR	4	TFK001A
EXBEL_BETRH	Total amount for an official document in local currency		EXBEL_BETRH	CURR	7
EXBEL_BETRW	Total amount of an official document in transaction currency		EXBEL_BETRW	CURR	7
.INCLUDE				SI_DFKKREV06_R	0
.INCLUDE				SI_DFKKREV06_T	0
.INCLUDE				SI_DFKKREV06_V	0
.INCLUDE				CI_DFKKREV06	0