J_1IEXHEAD SAP (Incoming Excise Invoice: CIN40A : Header Data) Structure details

Dictionary Type: Structure
Description: Incoming Excise Invoice: CIN40A : Header Data




ABAP Code to SELECT data from J_1IEXHEAD
Related tables to J_1IEXHEAD
Access table J_1IEXHEAD




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
TRNTYPExcise Transaction Type J_1ITRNTYPCHAR4Assigned to domainJ_1ITRNTYP
DOCYRYear J_1IDOCUYRNUMC4J_1IDOCUYRGJR
DOCNOInternal Excise Document Number J_1IDOCNONUMC10Assigned to domainJ_1IDOCNOJ2G
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
EXGRPExcise Group J_1IEXCGRPCHAR2Assigned to domainJ_1IEXCGRPJ2I
SRGRPExcise Document Series Group J_1ISERGRPCHAR3Assigned to domainJ_1ISERGRPJ2H
STRTYPSub Transaction Type J_1ISTRTYPCHAR2CHAR2J_1ISUBTYP
EXNUMOfficial Excise Document Number J_1IEXCNUMCHAR10J_1IEXCNUMJ2F
OLD_EXNUMOfficial Excise Document Number J_1IEXCNUMCHAR10J_1IEXCNUMJ2F
EXDATExcise Document Date J_1IEXCDATDATS8J_1IEXCDAT
OLD_EXDATExcise Document Date J_1IEXCDATDATS8J_1IEXCDAT
EXYEARExcise Year J_1IEXYEARNUMC4GJAHRGJAHRGJR
REMTIMETime of Removal J_1IREMTIMTIMS6UZEIT
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
OLD_LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
SHIPFROMShip-From Vendor J_1IEXSHIPFROMCHAR10Assigned to domainALPHALIFNR
RCWRKReceiving/Issuing Plant UMWRKCHAR4Assigned to domainWERKS
EXCURCurrency J_1IEXCCURCUKY5Assigned to domainWAERS
EXBEDBasic Excise Duty J_1IEXCBEDCURR13(2) WERT7
EXSEDSpecial Excise Duty J_1IEXCSEDCURR13(2) WERT7
EXAEDAdditional Excise Duty J_1IEXCAEDCURR13(2) WERT7
SALES_TAXNon-deductible tax value J_1INDTAXCURR13(2) WERT7
OTHERSNon-deductible tax value J_1INDTAXCURR13(2) WERT7
CESSCess amount J_1IEXCESSCURR13(2) WERT7
REFDOCInternal reference document J_1IINTREFCHAR10CHAR10
RDOCReference Document 1 J_1IRDOC1CHAR10CHAR10
RYEARReference year 1 J_1IRYEAR1CHAR4CHAR4
RINDReference Document Type 1 J_1IRIND1CHAR1J_1IRIND
KUNAGSold-to party KUNAGCHAR10Assigned to domainALPHAKUNNRVAG
KUNWEShip-to party KUNWECHAR10Assigned to domainALPHAKUNNR
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
EXCCDECC Number J_1IEXCDCHAR40CHAR40
EXCRNExcise Registration Number J_1IEXRNCHAR40CHAR40
EXCRGExcise Range J_1IEXRGCHAR60CHAR60
EXCDIExcise Division J_1IEXDICHAR60CHAR60
EXCCOExcise Commissionerate J_1IEXCOCHAR60CHAR60
CSTNOCentral Sales Tax Number J_1ICSTNOCHAR40CHAR40
LSTNOLocal Sales Tax Number J_1ILSTNOCHAR40CHAR40
PANNOPermanent Account Number J_1IPANNOCHAR40CHAR40
PREPRNPreprinted Serial Number J_1IPREPRNCHAR10CHAR10
RTDATReturn Date J_1IRTDATDATS8DATS
CVDINDCVD indication J_1ICVDINDCHAR1CHAR1_X
EXPINDExport Type J_1IINDEXPCHAR1J_1IINDEXP
STATUSExcise Document Status J_1ISTATUSCHAR1J_1ISTATUS
CENSTATCENVAT Utilization status J_1ICENSTCHAR1J_1ICENST
REJ_CODERejection Code J_1IREJCODECHAR3J_1IREJMASCHAR3
MRPINDMaximum Retail Price J_1IMRPINDCHAR1CHAR1
USNAMCreated By J_1IUSNAMCHAR12CHAR12
CPUDTExcise Document Entry Date J_1ICPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
BUDATPosting Date in the Document BUDATDATS8DATUM
ADDLDATA1Additional Data J_1IADDATACHAR60CHAR60
ADDLDATA2Additional Data J_1IADDATACHAR60CHAR60
ADDLDATA3Additional Data J_1IADDATACHAR60CHAR60
ADDLDATA4Additional Data J_1IADDATACHAR60CHAR60
ADDLVALAdditional Value J_1IADDVALCURR17(2) WERT9
RULESRule/Section J_2IRULECHAR10Assigned to domainJ_2IRULE
TOTAL_ITEMSNumber of Items in Excise Invoice J_1IEX_TOT_ITMNUMC4NUMC4
TOTAL_QTYTotal Quantity of All Items J_1IEX_TOT_QTYQUAN13(3) MENG13
TOTAL_BEDTotal Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
TOTAL_AEDTotal Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
TOTAL_SEDTotal Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
TOT_SALES_TAXNon-deductible tax value J_1INDTAXCURR13(2) WERT7
TOT_OTHERSNon-deductible tax value J_1INDTAXCURR13(2) WERT7
LOGLEVELError status J_1IEX_LOGLEVELCHAR50TEXT50
J_1IGRXREFNumber of Goods Receipts per Excise Invoice J_1IGREXCHAR1J_1IXREF
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
R_BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
REJ_ONHOLDIndicator for rejection onhold account J_1IEX_REJ_ONHOLDCHAR1CHAR1
REJ_VENDOR_PAYIndicator whether Vendor payment should include excise am J_1IPAYVENCHAR1CHAR1
REJ_ACC_DOCNOAccounting Document J_1IFAWREFCHAR10ALPHAAWREF
REJ_ACC_DOCTYPObject type of calling application (FI) J_1IFAWTYPCHAR5Assigned to domainAWTYP
REJ_ACC_YEARFinancial posting year J_1IFAYEARNUMC4NUMC4
TCODETransaction Code TCODECHAR20Assigned to domainTCODETCD
NO_OF_PART1 0
NO_OF_PART2 0
PART1_FROMRegister Entry Serial Number J_1ISRLNO1NUMC10NUMC10
PART1_TORegister Entry Serial Number J_1ISRLNO1NUMC10NUMC10
PART2_FROMRegister Entry Serial Number J_1ISRLNO1NUMC10NUMC10
PART2_TORegister Entry Serial Number J_1ISRLNO1NUMC10NUMC10
NO_OF_CANCEL 0
REV_ACC_DOCNOAccounting Document J_1IFAWREFCHAR10ALPHAAWREF
EXCISE_ACTIONExcise Action J_1IEXCISE_ACTIONCHAR2J_1IEXCISE_ACTION
PLANT_IND Plant indicator summary0
DEPOT_IND depot indicator summary0
EXCISE_IND Excise indicator summary0
SUBCON_IND Subcontracting Indicator0
BONDNOInternal Bond Number J_1IBONDNONUMC10J_1IBONDNO
BONDTYPBond Type J_1IBONDTYPCHAR4J_1IBONDTYP
BONDYRFiscal Year J_1IBONDYRNUMC4GJAHRGJAHR
BONDAMTBond Value J_1IBOAMTCURR13(2) WERT7
BONDCURBALBond Balance J_1IBOCURBALCURR13(2) WERT7
BOAMTBALBond Balance J_1IBOCURBALCURR13(2) WERT7
BOND_RESERV_AMTReservation Amount J_1IBORESERVCURR13(2) WERT7
BONDNOEXOfficial Bond Number J_1IBONDNOEXCHAR60CHAR60
BONDSTATUSBond Status J_1IBOSTATUSCHAR1J_1IBOSTATUS
BONDEXPDTExpiry Date J_1IBOEXPDTDATS8DATUM
TOTAL_EXCINVExcise Bonding: Total number of excise invoices J_1IEX_TOT_EXCNUMC4NUMC4
PRECUSDATArrived at Customs J_1IPRECUSDATDATS8DATUM
ACKCUSDATCountersigned J_1IACKCUSDATDATS8DATUM
RECPTDATArrived Back J_1IRECPTDATDATS8DATS
EXCSUBDATSent to Excise Department J_1IEXCSUBDATDATS8DATUM
POEXPDATExport Confirmed J_1IPOEXPDATDATS8DATUM
AMENDIND Exc Bonding: Amendment Indicator0
AMENDED_BALANCEBED After Amendment J_1IAMD_BALCURR13(2) WERT7
AMENDED_ONExc Bonding: Date of Amendment J_1IAMD_DATDATS8DATS
ADDN_EXNUMOfficial Excise Document Number J_1IEXCNUMCHAR10J_1IEXCNUMJ2F
ADDN_EXYEARExcise Year J_1IEXYEARNUMC4GJAHRGJAHRGJR
PRINT_AREPrint ARE Document J_1IPRINT_ARECHAR1CHAR1
EXC_ADDRESS_NOAddress J_1IADDR_NONUMC3NUM3
EXC_ADDR_DESCPExcise Address Description J_1IADDR_DESCCHAR40J_1ICHAR40LOW
CUS_ADDRESS_NOAddress J_1IADDR_NONUMC3NUM3
CUS_ADDR_DESCPExcise Address Description J_1IADDR_DESCCHAR40J_1ICHAR40LOW
EXPORT_PRD_EXCEED Export Period exceeded Indicator0
RG23ABEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
RG23CBEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
PLABEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IRG23ABEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IRG23CBEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IPLABEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
TOTAL_UTILExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
AUTO_RECON Automatic reconciliation0
NCCDNational Calamity Contingency Duty J_1IEXCNCCDCURR13(2) WERT7
TOTAL_NCCDTotal Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
ECSECS Value J_1IEXECSCURR13(2) WERT7
TOTAL_ECSTotal Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
EXADDTAX1Additional Tax1 value J_1IEXADDTAX1CURR13(2) WERT7
TOTAL_AT1Total Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
EXADDTAX2Additional Tax2 value J_1IEXADDTAX2CURR13(2) WERT7
TOTAL_AT2Total Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
EXADDTAX3Additional Tax3 value J_1IEXADDTAX3CURR13(2) WERT7
TOTAL_AT3Total Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
RG23AAEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
RG23CAEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
PLAAEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IRG23AAEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IRG23CAEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IPLAAEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
RG23ASEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
RG23CSEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
PLASEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IRG23ASEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IRG23CSEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IPLASEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
RG23ANCCDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
RG23CNCCDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
PLANCCDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IRG23ANCCDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IRG23CNCCDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IPLANCCDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
RG23AECSBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
RG23CECSBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
PLAECSBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IRG23AECSBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IRG23CECSBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IPLAECSBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
RG23AAT1BALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
RG23CAT1BALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
PLAAT1BALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IRG23AAT1BALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IRG23CAT1BALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IPLAAT1BALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
ISTBEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
ISTAEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
ISTSEDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
ISTNCCDBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
ISTECSBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
ISTAT1BALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IECSSTECSBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
IAT1STAT1BALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
STBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
STECSBALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(2) WERT7
STAT1BALExcise Bonding: BED balance RG23A/C J_1IBEDBALCURR13(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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!