J_1IITMDTL

Item Details - for Capital goods and subcontracting | #transactional | Component: Logistics India
Column Name Description
MANDT FK Client
TRNTYP FK Excise Transaction Type
MJAHR Material Document Year
MBLNR Number of Material Document
ZEILE Line Number
Column Name Description
💲 Currency (EXCUR):
EXBED Basic Excise Duty
EXSED Special Excise Duty
EXAED Additional Excise Duty
Column Name Description
📏 Base Unit of Measure (MEINS):
MENGE Quantity
RMENGE Quantity remaining to be sold/installed
Column Name Description
CPUDT Excise Document Entry Date
CPUTM Time of Entry
Column Name Description
STATUS Material Type Show values
RIND1 Reference Document Type 1 Show values
RIND2 Reference Document Type 2 Show values
Column Name Description Domain name
CHAPID Chapter ID CHAR12
RDOC1 Reference document CHAR12
RYEAR1 Reference year 1 CHAR4
RDOC2 Reference Document 2 CHAR10
RYEAR2 Reference year 2 CHAR4
SERIAL1 Register Entry Serial Number NUMC10
SYEAR1 Year of Register Entry NUMC4
SERIAL2 Serial Number NUMC10
SYEAR2 Year of Register Entry NUMC4
USNAM Changed by the user CHAR12
Master Data Relations Join Conditions
Batch number
  • Material Number
  • Client
  • Batch Number
  • J_1IITMDTL.MATNR == MCH1.MATNR
  • J_1IITMDTL.MANDT == MCH1.MANDT
  • J_1IITMDTL.CHARG == MCH1.CHARG
Currency key
  • J_1IITMDTL.MANDT == TCURC.MANDT
  • J_1IITMDTL.EXCUR == TCURC.WAERS
Account Number of Supplier
  • J_1IITMDTL.MANDT == LFA1.MANDT
  • J_1IITMDTL.LIFNR == LFA1.LIFNR
Client J_1IITMDTL.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • J_1IITMDTL.MATNR == MARA.MATNR
  • J_1IITMDTL.MANDT == MARA.MANDT
Unit of measure
  • J_1IITMDTL.MANDT == T006.MANDT
  • J_1IITMDTL.MEINS == T006.MSEHI
Plant
  • J_1IITMDTL.MANDT == T001W.MANDT
  • J_1IITMDTL.WERKS == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Excise Transaction Type
  • Excise Transaction Type
  • Client