SAP ABAP Table DFKKREV07 (Report on Tax on Sales/Purchases (clearing time))

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	DFKKREV07	Table Relationship Diagram
Short Description	Report on Tax on Sales/Purchases (clearing time)

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	XREFS	☐	XREFS_KK	XFELD	CHAR	1	0	Reference To Other Taxes
13	BETRH	☐	BETRH_KK	WRTV7	CURR	13	2	Amount In Local Currency With +/- Signs
14	BETRW	☐	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
15	GBETH	☐	GBETH_KK	WRTV7	CURR	13	2	Total amount in local currency
16	GBETW	☐	GBETW_KK	WRTV7	CURR	13	2	Total amount in transaction currency
17	AUGBO	☐	AUGBO_KK	WRTV7	CURR	13	2	Clearing Amount in Open Item Currency
18	AUGBH	☐	AUGBH_KK	WRTV7	CURR	13	2	Clearing amount in local currency with +/- sign
19	AUGBW	☐	AUGBW_KK	WRTV7	CURR	13	2	Clearing Amount in Transaction Currency (With +/- Sign)
20	HWAER	☐	HWAER_KK	WAERS	CUKY	5	0	Local Currency Key	*
21	TWAER	☐	TWAER	WAERS	CUKY	5	0	Transaction Currency	TCURC
22	TBDAT	☐	TBDAT_KK	DATUM	DATS	8	0	Posting Date Trigger Document
23	TLDAT	☐	TLDAT_KK	DATUM	DATS	8	0	Document Date For Trigger Document
24	FAEDN	☐	FAEDN_KK	DATUM	DATS	8	0	Due date for net payment
25	VMDAT	☐	VMDAT_KK	DATUM	DATS	8	0	Planned Report Date For Tax Item
26	SDATA	☐	SDATA_KK	CHAR140	CHAR	140	0	Additional Data For Tax Report
27	XBLNR	☐	EXBEL_KK	EXBEL_KK	CHAR	16	0	Official Document Number
28	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
29	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
30	GRICD	☐	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax	J_1AGICD
31	GITYP	☐	J_1ADTYP_D	J_1ADTYP	CHAR	2	0	Distribution Type for Employment Tax	J_1ADTYP
32	REPCLS	☐	REPCLS_KK	REPCLS_KK	CHAR	2	0	Report Classification	TFK_EXTDOC_AR2
33	AUBEL	☐	AUBEL_KK	OPBEL_KK	CHAR	12	0	Document Number Of Document To Be Triggered	DFKKKO
34	XSATZ	☐	XSATZ_KK	XSATZ_KK	CHAR	1	0	Record Triggered In Reporting Table
35	REFNR	☐	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	DFKKKO
36	AUGRD	☐	AUGRD_KK	AUGRD_KK	CHAR	2	0	Clearing Reason	TFK001A
37	EXBEL_BETRH	☐	EXBEL_BETRH	WRTV7	CURR	13	2	Total amount for an official document in local currency
38	EXBEL_BETRW	☐	EXBEL_BETRW	WRTV7	CURR	13	2	Total amount of an official document in transaction currency
39	.INCLUDE	☐				0	0
40	.INCLUDE	☐				0	0
41	.INCLUDE	☐				0	0
42	.INCLUDE	☐				0	0

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in