SAP ABAP Table DFKKREP06 (Tax Report Data (Invoicing Time or Triggered))

Hierarchy

☛ FI-CA (Software Component) FI-CA
   ⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
     ⤷ FKKB (Package) Contract A/R & A/P: Central Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DFKKREP06	Table Relationship Diagram
Short Description	Tax Report Data (Invoicing 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.	*
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	*
5	VINFO	☑	VINFO_KK	CHAR20	CHAR	20	0	Detailing Assignment In Tax Report
6	TZAHL	☑	TZAHL_KK	NUM3	NUMC	3	0	Counter For Identifying Respective Partial Payment Item
7	APPLK	☐	APPLK_KK	APPLK_KK	CHAR	1	0	Application area
8	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
9	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
10	HKONT	☐	HKONT_KK	SAKNR	CHAR	10	0	General ledger account	*
11	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
12	STRKZ	☐	STRKZ_KK	STRKZ_KK	CHAR	2	0	Tax Code for Other Taxes	*
13	STPRZ	☐	STPRZ_KK	STPRZ_KK	NUMC	6	0	Tax rate
14	SBASH	☐	SBASH_KK	WRTV7	CURR	13	2	Amount Subject to Tax in Local Currency (Tax Base Amount)
15	SBASW	☐	SBASW_KK	WRTV7	CURR	13	2	Amount Subject to Tax in Transaction Currency (Tax Base Amt)
16	SBETH	☐	SBETH_KK	WRTV7	CURR	13	2	Tax Amount in Local Currency With +/- Sign
17	SBETW	☐	SBETW_KK	WRTV7	CURR	13	2	Tax Amount in Transaction Currency with +/- Sign
18	HWAER	☐	HWAER_KK	WAERS	CUKY	5	0	Local Currency Key	*
19	TWAER	☐	TWAER	WAERS	CUKY	5	0	Transaction Currency	*
20	UBDAT	☐	UBDAT_KK	DATUM	DATS	8	0	Posting Date Original Document
21	ULDAT	☐	ULDAT_KK	DATUM	DATS	8	0	Original Document Date
22	FAEDN	☐	FAEDN_KK	DATUM	DATS	8	0	Due date for net payment
23	VMDAT	☐	VMDAT_KK	DATUM	DATS	8	0	Planned Report Date For Tax Item
24	SDATA	☐	SDATA_KK	CHAR140	CHAR	140	0	Additional Data For Tax Report
25	XBLNR	☐	EXBEL_KK	EXBEL_KK	CHAR	16	0	Official Document Number
26	KTOSL	☐	KTOSL_KK	CHAR3	CHAR	3	0	Transaction key for account determination
27	KSCHL	☐	KSCHL_STRKZ_KK	CHAR4	CHAR	4	0	Type of Tax Item for Other Tax Codes
28	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
29	TXJCO	☐	TXJCO_KK	TXJCD	CHAR	15	0	Jurisdiction code (specified value)	*
30	AUBEL	☐	AUBEL_KK	OPBEL_KK	CHAR	12	0	Document Number Of Document To Be Triggered	*
31	XNABE	☐	XNABE_KK	XNABE_KK	CHAR	1	0	Special Entry in Tax Reporting Table
32	NUREL	☐	NUREL_KK	NUMC10	NUMC	10	0	Item Number In Sales/Purchase Tax Report List
33	REFNR	☐	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	*
34	XSTOR	☐	XSTOR_KK	XFELD	CHAR	1	0	Document Has Been Reversed
35	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
36	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
37	XTEIL	☐	XTEIL_KK	XFELD	CHAR	1	0	Document Must be Reread Due to Partial Reset
38	GEBTH	☐	GEBTH_KK	WRTV7	CURR	13	2	Total Amount Per Tax Code In Local Currency
39	GEBTW	☐	GEBTW_KK	WRTV7	CURR	13	2	Total Amount Per Tax Code In Transaction Currency
40	EXBEL_BETRH	☐	EXBEL_BETRH	WRTV7	CURR	13	2	Total amount for an official document in local currency
41	EXBEL_BETRW	☐	EXBEL_BETRW	WRTV7	CURR	13	2	Total amount of an official document in transaction currency
42	ORI_OPBEL	☐	ORI_OPBEL_KK	OPBEL_KK	CHAR	12	0	Tax Reporting: Document Number of Transferred Document	*
43	ORI_OPUPK	☐	ORI_OPUPK_KK	OPUPK_KK	NUMC	4	0	Tax Reporting: Item Number of Transferred Tax Item
44	.INCLUDE	☐				0	0
45	.INCLUDE	☐				0	0	Include for Insurance
46	.INCLUDE	☐				0	0
47	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DFKKREP06	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in