ETXDCI - External tax document: line item info

External tax document: line item info information is stored in SAP table ETXDCI.
It is part of development package FYTX/ETXDC in software component FI-GL-GL. This development package consists of objects that can be grouped under "External Tax document".

Fields for table ETXDCI

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
DOCNR	External-tax document number	X	XTAX_DOCUMENT_NUMBER	CHAR	24	ETXDCH
ITEMNR	External-tax document item number	X	XTAX_DOC_ITEM_NUMBER	NUMC	12
.INCLUDE				TAX_LINE_KEY	0
TAXPS	Tax document item number		TAX_POSNR	NUMC	12
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4	*
SHPTO	Tax Jurisdiction		TXJCD	CHAR	30	*
.INCLUDE				EXTAX_ITEM_IN	0
.INCLUDE				ETDTAX_MAT_INF	0
POS_NO	Tax document item number		TAX_POSNR	NUMC	12
GROUP_ID	Grouping code for components that are part of the same set		TAX_GROUP_ID	CHAR	36
COUNTRY	Tax Departure Country/Region		LANDTX	CHAR	6	*
DIVISION	Business area/division code		DIVISION	CHAR	8
MATNR	Material number for taxes		TAX_MATNR	CHAR	36
PROD_CODE	SAP Internal Product Code (External Interface)		PROCD_TTXP	CHAR	20
GROUP_PROD_CODE	Group product code		GRP_PROCD	CHAR	20
QUANTITY	Material quantity (internal representation - KOMP-MENGE)		ETD_QUANTITY	QUAN	7
UNIT	Unit for quantity		TAX_UNIT	UNIT	6	*
UPMAT	Pricing reference material of main item		UPMAT	CHAR	80	*
MATKL	Material Group		MATKL	CHAR	18
.INCLUDE				TAX_TAXCODE_INF	0
APAR_IND	Indicator for A/P or A/R		APAR_IND	CHAR	2
TAX_TYPE	Indicator: Sales/Use/Rental/Service/... Tax		TAXTYPEXT	CHAR	2
EXEMP_IND	Indicator: Transaction Is Tax Exempt/Taxable		EXTEXMTFLG	CHAR	2
.INCLUDE				ETDTAX_TRANS_INF	0
TAX_DATE	Tax date (internal representation)		ETDTXDAT	DATS	16
TXJCD_ST	Jurisdiction code "Ship-to"		TXJCD_ST	CHAR	30	*
TXJCD_SF	Jurisdiction code "Ship-from"		TXJCD_SF	CHAR	30	*
TXJCD_POA	Jurisdiction code "Point of order acceptance"		TXJCD_POA	CHAR	30	*
TXJCD_POO	Jurisdiction code "Point of order origin"		TXJCD_POO	CHAR	30	*
AMOUNT	Tax base amount		ETDTAXBASE	CURR	12
GROSS_AMOUNT	Tax base amount gross.		ETDGROSS_AMOUNT	CURR	12
FREIGHT_AM	Freight Amount (internal representation)		ETDFRTAMOUNT	CURR	12
EXEMPT_AMT	Exempt amount (internal representation)		ETDEXMTAMOUNT	CURR	12
BILLED_AMOUNT	Billed amount (in currency format)		FOT_BILLED_AMOUNT_D	CURR	12
.INCLUDE				TAX_USER_INF	0
ACCNT_NO	Vendor or ship-to customer account number		TAX_ACCNT_NO	CHAR	32
ACCNT_CLS	Classification item of an account (Customer/vendor)		TAX_ACCNT_CLS	CHAR	20
COST_OBJECT	Cost object where the goods are consumed		TAX_COST_OBJECT	CHAR	36
PTP_IND	Indicator: Point of Title Passage		PTP_IND	CHAR	2
EXCERTIF	Customer tax exemption certificate number defined in SAP		EXCERTIF	CHAR	50
EXREASON	Tax Exemption Reason Code		EXDETCODE	CHAR	4
USER_DATA	User-Specific Field		USER_DATA	CHAR	100
.INCLUDE	POPUP_FIELDS			ETAX_POPUP_FIELDS	0
.INCLUDE	ETAX_FIELDS_S			ETAX_POPUP_FIELDS_S	0
SOLDTO	Sold-to Party		KUNAG	CHAR	20	*
SHIPTO	Ship-to Party		KUNWE	CHAR	20	*
GL_ACCOUNT	G/L Account Number, Significant Length		SAKAN	CHAR	20
KOSTL	Cost Center		KOSTL	CHAR	20	*
DOC_DATE	Document Date in Document		BLDAT	DATS	16
POST_DATE	Posting Date in the Document		BUDAT	DATS	16
SR_DATE	Service Render Date		FIS_ETXDC_SRDAT	DATS	16
EBELN	Purchasing Document Number		EBELN	CHAR	20
EBELP	Item Number of Purchasing Document		EBELP	NUMC	10	*
VBELN	Sales and Distribution Document Number		VBELN	CHAR	20
VBTYP	SD Document Category		VBTYPL	CHAR	8
CONT_VAL	Total Contract Value		FIS_ETXDC_CONVAL	CHAR	50
WBS_ELEMENT	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	*
BTT_CODE	Business Transaction Type(Do not use! Will be overwrited)		FOT_TDT_TXDAT_DET_BTT_CODE_E	NUMC	10
BILLTO	Bill-to Party		KUNRE	CHAR	20	*
SUPPLIER	Account Number of Supplier		LIFNR	CHAR	20
.INCLUDE	ETAX_FIELDS_C			ETAX_POPUP_FIELDS_C	0
EXTENSION_FIELD001	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD002	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD003	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD004	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD005	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD006	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD007	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD008	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD009	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD010	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD011	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD012	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD013	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD014	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD015	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD016	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD017	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD018	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD019	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD020	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD021	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD022	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD023	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD024	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD025	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD026	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD027	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD028	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD029	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD030	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD031	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD032	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD033	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD034	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD035	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD036	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD037	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD038	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD039	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD040	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD041	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD042	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD043	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD044	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD045	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD046	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD047	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD048	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD049	Text (100 characters)		TEXT100	CHAR	200
EXTENSION_FIELD050	Text (100 characters)		TEXT100	CHAR	200
.INCLUDE				TAX_REPT_DATA	0
STORE_CODE	Store Code		STORE_CODE	CHAR	20
USER_REPT_DATA	User specific reporting data		USER_REPT_DATA	CHAR	100
.INCLUDE				EXTAX_ITEM_OUT	0
DEFAULT_REASON	Tax Default Reason		TAX_DEFAULT_REASON	CHAR	2
.INCLUDE				ETDTAX_ITEM_INFO_OUT	0
TXJCD_IND	Indicator: Jurisdiction Code Used for Tax Calculation		TXJCDIND	CHAR	2
TAXPCOV	Total tax rate (internal representation - KBETR)		ETDTAXPERCNTG	CURR	12
TAX_DATE_RETURN	Date for tax calculation (format YYYYMMDD).		TAX_DATE	CHAR	16
TAXAMOV	Total tax amount (internal representation - HWSTE)		ETDTAXAMOUNTG	CURR	12
EXMATFLAG	Code for Material Tax Exemption		EXMATCODE	CHAR	4
EXCUSFLG	Code for Customer Tax Exemption		EXCUSCODE	CHAR	4
EXT_EXCERTIF	Customer exempt certificate as returned by tax system		EXT_EXCERTIF	CHAR	50
EXT_EXREASON	Tax Exemption Reason Code as returned by tax system		EXT_DETCODE	CHAR	4
.INCLUDE				GLTAX_ITEM_RESULTS	0
GL_TAXPCOV	G/L tax rate (KBETR)		GL_TAXPERCNT	CURR	12
GL_TAXAMOV	G/L tax amount (HWSTE)		GL_TAXAMOUNT	CURR	12
.INCLUDE				ETDTAX_ITEM_INFO_DERIVED	0
TAX_STATE	Tax State		FIS_ETXDC_REGION	CHAR	4
GL_TAXBAS	G/L Tax base amount (HWBAS)		GL_TAXBASE	CURR	12
.INCLUDE				EXTAX_POST_INFO	0
.INCLUDE				TAX_POST_INF	0
REP_DATE	Posting date (internal format)		EXTREPDATE	DATS	16
CREDIT_IND	Indicator: Tax Credit		EXTCREDFLG	CHAR	2
_DATAAGING	Data Filter Value for Data Aging		DATA_TEMPERATURE	DATS	16