J_1IQRDEP SAP (Quarterly Returns Depot structure) Table details

Dictionary Type: Table
Description: Quarterly Returns Depot structure




ABAP Code to SELECT data from J_1IQRDEP
Related tables to J_1IQRDEP
Access table J_1IQRDEP




Table field list including key, data, relationships and ABAP select examples

J_1IQRDEP is a standard SAP Table which is used to store Quarterly Returns Depot structure data and is available within R/3 SAP systems depending on the version and release level.

The J_1IQRDEP table consists of various fields, each holding specific information or linking keys about Quarterly Returns Depot structure data available in SAP. These include DOCYR (Excise year), ZEILE (Item Number), WERKS (Plant), FOLIO (Register Entry Serial Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP J_1IQRDEP table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
DOCNOInternal Excise Document Number J_1IDOCNONUMC10Assigned to domainJ_1IDOCNOJ2G
DOCYRExcise year J_1IDOCYRNUMC4GJAHRGJAHR
ZEILEItem Number J_1IZEILENUMC4J_1IZEILE
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
FOLIORegister Entry Serial Number J_1ISRLNO1NUMC10NUMC10
SERIALNOItem in Material Document MBLPONUMC4MBLPOPOS
EXNUMOfficial Excise Document Number J_1IEXCNUMCHAR10J_1IEXCNUMJ2F
EXDAT Date0
NAME1Name 1 AD_NAME1CHAR40TEXT40
ADDR1Street 2 AD_STRSPP1CHAR40TEXT40
ADDR2Street 2 AD_STRSPP1CHAR40TEXT40
ADDR3Street 2 AD_STRSPP1CHAR40TEXT40
ADDR4Street 2 AD_STRSPP1CHAR40TEXT40
EXCCDECC Number J_1IEXCDCHAR40CHAR40
EXCRNExcise Registration Number J_1IEXRNCHAR40CHAR40
EXCRGExcise Range J_1IEXRGCHAR60CHAR60
EXCDIExcise Division J_1IEXDICHAR60CHAR60
EXCCOExcise Commissionerate J_1IEXCOCHAR60CHAR60
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
MENGEExcise Invoice Quantity J_1IEXMENGEQUAN13(3) MENG13
CHAPIDChapter ID J_1ICHIDCHAR12CHAR12
CURRCurrency J_1IEXCCURCUKY5Assigned to domainWAERS
EXBEDBasic Excise Duty J_1IEXCBEDCURR13(2) WERT7
EXAEDSpecial Excise Duty J_1IEXCSEDCURR13(2) WERT7
EXSEDAdditional Excise Duty J_1IEXCAEDCURR13(2) WERT7
CESSCess amount J_1IEXCESSCURR13(2) WERT7
BEDRATEBED percentage J_1IBEDRATDEC7(4) PRZ34
SEDRATESpecial Excise Duty % J_1ISEDRATDEC7(4) PRZ34
AEDRATEAdditional Excise Duty % J_1IAEDRATDEC7(4) PRZ34
CESSRATECess percentage J_1ICESSDEC5(3) PRZ23
VBELNDelivery VBELN_VLCHAR10Assigned to domainALPHAVBELNVL
PDATEActual Goods Movement Date WADAT_ISTDATS8DATUMWDTI
NAME1BName 1 NAME1_GPCHAR35NAME
ORT01BCity ORT01_GPCHAR35TEXT35
PSTLZBPostal Code PSTLZCHAR10PSTLZ
S_EXNUMOfficial Excise Document Number J_1IEXCNUMCHAR10J_1IEXCNUMJ2F
S_EXDATExcise Document Date J_1IEXCDATDATS8J_1IEXCDAT
S_MENGEQuantity mentioned in the excise invoice J_1IMENGEQUAN13(3) MENG13
S_EXCCDECC Number J_1IEXCDCHAR40CHAR40
S_EXCRNExcise Registration Number J_1IEXRNCHAR40CHAR40
S_EXCRGExcise Range J_1IEXRGCHAR60CHAR60
S_EXCDIExcise Division J_1IEXDICHAR60CHAR60
S_EXCCOExcise Commissionerate J_1IEXCOCHAR60CHAR60
TOT_AMTDUTYBasic Excise Duty J_1IEXCBEDCURR13(2) WERT7
SNO Serial Number0
REMARKSRule/Section J_2IRULECHAR10Assigned to domainJ_2IRULE
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
NCCDNational Calamity Contingency Duty J_1IEXCNCCDCURR13(2) WERT7
ECSECS Value J_1IEXECSCURR13(2) WERT7
EXADDTAX1Additional Tax1 value J_1IEXADDTAX1CURR13(2) WERT7
EXADDTAX2Additional Tax2 value J_1IEXADDTAX2CURR13(2) WERT7
EXADDTAX3Additional Tax3 value J_1IEXADDTAX3CURR13(2) WERT7
NCCDRATENCCD Rate in % J_1INCCDRATDEC7(4) PRZ34
ECSRATEECS rate in % J_1IECSRATDEC7(4) PRZ34
EXADDRATE1AT1 rate in % J_1IEXADDRAT1DEC7(4) PRZ34
EXADDRATE2AT2 rate in % J_1IEXADDRAT2DEC7(4) PRZ34
EXADDRATE3AT3 rate in % J_1IEXADDRAT3DEC7(4) PRZ34
J_1IREGIDExcise Registration J_1IREGIDNUMC3Assigned to domainJ_1IREGID
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
QUARTERName of Company Code or Company BUTXTCHAR25TEXT25
NIL_RETURNExcise Document Series Group J_1ISERGRPCHAR3Assigned to domainJ_1ISERGRPJ2H

Key field Non-key field



How do I retrieve data from SAP table J_1IQRDEP using ABAP code

The following ABAP code Example will allow you to do a basic selection on J_1IQRDEP to SELECT all data from the table
DATA: WA_J_1IQRDEP TYPE J_1IQRDEP.

SELECT SINGLE *
FROM J_1IQRDEP
INTO CORRESPONDING FIELDS OF WA_J_1IQRDEP
WHERE...

How to access SAP table J_1IQRDEP

Within an ECC or HANA version of SAP you can also view further information about J_1IQRDEP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!