SAP ABAP Table EXTAX_ITEM_AUDIT_DATA (xtax item data to update the external system)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-GL-GL (Application Component) Basic Functions
     ⤷ FYTX/B (Package) Basic functions, structs and data elemts for tax interface.

Basic Data

Table Category	INTTAB	Structure
Structure	EXTAX_ITEM_AUDIT_DATA	Table Relationship Diagram
Short Description	xtax item data to update the external system

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	TXJLV_AUDIT_DATA	☐	EXTAX_LEVEL_AUDIT_DATA_TAB		TTYP	0	0
2	REF_ITEM_KEY	☐	TAX_LINE_KEY		STRU	0	0
3	TAXPS	☐	TAX_POSNR	NUM6	NUMC	6	0	Tax document item number
4	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code
5	SHPTO	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction
6	.INCLUDE	☐				0	0	Tax force update internal structure
7	.INCLUDE	☐				0	0	External Tax document substructure: material info
8	POS_NO	☐	TAX_POSNR	NUM6	NUMC	6	0	Tax document item number
9	GROUP_ID	☐	TAX_GROUP_ID	CHAR18	CHAR	18	0	Grouping code for components that are part of the same set
10	COUNTRY	☐	LANDTX	LAND1	CHAR	3	0	Tax Departure Country	*
11	DIVISION	☐	DIVISION	CHAR4	CHAR	4	0	Business area/division code
12	MATNR	☐	TAX_MATNR	CHAR18	CHAR	18	0	Material number for taxes
13	PROD_CODE	☐	PROCD_TTXP	CHAR10	CHAR	10	0	SAP internal product code (external interface)
14	GROUP_PROD_CODE	☐	GRP_PROCD	CHAR10	CHAR	10	0	Group product code
15	QUANTITY	☐	ETD_QUANTITY	MENG13	QUAN	13	3	Material quantity (internal representation - KOMP-MENGE)
16	UNIT	☐	TAX_UNIT	MEINS	UNIT	3	0	Unit for quantity	*
17	UPMAT	☐	UPMAT	MATNR	CHAR	18	0	Pricing reference material of main item	*
18	.INCLUDE	☐				0	0	Tax substructure: tax code info.
19	APAR_IND	☐	APAR_IND	CHAR1	CHAR	1	0	Indicator for A/P or A/R
20	TAX_TYPE	☐	TAXTYPEXT	CHAR1	CHAR	1	0	Indicator: Sales/use/rental/service/tax
21	EXEMP_IND	☐	EXTEXMTFLG	CHAR1	CHAR	1	0	Indicator: Transaction is tax exempt/taxable
22	.INCLUDE	☐				0	0	Tax substructure: Transaction Info
23	TAX_DATE	☐	ETDTXDAT	DATUM	DATS	8	0	Tax date (internal representation)
24	TXJCD_ST	☐	TXJCD_ST	TXJCD	CHAR	15	0	Jurisdiction code "Ship-to"	*
25	TXJCD_SF	☐	TXJCD_SF	TXJCD	CHAR	15	0	Jurisdiction code "Ship-from"	*
26	TXJCD_POA	☐	TXJCD_POA	TXJCD	CHAR	15	0	Jurisdiction code "Point of order acceptance"	*
27	TXJCD_POO	☐	TXJCD_POO	TXJCD	CHAR	15	0	Jurisdiction code "Point of order origin"	*
28	AMOUNT	☐	ETDTAXBASE	WERT7	CURR	13	2	Tax base amount
29	GROSS_AMOUNT	☐	ETDGROSS_AMOUNT	WERT7	CURR	13	2	Tax base amount gross.
30	FREIGHT_AM	☐	ETDFRTAMOUNT	WERT7	CURR	13	2	Freight Amount (internal representation)
31	EXEMPT_AMT	☐	ETDEXMTAMOUNT	WERT7	CURR	13	2	Exempt amount (internal representation)
32	.INCLUDE	☐				0	0	Tax substructure: Posting Info
33	REP_DATE	☐	EXTREPDATE	DATUM	DATS	8	0	Posting date (internal format)
34	CREDIT_IND	☐	EXTCREDFLG	CHAR1	CHAR	1	0	Indicator: Tax credit
35	.INCLUDE	☐				0	0	Tax substructure: Info about how material is used
36	ACCNT_NO	☐	TAX_ACCNT_NO	KTO16	CHAR	16	0	Vendor or ship-to customer account number
37	ACCNT_CLS	☐	TAX_ACCNT_CLS	CHAR10	CHAR	10	0	Classification item of an account (Customer/vendor)
38	COST_OBJECT	☐	TAX_COST_OBJECT	CHAR18	CHAR	18	0	Cost object where the goods are consumed
39	PTP_IND	☐	PTP_IND	CHAR1	CHAR	1	0	Indicator: Point of Title Passage
40	EXCERTIF	☐	EXCERTIF	CHAR25	CHAR	25	0	Customer tax exemption certificate number defined in SAP
41	EXREASON	☐	EXDETCODE	CHAR2	CHAR	2	0	Tax Exemption Reason Code
42	USER_DATA	☐	USER_DATA	TEXT50	CHAR	50	0	User-specific field
43	.INCLUDE	☐				0	0	Tax substructure: Reporting Info
44	STORE_CODE	☐	STORE_CODE	CHAR10	CHAR	10	0	Store Code
45	USER_REPT_DATA	☐	USER_REPT_DATA	TEXT50	CHAR	50	0	User specific reporting data
46	.INCLUDE	☐				0	0	Tax Interface: document item output.
47	TXJCD_IND	☐	TXJCDIND	CHAR1	CHAR	1	0	Indicator: Jurisdiction code used for tax calculation
48	TAXPCOV	☐	ETDTAXPERCNTG	WERTV6	CURR	11	2	Total tax rate (internal representation - KBETR)
49	TAXAMOV	☐	ETDTAXAMOUNTG	WERT7	CURR	13	2	Total tax amount (internal representation - HWSTE)
50	EXMATFLAG	☐	EXMATCODE	CHAR2	CHAR	2	0	Code for material tax exemption
51	EXCUSFLG	☐	EXCUSCODE	CHAR2	CHAR	2	0	Code for customer tax exemption
52	EXT_EXCERTIF	☐	EXT_EXCERTIF	CHAR25	CHAR	25	0	Customer exempt certificate as returned by tax system
53	EXT_EXREASON	☐	EXT_DETCODE	CHAR2	CHAR	2	0	Tax Exemption Reason Code as returned by tax system

History

Last changed by/on	SAP	20130529
SAP Release Created in