SAP Table J_1IEXCHDR

Excise invoice header detail

The table J_1IEXCHDR (Excise invoice header detail) is a standard table in SAP ERP. It belongs to the package J1I2.

Technical Information

Table	J_1IEXCHDR
Short Text	Excise invoice header detail
Package	J1I2
Table Type	Transparent Table

Fields for Table J_1IEXCHDR

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client	MANDT	CLNT	3	T000
TRNTYP	✔	Excise Transaction Type	J_1ITRNTYP	CHAR	4	J_1ITRAN
DOCYR	✔	Year	J_1IDOCUYR	NUMC	4
DOCNO	✔	Internal Excise Document Number	J_1IDOCNO	NUMC	10
BUKRS		Company Code	BUKRS	CHAR	4	T001
WERKS		Plant	WERKS_D	CHAR	4	T001W
EXGRP		Excise Group	J_1IEXCGRP	CHAR	2	J_1IEXGRPS
SRGRP		Excise Document Series Group	J_1ISERGRP	CHAR	3	J_1ISRGRPS
STRTYP		Sub Transaction Type	J_1ISTRTYP	CHAR	2
EXNUM		Official Excise Document Number	J_1IEXCNUM	CHAR	10
EXDAT		Excise Document Date	J_1IEXCDAT	DATS	8
EXYEAR		Excise Year	J_1IEXYEAR	NUMC	4
REMTIME		Time of Removal	J_1IREMTIM	TIMS	6
LIFNR		Account Number of Vendor or Creditor	LIFNR	CHAR	10	LFA1
SHIPFROM		Account Number of Vendor or Creditor	LIFNR	CHAR	10	*
RCWRK		Receiving/Issuing Plant	UMWRK	CHAR	4	T001W
EXCUR		Currency	J_1IEXCCUR	CUKY	5	TCURC
EXBED		Basic Excise Duty	J_1IEXCBED	CURR	13
EXSED		Special Excise Duty	J_1IEXCSED	CURR	13
EXAED		Additional Excise Duty	J_1IEXCAED	CURR	13
CESS		Cess amount	J_1IEXCESS	CURR	13
REFDOC		Internal reference document	J_1IINTREF	CHAR	10
RDOC		Reference Document 1	J_1IRDOC1	CHAR	10
RYEAR		Reference year 1	J_1IRYEAR1	CHAR	4
RIND		Reference Document Type 1	J_1IRIND1	CHAR	1
KUNAG		Sold-to party	KUNAG	CHAR	10	KNA1
KUNWE		Ship-to party	KUNWE	CHAR	10	KNA1
GSBER		Business Area	GSBER	CHAR	4	TGSB
EXCCD		ECC Number	J_1IEXCD	CHAR	40
EXCRN		Excise Registration Number	J_1IEXRN	CHAR	40
EXCRG		Excise Range	J_1IEXRG	CHAR	60
EXCDI		Excise Division	J_1IEXDI	CHAR	60
EXCCO		Excise Commissionerate	J_1IEXCO	CHAR	60
CSTNO		Central Sales Tax Number	J_1ICSTNO	CHAR	40
LSTNO		Local Sales Tax Number	J_1ILSTNO	CHAR	40
PANNO		Permanent Account Number	J_1IPANNO	CHAR	40
PREPRN		Preprinted Serial Number	J_1IPREPRN	CHAR	10
RTDAT		Return Date	J_1IRTDAT	DATS	8
CVDIND		CVD indication	J_1ICVDIND	CHAR	1
EXPIND		Export Type	J_1IINDEXP	CHAR	1
STATUS		Excise Document Status	J_1ISTATUS	CHAR	1
CENSTAT		CENVAT Utilization status	J_1ICENST	CHAR	1
REJ_CODE		Rejection Code	J_1IREJCODE	CHAR	3	J_1IREJMAS
MRPIND		Maximum Retail Price	J_1IMRPIND	CHAR	1
USNAM		Created By	J_1IUSNAM	CHAR	12
CPUDT		Excise Document Entry Date	J_1ICPUDT	DATS	8
CPUTM		Time of Entry	CPUTM	TIMS	6
AENAM		Name of Person Who Changed Object	AENAM	CHAR	12
AEDAT		Changed On	AEDAT	DATS	8
BUDAT		Posting Date in the Document	BUDAT	DATS	8
ADDLDATA1		Additional Data	J_1IADDATA	CHAR	60
ADDLDATA2		Additional Data	J_1IADDATA	CHAR	60
ADDLDATA3		Additional Data	J_1IADDATA	CHAR	60
ADDLDATA4		Additional Data	J_1IADDATA	CHAR	60
ADDLVAL		Additional Value	J_1IADDVAL	CURR	17
RULES		Rule/Section	J_2IRULE	CHAR	10	*
TCODE		Transaction code	J_1ITCODE	CHAR	20	*
REJ_ACC_DOCNO		Accounting Document	J_1IFAWREF	CHAR	10
REJ_ACC_DOCTYP		Object type of calling application (FI)	J_1IFAWTYP	CHAR	5	*
REJ_ACC_YEAR		Financial posting year	J_1IFAYEAR	NUMC	4
PRECUSDAT		Arrived at Customs	J_1IPRECUSDAT	DATS	8
ACKCUSDAT		Countersigned	J_1IACKCUSDAT	DATS	8
RECPTDAT		Arrived Back	J_1IRECPTDAT	DATS	8
EXCSUBDAT		Sent to Excise Department	J_1IEXCSUBDAT	DATS	8
POEXPDAT		Export Confirmed	J_1IPOEXPDAT	DATS	8
AMENDIND		Exc Bonding: Amendment Indicator		CHAR	1
BONDNO		Internal Bond Number	J_1IBONDNO	NUMC	10
BONDYR		Fiscal Year	J_1IBONDYR	NUMC	4
BOAMTBAL		Bond Balance	J_1IBOCURBAL	CURR	13
AMENDED_BALANCE		BED After Amendment	J_1IAMD_BAL	CURR	13
AMENDED_ON		Exc Bonding: Date of Amendment	J_1IAMD_DAT	DATS	8
EXC_ADDRESS_NO		Address	J_1IEDADDR_NO	NUMC	3
CUS_ADDRESS_NO		Address	J_1IEDADDR_NO	NUMC	3
INTEREST_VALUE		Interest Amount	J_1IINTVAL	CURR	13
NCCD		NCCD Value	J_1IEXNCCD	CURR	13
ECS		ECS Value	J_1IEXECS	CURR	13
EXADDTAX1		Additional Tax1 value	J_1IEXADDTAX1	CURR	13
EXADDTAX2		Additional Tax2 value	J_1IEXADDTAX2	CURR	13
EXADDTAX3		Additional Tax3 value	J_1IEXADDTAX3	CURR	13
BELNR		Accounting Document	J_1IFAWREF	CHAR	10
GJAHR		Financial posting year	J_1IFAYEAR	NUMC	4