SAP ABAP Table J_1IQEXCISE (Quantity based AED, NCCD and SED)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ J1ICIN30A (Package) Development class for cin30a

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_1IQEXCISE	Table Relationship Diagram
Short Description	Quantity based AED, NCCD and SED

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	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	*
3	CHAPID	☑	J_1ICHID	CHAR12	CHAR	12	0	Chapter ID
4	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	*
5	VALIDFROM	☑	J_1ITXDATF	DATUM_INV	CHAR	8	0	Date from which the tax rule is valid
6	VALIDTO	☐	J_1ITXDATT	DATUM_INV	CHAR	8	0	Date to which the tax rule is valid
7	AED_AMOUNT	☐	J_1IEXCAMT	WERT7	CURR	13	2	Excise Duty Rate
8	AED_KONWA	☐	KONWA	WAERS	CUKY	5	0	Rate unit (currency or percentage)	*
9	AED_KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
10	AED_KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
11	SED_AMOUNT	☐	J_1IEXCAMT	WERT7	CURR	13	2	Excise Duty Rate
12	SED_KONWA	☐	KONWA	WAERS	CUKY	5	0	Rate unit (currency or percentage)	*
13	SED_KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
14	SED_KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
15	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
16	USNAM	☐	J_1IUSNAM	CHAR12	CHAR	12	0	Created By
17	NCCD_AMOUNT	☐	J_1IEXCAMT	WERT7	CURR	13	2	Excise Duty Rate
18	NCCD_KONWA	☐	KONWA	WAERS	CUKY	5	0	Rate unit (currency or percentage)	*
19	NCCD_KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
20	NCCD_KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
21	AT1_AMOUNT	☐	J_1IEXCAMT	WERT7	CURR	13	2	Excise Duty Rate
22	AT1_KONWA	☐	KONWA	WAERS	CUKY	5	0	Rate unit (currency or percentage)	*
23	AT1_KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
24	AT1_KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
25	AT2_AMOUNT	☐	J_1IEXCAMT	WERT7	CURR	13	2	Excise Duty Rate
26	AT2_KONWA	☐	KONWA	WAERS	CUKY	5	0	Rate unit (currency or percentage)	*
27	AT2_KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
28	AT2_KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
29	AT3_AMOUNT	☐	J_1IEXCAMT	WERT7	CURR	13	2	Excise Duty Rate
30	AT3_KONWA	☐	KONWA	WAERS	CUKY	5	0	Rate unit (currency or percentage)	*
31	AT3_KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
32	AT3_KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	*

History

Last changed by/on	SAP	20110901
SAP Release Created in