J_1IMATEXP

Exceptional materials excise rates | #masterdata | Component: Logistics India
Column Name Description
MANDT FK Client
J_1IWERKS FK Plant
J_1IMATNR FK Material Number
LIFNR Account Number of Supplier
VALIDFROM Date from which the tax rule is valid
EDTYPE Type of Excise duty Show values
Column Name Description
💲 Condition Unit (Currency or Percentage) (KONWA):
J_1IEXPAMT Excise Duty Rate
Column Name Description
Column Name Description
AEDAT Last Changed On
Column Name Description
EDTYPE Type of Excise duty Show values
Column Name Description Domain name
VALIDTO Date to which the tax rule is valid DATUM_INV
CHAPID Chapter ID CHAR12
J_1IEXPRAT Rate of Excise Duty PRZ34
KPEIN Condition Pricing Unit KPEIN
USNAM Changed by the user CHAR12
Master Data Relations Join Conditions
Material existence check
  • Material Number
  • Client
  • J_1IMATEXP.J_1IMATNR == MARA.MATNR
  • J_1IMATEXP.MANDT == MARA.MANDT
Plant check
  • J_1IMATEXP.MANDT == T001W.MANDT
  • J_1IMATEXP.J_1IWERKS == T001W.WERKS
Condition Unit
  • J_1IMATEXP.MANDT == T006.MANDT
  • J_1IMATEXP.KMEIN == T006.MSEHI
Condition Unit (Currency or Percentage)
  • J_1IMATEXP.MANDT == TCURC.MANDT
  • J_1IMATEXP.KONWA == TCURC.WAERS
Client check J_1IMATEXP.MANDT == T000.MANDT