OIH_J1B_COP

Brazil: Controled prices table | #masterdata | Component: Tariffs, Duties and Permits
Column Name Description
MANDT FK Client
LAND1 FK Country/Region Key
STATE FK Region (State, Province, County)
CITY FK City Code
OIHVTYPE Vendor type (refinery/mill/other) (Brazil) Show values
MATNR FK Material Number
MTXGR FK Material tax group
VALIDFROM Date from which the tax rule is valid
Column Name Description
Column Name Description
Column Name Description
Column Name Description
OIHVTYPE Vendor type (refinery/mill/other) (Brazil) Show values
LOWEST Indicator lowest pump price Show values
Column Name Description Domain name
VALIDTO Date to which the tax rule is valid DATUM_INV
PUMPPRICE Pump price per unit OIH_J1B_PRICE
FACTOR Number of units for Sub.Trib. calc. (price per n units) DEC4_2
Master Data Relations Join Conditions
City Code
  • ?
  • City Code
  • Client
  • Country/Region Key
  • OIH_J1B_COP.[column in domain "REGIO"] == T005G.REGIO
  • OIH_J1B_COP.CITY == T005G.CITYC
  • OIH_J1B_COP.MANDT == T005G.MANDT
  • OIH_J1B_COP.LAND1 == T005G.LAND1
Country/Region Key
  • Country/Region Key
  • Client
  • OIH_J1B_COP.LAND1 == T005.LAND1
  • OIH_J1B_COP.MANDT == T005.MANDT
Client OIH_J1B_COP.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • OIH_J1B_COP.MATNR == MARA.MATNR
  • OIH_J1B_COP.MANDT == MARA.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • OIH_J1B_COP.MANDT == T005S.MANDT
  • OIH_J1B_COP.LAND1 == T005S.LAND1
  • OIH_J1B_COP.STATE == T005S.BLAND
Unit for price (Brazil tax)
  • OIH_J1B_COP.MANDT == T006.MANDT
  • OIH_J1B_COP.UNIT == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Material tax group