1. SAP Tutorial
  2. FI Module

J_1IEXGRPS SAP table for – Excise Groups

Here we would like to draw your attention to J_1IEXGRPS 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_1IEXGRPS is a SAP standard transp table used for storing Excise Groups related data in SAP. It comes under the package J1I2.

SAP J_1IEXGRPS table

Table J_1IEXGRPS technical data

TableJ_1IEXGRPS
Data storingExcise Groups
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ1I2
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_APPL
Table CategoryTRANSP

SAP J_1IEXGRPS 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_1IEXGRPS table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • J_1IEXCGRP : Excise Group
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • J_1IWERKS : Plant
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • J_1IGRPDES : Excise Group Description
    Its data type is CHAR (Character String) with field length 60
  • J_1IREGID : Excise Registration
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • J_1IDEPOT : Depot
    Its data type is CHAR (Character String) with field length 1
  • J_1IGRXREF : Number of Goods Receipts per Excise Invoice
    Its data type is CHAR (Character String) with field length 1
  • J_1IEICBATCH : Create Excise Invoice Automatically
    Its data type is CHAR (Character String) with field length 1
  • J_1IPART1IND : Part1 creation time indicator
    Its data type is CHAR (Character String) with field length 1
  • J_1IRG23DOPT : Automatically Verify and Post EIs for Depot Sales
    Its data type is CHAR (Character String) with field length 1
  • J_1IDEFQTY : Copy Excise Invoice Quantity to Goods Receipt
    Its data type is CHAR (Character String) with field length 1
  • J_1IFOLIO : Generate Folio Numbers
    Its data type is CHAR (Character String) with field length 1
  • J_1IOTMVMTS : Automatic Posting for J1IS
    Its data type is CHAR (Character String) with field length 1
  • J_1IBLOCK : Create Part I Entry For Blocked Stock
    Its data type is CHAR (Character String) with field length 1
  • J_1ISTO : Create Part I Entry For Stock Transport Order
    Its data type is CHAR (Character String) with field length 1
  • J_1ICON : Create Part I Entry for Direct Consumption
    Its data type is CHAR (Character String) with field length 1
  • J_1IMIGO_CAPTURE : Capture Excise Invoice in MIGO
    Its data type is CHAR (Character String) with field length 1
  • J_1IMIGO_POST : Post Excise Invoice Captured in MIGO
    Its data type is CHAR (Character String) with field length 1
  • J_1IMIGO_CREATE : Create Excise Invoice or RG23D Selection in MIGO
    Its data type is CHAR (Character String) with field length 1
  • EXC_ADDRESS_NO : Address
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • J_1IMIGO_RG1 : Update RG1 at MIGO
    Its data type is CHAR (Character String) with field length 1
  • J_1IMIGO_DIF : Post Incoming Excise Invoice at MIGO if duties are changed
    Its data type is CHAR (Character String) with field length 1

    • J_1IEXGRPS related tables

    • J_1ITRAN : Transaction code
    • J_1IGAR7 : Recordings of GAR7
    • J_1IT059A : Indicator to mention tax exemption
    • J_1ISERCATMM1 : Cust table to determine the Service Category on MM – Level1
    • J_1IITMDTL : Item Details – for Capital goods and subcontracting
    • J_1ICALOC : Allocation of materials to assets
    • J_1ISERCATMMFI3 : Table to determine the Service Category on MM-FI – Level3
    • J_1ISERCATMMFI2 : Table to determine the Service Category on MM-FI – Level2
    • J_1ITCJCUPDATE : Updatation table for open documents
    • J_1ISERCATSDFI4 : Customization table to determine the Service Category Level4
    • J_1IEXCDEF : Tax default informations
    • J_1ISERCATMMFI4 : Table to determine the Service Category on MM-FI – Level4
    • J_1I_INBDELV : INBOUND DELIVERY DETAILS FROM sus
    • J_1ITRNACC : Transaction code vs accounts
    • J_1I_WTH_SER_GTA : Table to determine withholding line for GTA
    • J_1I_BCKEXCSUS : Customizing table for background capture of Exc Invoice-SUS
    • J_1IMVMT : Movement types versus register relevance
    • J_1IEXESTA : Excise indicator determination for co / cust / form code
    • J_1IPART2 : Excise Part II details
    • J_1IREJAPPL : Rejection code for Applications

    J_1IEXGRPS related transaction codes under SAP package J1I2

    • J1I0 : Customizing wizard
    • S_AL0_96000116 : IMG activity: J_1IEXCREF
    • S_AL0_96000105 : IMG activity: J_1IEXCDEF
    • J1ISAL : Sales Register – India
    • S_AL0_96000174 : IMG activity: J_1ITDSSEC
    • J1I2 : Sales Tax Register
    • J1IV : Excise post & print for others mvmts
    • J1I5 : Register creation for RG23 and RG1
    • J1IH : Create Excise JV
    • S_AL0_96000122 : IMG activity: J_1IVFRTYP
    • S_AL0_96000119 : IMG activity: J_1IJ1I9
    • J1IO : Retrospective price amendments
    • S_AL0_96000099 : IMG activity: J_1IREGSET
    • S_EBS_44000483 : Program J_1IER1
    • J1ICANCINV : Cancel Invoice
    • J1I6 : Modvat forecast
    • S_AL0_96000120 : IMG activity: J_1IVTTXID
    • J1IG : RG23D register receipt at depot
    • J1IST : Service Category Maintenance
    • J1IK : Selection of Excise Invoice – Common

    Related References

    Related Tutorials

    J_1IREGSET SAP table for – Excise Registrations

    J_1IREGSET table in SAP FI (Localization in FI) module. This table is used for storing data of Excise Registrations. See...

    S_AL0_96000102 SAP tcode for – IMG activity: J_1IEXGRPS

    S_AL0_96000102 tcode in SAP FI (Localization in FI) module. This transaction code is used for IMG activity: J_1IEXGRPS. See the...

    J_1IEXCDEP SAP table for – Excise information of vendor at detail level for depot

    J_1IEXCDEP table in SAP FI (Localization in FI) module. This table is used for storing data of Excise information of...

    J_1IEXESTA SAP table for – Excise indicator determination for co / cust / form code

    J_1IEXESTA table in SAP FI (Localization in FI) module. This table is used for storing data of Excise indicator determination...

    J_1IEXSRDET SAP table for – Excise / Series group determination

    J_1IEXSRDET table in SAP FI (Localization in FI) module. This table is used for storing data of Excise / Series...

    J_1ISRGRPS SAP table for – Excise Document Series

    J_1ISRGRPS table in SAP FI (Localization in FI) module. This table is used for storing data of Excise Document Series....

    J_1IASSVAL SAP table for – Assessable value table for excise calculation

    J_1IASSVAL table in SAP FI (Localization in FI) module. This table is used for storing data of Assessable value table...

    «
    »