SAP Tables | Financial Accounting | Localization(FI-LOC) SAP FI

Share |

J_1IEXCHDR SAP Excise invoice header detail Table


J_1IEXCHDR is a standard SAP Table which is used to store Excise invoice header detail information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about Table J_1IEXCHDR and the data within it using relevant SAP transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

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

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)


Dictionary fields for SAP Table J_1IEXCHDR

FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3 T000Client
TRNTYPJ_1ITRNTYPCHAR4 J_1ITRANExcise Transaction Type
DOCYRJ_1IDOCUYRNUMC4 Year
DOCNOJ_1IDOCNONUMC10 Internal Excise Document Number
BUKRSBUKRSCHAR4 T001Company Code
WERKSWERKS_DCHAR4 T001WPlant
EXGRPJ_1IEXCGRPCHAR2 J_1IEXGRPSExcise Group
SRGRPJ_1ISERGRPCHAR3 J_1ISRGRPSExcise Document Series Group
STRTYPJ_1ISTRTYPCHAR2 Sub Transaction Type
EXNUMJ_1IEXCNUMCHAR10 Official Excise Document Number
EXDATJ_1IEXCDATDATS8 Excise Document Date
EXYEARJ_1IEXYEARNUMC4 Excise Year
REMTIMEJ_1IREMTIMTIMS6 Time of Removal
LIFNRLIFNRCHAR10 LFA1Account Number of Vendor or Creditor
SHIPFROMLIFNRCHAR10
*
Account Number of Vendor or Creditor
RCWRKUMWRKCHAR4 T001WReceiving/Issuing Plant
EXCURJ_1IEXCCURCUKY5 TCURCCurrency
EXBEDJ_1IEXCBEDCURR13(2) Basic Excise Duty
EXSEDJ_1IEXCSEDCURR13(2) Special Excise Duty
EXAEDJ_1IEXCAEDCURR13(2) Additional Excise Duty
CESSJ_1IEXCESSCURR13(2) Cess amount
REFDOCJ_1IINTREFCHAR10 Internal reference document
RDOCJ_1IRDOC1CHAR10 Reference Document 1
RYEARJ_1IRYEAR1CHAR4 Reference year 1
RINDJ_1IRIND1CHAR1 Reference Document Type 1
KUNAGKUNAGCHAR10 KNA1Sold-to party
KUNWEKUNWECHAR10 KNA1Ship-to party
GSBERGSBERCHAR4 TGSBBusiness Area
EXCCDJ_1IEXCDCHAR40 ECC Number
EXCRNJ_1IEXRNCHAR40 Excise Registration Number
EXCRGJ_1IEXRGCHAR60 Excise Range
EXCDIJ_1IEXDICHAR60 Excise Division
EXCCOJ_1IEXCOCHAR60 Excise Commissionerate
CSTNOJ_1ICSTNOCHAR40 Central Sales Tax Number
LSTNOJ_1ILSTNOCHAR40 Local Sales Tax Number
PANNOJ_1IPANNOCHAR40 Permanent Account Number
PREPRNJ_1IPREPRNCHAR10 Preprinted Serial Number
RTDATJ_1IRTDATDATS8 Return Date
CVDINDJ_1ICVDINDCHAR1 CVD indication
EXPINDJ_1IINDEXPCHAR1 Export Type
STATUSJ_1ISTATUSCHAR1 Excise Document Status
CENSTATJ_1ICENSTCHAR1 CENVAT Utilization status
REJ_CODEJ_1IREJCODECHAR3 J_1IREJMASRejection Code
MRPINDJ_1IMRPINDCHAR1 Maximum Retail Price
USNAMJ_1IUSNAMCHAR12 Created By
CPUDTJ_1ICPUDTDATS8 Excise Document Entry Date
CPUTMCPUTMTIMS6 Time of Entry
AENAMAENAMCHAR12 Name of Person Who Changed Object
AEDATAEDATDATS8 Changed On
BUDATBUDATDATS8 Posting Date in the Document
ADDLDATA1J_1IADDATACHAR60 Additional Data
ADDLDATA2J_1IADDATACHAR60 Additional Data
ADDLDATA3J_1IADDATACHAR60 Additional Data
ADDLDATA4J_1IADDATACHAR60 Additional Data
ADDLVALJ_1IADDVALCURR17(2) Additional Value
RULESJ_2IRULECHAR10
*
Rule/Section
TCODEJ_1ITCODECHAR20
*
Transaction code
REJ_ACC_DOCNOJ_1IFAWREFCHAR10 Accounting Document
REJ_ACC_DOCTYPJ_1IFAWTYPCHAR5
*
Object type of calling application (FI)
REJ_ACC_YEARJ_1IFAYEARNUMC4 Financial posting year
PRECUSDATJ_1IPRECUSDATDATS8 Arrived at Customs
ACKCUSDATJ_1IACKCUSDATDATS8 Countersigned
RECPTDATJ_1IRECPTDATDATS8 Arrived Back
EXCSUBDATJ_1IEXCSUBDATDATS8 Sent to Excise Department
POEXPDATJ_1IPOEXPDATDATS8 Export Confirmed
AMENDINDCHAR1 Exc Bonding: Amendment Indicator
BONDNOJ_1IBONDNONUMC10 Internal Bond Number
BONDYRJ_1IBONDYRNUMC4 Fiscal Year
BOAMTBALJ_1IBOCURBALCURR13(2) Bond Balance
AMENDED_BALANCEJ_1IAMD_BALCURR13(2) BED After Amendment
AMENDED_ONJ_1IAMD_DATDATS8 Exc Bonding: Date of Amendment
EXC_ADDRESS_NOJ_1IEDADDR_NONUMC3 Address
CUS_ADDRESS_NOJ_1IEDADDR_NONUMC3 Address
INTEREST_VALUEJ_1IINTVALCURR13(2) Interest Amount
NCCDJ_1IEXNCCDCURR13(2) NCCD Value
ECSJ_1IEXECSCURR13(2) ECS Value
EXADDTAX1J_1IEXADDTAX1CURR13(2) Additional Tax1 value
EXADDTAX2J_1IEXADDTAX2CURR13(2) Additional Tax2 value
EXADDTAX3J_1IEXADDTAX3CURR13(2) Additional Tax3 value
BELNRJ_1IFAWREFCHAR10 Accounting Document
GJAHRJ_1IFAYEARNUMC4 Financial posting year


Key field
Non-key field




comments powered by Disqus