SAP ABAP Table J_1IRG23D (RG23D register for the depot)

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_1IRG23D	Table Relationship Diagram
Short Description	RG23D register for the depot

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_1IDOCYR1	NUMC4	NUMC	4	0	Document year - GR for depot
4	DOCNO	☑	J_1IDOCNO1	J_1IDOCNO	NUMC	10	0	Internal number - GR for delivery at depot	J_1IEXCHDR
5	ZEILE	☑	J_1IZEILE1	NUMC4	NUMC	4	0	Item number - GR at depot
6	VBELN	☑	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
7	POSNR	☑	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
8	MBLNR	☑	MBLNR	BELNR	CHAR	10	0	Number of Material Document
9	MJAHR	☑	MJAHR	GJAHR	NUMC	4	0	Year of material document
10	MZEILE	☑	MBLPO	MBLPO	NUMC	4	0	Item in material document
11	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
12	FOLIO	☑	J_1ISRLNO1	NUMC10	NUMC	10	0	Register Entry Serial Number
13	SERIALNO	☑	MBLPO	MBLPO	NUMC	4	0	Item in material document
14	EXGRP	☐	J_1IEXCGRP	J_1IEXCGRP	CHAR	2	0	Excise Group	*
15	EXNUM	☐	J_1IEXCNUM	J_1IEXCNUM	CHAR	10	0	Official Excise Document Number
16	EXYEAR	☐	J_1IEXYEAR	GJAHR	NUMC	4	0	Excise Year
17	SRGRP	☐	J_1ISERGRP	J_1ISERGRP	CHAR	3	0	Excise Document Series Group	*
18	DEPEXNUM	☐	J_1IEXCNUM	J_1IEXCNUM	CHAR	10	0	Official Excise Document Number
19	DEPEXYEAR	☐	J_1IEXYEAR	GJAHR	NUMC	4	0	Excise Year
20	REMTIME	☐	J_1IREMTIM	UZEIT	TIMS	6	0	Time of Removal
21	LIFNR	☐	J_1ILIFNR	J_1ILIFNR	CHAR	10	0	Vendor
22	SHIPFROM	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
23	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
24	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
25	CHAPID	☐	J_1ICHID	CHAR12	CHAR	12	0	Chapter ID
26	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
27	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
28	EXCUR	☐	J_1IEXCCUR	WAERS	CUKY	5	0	Currency	TCURC
29	EXBAS	☐	J_1IEXCBAS	WERT7	CURR	13	2	Excise Duty Base Amount
30	EXBED	☐	J_1IEXCBED	WERT7	CURR	13	2	Basic Excise Duty
31	EXSED	☐	J_1IEXCSED	WERT7	CURR	13	2	Special Excise Duty
32	EXAED	☐	J_1IEXCAED	WERT7	CURR	13	2	Additional Excise Duty
33	CESS	☐	J_1IEXCESS	WERT7	CURR	13	2	Cess amount
34	BEDRAT	☐	J_1IBEDRAT	PRZ34	DEC	7	4	BED percentage
35	AEDRAT	☐	J_1IAEDRAT	PRZ34	DEC	7	4	Additional Excise Duty %
36	SEDRAT	☐	J_1ISEDRAT	PRZ34	DEC	7	4	Special Excise Duty %
37	CESSRATE	☐	J_1ICESS	PRZ23	DEC	5	3	Cess percentage
38	RG23ASER	☐	J_1I23ASER	NUMC10	NUMC	10	0	RG23A serial no.
39	RG23CSER	☐	J_1I23CSER	NUMC10	NUMC	10	0	RG23C serial no.
40	RGPLASER	☐	J_1IPLASER	NUMC10	NUMC	10	0	PLA serial no.
41	RDOC	☐	J_1IRDOC1	CHAR10	CHAR	10	0	Reference Document 1
42	RDATE	☐	J_1IBUDAT	DATUM	DATS	8	0	Posting date in the reference document
43	DOWNL	☐	J_1IDOWNL	XFELD	CHAR	1	0	Download indicator
44	STATUS	☐	J_1ISTATUS	J_1ISTATUS	CHAR	1	0	Excise Document Status
45	REF_FOLIO	☐	J_1ISRLNO1	NUMC10	NUMC	10	0	Register Entry Serial Number
46	REF_SERIAL	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
47	USNAM	☐	J_1IUSNAM	CHAR12	CHAR	12	0	Created By
48	CPUDT	☐	J_1ICPUDT	DATUM	DATS	8	0	Excise Document Entry Date
49	NCCDRATE	☐	J_1INCCDRAT	PRZ34	DEC	7	4	NCCD Rate in %
50	NCCD	☐	J_1IEXNCCD	WERT7	CURR	13	2	NCCD Value
51	ECSRATE	☐	J_1IECSRAT	PRZ34	DEC	7	4	ECS rate in %
52	ECS	☐	J_1IEXECS	WERT7	CURR	13	2	ECS Value
53	EXADDTAX1	☐	J_1IEXADDTAX1	WERT7	CURR	13	2	Additional Tax1 value
54	EXADDRATE1	☐	J_1IEXADDRAT1	PRZ34	DEC	7	4	AT1 rate in %
55	EXADDTAX2	☐	J_1IEXADDTAX2	WERT7	CURR	13	2	Additional Tax2 value
56	EXADDRATE2	☐	J_1IEXADDRAT2	PRZ34	DEC	7	4	AT2 rate in %
57	EXADDTAX3	☐	J_1IEXADDTAX3	WERT7	CURR	13	2	Additional Tax3 value
58	EXADDRATE3	☐	J_1IEXADDRAT3	PRZ34	DEC	7	4	AT3 rate in %

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1IRG23D	DOCNO	J_1IEXCHDR	DOCNO
2	J_1IRG23D	EXCUR	TCURC	WAERS
3	J_1IRG23D	MANDT	T000	MANDT
4	J_1IRG23D	MATNR	MARA	MATNR
5	J_1IRG23D	MEINS	T006	MSEHI
6	J_1IRG23D	POSNR	VBUP	POSNR
7	J_1IRG23D	TRNTYP	J_1ITRAN	J_1ITRNTYP
8	J_1IRG23D	VBELN	VBUK	VBELN
9	J_1IRG23D	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in