OIH_J_1BTXIX1

Tax calc.: ISS rules for sales and purchasing exeptions | #other | Component: Tariffs, Duties and Permits
Column Name Description
MANDT FK Client
LAND1 FK Country/Region Key
SHIPFROM FK Ship from location (tax region)
SHIPTO FK Ship to location (tax region)
CITY FK City Code
MATNR FK Material Number
NBMCODE FK Control code for consumption taxes in foreign trade
KUNNR FK Customer Number
CGROUP FK Customer tax group
VENDOR FK Account Number of Supplier
VEND_GROUP FK Vendor group (refinery/mill/other)
VALIDFROM Date from which the tax rule is valid
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
VALIDTO Date to which the tax rule is valid DATUM_INV
BASE Tax base (%) J_1BTXBASE
RATE Tax Rate J_1BTXRATE
Master Data Relations | to Other Relations ↓ Join Conditions
City Code
  • ?
  • City Code
  • Client
  • Country/Region Key
  • OIH_J_1BTXIX1.[column in domain "REGIO"] == T005G.REGIO
  • OIH_J_1BTXIX1.CITY == T005G.CITYC
  • OIH_J_1BTXIX1.MANDT == T005G.MANDT
  • OIH_J_1BTXIX1.LAND1 == T005G.LAND1
Customer Number
  • OIH_J_1BTXIX1.MANDT == KNA1.MANDT
  • OIH_J_1BTXIX1.KUNNR == KNA1.KUNNR
Country/Region Key
  • Country/Region Key
  • Client
  • OIH_J_1BTXIX1.LAND1 == T005.LAND1
  • OIH_J_1BTXIX1.MANDT == T005.MANDT
Client OIH_J_1BTXIX1.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • OIH_J_1BTXIX1.MATNR == MARA.MATNR
  • OIH_J_1BTXIX1.MANDT == MARA.MANDT
Control code for consumption taxes in foreign trade
  • Control code for consumption taxes in foreign trade
  • Client
  • Country/Region Key
  • OIH_J_1BTXIX1.NBMCODE == T604F.STEUC
  • OIH_J_1BTXIX1.MANDT == T604F.MANDT
  • OIH_J_1BTXIX1.LAND1 == T604F.LAND1
Ship from location (tax region)
  • Country/Region Key
  • Ship from location (tax region)
Ship to location (tax region)
  • Country/Region Key
  • Ship to location (tax region)
Account Number of Supplier
  • OIH_J_1BTXIX1.MANDT == LFA1.MANDT
  • OIH_J_1BTXIX1.VENDOR == LFA1.LIFNR
Other Relations | to Master Data Relations ↑ Join Conditions
Customer tax group
Vendor group (refinery/mill/other)