J_1IEXCDTL - Excise invoice line item details

Excise invoice line item details information is stored in SAP table J_1IEXCDTL.
It is part of development package J1I2 in software component FI-LOC-LO-IN. This development package consists of objects that can be grouped under "India, Phase II".

Fields for table J_1IEXCDTL

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
TRNTYPExcise Transaction TypeXJ_1ITRNTYPCHAR8J_1ITRAN
DOCYRYearXJ_1IDOCUYRNUMC8
DOCNOInternal Excise Document NumberXJ_1IDOCNONUMC20J_1IEXCHDR
WERKSPlantWERKS_DCHAR8T001W
EXNUMOfficial Excise Document NumberJ_1IEXCNUMCHAR20
EXDATExcise Document DateJ_1IEXCDATDATS16
EXYEARExcise YearJ_1IEXYEARNUMC8
EXGRPExcise GroupJ_1IEXCGRPCHAR4
LIFNRVendorJ_1ILIFNRCHAR20
SHIPFROMAccount Number of SupplierLIFNRCHAR20
RCWRKReceiving plant/issuing plantUMWRKCHAR8T001W
GSBERBusiness AreaGSBERCHAR8TGSB
LGORTStorage locationLGORT_DCHAR8T001L
MATNRMaterial NumberMATNRCHAR80MARA
MAKTXMaterial DescriptionMAKTXCHAR80
CHARGBatch NumberCHARG_DCHAR20
CHAPIDChapter IDJ_1ICHIDCHAR24
MENGEQuantity mentioned in the excise invoiceJ_1IMENGEQUAN7
MENGAQuantity of Goods ReceivedJ_1IMENGAQUAN7
CREDIT_QTYQuantity on Which CENVAT Credit Is TakenJ_1IMENGCQUAN7
MENGRQuantity remaining in the depotJ_1IMENGRQUAN7
SCPGNQuantity of Scrap generatedJ_1ISCPGNQUAN7
MEINSUnit of MeasureJ_1IMEINSUNIT6T006
MENGR_UOMBase Unit of MeasureMEINSUNIT6T006
EXCURCurrencyJ_1IEXCCURCUKY10TCURC
EXBASExcise Duty Base AmountJ_1IEXCBASCURR7
EXBEDBasic Excise DutyJ_1IEXCBEDCURR7
EXSEDSpecial Excise DutyJ_1IEXCSEDCURR7
EXAEDAdditional Excise DutyJ_1IEXCAEDCURR7
CESSCess amountJ_1IEXCESSCURR7
BEDINVInventorized BEDJ_1IBEDINVCURR7
AEDINVInventorized AEDJ_1IAEDINVCURR7
SEDINVInventorized SEDJ_1ISEDINVCURR7
ADDBEDAdditional BEDJ_1IADDBEDCURR7
ADDSEDAdditional SEDJ_1IADDSEDCURR7
ADDAEDAdditional AEDJ_1IADDAEDCURR7
INDTAXNon-deductible tax valueJ_1INDTAXCURR7
PART2YRYear of Register EntryJ_1IYEARNUMC8
RG23ASERRG23A serial no.J_1I23ASERNUMC20
RG23CSERRG23C serial no.J_1I23CSERNUMC20
RGPLASERPLA serial no.J_1IPLASERNUMC20
PART1YRYear of Register EntryJ_1IYEARNUMC8
PART1SERRegister Entry Serial NumberJ_1ISRLNO1NUMC20
RDOC1Reference Document 1J_1IRDOC1CHAR20
RYEAR1Reference year 1J_1IRYEAR1CHAR8
RITEM1Reference Item 1J_1IRITEM1NUMC12
RIND1Reference Document Type 1J_1IRIND1CHAR2
RDOC2Reference Document 2J_1IRDOC2CHAR20
RYEAR2Reference year 2J_1IRYEAR2CHAR8
RITEM2Reference Item 2J_1IRITEM2NUMC12
RIND2Reference Document Type 2J_1IRIND2CHAR2
RDOC3Reference Document 3J_1IRDOC3CHAR80
RIND3Reference document type 3J_1IRIND3CHAR2
STATUSExcise Document StatusJ_1ISTATUSCHAR2
BEDRATEBED percentageJ_1IBEDRATDEC4
AEDRATEAdditional Excise Duty %J_1IAEDRATDEC4
SEDRATESpecial Excise Duty %J_1ISEDRATDEC4
CESSRATECess RateJ_1ICESSDEC4
CAPINDMaterial TypeJ_1ICAPINDCHAR2
MRPINDSingle-Character FlagCHAR1CHAR2
REJ_CODERejection CodeJ_1IREJCODECHAR6J_1IREJMAS
USNAMCreated ByJ_1IUSNAMCHAR24
CPUDTExcise Document Entry DateJ_1ICPUDTDATS16
CPUTMTime of EntryCPUTMTIMS12
AENAMChanged by the userJ_1IUSNAMCCHAR24
AEDATChanged on dateJ_1IAEDATDATS16
ADDLDATA1Additional DataJ_1IADDATACHAR120
ADDLDATA2Additional DataJ_1IADDATACHAR120
ADDLDATA3Additional DataJ_1IADDATACHAR120
ADDLDATA4Additional DataJ_1IADDATACHAR120
ADDLVAL1Additional ValueJ_1IADDVALCURR9
ADDLVAL2Additional ValueJ_1IADDVALCURR9
NUM_OF_PKGSNumber of PackagesJ_1INUM_OF_PKGCHAR20
DESC_PKGPackage DescriptionJ_1IDESC_PKGCHAR60
NTGEWNet weightNTGEW_15QUAN8
BRGEWGross weightBRGEW_15QUAN8
GEWEIWeight UnitGEWEIUNIT6
MRK_PKGMarks on PackageJ_1IMRK_PKGCHAR60
NOS_ON_PKGNumbers on PackageJ_1INOS_ON_PKGCHAR60
LICYRLicense YearJ_1ILICYRNUMC8
LICNOInternal License NumberJ_1ILICNONUMC20
LICZEILEItem NumberJ_1IZEILENUMC8
NCCDNCCD ValueJ_1IEXNCCDCURR7
NCCDINVNCCD Inventory ComponentJ_1INCCDINVCURR7
NCCDRATENCCD Rate in %J_1INCCDRATDEC4
ADDNCCDAdditional NCCDJ_1IADDNCCDCURR7
ECSECS ValueJ_1IEXECSCURR7
ECSINVECS Inventory componentJ_1IECSINVCURR7
ECSRATEECS rate in %J_1IECSRATDEC4
EXADDTAX1Additional Tax1 valueJ_1IEXADDTAX1CURR7
EXADDINV1Inventorized AT1J_1IEXADDINV1CURR7
EXADDRATE1AT1 rate in %J_1IEXADDRAT1DEC4
ADDAT1Additional AT1J_1IADDAT1CURR7
EXADDTAX2Additional Tax2 valueJ_1IEXADDTAX2CURR7
EXADDINV2Inventorized AT2J_1IEXADDINV2CURR7
EXADDRATE2AT2 rate in %J_1IEXADDRAT2DEC4
ADDAT2Additional AT2J_1IADDAT2CURR7
EXADDTAX3Additional Tax3 valueJ_1IEXADDTAX3CURR7
EXADDINV3Inventorized AT3J_1IEXADDINV3CURR7
EXADDRATE3AT3 rate in %J_1IEXADDRAT3DEC4
ADDAT3Additional AT3J_1IADDAT3CURR7
SERTAXSERNOService Tax Serial NumberJ_1ISERTAXNONUMC20
Privacy Policy