SAP ABAP Table FKK_ID_TAX_DATA (Tax reporting data)

Hierarchy

☛ FI-CA (Software Component) FI-CA
   ⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
     ⤷ FKK_INTDEV (Package) FI-CA: Country specific development

Basic Data

Table Category	INTTAB	Structure
Structure	FKK_ID_TAX_DATA	Table Relationship Diagram
Short Description	Tax reporting data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	472