SAP ABAP Table J_1IRG1 (Excise RG1 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_1IRG1	Table Relationship Diagram
Short Description	Excise RG1 details

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	T000
2	EXGRP	☑	J_1IEXCGRP	J_1IEXCGRP	CHAR	2	0	Excise Group	J_1IEXGRPS
3	SYEAR	☑	J_1IYEAR	NUMC4	NUMC	4	0	Year of Register Entry
4	SERIALNO	☑	J_1ISRLNO	NUMC10	NUMC	10	0	RG1 serial number
5	CHAPID	☐	J_1ICHID	CHAR12	CHAR	12	0	Chapter ID
6	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
7	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
8	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
9	RULES	☐	J_2IRULE	J_2IRULE	CHAR	10	0	Rule/Section	*
10	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
11	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
12	MATFORM	☐	J_2IMATFRM	J_2IMATFRM	CHAR	1	0	Material packaging form: Packed, Loose
13	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
14	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
15	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
16	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
17	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
18	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
19	LGORTIND	☐	J_2ISLINDI	J_2ISLINDI	CHAR	1	0	Storage location type indicator
20	RISIND	☐	J_1IRISIND	J_1IRISIND	CHAR	1	0	Goods Movement Direction
21	RCPTISSRSN	☐	J_2IRIIND	J_2IRIIND	CHAR	3	0	Rcpt/Issu classification codes
22	DOWNL	☐	J_1IDOWNL	XFELD	CHAR	1	0	Download indicator
23	DECLRD	☐	J_1IDECLRD	CHAR1	CHAR	1	0	Item declared for Excise
24	EXPIND	☐	J_1IINDEXP	J_1IINDEXP	CHAR	1	0	Export Type
25	REASON	☐	J_1IREASON	CHAR40	CHAR	40	0	reason for movement
26	REMARKS	☐	J_2IREMARK	J_2IREMARK	CHAR	45	0	Remarks containing RG1 prod.ser.no or excise inv. ranges
27	RDOC1	☐	J_1IRDOC1	CHAR10	CHAR	10	0	Reference Document 1
28	RYEAR1	☐	J_1IRYEAR1	CHAR4	CHAR	4	0	Reference year 1
29	RIND1	☐	J_1IRIND1	J_1IRIND	CHAR	1	0	Reference Document Type 1
30	BEDRATE	☐	J_1IBEDRAT	PRZ34	DEC	7	4	BED percentage
31	AEDRATE	☐	J_1IAEDRAT	PRZ34	DEC	7	4	Additional Excise Duty %
32	SEDRATE	☐	J_1ISEDRAT	PRZ34	DEC	7	4	Special Excise Duty %
33	EXCUR	☐	J_1IEXCCUR	WAERS	CUKY	5	0	Currency	TCURC
34	EXBAS	☐	J_1IEXCBAS	WERT7	CURR	13	2	Excise Duty Base Amount
35	EXBED	☐	J_1IEXCBED	WERT7	CURR	13	2	Basic Excise Duty
36	EXAED	☐	J_1IEXCAED	WERT7	CURR	13	2	Additional Excise Duty
37	EXSED	☐	J_1IEXCSED	WERT7	CURR	13	2	Special Excise Duty
38	CESS	☐	J_1IEXCESS	WERT7	CURR	13	2	Cess amount
39	STATUS	☐	J_1IRGSTAT	J_1IRGSTAT	CHAR	1	0	Register Entry Status
40	USNAM	☐	J_1IUSNAM	CHAR12	CHAR	12	0	Created By
41	CPUDT	☐	J_1ICPUDT	DATUM	DATS	8	0	Excise Document Entry Date
42	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
43	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
44	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
45	NCCDRATE	☐	J_1INCCDRAT	PRZ34	DEC	7	4	NCCD Rate in %
46	NCCD	☐	J_1IEXNCCD	WERT7	CURR	13	2	NCCD Value
47	ECSRATE	☐	J_1IECSRAT	PRZ34	DEC	7	4	ECS rate in %
48	ECS	☐	J_1IEXECS	WERT7	CURR	13	2	ECS Value
49	EXADDRATE1	☐	J_1IEXADDRAT1	PRZ34	DEC	7	4	AT1 rate in %
50	EXADDTAX1	☐	J_1IEXADDTAX1	WERT7	CURR	13	2	Additional Tax1 value
51	EXADDRATE2	☐	J_1IEXADDRAT2	PRZ34	DEC	7	4	AT2 rate in %
52	EXADDTAX2	☐	J_1IEXADDTAX2	WERT7	CURR	13	2	Additional Tax2 value
53	EXADDRATE3	☐	J_1IEXADDRAT3	PRZ34	DEC	7	4	AT3 rate in %
54	EXADDTAX3	☐	J_1IEXADDTAX3	WERT7	CURR	13	2	Additional Tax3 value

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1IRG1	BWART	T156	BWART
2	J_1IRG1	EXCUR	TCURC	WAERS
3	J_1IRG1	EXGRP	J_1IEXGRPS	J_1IEXCGRP
4	J_1IRG1	MANDT	T000	MANDT
5	J_1IRG1	MATNR	MARA	MATNR
6	J_1IRG1	MEINS	T006	MSEHI

History

Last changed by/on	SAP	20130529
SAP Release Created in