J_1IEXGRPS SAP (Excise Groups) Table details
Dictionary Type: Table
Description: Excise Groups
Description: Excise Groups
Table field list including key, data, relationships and ABAP select examples
J_1IEXGRPS is a standard SAP Table which is used to store Excise Groups data and is available within R/3 SAP systems depending on the version and release level.
The J_1IEXGRPS table consists of various fields, each holding specific information or linking keys about Excise Groups data available in SAP. These include J_1IEXCGRP (Excise Group), J_1IWERKS (Plant), J_1IGRPDES (Excise Group Description), J_1IREGID (Excise Registration).. 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: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP J_1IEXGRPS 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 |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| J_1IEXCGRP | Excise Group | J_1IEXCGRP | CHAR | 2 | Assigned to domain | J_1IEXCGRP | J2I | ||
| J_1IWERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| J_1IGRPDES | Excise Group Description | J_1IGRPDES | CHAR | 60 | CHAR60 | ||||
| J_1IREGID | Excise Registration | J_1IREGID | NUMC | 3 | Assigned to domain | J_1IREGID | |||
| J_1IDEPOT | Depot | J_1IDEPOT | CHAR | 1 | XFELD | ||||
| J_1IGRXREF | Number of Goods Receipts per Excise Invoice | J_1IGREX | CHAR | 1 | J_1IXREF | ||||
| J_1IEICBATCH | Create Excise Invoice Automatically | J_1IEICBATCH | CHAR | 1 | XFELD | ||||
| J_1IPART1IND | Part1 creation time indicator | J_1IPART1IND | CHAR | 1 | J_1IPART1INDC | ||||
| J_1IRG23DOPT | Automatically Verify and Post EIs for Depot Sales | J_1IRG23DSOPT | CHAR | 1 | XFELD | ||||
| J_1IDEFQTY | Copy Excise Invoice Quantity to Goods Receipt | J_1IDEFQTY | CHAR | 1 | XFELD | ||||
| J_1IFOLIO | Generate Folio Numbers | J_1IFOLIO | CHAR | 1 | XFELD | ||||
| J_1IOTMVMTS | Automatic Posting for J1IS | J_1IOTMVMTS | CHAR | 1 | XFELD | ||||
| J_1IBLOCK | Create Part I Entry For Blocked Stock | J_1IBLOCK | CHAR | 1 | XFELD | ||||
| J_1ISTO | Create Part I Entry For Stock Transport Order | J_1ISTO | CHAR | 1 | XFELD | ||||
| J_1ICON | Create Part I Entry for Direct Consumption | J_1ICON | CHAR | 1 | XFELD | ||||
| J_1IMIGO_CAPTURE | Capture Excise Invoice in MIGO | J_1IMIGO_CAPTURE | CHAR | 1 | XFELD | ||||
| J_1IMIGO_POST | Post Excise Invoice Captured in MIGO | J_1IMIGO_POST | CHAR | 1 | XFELD | ||||
| J_1IMIGO_CREATE | Create Excise Invoice or RG23D Selection in MIGO | J_1IMIGO_CREATE | CHAR | 1 | XFELD | ||||
| EXC_ADDRESS_NO | Address | J_1IEDADDR_NO | NUMC | 3 | NUM3 | ||||
| J_1IMIGO_RG1 | Update RG1 at MIGO | J_1IMIGO_RG1 | CHAR | 1 | XFELD | ||||
| J_1IMIGO_DIF | Post Incoming Excise Invoice at MIGO if duties are changed | J_1IMIGO_DIF | CHAR | 1 | XFELD |
| Key field | Non-key field |
How do I retrieve data from SAP table J_1IEXGRPS using ABAP code
The following ABAP code Example will allow you to do a basic selection on J_1IEXGRPS to SELECT all data from the tableDATA: WA_J_1IEXGRPS TYPE J_1IEXGRPS.
SELECT SINGLE *
FROM J_1IEXGRPS
INTO CORRESPONDING FIELDS OF WA_J_1IEXGRPS
WHERE...
How to access SAP table J_1IEXGRPS
Within an ECC or HANA version of SAP you can also view further information about J_1IEXGRPS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects