SAP Tables

Share |

J_1IEXCHDR SAP Table - Excise invoice header detail

J_1IEXCHDR is a standard SAP Table available within R/3 SAP systems depending on your version and release level. Below is the standard documentation available for this table and a few details of the fields which make up this table. You can view this information and more if you enter the Table name J_1IEXCHDR into the relevant SAP transaction such as SE11 or SE80. You can also view the data contained in this database table via these transactions or alternatively use transaction SE16

Delivery Class = A - Application table containing master and transaction data

Contribute (Add Comments)
Within the comments section below there is also an opportunity for you to add useful hints, tips and screen shots specific to this SAP object. This means that you and other users will be able to find these details quickly by simply searching on the object name J_1IEXCHDR or its description.


Dictionary fields for SAP Table J_1IEXCHDR
FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3T000Client
TRNTYPJ_1ITRNTYPCHAR4J_1ITRANExcise transaction type
DOCYRJ_1IDOCUYRNUMC4Year
DOCNOJ_1IDOCNONUMC10Internal Excise Document No.
BUKRSBUKRSCHAR4T001Company Code
WERKSWERKS_DCHAR4T001WPlant
EXGRPJ_1IEXCGRPCHAR2J_1IEXGRPSExcise Group
SRGRPJ_1ISERGRPCHAR3J_1ISRGRPSSeries Group
STRTYPJ_1ISTRTYPCHAR2Sub Transaction Type
EXNUMJ_1IEXCNUMCHAR10Official Excise Document No.
EXDATJ_1IEXCDATDATS8Excise document date
EXYEARJ_1IEXYEARNUMC4Excise year
REMTIMEJ_1IREMTIMTIMS6Time of removal
LIFNRLIFNRCHAR10LFA1Vendor
SHIPFROMLIFNRCHAR10
*
Vendor
RCWRKUMWRKCHAR4T001WReceiving Plant
EXCURJ_1IEXCCURCUKY5TCURCCurrency
EXBEDJ_1IEXCBEDCURR13(2)BED
EXSEDJ_1IEXCSEDCURR13(2)SED
EXAEDJ_1IEXCAEDCURR13(2)AED
CESSJ_1IEXCESSCURR13(2)CESS
REFDOCJ_1IINTREFCHAR10Internal reference
RDOCJ_1IRDOC1CHAR10Reference document 1
RYEARJ_1IRYEAR1CHAR4Reference Year1
RINDJ_1IRIND1CHAR1Ref. document type 1
KUNAGKUNAGCHAR10KNA1Sold-to party
KUNWEKUNWECHAR10KNA1Ship-to party
GSBERGSBERCHAR4TGSBBusiness Area
EXCCDJ_1IEXCDCHAR40ECC No.
EXCRNJ_1IEXRNCHAR40Excise Reg. No.
EXCRGJ_1IEXRGCHAR60Excise Range
EXCDIJ_1IEXDICHAR60Excise Division
EXCCOJ_1IEXCOCHAR60Excise Commissionerate
CSTNOJ_1ICSTNOCHAR40CST number
LSTNOJ_1ILSTNOCHAR40LST number
PANNOJ_1IPANNOCHAR40Permanent account number
PREPRNJ_1IPREPRNCHAR10Preprinted serial no.
RTDATJ_1IRTDATDATS8Return date
CVDINDJ_1ICVDINDCHAR1CVD indicator
EXPINDJ_1IINDEXPCHAR1Export Type
STATUSJ_1ISTATUSCHAR1Status
CENSTATJ_1ICENSTCHAR1CENVAT Utilization status
REJ_CODEJ_1IREJCODECHAR3J_1IREJMASRejection code
MRPINDJ_1IMRPINDCHAR1Maximum retail price
USNAMJ_1IUSNAMCHAR12Entered by user
CPUDTJ_1ICPUDTDATS8Excise Document Entry Date
CPUTMCPUTMTIMS6Time of Entry
AENAMAENAMCHAR12Changed by
AEDATAEDATDATS8Changed on
BUDATBUDATDATS8Posting Date
ADDLDATA1J_1IADDATACHAR60Additional data
ADDLDATA2J_1IADDATACHAR60Additional data
ADDLDATA3J_1IADDATACHAR60Additional data
ADDLDATA4J_1IADDATACHAR60Additional data
ADDLVALJ_1IADDVALCURR17(2)Additional value
RULESJ_2IRULECHAR10
*
Rule/Section
TCODEJ_1ITCODECHAR20
*
Transaction code
REJ_ACC_DOCNOJ_1IFAWREFCHAR10Accounting document
REJ_ACC_DOCTYPJ_1IFAWTYPCHAR5
*
Object typeFi
REJ_ACC_YEARJ_1IFAYEARNUMC4Financial Year
PRECUSDATJ_1IPRECUSDATDATS8Arrived at Customs
ACKCUSDATJ_1IACKCUSDATDATS8Countersigned
RECPTDATJ_1IRECPTDATDATS8Arrived Back
EXCSUBDATJ_1IEXCSUBDATDATS8Sent to Excise Dept
POEXPDATJ_1IPOEXPDATDATS8Export Confirmed
AMENDINDCHAR1
BONDNOJ_1IBONDNONUMC10Internal Bond No.
BONDYRJ_1IBONDYRNUMC4Fiscal Year
BOAMTBALJ_1IBOCURBALCURR13(2)Balance
AMENDED_BALANCEJ_1IAMD_BALCURR13(2)BED After Amendment
AMENDED_ONJ_1IAMD_DATDATS8Amendment Date
EXC_ADDRESS_NOJ_1IEDADDR_NONUMC3Address
CUS_ADDRESS_NOJ_1IEDADDR_NONUMC3Address
INTEREST_VALUEJ_1IINTVALCURR13(2)Interest Amount
NCCDJ_1IEXNCCDCURR13(2)NCCD Value
ECSJ_1IEXECSCURR13(2)ECS
EXADDTAX1J_1IEXADDTAX1CURR13(2)Additional tax1
EXADDTAX2J_1IEXADDTAX2CURR13(2)Additional tax2
EXADDTAX3J_1IEXADDTAX3CURR13(2)Additional tax3
BELNRJ_1IFAWREFCHAR10Accounting document
GJAHRJ_1IFAYEARNUMC4Financial Year







comments powered by Disqus