SAP ABAP Table J_1IEXCDTL (Excise invoice line item details)

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_1IEXCDTL	Table Relationship Diagram
Short Description	Excise invoice line item details

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	J_1IEXCHDR
5	ZEILE	☑	J_1IZEILE	J_1IZEILE	NUMC	4	0	Item Number
6	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
7	EXNUM	☐	J_1IEXCNUM	J_1IEXCNUM	CHAR	10	0	Official Excise Document Number
8	EXDAT	☐	J_1IEXCDAT	J_1IEXCDAT	DATS	8	0	Excise Document Date
9	EXYEAR	☐	J_1IEXYEAR	GJAHR	NUMC	4	0	Excise Year
10	EXGRP	☐	J_1IEXCGRP	J_1IEXCGRP	CHAR	2	0	Excise Group	*
11	LIFNR	☐	J_1ILIFNR	J_1ILIFNR	CHAR	10	0	Vendor
12	SHIPFROM	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
13	RCWRK	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	T001W
14	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
15	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
16	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
17	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
18	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
19	CHAPID	☐	J_1ICHID	CHAR12	CHAR	12	0	Chapter ID
20	MENGE	☐	J_1IMENGE	MENG13	QUAN	13	3	Quantity mentioned in the excise invoice
21	MENGA	☐	J_1IMENGA	MENG13	QUAN	13	3	Quantity of Goods Received
22	CREDIT_QTY	☐	J_1IMENGC	MENG13	QUAN	13	3	Quantity on Which CENVAT Credit Is Taken
23	MENGR	☐	J_1IMENGR	MENG13	QUAN	13	3	Quantity remaining in the depot
24	SCPGN	☐	J_1ISCPGN	MENG13	QUAN	13	3	Quantity of Scrap generated
25	MEINS	☐	J_1IMEINS	MEINS	UNIT	3	0	Unit of Measure	T006
26	MENGR_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
27	EXCUR	☐	J_1IEXCCUR	WAERS	CUKY	5	0	Currency	TCURC
28	EXBAS	☐	J_1IEXCBAS	WERT7	CURR	13	2	Excise Duty Base Amount
29	EXBED	☐	J_1IEXCBED	WERT7	CURR	13	2	Basic Excise Duty
30	EXSED	☐	J_1IEXCSED	WERT7	CURR	13	2	Special Excise Duty
31	EXAED	☐	J_1IEXCAED	WERT7	CURR	13	2	Additional Excise Duty
32	CESS	☐	J_1IEXCESS	WERT7	CURR	13	2	Cess amount
33	BEDINV	☐	J_1IBEDINV	WERT7	CURR	13	2	Inventorized BED
34	AEDINV	☐	J_1IAEDINV	WERT7	CURR	13	2	Inventorized AED
35	SEDINV	☐	J_1ISEDINV	WERT7	CURR	13	2	Inventorized SED
36	ADDBED	☐	J_1IADDBED	WERT7	CURR	13	2	Additional BED
37	ADDSED	☐	J_1IADDSED	WERT7	CURR	13	2	Additional SED
38	ADDAED	☐	J_1IADDAED	WERT7	CURR	13	2	Additional AED
39	INDTAX	☐	J_1INDTAX	WERT7	CURR	13	2	Non-deductible tax value
40	PART2YR	☐	J_1IYEAR	NUMC4	NUMC	4	0	Year of Register Entry
41	RG23ASER	☐	J_1I23ASER	NUMC10	NUMC	10	0	RG23A serial no.
42	RG23CSER	☐	J_1I23CSER	NUMC10	NUMC	10	0	RG23C serial no.
43	RGPLASER	☐	J_1IPLASER	NUMC10	NUMC	10	0	PLA serial no.
44	PART1YR	☐	J_1IYEAR	NUMC4	NUMC	4	0	Year of Register Entry
45	PART1SER	☐	J_1ISRLNO1	NUMC10	NUMC	10	0	Register Entry Serial Number
46	RDOC1	☐	J_1IRDOC1	CHAR10	CHAR	10	0	Reference Document 1
47	RYEAR1	☐	J_1IRYEAR1	CHAR4	CHAR	4	0	Reference year 1
48	RITEM1	☐	J_1IRITEM1	NUMC6	NUMC	6	0	Reference Item 1
49	RIND1	☐	J_1IRIND1	J_1IRIND	CHAR	1	0	Reference Document Type 1
50	RDOC2	☐	J_1IRDOC2	CHAR10	CHAR	10	0	Reference Document 2
51	RYEAR2	☐	J_1IRYEAR2	CHAR4	CHAR	4	0	Reference year 2
52	RITEM2	☐	J_1IRITEM2	NUMC6	NUMC	6	0	Reference Item 2
53	RIND2	☐	J_1IRIND2	J_1IRIND	CHAR	1	0	Reference Document Type 2
54	RDOC3	☐	J_1IRDOC3	CHAR40	CHAR	40	0	Reference Document 3
55	RIND3	☐	J_1IRIND3	J_1IRIND	CHAR	1	0	Reference document type 3
56	STATUS	☐	J_1ISTATUS	J_1ISTATUS	CHAR	1	0	Excise Document Status
57	BEDRATE	☐	J_1IBEDRAT	PRZ34	DEC	7	4	BED percentage
58	AEDRATE	☐	J_1IAEDRAT	PRZ34	DEC	7	4	Additional Excise Duty %
59	SEDRATE	☐	J_1ISEDRAT	PRZ34	DEC	7	4	Special Excise Duty %
60	CESSRATE	☐	J_1ICESS	PRZ23	DEC	5	3	Cess percentage
61	CAPIND	☐	J_1ICAPIND	J_1ICAPIND	CHAR	1	0	Material Type
62	MRPIND	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
63	REJ_CODE	☐	J_1IREJCODE	CHAR3	CHAR	3	0	Rejection Code	J_1IREJMAS
64	USNAM	☐	J_1IUSNAM	CHAR12	CHAR	12	0	Created By
65	CPUDT	☐	J_1ICPUDT	DATUM	DATS	8	0	Excise Document Entry Date
66	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
67	AENAM	☐	J_1IUSNAMC	CHAR12	CHAR	12	0	Changed by the user
68	AEDAT	☐	J_1IAEDAT	J_1IAEDAT	DATS	8	0	Changed on date
69	ADDLDATA1	☐	J_1IADDATA	CHAR60	CHAR	60	0	Additional Data
70	ADDLDATA2	☐	J_1IADDATA	CHAR60	CHAR	60	0	Additional Data
71	ADDLDATA3	☐	J_1IADDATA	CHAR60	CHAR	60	0	Additional Data
72	ADDLDATA4	☐	J_1IADDATA	CHAR60	CHAR	60	0	Additional Data
73	ADDLVAL1	☐	J_1IADDVAL	WERT9	CURR	17	2	Additional Value
74	ADDLVAL2	☐	J_1IADDVAL	WERT9	CURR	17	2	Additional Value
75	NUM_OF_PKGS	☐	J_1INUM_OF_PKG	J_1ICHAR10LOW	CHAR	10	0	Number of Packages
76	DESC_PKG	☐	J_1IDESC_PKG	CHAR30LOW	CHAR	30	0	Package Description
77	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
78	BRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
79	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
80	MRK_PKG	☐	J_1IMRK_PKG	CHAR30LOW	CHAR	30	0	Marks on Package
81	NOS_ON_PKG	☐	J_1INOS_ON_PKG	CHAR30LOW	CHAR	30	0	Numbers on Package
82	LICYR	☐	J_1ILICYR	GJAHR	NUMC	4	0	License Year
83	LICNO	☐	J_1ILICNO	J_1ILICNO	NUMC	10	0	Internal License Number
84	LICZEILE	☐	J_1IZEILE	J_1IZEILE	NUMC	4	0	Item Number
85	NCCD	☐	J_1IEXNCCD	WERT7	CURR	13	2	NCCD Value
86	NCCDINV	☐	J_1INCCDINV	WERT7	CURR	13	2	NCCD Inventory Component
87	NCCDRATE	☐	J_1INCCDRAT	PRZ34	DEC	7	4	NCCD Rate in %
88	ADDNCCD	☐	J_1IADDNCCD	WERT7	CURR	13	2	Additional NCCD
89	ECS	☐	J_1IEXECS	WERT7	CURR	13	2	ECS Value
90	ECSINV	☐	J_1IECSINV	WERT7	CURR	13	2	ECS Inventory component
91	ECSRATE	☐	J_1IECSRAT	PRZ34	DEC	7	4	ECS rate in %
92	EXADDTAX1	☐	J_1IEXADDTAX1	WERT7	CURR	13	2	Additional Tax1 value
93	EXADDINV1	☐	J_1IEXADDINV1	WERT7	CURR	13	2	Inventorized AT1
94	EXADDRATE1	☐	J_1IEXADDRAT1	PRZ34	DEC	7	4	AT1 rate in %
95	ADDAT1	☐	J_1IADDAT1	WERT7	CURR	13	2	Additional AT1
96	EXADDTAX2	☐	J_1IEXADDTAX2	WERT7	CURR	13	2	Additional Tax2 value
97	EXADDINV2	☐	J_1IEXADDINV2	WERT7	CURR	13	2	Inventorized AT2
98	EXADDRATE2	☐	J_1IEXADDRAT2	PRZ34	DEC	7	4	AT2 rate in %
99	ADDAT2	☐	J_1IADDAT2	WERT7	CURR	13	2	Additional AT2
100	EXADDTAX3	☐	J_1IEXADDTAX3	WERT7	CURR	13	2	Additional Tax3 value
101	EXADDINV3	☐	J_1IEXADDINV3	WERT7	CURR	13	2	Inventorized AT3
102	EXADDRATE3	☐	J_1IEXADDRAT3	PRZ34	DEC	7	4	AT3 rate in %
103	ADDAT3	☐	J_1IADDAT3	WERT7	CURR	13	2	Additional AT3
104	SERTAXSERNO	☐	J_1ISERTAXNO	NUMC10	NUMC	10	0	Service Tax Serial Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1IEXCDTL	DOCNO	J_1IEXCHDR	DOCNO
2	J_1IEXCDTL	EXCUR	TCURC	WAERS
3	J_1IEXCDTL	GSBER	TGSB	GSBER
4	J_1IEXCDTL	LGORT	T001L	LGORT
5	J_1IEXCDTL	MANDT	T000	MANDT
6	J_1IEXCDTL	MATNR	MARA	MATNR
7	J_1IEXCDTL	MEINS	T006	MSEHI
8	J_1IEXCDTL	MENGR_UOM	T006	MSEHI
9	J_1IEXCDTL	RCWRK	T001W	WERKS
10	J_1IEXCDTL	REJ_CODE	J_1IREJMAS	REJ_CODE
11	J_1IEXCDTL	TRNTYP	J_1ITRAN	J_1ITRNTYP
12	J_1IEXCDTL	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in