SAP Table J_1IRG1
Excise RG1 details
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table J_1IRG1 (Excise RG1 details) is a standard table in SAP ERP. It belongs to the package J1I2.
Technical Information
| Table | J_1IRG1 |
| Short Text | Excise RG1 details |
| Package | J1I2 |
| Table Type | Transparent Table |
Fields for Table J_1IRG1
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| EXGRP | ✔ | Excise Group | J_1IEXCGRP | CHAR | 2 | J_1IEXGRPS |
| SYEAR | ✔ | Year of Register Entry | J_1IYEAR | NUMC | 4 | |
| SERIALNO | ✔ | RG1 serial number | J_1ISRLNO | NUMC | 10 | |
| CHAPID | Chapter ID | J_1ICHID | CHAR | 12 | ||
| MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ||
| MJAHR | Material Document Year | MJAHR | NUMC | 4 | ||
| ZEILE | Item in Material Document | MBLPO | NUMC | 4 | ||
| RULES | Rule/Section | J_2IRULE | CHAR | 10 | * | |
| BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | T156 | |
| MATNR | Material Number | MATNR | CHAR | 18 | MARA | |
| MATFORM | Material packaging form: Packed, Loose | J_2IMATFRM | CHAR | 1 | ||
| MENGE | Quantity | MENGE_D | QUAN | 13 | ||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | |
| MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | ||
| WERKS | Plant | WERKS_D | CHAR | 4 | * | |
| LGORT | Storage Location | LGORT_D | CHAR | 4 | * | |
| CHARG | Batch Number | CHARG_D | CHAR | 10 | * | |
| LGORTIND | Storage location type indicator | J_2ISLINDI | CHAR | 1 | ||
| RISIND | Goods Movement Direction | J_1IRISIND | CHAR | 1 | ||
| RCPTISSRSN | Rcpt/Issu classification codes | J_2IRIIND | CHAR | 3 | ||
| DOWNL | Download indicator | J_1IDOWNL | CHAR | 1 | ||
| DECLRD | Item declared for Excise | J_1IDECLRD | CHAR | 1 | ||
| EXPIND | Export Type | J_1IINDEXP | CHAR | 1 | ||
| REASON | reason for movement | J_1IREASON | CHAR | 40 | ||
| REMARKS | Remarks containing RG1 prod.ser.no or excise inv. ranges | J_2IREMARK | CHAR | 45 | ||
| RDOC1 | Reference Document 1 | J_1IRDOC1 | CHAR | 10 | ||
| RYEAR1 | Reference year 1 | J_1IRYEAR1 | CHAR | 4 | ||
| RIND1 | Reference Document Type 1 | J_1IRIND1 | CHAR | 1 | ||
| BEDRATE | BED percentage | J_1IBEDRAT | DEC | 7 | ||
| AEDRATE | Additional Excise Duty % | J_1IAEDRAT | DEC | 7 | ||
| SEDRATE | Special Excise Duty % | J_1ISEDRAT | DEC | 7 | ||
| EXCUR | Currency | J_1IEXCCUR | CUKY | 5 | TCURC | |
| EXBAS | Excise Duty Base Amount | J_1IEXCBAS | CURR | 13 | ||
| EXBED | Basic Excise Duty | J_1IEXCBED | CURR | 13 | ||
| EXAED | Additional Excise Duty | J_1IEXCAED | CURR | 13 | ||
| EXSED | Special Excise Duty | J_1IEXCSED | CURR | 13 | ||
| CESS | Cess amount | J_1IEXCESS | CURR | 13 | ||
| STATUS | Register Entry Status | J_1IRGSTAT | CHAR | 1 | ||
| USNAM | Created By | J_1IUSNAM | CHAR | 12 | ||
| CPUDT | Excise Document Entry Date | J_1ICPUDT | DATS | 8 | ||
| CPUTM | Time of Entry | CPUTM | TIMS | 6 | ||
| AEDAT | Changed On | AEDAT | DATS | 8 | ||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | ||
| NCCDRATE | NCCD Rate in % | J_1INCCDRAT | DEC | 7 | ||
| NCCD | NCCD Value | J_1IEXNCCD | CURR | 13 | ||
| ECSRATE | ECS rate in % | J_1IECSRAT | DEC | 7 | ||
| ECS | ECS Value | J_1IEXECS | CURR | 13 | ||
| EXADDRATE1 | AT1 rate in % | J_1IEXADDRAT1 | DEC | 7 | ||
| EXADDTAX1 | Additional Tax1 value | J_1IEXADDTAX1 | CURR | 13 | ||
| EXADDRATE2 | AT2 rate in % | J_1IEXADDRAT2 | DEC | 7 | ||
| EXADDTAX2 | Additional Tax2 value | J_1IEXADDTAX2 | CURR | 13 | ||
| EXADDRATE3 | AT3 rate in % | J_1IEXADDRAT3 | DEC | 7 | ||
| EXADDTAX3 | Additional Tax3 value | J_1IEXADDTAX3 | CURR | 13 |