1. SAP Tutorial
  2. FI Module

J_1IRG1 SAP table for – Excise RG1 details

Here we would like to draw your attention to J_1IRG1 table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). J_1IRG1 is a SAP standard transp table used for storing Excise RG1 details related data in SAP. It comes under the package J1I2.

SAP J_1IRG1 table

Table J_1IRG1 technical data

TableJ_1IRG1
Data storingExcise RG1 details
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ1I2
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_APPL
Table CategoryTRANSP

SAP J_1IRG1 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in J_1IRG1 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • EXGRP : Excise Group
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • SYEAR : Year of Register Entry
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • SERIALNO : RG1 serial number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • CHAPID : Chapter ID
    Its data type is CHAR (Character String) with field length 12
  • MBLNR : Number of Material Document
    Its data type is CHAR (Character String) with field length 10
  • MJAHR : Year of material document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ZEILE : Item in material document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • RULES : Rule/Section
    Its data type is CHAR (Character String) with field length 10
  • BWART : Movement type (inventory management)
    Its data type is CHAR (Character String) with field length 3
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • MATFORM : Material packaging form: Packed, Loose
    Its data type is CHAR (Character String) with field length 1
  • MENGE : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MAKTX : Material description
    Its data type is CHAR (Character String) with field length 40
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • LGORT : Storage location
    Its data type is CHAR (Character String) with field length 4
  • CHARG : Batch Number
    Its data type is CHAR (Character String) with field length 10
  • LGORTIND : Storage location type indicator
    Its data type is CHAR (Character String) with field length 1
  • RISIND : Goods Movement Direction
    Its data type is CHAR (Character String) with field length 1
  • RCPTISSRSN : Rcpt/Issu classification codes
    Its data type is CHAR (Character String) with field length 3
  • DOWNL : Download indicator
    Its data type is CHAR (Character String) with field length 1
  • DECLRD : Item declared for Excise
    Its data type is CHAR (Character String) with field length 1
  • EXPIND : Export Type
    Its data type is CHAR (Character String) with field length 1
  • REASON : reason for movement
    Its data type is CHAR (Character String) with field length 40
  • REMARKS : Remarks containing RG1 prod.ser.no or excise inv. ranges
    Its data type is CHAR (Character String) with field length 45
  • RDOC1 : Reference Document 1
    Its data type is CHAR (Character String) with field length 10
  • RYEAR1 : Reference year 1
    Its data type is CHAR (Character String) with field length 4
  • RIND1 : Reference Document Type 1
    Its data type is CHAR (Character String) with field length 1
  • BEDRATE : BED percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • AEDRATE : Additional Excise Duty %
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • SEDRATE : Special Excise Duty %
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • EXCUR : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • EXBAS : Excise Duty Base Amount
    Its data type is CURR (Currency Field) with field length 13
  • EXBED : Basic Excise Duty
    Its data type is CURR (Currency Field) with field length 13
  • EXAED : Additional Excise Duty
    Its data type is CURR (Currency Field) with field length 13
  • EXSED : Special Excise Duty
    Its data type is CURR (Currency Field) with field length 13
  • CESS : Cess amount
    Its data type is CURR (Currency Field) with field length 13
  • STATUS : Register Entry Status
    Its data type is CHAR (Character String) with field length 1
  • USNAM : Created By
    Its data type is CHAR (Character String) with field length 12
  • CPUDT : Excise Document Entry Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AEDAT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AENAM : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • NCCDRATE : NCCD Rate in %
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • NCCD : NCCD Value
    Its data type is CURR (Currency Field) with field length 13
  • ECSRATE : ECS rate in %
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • ECS : ECS Value
    Its data type is CURR (Currency Field) with field length 13
  • EXADDRATE1 : AT1 rate in %
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • EXADDTAX1 : Additional Tax1 value
    Its data type is CURR (Currency Field) with field length 13
  • EXADDRATE2 : AT2 rate in %
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • EXADDTAX2 : Additional Tax2 value
    Its data type is CURR (Currency Field) with field length 13
  • EXADDRATE3 : AT3 rate in %
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • EXADDTAX3 : Additional Tax3 value
    Its data type is CURR (Currency Field) with field length 13

    • J_1IRG1 related tables

    • J_1ISERCATSDFI3 : Customization table to determine the Service Category Level3
    • J_1ICUS_BILL_TYP : Assign Customer Category to Bill Type
    • J_1ITCJCMAP : Tax code and Jurisdiction code mapping
    • J_1IEXESTA : Excise indicator determination for co / cust / form code
    • J_1IEXGRPS : Excise Groups
    • J_1ISERCATMM2 : Cust table to determine the Service Category on MM – Level2
    • J_1ISTAPPL : Tax applicability
    • J_1IEXSRDET : Excise / Series group determination
    • J_1ISERCAT : Service tax category description table
    • J_1ISERCATMM : Service category determination for GTA and imports Invoices
    • J_1ISERCATMM5 : Cust table to determine the Service Category on MM – Level5
    • J_1ISERCATMMFI1 : Table to determine the Service Category on MM-FI – Level1
    • J_1ISERCATMMFI3 : Table to determine the Service Category on MM-FI – Level3
    • J_1ISERCATMM4 : Cust table to determine the Service Category on MM – Level4
    • J_1ISERCATSD3 : Service Category based on Material (L3)
    • J_1IEXCDEF : Tax default informations
    • J_1IEXCDEP : Excise information of vendor at detail level for depot
    • J_1IVATDATE : Maintain Valid from date of VAT legislation in India
    • J_1ISUBTYP : Subtransaction type text
    • A375 : Country/Sales org./Region/PlntRegion/TaxCl2Cust/TaxCl.2Mat

    J_1IRG1 related transaction codes under SAP package J1I2

    • J1IST : Service Category Maintenance
    • S_EBS_44000483 : Program J_1IER1
    • J1IR : Data Download
    • J1IF : Subcontracting
    • J1I2 : Sales Tax Register
    • J1I7 : Query Excise invoices
    • J1IPUR : Purchase Register – India
    • J1IC194J : Annual Return under section 194J
    • S_AL0_96000112 : IMG activity: J_1IREJMAS
    • J1IU : Forms capture
    • S_AL0_96000121 : IMG activity: J_1IMESG
    • J1IP : Excise invoice print
    • S_AL0_96000102 : IMG activity: J_1IEXGRPS
    • J1IH : Create Excise JV
    • S_EBS_44000097 : Report J_1I_ST3
    • J1I5 : Register creation for RG23 and RG1
    • J1IHBK : Copy House Bank ID from Invoice
    • J1I6 : Modvat forecast
    • S_AL0_96000116 : IMG activity: J_1IEXCREF
    • J1IME2W : Open Orders- PO & Scheduling Agrmnt

    Related References

    Related Tutorials

    J_1IEXCDTL SAP table for – Excise invoice line item details

    J_1IEXCDTL table in SAP FI (Localization in FI) module. This table is used for storing data of Excise invoice line...

    J_1IPART2 SAP table for – Excise Part II details

    J_1IPART2 table in SAP FI (Localization in FI) module. This table is used for storing data of Excise Part II...

    J_1IEXCTAX SAP table for – Tax calc. – Excise tax rates

    J_1IEXCTAX table in SAP FI (Localization in FI) module. This table is used for storing data of Tax calc. -...

    J_1IMATEXP SAP table for – Exceptional materials excise rates

    J_1IMATEXP table in SAP FI (Localization in FI) module. This table is used for storing data of Exceptional materials excise...

    J_1IADDEXC SAP table for – Additional Excise rate table

    J_1IADDEXC table in SAP FI (Localization in FI) module. This table is used for storing data of Additional Excise rate...

    J_1IGRXREF SAP table for – Goods Receipt to Excise Invoice Coss Reference

    J_1IGRXREF table in SAP FI (Localization in FI) module. This table is used for storing data of Goods Receipt to...

    J_1IEXCHDR SAP table for – Excise invoice header detail

    J_1IEXCHDR table in SAP FI (Localization in FI) module. This table is used for storing data of Excise invoice header...

    «
    »