SAP Table J_1IEXCHDR
Excise invoice header detail
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_1IEXCHDR (Excise invoice header detail) is a standard table in SAP ERP. It belongs to the package J1I2.
Technical Information
| Table | J_1IEXCHDR |
| Short Text | Excise invoice header detail |
| Package | J1I2 |
| Table Type | Transparent Table |
Fields for Table J_1IEXCHDR
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| TRNTYP | ✔ | Excise Transaction Type | J_1ITRNTYP | CHAR | 4 | J_1ITRAN |
| DOCYR | ✔ | Year | J_1IDOCUYR | NUMC | 4 | |
| DOCNO | ✔ | Internal Excise Document Number | J_1IDOCNO | NUMC | 10 | |
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | |
| WERKS | Plant | WERKS_D | CHAR | 4 | T001W | |
| EXGRP | Excise Group | J_1IEXCGRP | CHAR | 2 | J_1IEXGRPS | |
| SRGRP | Excise Document Series Group | J_1ISERGRP | CHAR | 3 | J_1ISRGRPS | |
| STRTYP | Sub Transaction Type | J_1ISTRTYP | CHAR | 2 | ||
| EXNUM | Official Excise Document Number | J_1IEXCNUM | CHAR | 10 | ||
| EXDAT | Excise Document Date | J_1IEXCDAT | DATS | 8 | ||
| EXYEAR | Excise Year | J_1IEXYEAR | NUMC | 4 | ||
| REMTIME | Time of Removal | J_1IREMTIM | TIMS | 6 | ||
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | |
| SHIPFROM | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | * | |
| RCWRK | Receiving/Issuing Plant | UMWRK | CHAR | 4 | T001W | |
| EXCUR | Currency | J_1IEXCCUR | CUKY | 5 | TCURC | |
| EXBED | Basic Excise Duty | J_1IEXCBED | CURR | 13 | ||
| EXSED | Special Excise Duty | J_1IEXCSED | CURR | 13 | ||
| EXAED | Additional Excise Duty | J_1IEXCAED | CURR | 13 | ||
| CESS | Cess amount | J_1IEXCESS | CURR | 13 | ||
| REFDOC | Internal reference document | J_1IINTREF | CHAR | 10 | ||
| RDOC | Reference Document 1 | J_1IRDOC1 | CHAR | 10 | ||
| RYEAR | Reference year 1 | J_1IRYEAR1 | CHAR | 4 | ||
| RIND | Reference Document Type 1 | J_1IRIND1 | CHAR | 1 | ||
| KUNAG | Sold-to party | KUNAG | CHAR | 10 | KNA1 | |
| KUNWE | Ship-to party | KUNWE | CHAR | 10 | KNA1 | |
| GSBER | Business Area | GSBER | CHAR | 4 | TGSB | |
| EXCCD | ECC Number | J_1IEXCD | CHAR | 40 | ||
| EXCRN | Excise Registration Number | J_1IEXRN | CHAR | 40 | ||
| EXCRG | Excise Range | J_1IEXRG | CHAR | 60 | ||
| EXCDI | Excise Division | J_1IEXDI | CHAR | 60 | ||
| EXCCO | Excise Commissionerate | J_1IEXCO | CHAR | 60 | ||
| CSTNO | Central Sales Tax Number | J_1ICSTNO | CHAR | 40 | ||
| LSTNO | Local Sales Tax Number | J_1ILSTNO | CHAR | 40 | ||
| PANNO | Permanent Account Number | J_1IPANNO | CHAR | 40 | ||
| PREPRN | Preprinted Serial Number | J_1IPREPRN | CHAR | 10 | ||
| RTDAT | Return Date | J_1IRTDAT | DATS | 8 | ||
| CVDIND | CVD indication | J_1ICVDIND | CHAR | 1 | ||
| EXPIND | Export Type | J_1IINDEXP | CHAR | 1 | ||
| STATUS | Excise Document Status | J_1ISTATUS | CHAR | 1 | ||
| CENSTAT | CENVAT Utilization status | J_1ICENST | CHAR | 1 | ||
| REJ_CODE | Rejection Code | J_1IREJCODE | CHAR | 3 | J_1IREJMAS | |
| MRPIND | Maximum Retail Price | J_1IMRPIND | 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 | ||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | ||
| AEDAT | Changed On | AEDAT | DATS | 8 | ||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | ||
| ADDLDATA1 | Additional Data | J_1IADDATA | CHAR | 60 | ||
| ADDLDATA2 | Additional Data | J_1IADDATA | CHAR | 60 | ||
| ADDLDATA3 | Additional Data | J_1IADDATA | CHAR | 60 | ||
| ADDLDATA4 | Additional Data | J_1IADDATA | CHAR | 60 | ||
| ADDLVAL | Additional Value | J_1IADDVAL | CURR | 17 | ||
| RULES | Rule/Section | J_2IRULE | CHAR | 10 | * | |
| TCODE | Transaction code | J_1ITCODE | CHAR | 20 | * | |
| REJ_ACC_DOCNO | Accounting Document | J_1IFAWREF | CHAR | 10 | ||
| REJ_ACC_DOCTYP | Object type of calling application (FI) | J_1IFAWTYP | CHAR | 5 | * | |
| REJ_ACC_YEAR | Financial posting year | J_1IFAYEAR | NUMC | 4 | ||
| PRECUSDAT | Arrived at Customs | J_1IPRECUSDAT | DATS | 8 | ||
| ACKCUSDAT | Countersigned | J_1IACKCUSDAT | DATS | 8 | ||
| RECPTDAT | Arrived Back | J_1IRECPTDAT | DATS | 8 | ||
| EXCSUBDAT | Sent to Excise Department | J_1IEXCSUBDAT | DATS | 8 | ||
| POEXPDAT | Export Confirmed | J_1IPOEXPDAT | DATS | 8 | ||
| AMENDIND | Exc Bonding: Amendment Indicator | CHAR | 1 | |||
| BONDNO | Internal Bond Number | J_1IBONDNO | NUMC | 10 | ||
| BONDYR | Fiscal Year | J_1IBONDYR | NUMC | 4 | ||
| BOAMTBAL | Bond Balance | J_1IBOCURBAL | CURR | 13 | ||
| AMENDED_BALANCE | BED After Amendment | J_1IAMD_BAL | CURR | 13 | ||
| AMENDED_ON | Exc Bonding: Date of Amendment | J_1IAMD_DAT | DATS | 8 | ||
| EXC_ADDRESS_NO | Address | J_1IEDADDR_NO | NUMC | 3 | ||
| CUS_ADDRESS_NO | Address | J_1IEDADDR_NO | NUMC | 3 | ||
| INTEREST_VALUE | Interest Amount | J_1IINTVAL | CURR | 13 | ||
| NCCD | NCCD Value | J_1IEXNCCD | CURR | 13 | ||
| ECS | ECS Value | J_1IEXECS | CURR | 13 | ||
| EXADDTAX1 | Additional Tax1 value | J_1IEXADDTAX1 | CURR | 13 | ||
| EXADDTAX2 | Additional Tax2 value | J_1IEXADDTAX2 | CURR | 13 | ||
| EXADDTAX3 | Additional Tax3 value | J_1IEXADDTAX3 | CURR | 13 | ||
| BELNR | Accounting Document | J_1IFAWREF | CHAR | 10 | ||
| GJAHR | Financial posting year | J_1IFAYEAR | NUMC | 4 |