OIH_J1B_SAL_2

Brazil: ICMS Deferment | #other | Component: Tariffs, Duties and Permits
Column Name Description
MANDT FK Client
LAND1 FK Country/Region Key
TXREG FK Tax Region
OIHVTYPE Vendor type (refinery/mill/other) (Brazil) Show values
MATNR FK Material Number
MTXGR FK Material tax group
KUNNR FK Customer Number
CUST_GROUP FK Customer tax group
OPTYPE Inter / intra operation type Show values
ORDER_TYPE FK Sales Document Type
ITEM_CAT FK Sales document item category
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
OPTYPE Inter / intra operation type Show values
Column Name Description Domain name
VALIDTO Date to which the tax rule is valid DATUM_INV
Master Data Relations | to Other Relations ↓ Join Conditions
Sales document item category
  • Sales document item category
  • Client
  • OIH_J1B_SAL_2.ITEM_CAT == TVPT.PSTYV
  • OIH_J1B_SAL_2.MANDT == TVPT.MANDT
Customer Number
  • OIH_J1B_SAL_2.MANDT == KNA1.MANDT
  • OIH_J1B_SAL_2.KUNNR == KNA1.KUNNR
Country/Region Key
  • Country/Region Key
  • Client
  • OIH_J1B_SAL_2.LAND1 == T005.LAND1
  • OIH_J1B_SAL_2.MANDT == T005.MANDT
Client OIH_J1B_SAL_2.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • OIH_J1B_SAL_2.MATNR == MARA.MATNR
  • OIH_J1B_SAL_2.MANDT == MARA.MANDT
Sales Document Type
  • OIH_J1B_SAL_2.MANDT == TVAK.MANDT
  • OIH_J1B_SAL_2.ORDER_TYPE == TVAK.AUART
SD tax code
Tax law: ICMS
Tax law: IPI
COFINS Tax Law
PIS Tax Law
Tax Region
  • Country/Region Key
  • Tax Region
Other Relations | to Master Data Relations ↑ Join Conditions
Customer tax group
Material tax group