SAP ABAP Table ETXDCI (External tax document: line item info)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-GL-GL (Application Component) Basic Functions
     ⤷ FYTX/ETXDC (Package) External Tax document

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ETXDCI	Table Relationship Diagram
Short Description	External tax document: line item info

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ETXDCI	DOCNR	ETXDCH	DOCNR

History

Last changed by/on	SAP	20130529
SAP Release Created in