SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

J_1IEXCDTL Table in SAP: Excise invoice line item details

J_1IEXCDTL is an SAP table in package J1I2, software component SAP_APPL. View details, fields & related tables of J_1IEXCDTL in SAP.

  • Table description : Excise invoice line item details
  • Package : J1I2
  • Software Component : SAP_APPL
J_1IEXCDTL table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP J_1IEXCDTL Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
TRNTYPExcise Transaction TypeJ_1ITRNTYPJ_1ITRNTYP
DOCYRYearJ_1IDOCUYRJ_1IDOCUYR
DOCNOInternal Excise Document NumberJ_1IDOCNOJ_1IDOCNO
ZEILEItem NumberJ_1IZEILEJ_1IZEILE
WERKSPlantWERKS_DWERKS
EXNUMOfficial Excise Document NumberJ_1IEXCNUMJ_1IEXCNUM
EXDATExcise Document DateJ_1IEXCDATJ_1IEXCDAT
EXYEARExcise YearJ_1IEXYEARGJAHR
EXGRPExcise GroupJ_1IEXCGRPJ_1IEXCGRP
LIFNRVendorJ_1ILIFNRJ_1ILIFNR
SHIPFROMAccount Number of Vendor or CreditorLIFNRLIFNR
RCWRKReceiving plant/issuing plantUMWRKWERKS
GSBERBusiness AreaGSBERGSBER
LGORTStorage locationLGORT_DLGORT
MATNRMaterial NumberMATNRMATNR
MAKTXMaterial descriptionMAKTXTEXT40
CHARGBatch NumberCHARG_DCHARG
CHAPIDChapter IDJ_1ICHIDCHAR12
MENGEQuantity mentioned in the excise invoiceJ_1IMENGEMENG13
MENGAQuantity of Goods ReceivedJ_1IMENGAMENG13
CREDIT_QTYQuantity on Which CENVAT Credit Is TakenJ_1IMENGCMENG13
MENGRQuantity remaining in the depotJ_1IMENGRMENG13
SCPGNQuantity of Scrap generatedJ_1ISCPGNMENG13
MEINSUnit of MeasureJ_1IMEINSMEINS
MENGR_UOMBase Unit of MeasureMEINSMEINS
EXCURCurrencyJ_1IEXCCURWAERS
EXBASExcise Duty Base AmountJ_1IEXCBASWERT7
EXBEDBasic Excise DutyJ_1IEXCBEDWERT7
EXSEDSpecial Excise DutyJ_1IEXCSEDWERT7
EXAEDAdditional Excise DutyJ_1IEXCAEDWERT7
CESSCess amountJ_1IEXCESSWERT7
BEDINVInventorized BEDJ_1IBEDINVWERT7
AEDINVInventorized AEDJ_1IAEDINVWERT7
SEDINVInventorized SEDJ_1ISEDINVWERT7
ADDBEDAdditional BEDJ_1IADDBEDWERT7
ADDSEDAdditional SEDJ_1IADDSEDWERT7
ADDAEDAdditional AEDJ_1IADDAEDWERT7
INDTAXNon-deductible tax valueJ_1INDTAXWERT7
PART2YRYear of Register EntryJ_1IYEARNUMC4
RG23ASERRG23A serial no.J_1I23ASERNUMC10
RG23CSERRG23C serial no.J_1I23CSERNUMC10
RGPLASERPLA serial no.J_1IPLASERNUMC10
PART1YRYear of Register EntryJ_1IYEARNUMC4
PART1SERRegister Entry Serial NumberJ_1ISRLNO1NUMC10
RDOC1Reference Document 1J_1IRDOC1CHAR10
RYEAR1Reference year 1J_1IRYEAR1CHAR4
RITEM1Reference Item 1J_1IRITEM1NUMC6
RIND1Reference Document Type 1J_1IRIND1J_1IRIND
RDOC2Reference Document 2J_1IRDOC2CHAR10
RYEAR2Reference year 2J_1IRYEAR2CHAR4
RITEM2Reference Item 2J_1IRITEM2NUMC6
RIND2Reference Document Type 2J_1IRIND2J_1IRIND
RDOC3Reference Document 3J_1IRDOC3CHAR40
RIND3Reference document type 3J_1IRIND3J_1IRIND
STATUSExcise Document StatusJ_1ISTATUSJ_1ISTATUS
BEDRATEBED percentageJ_1IBEDRATPRZ34
AEDRATEAdditional Excise Duty %J_1IAEDRATPRZ34
SEDRATESpecial Excise Duty %J_1ISEDRATPRZ34
CESSRATECess percentageJ_1ICESSPRZ23
CAPINDMaterial TypeJ_1ICAPINDJ_1ICAPIND
MRPINDSingle-Character FlagCHAR1CHAR1
REJ_CODERejection CodeJ_1IREJCODECHAR3
USNAMCreated ByJ_1IUSNAMCHAR12
CPUDTExcise Document Entry DateJ_1ICPUDTDATUM
CPUTMTime of data entryCPUTMUZEIT
AENAMChanged by the userJ_1IUSNAMCCHAR12
AEDATChanged on dateJ_1IAEDATJ_1IAEDAT
ADDLDATA1Additional DataJ_1IADDATACHAR60
ADDLDATA2Additional DataJ_1IADDATACHAR60
ADDLDATA3Additional DataJ_1IADDATACHAR60
ADDLDATA4Additional DataJ_1IADDATACHAR60
ADDLVAL1Additional ValueJ_1IADDVALWERT9
ADDLVAL2Additional ValueJ_1IADDVALWERT9
NUM_OF_PKGSNumber of PackagesJ_1INUM_OF_PKGJ_1ICHAR10LOW
DESC_PKGPackage DescriptionJ_1IDESC_PKGCHAR30LOW
NTGEWNet weightNTGEW_15MENG15
BRGEWGross weightBRGEW_15MENG15
GEWEIWeight UnitGEWEIMEINS
MRK_PKGMarks on PackageJ_1IMRK_PKGCHAR30LOW
NOS_ON_PKGNumbers on PackageJ_1INOS_ON_PKGCHAR30LOW
LICYRLicense YearJ_1ILICYRGJAHR
LICNOInternal License NumberJ_1ILICNOJ_1ILICNO
LICZEILEItem NumberJ_1IZEILEJ_1IZEILE
NCCDNCCD ValueJ_1IEXNCCDWERT7
NCCDINVNCCD Inventory ComponentJ_1INCCDINVWERT7
NCCDRATENCCD Rate in %J_1INCCDRATPRZ34
ADDNCCDAdditional NCCDJ_1IADDNCCDWERT7
ECSECS ValueJ_1IEXECSWERT7
ECSINVECS Inventory componentJ_1IECSINVWERT7
ECSRATEECS rate in %J_1IECSRATPRZ34
EXADDTAX1Additional Tax1 valueJ_1IEXADDTAX1WERT7
EXADDINV1Inventorized AT1J_1IEXADDINV1WERT7
EXADDRATE1AT1 rate in %J_1IEXADDRAT1PRZ34
ADDAT1Additional AT1J_1IADDAT1WERT7
EXADDTAX2Additional Tax2 valueJ_1IEXADDTAX2WERT7
EXADDINV2Inventorized AT2J_1IEXADDINV2WERT7
EXADDRATE2AT2 rate in %J_1IEXADDRAT2PRZ34
ADDAT2Additional AT2J_1IADDAT2WERT7
EXADDTAX3Additional Tax3 valueJ_1IEXADDTAX3WERT7
EXADDINV3Inventorized AT3J_1IEXADDINV3WERT7
EXADDRATE3AT3 rate in %J_1IEXADDRAT3PRZ34
ADDAT3Additional AT3J_1IADDAT3WERT7
SERTAXSERNOService Tax Serial NumberJ_1ISERTAXNONUMC10

