SAP ABAP Table J_1IQRDEP (Quarterly Returns Depot structure)

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_1IQRDEP	Table Relationship Diagram
Short Description	Quarterly Returns Depot structure

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	DOCNO	☑	J_1IDOCNO	J_1IDOCNO	NUMC	10	0	Internal Excise Document Number	*
2	DOCYR	☑	J_1IDOCYR	GJAHR	NUMC	4	0	Excise year
3	ZEILE	☑	J_1IZEILE	J_1IZEILE	NUMC	4	0	Item Number
4	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	*
5	FOLIO	☑	J_1ISRLNO1	NUMC10	NUMC	10	0	Register Entry Serial Number
6	SERIALNO	☑	MBLPO	MBLPO	NUMC	4	0	Item in material document
7	EXNUM	☐	J_1IEXCNUM	J_1IEXCNUM	CHAR	10	0	Official Excise Document Number
8	EXDAT	☐			CHAR	10	0
9	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
10	ADDR1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
11	ADDR2	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
12	ADDR3	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
13	ADDR4	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
14	EXCCD	☐	J_1IEXCD	CHAR40	CHAR	40	0	ECC Number
15	EXCRN	☐	J_1IEXRN	CHAR40	CHAR	40	0	Excise Registration Number
16	EXCRG	☐	J_1IEXRG	CHAR60	CHAR	60	0	Excise Range
17	EXCDI	☐	J_1IEXDI	CHAR60	CHAR	60	0	Excise Division
18	EXCCO	☐	J_1IEXCO	CHAR60	CHAR	60	0	Excise Commissionerate
19	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
20	MENGE	☐	J_1IEXMENGE	MENG13	QUAN	13	3	Excise Invoice Quantity
21	CHAPID	☐	J_1ICHID	CHAR12	CHAR	12	0	Chapter ID
22	CURR	☐	J_1IEXCCUR	WAERS	CUKY	5	0	Currency	*
23	EXBED	☐	J_1IEXCBED	WERT7	CURR	13	2	Basic Excise Duty
24	EXAED	☐	J_1IEXCSED	WERT7	CURR	13	2	Special Excise Duty
25	EXSED	☐	J_1IEXCAED	WERT7	CURR	13	2	Additional Excise Duty
26	CESS	☐	J_1IEXCESS	WERT7	CURR	13	2	Cess amount
27	BEDRATE	☐	J_1IBEDRAT	PRZ34	DEC	7	4	BED percentage
28	SEDRATE	☐	J_1ISEDRAT	PRZ34	DEC	7	4	Special Excise Duty %
29	AEDRATE	☐	J_1IAEDRAT	PRZ34	DEC	7	4	Additional Excise Duty %
30	CESSRATE	☐	J_1ICESS	PRZ23	DEC	5	3	Cess percentage
31	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
32	PDATE	☐	WADAT_IST	DATUM	DATS	8	0	Actual Goods Movement Date
33	NAME1B	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
34	ORT01B	☐	ORT01_GP	TEXT35	CHAR	35	0	City
35	PSTLZB	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
36	S_EXNUM	☐	J_1IEXCNUM	J_1IEXCNUM	CHAR	10	0	Official Excise Document Number
37	S_EXDAT	☐	J_1IEXCDAT	J_1IEXCDAT	DATS	8	0	Excise Document Date
38	S_MENGE	☐	J_1IMENGE	MENG13	QUAN	13	3	Quantity mentioned in the excise invoice
39	S_EXCCD	☐	J_1IEXCD	CHAR40	CHAR	40	0	ECC Number
40	S_EXCRN	☐	J_1IEXRN	CHAR40	CHAR	40	0	Excise Registration Number
41	S_EXCRG	☐	J_1IEXRG	CHAR60	CHAR	60	0	Excise Range
42	S_EXCDI	☐	J_1IEXDI	CHAR60	CHAR	60	0	Excise Division
43	S_EXCCO	☐	J_1IEXCO	CHAR60	CHAR	60	0	Excise Commissionerate
44	TOT_AMTDUTY	☐	J_1IEXCBED	WERT7	CURR	13	2	Basic Excise Duty
45	SNO	☐			NUMC	4	0
46	REMARKS	☐	J_2IRULE	J_2IRULE	CHAR	10	0	Rule/Section	*
47	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
48	NCCD	☐	J_1IEXCNCCD	WERT7	CURR	13	2	National Calamity Contingency Duty
49	ECS	☐	J_1IEXECS	WERT7	CURR	13	2	ECS Value
50	EXADDTAX1	☐	J_1IEXADDTAX1	WERT7	CURR	13	2	Additional Tax1 value
51	EXADDTAX2	☐	J_1IEXADDTAX2	WERT7	CURR	13	2	Additional Tax2 value
52	EXADDTAX3	☐	J_1IEXADDTAX3	WERT7	CURR	13	2	Additional Tax3 value
53	NCCDRATE	☐	J_1INCCDRAT	PRZ34	DEC	7	4	NCCD Rate in %
54	ECSRATE	☐	J_1IECSRAT	PRZ34	DEC	7	4	ECS rate in %
55	EXADDRATE1	☐	J_1IEXADDRAT1	PRZ34	DEC	7	4	AT1 rate in %
56	EXADDRATE2	☐	J_1IEXADDRAT2	PRZ34	DEC	7	4	AT2 rate in %
57	EXADDRATE3	☐	J_1IEXADDRAT3	PRZ34	DEC	7	4	AT3 rate in %
58	J_1IREGID	☐	J_1IREGID	J_1IREGID	NUMC	3	0	Excise Registration	*
59	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
60	QUARTER	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
61	NIL_RETURN	☐	J_1ISERGRP	J_1ISERGRP	CHAR	3	0	Excise Document Series Group	*

History

Last changed by/on	SAP	20130529
SAP Release Created in	606