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
Here is some free PDF files that you can download free for your reference.
Download Now
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
| Field | Note | Data Element | Domain |
|---|---|---|---|
| DOCNO | Internal Excise Document Number | J_1IDOCNO | J_1IDOCNO |
| DOCYR | Excise year | J_1IDOCYR | GJAHR |
| ZEILE | Item Number | J_1IZEILE | J_1IZEILE |
| WERKS | Plant | WERKS_D | WERKS |
| FOLIO | Register Entry Serial Number | J_1ISRLNO1 | NUMC10 |
| SERIALNO | Item in material document | MBLPO | MBLPO |
| EXNUM | Official Excise Document Number | J_1IEXCNUM | J_1IEXCNUM |
| EXDAT | |||
| NAME1 | Name 1 | AD_NAME1 | TEXT40 |
| ADDR1 | Street 2 | AD_STRSPP1 | TEXT40 |
| ADDR2 | Street 2 | AD_STRSPP1 | TEXT40 |
| ADDR3 | Street 2 | AD_STRSPP1 | TEXT40 |
| ADDR4 | Street 2 | AD_STRSPP1 | TEXT40 |
| EXCCD | ECC Number | J_1IEXCD | CHAR40 |
| EXCRN | Excise Registration Number | J_1IEXRN | CHAR40 |
| EXCRG | Excise Range | J_1IEXRG | CHAR60 |
| EXCDI | Excise Division | J_1IEXDI | CHAR60 |
| EXCCO | Excise Commissionerate | J_1IEXCO | CHAR60 |
| MAKTX | Material description | MAKTX | TEXT40 |
| MENGE | Excise Invoice Quantity | J_1IEXMENGE | MENG13 |
| CHAPID | Chapter ID | J_1ICHID | CHAR12 |
| CURR | Currency | J_1IEXCCUR | WAERS |
| EXBED | Basic Excise Duty | J_1IEXCBED | WERT7 |
| EXAED | Special Excise Duty | J_1IEXCSED | WERT7 |
| EXSED | Additional Excise Duty | J_1IEXCAED | WERT7 |
| CESS | Cess amount | J_1IEXCESS | WERT7 |
| BEDRATE | BED percentage | J_1IBEDRAT | PRZ34 |
| SEDRATE | Special Excise Duty % | J_1ISEDRAT | PRZ34 |
| AEDRATE | Additional Excise Duty % | J_1IAEDRAT | PRZ34 |
| CESSRATE | Cess percentage | J_1ICESS | PRZ23 |
| VBELN | Delivery | VBELN_VL | VBELN |
| PDATE | Actual Goods Movement Date | WADAT_IST | DATUM |
| NAME1B | Name 1 | NAME1_GP | NAME |
| ORT01B | City | ORT01_GP | TEXT35 |
| PSTLZB | Postal Code | PSTLZ | PSTLZ |
| S_EXNUM | Official Excise Document Number | J_1IEXCNUM | J_1IEXCNUM |
| S_EXDAT | Excise Document Date | J_1IEXCDAT | J_1IEXCDAT |
| S_MENGE | Quantity mentioned in the excise invoice | J_1IMENGE | MENG13 |
| S_EXCCD | ECC Number | J_1IEXCD | CHAR40 |
| S_EXCRN | Excise Registration Number | J_1IEXRN | CHAR40 |
| S_EXCRG | Excise Range | J_1IEXRG | CHAR60 |
| S_EXCDI | Excise Division | J_1IEXDI | CHAR60 |
| S_EXCCO | Excise Commissionerate | J_1IEXCO | CHAR60 |
| TOT_AMTDUTY | Basic Excise Duty | J_1IEXCBED | WERT7 |
| SNO | |||
| REMARKS | Rule/Section | J_2IRULE | J_2IRULE |
| MBLNR | Number of Material Document | MBLNR | BELNR |
| NCCD | National Calamity Contingency Duty | J_1IEXCNCCD | WERT7 |
| ECS | ECS Value | J_1IEXECS | WERT7 |
| EXADDTAX1 | Additional Tax1 value | J_1IEXADDTAX1 | WERT7 |
| EXADDTAX2 | Additional Tax2 value | J_1IEXADDTAX2 | WERT7 |
| EXADDTAX3 | Additional Tax3 value | J_1IEXADDTAX3 | WERT7 |
| NCCDRATE | NCCD Rate in % | J_1INCCDRAT | PRZ34 |
| ECSRATE | ECS rate in % | J_1IECSRAT | PRZ34 |
| EXADDRATE1 | AT1 rate in % | J_1IEXADDRAT1 | PRZ34 |
| EXADDRATE2 | AT2 rate in % | J_1IEXADDRAT2 | PRZ34 |
| EXADDRATE3 | AT3 rate in % | J_1IEXADDRAT3 | PRZ34 |
| J_1IREGID | Excise Registration | J_1IREGID | J_1IREGID |
| MEINS | Base Unit of Measure | MEINS | MEINS |
| QUARTER | Name of Company Code or Company | BUTXT | TEXT25 |
| NIL_RETURN | Excise Document Series Group | J_1ISERGRP | J_1ISERGRP |
J_1IQRDEP related tables
| Table | Note |
|---|---|
| J_1IQRDEP | Quarterly Returns Depot structure |
| J_1IEWT_ACKN | Acknowledgement numbers for quarterly returns filed |
| J_1IEWT_ACKN_N | Acknowledgement numbers for quarterly returns filed |
| J_1IEXCDEP | Excise information of vendor at detail level for depot |
| J_1IRG23D | RG23D register for the depot |
| TZWR0 | Valuation in cross-depot |
| /IWFND/SU_XMLDEP | XML Depot |
| DFKKRPE | Returns lot: Error message for returns item |
| MSR_C_RET_REASON | Multi-step returns - Returns reason |
| MSR_C_RET_REASOT | Multi-step returns - Returns reason text |
| MSR_C_RET_REFUNT | Multi-step returns - Returns refund text |
| MSR_I_STEP | Multi-step returns - atomic unit of a returns |
| TFK045E | Returns Activities (Returns Lot) |
| ADCNTRYQU | Countries with active quarterly adjustment |
| ADQUINDX | INDX-type table for quarterly adjustment addresses |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP