1. SAP Tutorial
  2. Oil & Gas

OIH_J_1BTXIX1 SAP table for – Tax calc.: ISS rules for sales and purchasing exeptions

Here we would like to draw your attention to OIH_J_1BTXIX1 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_1BTXIX1 is a SAP standard transp table used for storing Tax calc.: ISS rules for sales and purchasing exeptions related data in SAP. It comes under the package OIH_CV_BR.

SAP OIH_J_1BTXIX1 table

Table OIH_J_1BTXIX1 technical data

TableOIH_J_1BTXIX1
Data storingTax calc.: ISS rules for sales and purchasing exeptions
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_1BTXIX1 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_1BTXIX1 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
  • CITY : City Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • NBMCODE : Control code for consumption taxes in foreign trade
    Its a key field. Its data type is CHAR (Character String) with field length 16
  • KUNNR : Customer Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • CGROUP : Customer tax group
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • VENDOR : Account Number of Vendor or Creditor
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • VEND_GROUP : Vendor group (refinery/mill/other)
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • 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
  • BASE : Tax base (%)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • RATE : Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6

    • OIH_J_1BTXIX1 related tables

    • OIH_J_1BMSEG_NF : Link between Gain and Losses Movements and Nota Fiscal
    • OIH_J1B_ACSVAL : Brazil: Oil Access Values
    • OIH_J1B_TIN : Brazil: Check table for tax codes in Transfer Incoming
    • OIH_J_1BTXIS1 : Tax calc.: ISS rules for sales exeptions
    • OIH2M_J1B : Check table for material tax group
    • OIH_J1B_PPR : Brazil Tax: Pondered average price table for final consume
    • OIH_J_1BTXCI2 : Tax calc.: Complement of ICMS rules INSIDE CALCULATION
    • OIH_J1B_FAC : Brazil: Factor for calculation of PIS / COFINS ST
    • OIH2C_J1B : Check table for customer tax group
    • OIH_J1B_INC : Brazil: Incoming taxation table
    • OIH_J1B_TOU : Brazil: Check table for tax codes in Transfer Outgoing
    • OIH_J_1BTREGX : Tax region
    • OIH_J1B_TCH : Tax Calculation Commands Header
    • OIH_J1B_ZFD : Brazil tax: Sub. Trib. Discount for Zona Franca de Manaus
    • OIH_J1B_SDTXCD : SD tax code for ICMS ST calculation
    • OIH_J1B_ALC : Brazil: Percentage of alcohol in gasoline
    • OIH_J1B_PIC : Brazil: Printing exceptions for ICMS
    • OIH_J1B_SAL : Brazil: Check table for tax codes in sales process
    • OIH_J1B_COP : Brazil: Controled prices table
    • OIH_J_1BATL4T : Tax Law ICMS – Texts

    OIH_J_1BTXIX1 related transaction codes under SAP package OIH_CV_BR

    • O4K_J1B_16 : Complement ICMS rules inside calc.
    • O4K_J1B_13 : Maintain Controlled Price
    • O4K_J1B_20 : Maintain Post. exp. for ICMS compl.
    • O4K_J1B_12 : Maintain Acquisition Price Table
    • O4K_J1B_10 : Maintain Refinery Taxation Table
    • O4K_J1B_28 : Maintain PMPF price table
    • O4K_J1B_08 : Maintain Incoming Taxation Table
    • O4K_J1B_11 : Maintain Printing Exceptions ICMS
    • O5K_J1B_27 : Global plant business settings
    • O4K_J1B_23 : Nota Fiscal for gains/losses

    Related References

    Related Tutorials

    OIH_J_1BTXIS1 SAP table for – Tax calc.: ISS rules for sales exeptions

    OIH_J_1BTXIS1 table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Tax calc.: ISS...

    OIH_J_1BTXIC2 SAP table for – Tax calc.: ICMS rules (exceptions)

    OIH_J_1BTXIC2 table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Tax calc.: ICMS...

    OIH_J_1BTXCI2 SAP table for – Tax calc.: Complement of ICMS rules INSIDE CALCULATION

    OIH_J_1BTXCI2 table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Tax calc.: Complement...

    OIH_J_1BTXCI1 SAP table for – Tax calc.: Complement of ICMS rules

    OIH_J_1BTXCI1 table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Tax calc.: Complement...

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

    OIH_J_1BTXST1 table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Tax calc.: Sub.Trib....

    O4K_J1B_16 SAP tcode for – Complement ICMS rules inside calc.

    O4K_J1B_16 tcode in SAP IS-OIL (Downstream in IS-OIL) module. This transaction code is used for Complement ICMS rules inside calc.....

    OIH_J1B_PCK SAP table for – Brazil: Check table for tax codes in Purchasing

    OIH_J1B_PCK table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Brazil: Check table...

    «
    »