SAP ABAP Table DFKKREV06 (Report for Tax on Sales/Purchases (bill. time or triggered))

Hierarchy

☛ FI-CA (Software Component) FI-CA
   ⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
     ⤷ EEREV_REP (Package) Sales Tax Reporting

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DFKKREV06	Table Relationship Diagram
Short Description	Report for Tax on Sales/Purchases (bill. time or triggered)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	OPBEL	☑	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	DFKKKO
3	OPUPK	☑	OPUPK_KK	OPUPK_KK	NUMC	4	0	Item number in contract account document
4	GPART	☑	GPART_KK	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
5	VINFO	☑	VINFO_KK	CHAR20	CHAR	20	0	Detailing Assignment In Tax Report
6	MZPKT	☑	MZPKT_KK	MZPKT_KK	NUMC	2	0	Report Time For Sales/Purchase Tax
7	MUMFA	☑	MUMFA_KK	MUMFA_KK	NUMC	1	0	Scope Of Data For Sales/Purchase Tax Explanation
8	TZAHL	☑	TZAHL_KK	NUM3	NUMC	3	0	Counter For Identifying Respective Partial Payment Item
9	APPLK	☐	APPLK_KK	APPLK_KK	CHAR	1	0	Application area
10	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
11	HKONT	☐	HKONT_KK	SAKNR	CHAR	10	0	General ledger account	SKA1
12	BETRH	☐	BETRH_KK	WRTV7	CURR	13	2	Amount In Local Currency With +/- Signs
13	BETRW	☐	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
14	HWAER	☐	HWAER_KK	WAERS	CUKY	5	0	Local Currency Key	*
15	TWAER	☐	TWAER	WAERS	CUKY	5	0	Transaction Currency	TCURC
16	UBDAT	☐	UBDAT_KK	DATUM	DATS	8	0	Posting Date Original Document
17	ULDAT	☐	ULDAT_KK	DATUM	DATS	8	0	Original Document Date
18	FAEDN	☐	FAEDN_KK	DATUM	DATS	8	0	Due date for net payment
19	VMDAT	☐	VMDAT_KK	DATUM	DATS	8	0	Planned Report Date For Tax Item
20	SDATA	☐	SDATA_KK	CHAR140	CHAR	140	0	Additional Data For Tax Report
21	XBLNR	☐	EXBEL_KK	EXBEL_KK	CHAR	16	0	Official Document Number
22	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
23	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
24	GRICD	☐	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax	J_1AGICD
25	GITYP	☐	J_1ADTYP_D	J_1ADTYP	CHAR	2	0	Distribution Type for Employment Tax	J_1ADTYP
26	REPCLS	☐	REPCLS_KK	REPCLS_KK	CHAR	2	0	Report Classification	TFK_EXTDOC_AR2
27	AUBEL	☐	AUBEL_KK	OPBEL_KK	CHAR	12	0	Document Number Of Document To Be Triggered	DFKKKO
28	XNABE	☐	XNABE_KK	XNABE_KK	CHAR	1	0	Special Entry in Tax Reporting Table
29	REFNR	☐	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	DFKKKO
30	XSTOR	☐	XSTOR_KK	XFELD	CHAR	1	0	Document Has Been Reversed
31	EXBEL_BETRH	☐	EXBEL_BETRH	WRTV7	CURR	13	2	Total amount for an official document in local currency
32	EXBEL_BETRW	☐	EXBEL_BETRW	WRTV7	CURR	13	2	Total amount of an official document in transaction currency
33	.INCLUDE	☐				0	0
34	.INCLUDE	☐				0	0
35	.INCLUDE	☐				0	0
36	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DFKKREV06	AUBEL	DFKKKO	OPBEL	REF	C	CN
2	DFKKREV06	BUKRS	T001	BUKRS	REF	1	CN
3	DFKKREV06	COUNC	T005E	COUNC	REF	1	CN
4	DFKKREV06	GITYP	J_1ADTYP	J_1ADTYP	REF	C	CN
5	DFKKREV06	GPART	BUT000	PARTNER
6	DFKKREV06	GRICD	J_1AGICD	J_1AGICD	REF	1	CN
7	DFKKREV06	HKONT	SKA1	SAKNR	REF	C	CN
8	DFKKREV06	MANDT	T000	MANDT	KEY	1	CN
9	DFKKREV06	OPBEL	DFKKKO	OPBEL
10	DFKKREV06	REFNR	DFKKKO	OPBEL	REF	C	CN
11	DFKKREV06	REGIO	T005S	BLAND
12	DFKKREV06	REPCLS	TFK_EXTDOC_AR2	REPCLS	REF	C	CN
13	DFKKREV06	TWAER	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in