J_1IEXCDTL related tables

TableNote
J_1IEXCDTLExcise invoice line item details
OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger
OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger
OIHSLATDP (excise duty) special ledger actual line item table
DBERDLBReference of a Print Doc. Line Item to a Bill.Doc. Line Item
J_1IEXCHDRExcise invoice header detail
J_1IEXCREFDelivery document to excise invoice refrence document link
J_1IGRXREFGoods Receipt to Excise Invoice Coss Reference
CNV_20000_RSEGBackup copy of RSEG (line item for incoming invoice)
CRMD_EDRCRM Invoice Line Item - EDR Table
T023EInvoice line item handling rules
J_1IPART2Excise Part II details
J_1IRG1Excise RG1 details
BBPD_OR_INVHUBObject Link: Invoice/Invoice Template to Reference Document
CRMC_EDRINV_PEREDR Invoice: Default values for Invoice Date search

Related tcodes for J_1IEXCDTL

Transaction codes in the same SAP package (J1I2) as the J_1IEXCDTL table.

TcodeDescription
J1I0Customizing wizard
J1I2Sales Tax Register
J1I3Modvat utilzation in batch
J1I5Register creation for RG23 and RG1
J1I6Modvat forecast
J1I7Query Excise invoices
J1I8TDS Challan Update
J1I9Number ranges for excise invoice
J1IAExcise Invoice Details
J1IBExcise Verification And Posting
J1IDRate maint & amend open po's/so's
J1IFSubcontracting
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2026 sapstack.com