SAP ABAP Table J_1IEXCHDR (Excise invoice header detail)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ FI-LOC (Application Component) Localization
     ⤷ J1I2 (Package) India, Phase II

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_1IEXCHDR	Table Relationship Diagram
Short Description	Excise invoice header detail

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	TRNTYP	☑	J_1ITRNTYP	J_1ITRNTYP	CHAR	4	0	Excise Transaction Type	J_1ITRAN
3	DOCYR	☑	J_1IDOCUYR	J_1IDOCUYR	NUMC	4	0	Year
4	DOCNO	☑	J_1IDOCNO	J_1IDOCNO	NUMC	10	0	Internal Excise Document Number
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
7	EXGRP	☐	J_1IEXCGRP	J_1IEXCGRP	CHAR	2	0	Excise Group	J_1IEXGRPS
8	SRGRP	☐	J_1ISERGRP	J_1ISERGRP	CHAR	3	0	Excise Document Series Group	J_1ISRGRPS
9	STRTYP	☐	J_1ISTRTYP	CHAR2	CHAR	2	0	Sub Transaction Type
10	EXNUM	☐	J_1IEXCNUM	J_1IEXCNUM	CHAR	10	0	Official Excise Document Number
11	EXDAT	☐	J_1IEXCDAT	J_1IEXCDAT	DATS	8	0	Excise Document Date
12	EXYEAR	☐	J_1IEXYEAR	GJAHR	NUMC	4	0	Excise Year
13	REMTIME	☐	J_1IREMTIM	UZEIT	TIMS	6	0	Time of Removal
14	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
15	SHIPFROM	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
16	RCWRK	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	T001W
17	EXCUR	☐	J_1IEXCCUR	WAERS	CUKY	5	0	Currency	TCURC
18	EXBED	☐	J_1IEXCBED	WERT7	CURR	13	2	Basic Excise Duty
19	EXSED	☐	J_1IEXCSED	WERT7	CURR	13	2	Special Excise Duty
20	EXAED	☐	J_1IEXCAED	WERT7	CURR	13	2	Additional Excise Duty
21	CESS	☐	J_1IEXCESS	WERT7	CURR	13	2	Cess amount
22	REFDOC	☐	J_1IINTREF	CHAR10	CHAR	10	0	Internal reference document
23	RDOC	☐	J_1IRDOC1	CHAR10	CHAR	10	0	Reference Document 1
24	RYEAR	☐	J_1IRYEAR1	CHAR4	CHAR	4	0	Reference year 1
25	RIND	☐	J_1IRIND1	J_1IRIND	CHAR	1	0	Reference Document Type 1
26	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
27	KUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
28	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
29	EXCCD	☐	J_1IEXCD	CHAR40	CHAR	40	0	ECC Number
30	EXCRN	☐	J_1IEXRN	CHAR40	CHAR	40	0	Excise Registration Number
31	EXCRG	☐	J_1IEXRG	CHAR60	CHAR	60	0	Excise Range
32	EXCDI	☐	J_1IEXDI	CHAR60	CHAR	60	0	Excise Division
33	EXCCO	☐	J_1IEXCO	CHAR60	CHAR	60	0	Excise Commissionerate
34	CSTNO	☐	J_1ICSTNO	CHAR40	CHAR	40	0	Central Sales Tax Number
35	LSTNO	☐	J_1ILSTNO	CHAR40	CHAR	40	0	Local Sales Tax Number
36	PANNO	☐	J_1IPANNO	CHAR40	CHAR	40	0	Permanent Account Number
37	PREPRN	☐	J_1IPREPRN	CHAR10	CHAR	10	0	Preprinted Serial Number
38	RTDAT	☐	J_1IRTDAT	DATS	DATS	8	0	Return Date
39	CVDIND	☐	J_1ICVDIND	CHAR1_X	CHAR	1	0	CVD indication
40	EXPIND	☐	J_1IINDEXP	J_1IINDEXP	CHAR	1	0	Export Type
41	STATUS	☐	J_1ISTATUS	J_1ISTATUS	CHAR	1	0	Excise Document Status
42	CENSTAT	☐	J_1ICENST	J_1ICENST	CHAR	1	0	CENVAT Utilization status
43	REJ_CODE	☐	J_1IREJCODE	CHAR3	CHAR	3	0	Rejection Code	J_1IREJMAS
44	MRPIND	☐	J_1IMRPIND	CHAR1	CHAR	1	0	Maximum Retail Price
45	USNAM	☐	J_1IUSNAM	CHAR12	CHAR	12	0	Created By
46	CPUDT	☐	J_1ICPUDT	DATUM	DATS	8	0	Excise Document Entry Date
47	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
48	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
49	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
50	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
51	ADDLDATA1	☐	J_1IADDATA	CHAR60	CHAR	60	0	Additional Data
52	ADDLDATA2	☐	J_1IADDATA	CHAR60	CHAR	60	0	Additional Data
53	ADDLDATA3	☐	J_1IADDATA	CHAR60	CHAR	60	0	Additional Data
54	ADDLDATA4	☐	J_1IADDATA	CHAR60	CHAR	60	0	Additional Data
55	ADDLVAL	☐	J_1IADDVAL	WERT9	CURR	17	2	Additional Value
56	RULES	☐	J_2IRULE	J_2IRULE	CHAR	10	0	Rule/Section	*
57	TCODE	☐	J_1ITCODE	TCODE	CHAR	20	0	Transaction code	*
58	REJ_ACC_DOCNO	☐	J_1IFAWREF	AWREF	CHAR	10	0	Accounting Document
59	REJ_ACC_DOCTYP	☐	J_1IFAWTYP	AWTYP	CHAR	5	0	Object type of calling application (FI)	*
60	REJ_ACC_YEAR	☐	J_1IFAYEAR	NUMC4	NUMC	4	0	Financial posting year
61	PRECUSDAT	☐	J_1IPRECUSDAT	DATUM	DATS	8	0	Arrived at Customs
62	ACKCUSDAT	☐	J_1IACKCUSDAT	DATUM	DATS	8	0	Countersigned
63	RECPTDAT	☐	J_1IRECPTDAT	DATS	DATS	8	0	Arrived Back
64	EXCSUBDAT	☐	J_1IEXCSUBDAT	DATUM	DATS	8	0	Sent to Excise Department
65	POEXPDAT	☐	J_1IPOEXPDAT	DATUM	DATS	8	0	Export Confirmed
66	AMENDIND	☐			CHAR	1	0
67	BONDNO	☐	J_1IBONDNO	J_1IBONDNO	NUMC	10	0	Internal Bond Number
68	BONDYR	☐	J_1IBONDYR	GJAHR	NUMC	4	0	Fiscal Year
69	BOAMTBAL	☐	J_1IBOCURBAL	WERT7	CURR	13	2	Bond Balance
70	AMENDED_BALANCE	☐	J_1IAMD_BAL	WERT7	CURR	13	2	BED After Amendment
71	AMENDED_ON	☐	J_1IAMD_DAT	DATS	DATS	8	0	Exc Bonding: Date of Amendment
72	EXC_ADDRESS_NO	☐	J_1IEDADDR_NO	NUM3	NUMC	3	0	Address
73	CUS_ADDRESS_NO	☐	J_1IEDADDR_NO	NUM3	NUMC	3	0	Address
74	INTEREST_VALUE	☐	J_1IINTVAL	WERT7	CURR	13	2	Interest Amount
75	NCCD	☐	J_1IEXNCCD	WERT7	CURR	13	2	NCCD Value
76	ECS	☐	J_1IEXECS	WERT7	CURR	13	2	ECS Value
77	EXADDTAX1	☐	J_1IEXADDTAX1	WERT7	CURR	13	2	Additional Tax1 value
78	EXADDTAX2	☐	J_1IEXADDTAX2	WERT7	CURR	13	2	Additional Tax2 value
79	EXADDTAX3	☐	J_1IEXADDTAX3	WERT7	CURR	13	2	Additional Tax3 value
80	BELNR	☐	J_1IFAWREF	AWREF	CHAR	10	0	Accounting Document
81	GJAHR	☐	J_1IFAYEAR	NUMC4	NUMC	4	0	Financial posting year

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1IEXCHDR	BUKRS	T001	BUKRS
2	J_1IEXCHDR	EXCUR	TCURC	WAERS
3	J_1IEXCHDR	EXGRP	J_1IEXGRPS	J_1IEXCGRP
4	J_1IEXCHDR	GSBER	TGSB	GSBER
5	J_1IEXCHDR	KUNAG	KNA1	KUNNR
6	J_1IEXCHDR	KUNWE	KNA1	KUNNR
7	J_1IEXCHDR	LIFNR	LFA1	LIFNR
8	J_1IEXCHDR	MANDT	T000	MANDT
9	J_1IEXCHDR	RCWRK	T001W	WERKS
10	J_1IEXCHDR	REJ_CODE	J_1IREJMAS	REJ_CODE
11	J_1IEXCHDR	SRGRP	J_1ISRGRPS	J_1ISERGRP
12	J_1IEXCHDR	TRNTYP	J_1ITRAN	J_1ITRNTYP
13	J_1IEXCHDR	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in