OIH_J_1BTXST1 SAP table for – Tax calc.: Sub.Trib. rules

Here we would like to draw your attention to OIH_J_1BTXST1 table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIH_J_1BTXST1 is a SAP standard transp table used for storing Tax calc.: Sub.Trib. rules related data in SAP. It comes under the package OIH_CV_BR.

SAP OIH_J_1BTXST1 table

Table OIH_J_1BTXST1 technical data

TableOIH_J_1BTXST1
Data storingTax calc.: Sub.Trib. rules
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TDP
SAP PackageOIH_CV_BR
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentIS-OIL
Table CategoryTRANSP

SAP OIH_J_1BTXST1 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIH_J_1BTXST1 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LAND1 : Country Key
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • SHIPFROM : Ship from location (tax region)
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • SHIPTO : Ship to location (tax region)
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • OIHVTYPE : Vendor type (refinery/mill/other) (Brazil)
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • OIHMTXGR : Material tax group
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • STGRP : Customer group for Substituiçao Tributária calculation
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • VALIDFROM : Date from which the tax rule is valid
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • VALIDTO : Date to which the tax rule is valid
    Its data type is CHAR (Character String) with field length 8
  • SUR_TYPE : Sub.Trib. calculation rule
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • RATE : Sub.Trib. surcharge percentage rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • PRICE : Sub.Trib. fixed price per unit
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • FACTOR : Number of units for Sub.Trib. calc. (price per n units)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • UNIT : Unit for Sub.Trib. calculation (price per n units)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • BASERED1 : Sub.Trib. Base Reduction 1 (Federal) (in %)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • BASERED2 : Sub.Trib. Base Reduction 2 (State) (in %)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • ICMSBASER : ICMS Reduction for Sub.Trib. (in %)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • TXLW1 : Tax law: ICMS
    Its data type is CHAR (Character String) with field length 3
  • MINPRICE : Minimum Price Per Item Is Basis for Substituição Tributária
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SURCHIN : Compare Minimum Price Without Surcharge
    Its data type is CHAR (Character String) with field length 1