I_ExciseDocumentItem

Excise Document Item | view: ISDEXCISEDOCI | TRAN | Extraction: Not supported | Component: Logistics India
Tables used: J_1IEXCDTL
Column Name Description
ExciseTransactionType FK Excise Transaction Type
ExciseDocumentYear Year
InternalExciseDocNumber FK Internal Excise Document Number
ExciseItemNumber Item Number
Column Name Description
💲 Currency (Currency):
ExciseDutyBaseAmount Excise Duty Base Amount
BEDAmount Basic Excise Duty
SEDAmount Special Excise Duty
AEDAmount Additional Excise Duty
CESSAmount Cess amount
NCCDAmount NCCD Value
ECSAmount ECS Value
AdditionalTax1Value Additional Tax1 value
AdditionalTax2Value Additional Tax2 value
AdditionalTax3Value Additional Tax3 value
Column Name Description
📏 Base Unit of Measure (BaseUnit):
ExciseInvoiceQuantity Quantity mentioned in the excise invoice
Column Name Description
ExciseDocumentDate Excise Document Date
Column Name Description
Column Name Description Domain name
OfficialExciseDocNumber Official Excise Document Number J_1IEXCNUM
ExciseYear Excise Year GJAHR
ExciseGroup Excise Group J_1IEXCGRP
ExciseSupplier Vendor J_1ILIFNR
ExciseShipFrom Account Number of Supplier LIFNR
MaterialName Material Description TEXT40
Batch Batch Number CHARG
BEDRate BED percentage PRZ34
AEDRate Additional Excise Duty % PRZ34
SEDRate Special Excise Duty % PRZ34
NCCDRate NCCD Rate in % PRZ34
ECSRate ECS rate in % PRZ34
CESSRate Cess Rate PRZ34
AdditionalTax1Rate AT1 rate in % PRZ34
AdditionalTax2Rate AT1 rate in % PRZ34
AdditionalTax3Rate AT1 rate in % PRZ34
DeliveryDocument Reference Document 1 CHAR10
BillingDocument Reference Document 2 CHAR10
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_EXCISEDOCUMENTITEM.BASEUNIT == T006.MSEHI
  • I_EXCISEDOCUMENTITEM.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • I_EXCISEDOCUMENTITEM.BUSINESSAREA == TGSB.GSBER
  • I_EXCISEDOCUMENTITEM.MANDT == TGSB.MANDT
Foreign key for Currency key
  • Currency
  • Client
  • I_EXCISEDOCUMENTITEM.CURRENCY == TCURC.WAERS
  • I_EXCISEDOCUMENTITEM.MANDT == TCURC.MANDT
Receiving plant/issuing plant
  • Receiving plant/issuing plant
  • Client
  • I_EXCISEDOCUMENTITEM.ISSUINGRECEIVINGPLANT == T001W.WERKS
  • I_EXCISEDOCUMENTITEM.MANDT == T001W.MANDT
Foreign key for Material number
  • Material Number
  • Client
  • I_EXCISEDOCUMENTITEM.MATERIAL == MARA.MATNR
  • I_EXCISEDOCUMENTITEM.MANDT == MARA.MANDT
Plant Foreign key
  • Plant
  • Client
  • I_EXCISEDOCUMENTITEM.PLANT == T001W.WERKS
  • I_EXCISEDOCUMENTITEM.MANDT == T001W.MANDT
Foreign key for storage location
  • Plant
  • Storage location
  • Client
  • I_EXCISEDOCUMENTITEM.PLANT == T001L.WERKS
  • I_EXCISEDOCUMENTITEM.STORAGELOCATION == T001L.LGORT
  • I_EXCISEDOCUMENTITEM.MANDT == T001L.MANDT
Foreign key for unit of measure
  • Client
  • Unit of Measure
  • I_EXCISEDOCUMENTITEM.MANDT == T006.MANDT
  • I_EXCISEDOCUMENTITEM.UNITOFMEASURE == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Excise Transaction Type
  • Excise Transaction Type
  • Client
  • I_EXCISEDOCUMENTITEM.EXCISETRANSACTIONTYPE == J_1ITRAN.J_1ITRNTYP
  • I_EXCISEDOCUMENTITEM.MANDT == J_1ITRAN.MANDT