J_1IEXHEAD SAP (Incoming Excise Invoice: CIN40A : Header Data) Structure details
Description: Incoming Excise Invoice: CIN40A : Header Data
Structure field list including key, data, relationships and ABAP select examples
J_1IEXHEAD is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Incoming Excise Invoice: CIN40A : Header Data" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_J_1IEXHEAD TYPE J_1IEXHEAD.
The J_1IEXHEAD table consists of various fields, each holding specific information or linking keys about Incoming Excise Invoice: CIN40A : Header Data data available in SAP. These include DOCYR (Year), DOCNO (Internal Excise Document Number), BUKRS (Company Code), WERKS (Plant).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP J_1IEXHEAD structure 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 |
TRNTYP | Excise Transaction Type | J_1ITRNTYP | CHAR | 4 | Assigned to domain | J_1ITRNTYP | |||
DOCYR | Year | J_1IDOCUYR | NUMC | 4 | J_1IDOCUYR | GJR | |||
DOCNO | Internal Excise Document Number | J_1IDOCNO | NUMC | 10 | Assigned to domain | J_1IDOCNO | J2G | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
EXGRP | Excise Group | J_1IEXCGRP | CHAR | 2 | Assigned to domain | J_1IEXCGRP | J2I | ||
SRGRP | Excise Document Series Group | J_1ISERGRP | CHAR | 3 | Assigned to domain | J_1ISERGRP | J2H | ||
STRTYP | Sub Transaction Type | J_1ISTRTYP | CHAR | 2 | CHAR2 | J_1ISUBTYP | |||
EXNUM | Official Excise Document Number | J_1IEXCNUM | CHAR | 10 | J_1IEXCNUM | J2F | |||
OLD_EXNUM | Official Excise Document Number | J_1IEXCNUM | CHAR | 10 | J_1IEXCNUM | J2F | |||
EXDAT | Excise Document Date | J_1IEXCDAT | DATS | 8 | J_1IEXCDAT | ||||
OLD_EXDAT | Excise Document Date | J_1IEXCDAT | DATS | 8 | J_1IEXCDAT | ||||
EXYEAR | Excise Year | J_1IEXYEAR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
REMTIME | Time of Removal | J_1IREMTIM | TIMS | 6 | UZEIT | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
OLD_LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
SHIPFROM | Ship-From Vendor | J_1IEXSHIPFROM | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
RCWRK | Receiving/Issuing Plant | UMWRK | CHAR | 4 | Assigned to domain | WERKS | |||
EXCUR | Currency | J_1IEXCCUR | CUKY | 5 | Assigned to domain | WAERS | |||
EXBED | Basic Excise Duty | J_1IEXCBED | CURR | 13(2) | WERT7 | ||||
EXSED | Special Excise Duty | J_1IEXCSED | CURR | 13(2) | WERT7 | ||||
EXAED | Additional Excise Duty | J_1IEXCAED | CURR | 13(2) | WERT7 | ||||
SALES_TAX | Non-deductible tax value | J_1INDTAX | CURR | 13(2) | WERT7 | ||||
OTHERS | Non-deductible tax value | J_1INDTAX | CURR | 13(2) | WERT7 | ||||
CESS | Cess amount | J_1IEXCESS | CURR | 13(2) | WERT7 | ||||
REFDOC | Internal reference document | J_1IINTREF | CHAR | 10 | CHAR10 | ||||
RDOC | Reference Document 1 | J_1IRDOC1 | CHAR | 10 | CHAR10 | ||||
RYEAR | Reference year 1 | J_1IRYEAR1 | CHAR | 4 | CHAR4 | ||||
RIND | Reference Document Type 1 | J_1IRIND1 | CHAR | 1 | J_1IRIND | ||||
KUNAG | Sold-to party | KUNAG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | VAG | |
KUNWE | Ship-to party | KUNWE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
EXCCD | ECC Number | J_1IEXCD | CHAR | 40 | CHAR40 | ||||
EXCRN | Excise Registration Number | J_1IEXRN | CHAR | 40 | CHAR40 | ||||
EXCRG | Excise Range | J_1IEXRG | CHAR | 60 | CHAR60 | ||||
EXCDI | Excise Division | J_1IEXDI | CHAR | 60 | CHAR60 | ||||
EXCCO | Excise Commissionerate | J_1IEXCO | CHAR | 60 | CHAR60 | ||||
CSTNO | Central Sales Tax Number | J_1ICSTNO | CHAR | 40 | CHAR40 | ||||
LSTNO | Local Sales Tax Number | J_1ILSTNO | CHAR | 40 | CHAR40 | ||||
PANNO | Permanent Account Number | J_1IPANNO | CHAR | 40 | CHAR40 | ||||
PREPRN | Preprinted Serial Number | J_1IPREPRN | CHAR | 10 | CHAR10 | ||||
RTDAT | Return Date | J_1IRTDAT | DATS | 8 | DATS | ||||
CVDIND | CVD indication | J_1ICVDIND | CHAR | 1 | CHAR1_X | ||||
EXPIND | Export Type | J_1IINDEXP | CHAR | 1 | J_1IINDEXP | ||||
STATUS | Excise Document Status | J_1ISTATUS | CHAR | 1 | J_1ISTATUS | ||||
CENSTAT | CENVAT Utilization status | J_1ICENST | CHAR | 1 | J_1ICENST | ||||
REJ_CODE | Rejection Code | J_1IREJCODE | CHAR | 3 | J_1IREJMAS | CHAR3 | |||
MRPIND | Maximum Retail Price | J_1IMRPIND | CHAR | 1 | CHAR1 | ||||
USNAM | Created By | J_1IUSNAM | CHAR | 12 | CHAR12 | ||||
CPUDT | Excise Document Entry Date | J_1ICPUDT | DATS | 8 | DATUM | ||||
CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
ADDLDATA1 | Additional Data | J_1IADDATA | CHAR | 60 | CHAR60 | ||||
ADDLDATA2 | Additional Data | J_1IADDATA | CHAR | 60 | CHAR60 | ||||
ADDLDATA3 | Additional Data | J_1IADDATA | CHAR | 60 | CHAR60 | ||||
ADDLDATA4 | Additional Data | J_1IADDATA | CHAR | 60 | CHAR60 | ||||
ADDLVAL | Additional Value | J_1IADDVAL | CURR | 17(2) | WERT9 | ||||
RULES | Rule/Section | J_2IRULE | CHAR | 10 | Assigned to domain | J_2IRULE | |||
TOTAL_ITEMS | Number of Items in Excise Invoice | J_1IEX_TOT_ITM | NUMC | 4 | NUMC4 | ||||
TOTAL_QTY | Total Quantity of All Items | J_1IEX_TOT_QTY | QUAN | 13(3) | MENG13 | ||||
TOTAL_BED | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
TOTAL_AED | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
TOTAL_SED | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
TOT_SALES_TAX | Non-deductible tax value | J_1INDTAX | CURR | 13(2) | WERT7 | ||||
TOT_OTHERS | Non-deductible tax value | J_1INDTAX | CURR | 13(2) | WERT7 | ||||
LOGLEVEL | Error status | J_1IEX_LOGLEVEL | CHAR | 50 | TEXT50 | ||||
J_1IGRXREF | Number of Goods Receipts per Excise Invoice | J_1IGREX | CHAR | 1 | J_1IXREF | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
R_BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
REJ_ONHOLD | Indicator for rejection onhold account | J_1IEX_REJ_ONHOLD | CHAR | 1 | CHAR1 | ||||
REJ_VENDOR_PAY | Indicator whether Vendor payment should include excise am | J_1IPAYVEN | CHAR | 1 | CHAR1 | ||||
REJ_ACC_DOCNO | Accounting Document | J_1IFAWREF | CHAR | 10 | ALPHA | AWREF | |||
REJ_ACC_DOCTYP | Object type of calling application (FI) | J_1IFAWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
REJ_ACC_YEAR | Financial posting year | J_1IFAYEAR | NUMC | 4 | NUMC4 | ||||
TCODE | Transaction Code | TCODE | CHAR | 20 | Assigned to domain | TCODE | TCD | ||
NO_OF_PART1 | 0 | ||||||||
NO_OF_PART2 | 0 | ||||||||
PART1_FROM | Register Entry Serial Number | J_1ISRLNO1 | NUMC | 10 | NUMC10 | ||||
PART1_TO | Register Entry Serial Number | J_1ISRLNO1 | NUMC | 10 | NUMC10 | ||||
PART2_FROM | Register Entry Serial Number | J_1ISRLNO1 | NUMC | 10 | NUMC10 | ||||
PART2_TO | Register Entry Serial Number | J_1ISRLNO1 | NUMC | 10 | NUMC10 | ||||
NO_OF_CANCEL | 0 | ||||||||
REV_ACC_DOCNO | Accounting Document | J_1IFAWREF | CHAR | 10 | ALPHA | AWREF | |||
EXCISE_ACTION | Excise Action | J_1IEXCISE_ACTION | CHAR | 2 | J_1IEXCISE_ACTION | ||||
PLANT_IND | Plant indicator summary | 0 | |||||||
DEPOT_IND | depot indicator summary | 0 | |||||||
EXCISE_IND | Excise indicator summary | 0 | |||||||
SUBCON_IND | Subcontracting Indicator | 0 | |||||||
BONDNO | Internal Bond Number | J_1IBONDNO | NUMC | 10 | J_1IBONDNO | ||||
BONDTYP | Bond Type | J_1IBONDTYP | CHAR | 4 | J_1IBONDTYP | ||||
BONDYR | Fiscal Year | J_1IBONDYR | NUMC | 4 | GJAHR | GJAHR | |||
BONDAMT | Bond Value | J_1IBOAMT | CURR | 13(2) | WERT7 | ||||
BONDCURBAL | Bond Balance | J_1IBOCURBAL | CURR | 13(2) | WERT7 | ||||
BOAMTBAL | Bond Balance | J_1IBOCURBAL | CURR | 13(2) | WERT7 | ||||
BOND_RESERV_AMT | Reservation Amount | J_1IBORESERV | CURR | 13(2) | WERT7 | ||||
BONDNOEX | Official Bond Number | J_1IBONDNOEX | CHAR | 60 | CHAR60 | ||||
BONDSTATUS | Bond Status | J_1IBOSTATUS | CHAR | 1 | J_1IBOSTATUS | ||||
BONDEXPDT | Expiry Date | J_1IBOEXPDT | DATS | 8 | DATUM | ||||
TOTAL_EXCINV | Excise Bonding: Total number of excise invoices | J_1IEX_TOT_EXC | NUMC | 4 | NUMC4 | ||||
PRECUSDAT | Arrived at Customs | J_1IPRECUSDAT | DATS | 8 | DATUM | ||||
ACKCUSDAT | Countersigned | J_1IACKCUSDAT | DATS | 8 | DATUM | ||||
RECPTDAT | Arrived Back | J_1IRECPTDAT | DATS | 8 | DATS | ||||
EXCSUBDAT | Sent to Excise Department | J_1IEXCSUBDAT | DATS | 8 | DATUM | ||||
POEXPDAT | Export Confirmed | J_1IPOEXPDAT | DATS | 8 | DATUM | ||||
AMENDIND | Exc Bonding: Amendment Indicator | 0 | |||||||
AMENDED_BALANCE | BED After Amendment | J_1IAMD_BAL | CURR | 13(2) | WERT7 | ||||
AMENDED_ON | Exc Bonding: Date of Amendment | J_1IAMD_DAT | DATS | 8 | DATS | ||||
ADDN_EXNUM | Official Excise Document Number | J_1IEXCNUM | CHAR | 10 | J_1IEXCNUM | J2F | |||
ADDN_EXYEAR | Excise Year | J_1IEXYEAR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
PRINT_ARE | Print ARE Document | J_1IPRINT_ARE | CHAR | 1 | CHAR1 | ||||
EXC_ADDRESS_NO | Address | J_1IADDR_NO | NUMC | 3 | NUM3 | ||||
EXC_ADDR_DESCP | Excise Address Description | J_1IADDR_DESC | CHAR | 40 | J_1ICHAR40LOW | ||||
CUS_ADDRESS_NO | Address | J_1IADDR_NO | NUMC | 3 | NUM3 | ||||
CUS_ADDR_DESCP | Excise Address Description | J_1IADDR_DESC | CHAR | 40 | J_1ICHAR40LOW | ||||
EXPORT_PRD_EXCEED | Export Period exceeded Indicator | 0 | |||||||
RG23ABEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
RG23CBEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
PLABEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IRG23ABEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IRG23CBEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IPLABEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
TOTAL_UTIL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
AUTO_RECON | Automatic reconciliation | 0 | |||||||
NCCD | National Calamity Contingency Duty | J_1IEXCNCCD | CURR | 13(2) | WERT7 | ||||
TOTAL_NCCD | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
ECS | ECS Value | J_1IEXECS | CURR | 13(2) | WERT7 | ||||
TOTAL_ECS | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
EXADDTAX1 | Additional Tax1 value | J_1IEXADDTAX1 | CURR | 13(2) | WERT7 | ||||
TOTAL_AT1 | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
EXADDTAX2 | Additional Tax2 value | J_1IEXADDTAX2 | CURR | 13(2) | WERT7 | ||||
TOTAL_AT2 | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
EXADDTAX3 | Additional Tax3 value | J_1IEXADDTAX3 | CURR | 13(2) | WERT7 | ||||
TOTAL_AT3 | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
RG23AAEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
RG23CAEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
PLAAEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IRG23AAEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IRG23CAEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IPLAAEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
RG23ASEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
RG23CSEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
PLASEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IRG23ASEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IRG23CSEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IPLASEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
RG23ANCCDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
RG23CNCCDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
PLANCCDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IRG23ANCCDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IRG23CNCCDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IPLANCCDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
RG23AECSBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
RG23CECSBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
PLAECSBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IRG23AECSBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IRG23CECSBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IPLAECSBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
RG23AAT1BAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
RG23CAT1BAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
PLAAT1BAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IRG23AAT1BAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IRG23CAT1BAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IPLAAT1BAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
ISTBEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
ISTAEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
ISTSEDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
ISTNCCDBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
ISTECSBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
ISTAT1BAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IECSSTECSBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
IAT1STAT1BAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
STBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
STECSBAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 | ||||
STAT1BAL | Excise Bonding: BED balance RG23A/C | J_1IBEDBAL | CURR | 13(2) | WERT7 |
Key field | Non-key field |
How do I retrieve data from SAP structure J_1IEXHEAD using ABAP code?
As J_1IEXHEAD is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on J_1IEXHEAD as there is no data to select.How to access SAP table J_1IEXHEAD
Within an ECC or HANA version of SAP you can also view further information about J_1IEXHEAD 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