SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

J_1IQRDEP Table in SAP: Quarterly Returns Depot structure

J_1IQRDEP is a SAP table coming under FI module and SAP_APPL component.View details, Fields & related tables of J_1IQRDEP in SAP.

  • Table description : Quarterly Returns Depot structure
  • Module : FI-LOC
  • Parent Module : FI
  • Package : J1I2
  • Software Component : SAP_APPL
J_1IQRDEP table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP J_1IQRDEP Table Fields structure

FieldNoteData ElementDomain
DOCNOInternal Excise Document NumberJ_1IDOCNOJ_1IDOCNO
DOCYRExcise yearJ_1IDOCYRGJAHR
ZEILEItem NumberJ_1IZEILEJ_1IZEILE
WERKSPlantWERKS_DWERKS
FOLIORegister Entry Serial NumberJ_1ISRLNO1NUMC10
SERIALNOItem in material documentMBLPOMBLPO
EXNUMOfficial Excise Document NumberJ_1IEXCNUMJ_1IEXCNUM
EXDAT   
NAME1Name 1AD_NAME1TEXT40
ADDR1Street 2AD_STRSPP1TEXT40
ADDR2Street 2AD_STRSPP1TEXT40
ADDR3Street 2AD_STRSPP1TEXT40
ADDR4Street 2AD_STRSPP1TEXT40
EXCCDECC NumberJ_1IEXCDCHAR40
EXCRNExcise Registration NumberJ_1IEXRNCHAR40
EXCRGExcise RangeJ_1IEXRGCHAR60
EXCDIExcise DivisionJ_1IEXDICHAR60
EXCCOExcise CommissionerateJ_1IEXCOCHAR60
MAKTXMaterial descriptionMAKTXTEXT40
MENGEExcise Invoice QuantityJ_1IEXMENGEMENG13
CHAPIDChapter IDJ_1ICHIDCHAR12
CURRCurrencyJ_1IEXCCURWAERS
EXBEDBasic Excise DutyJ_1IEXCBEDWERT7
EXAEDSpecial Excise DutyJ_1IEXCSEDWERT7
EXSEDAdditional Excise DutyJ_1IEXCAEDWERT7
CESSCess amountJ_1IEXCESSWERT7
BEDRATEBED percentageJ_1IBEDRATPRZ34
SEDRATESpecial Excise Duty %J_1ISEDRATPRZ34
AEDRATEAdditional Excise Duty %J_1IAEDRATPRZ34
CESSRATECess percentageJ_1ICESSPRZ23
VBELNDeliveryVBELN_VLVBELN
PDATEActual Goods Movement DateWADAT_ISTDATUM
NAME1BName 1NAME1_GPNAME
ORT01BCityORT01_GPTEXT35
PSTLZBPostal CodePSTLZPSTLZ
S_EXNUMOfficial Excise Document NumberJ_1IEXCNUMJ_1IEXCNUM
S_EXDATExcise Document DateJ_1IEXCDATJ_1IEXCDAT
S_MENGEQuantity mentioned in the excise invoiceJ_1IMENGEMENG13
S_EXCCDECC NumberJ_1IEXCDCHAR40
S_EXCRNExcise Registration NumberJ_1IEXRNCHAR40
S_EXCRGExcise RangeJ_1IEXRGCHAR60
S_EXCDIExcise DivisionJ_1IEXDICHAR60
S_EXCCOExcise CommissionerateJ_1IEXCOCHAR60
TOT_AMTDUTYBasic Excise DutyJ_1IEXCBEDWERT7
SNO   
REMARKSRule/SectionJ_2IRULEJ_2IRULE
MBLNRNumber of Material DocumentMBLNRBELNR
NCCDNational Calamity Contingency DutyJ_1IEXCNCCDWERT7
ECSECS ValueJ_1IEXECSWERT7
EXADDTAX1Additional Tax1 valueJ_1IEXADDTAX1WERT7
EXADDTAX2Additional Tax2 valueJ_1IEXADDTAX2WERT7
EXADDTAX3Additional Tax3 valueJ_1IEXADDTAX3WERT7
NCCDRATENCCD Rate in %J_1INCCDRATPRZ34
ECSRATEECS rate in %J_1IECSRATPRZ34
EXADDRATE1AT1 rate in %J_1IEXADDRAT1PRZ34
EXADDRATE2AT2 rate in %J_1IEXADDRAT2PRZ34
EXADDRATE3AT3 rate in %J_1IEXADDRAT3PRZ34
J_1IREGIDExcise RegistrationJ_1IREGIDJ_1IREGID
MEINSBase Unit of MeasureMEINSMEINS
QUARTERName of Company Code or CompanyBUTXTTEXT25
NIL_RETURNExcise Document Series GroupJ_1ISERGRPJ_1ISERGRP

J_1IQRDEP related tables

TableNote
J_1IQRDEPQuarterly Returns Depot structure
J_1IEWT_ACKNAcknowledgement numbers for quarterly returns filed
J_1IEWT_ACKN_NAcknowledgement numbers for quarterly returns filed
J_1IEXCDEPExcise information of vendor at detail level for depot
J_1IRG23DRG23D register for the depot
TZWR0Valuation in cross-depot
/IWFND/SU_XMLDEPXML Depot
DFKKRPEReturns lot: Error message for returns item
MSR_C_RET_REASONMulti-step returns - Returns reason
MSR_C_RET_REASOTMulti-step returns - Returns reason text
MSR_C_RET_REFUNTMulti-step returns - Returns refund text
MSR_I_STEPMulti-step returns - atomic unit of a returns
TFK045EReturns Activities (Returns Lot)
ADCNTRYQUCountries with active quarterly adjustment
ADQUINDXINDX-type table for quarterly adjustment addresses

Related tcodes for J_1IQRDEP

Transaction codes in the same SAP package (J1I2) as the J_1IQRDEP table.

TcodeDescription
J1I0Customizing wizard
J1I2Sales Tax Register
J1I3Modvat utilzation in batch
J1I5Register creation for RG23 and RG1
J1I6Modvat forecast
J1I7Query Excise invoices
J1I8TDS Challan Update
J1I9Number ranges for excise invoice
J1IAExcise Invoice Details
J1IBExcise Verification And Posting
J1IDRate maint & amend open po's/so's
J1IFSubcontracting
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2026 sapstack.com