1. SAP Tutorial
  2. Oil & Gas

OIH_J1B_INC SAP table for – Brazil: Incoming taxation table

Here we would like to draw your attention to OIH_J1B_INC 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_J1B_INC is a SAP standard transp table used for storing Brazil: Incoming taxation table related data in SAP. It comes under the package OIH_CV_BR.

SAP OIH_J1B_INC table

Table OIH_J1B_INC technical data

TableOIH_J1B_INC
Data storingBrazil: Incoming taxation table
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TDP
SAP PackageOIH_CV_BR
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIH_J1B_INC 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_J1B_INC 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
  • TXREG : 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
  • MTXGR : Material tax group
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • LIFNR : Account Number of Vendor or Creditor
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • VGROUP : Vendor group (refinery/mill/other)
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • MOVTP : Movement type (business operation) for taxes Brazil
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • OPTYPE : Inter / intra operation type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • 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
  • CREDIT_IPI : IPI credit allowed
    Its data type is CHAR (Character String) with field length 1
  • CREDIT_ICMS : ICMS credit allowed (Brazil taxes)
    Its data type is CHAR (Character String) with field length 1
  • TAXTYPE : Incoming taxation type (Brazil)
    Its data type is CHAR (Character String) with field length 1
  • PERCENT : Percentage of backward sub.trib. collected
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • MIXPROD : Product to be mixed with
    Its data type is CHAR (Character String) with field length 18
  • TXLW1 : Tax law: ICMS
    Its data type is CHAR (Character String) with field length 3
  • TXLW2 : Tax law: IPI
    Its data type is CHAR (Character String) with field length 3
  • TXLW4 : COFINS Tax Law
    Its data type is CHAR (Character String) with field length 3
  • TXLW5 : PIS Tax Law
    Its data type is CHAR (Character String) with field length 3

    • OIH_J1B_INC related tables

    • OIH_J1B_RAF : Brazil: Refinery taxation table
    • OIH_J1B_PIS : Brazil: PIS/COFINS taxation table (exactly one entry)
    • OIH_J_1BATL4T : Tax Law ICMS – Texts
    • OIH_J1B_TOU : Brazil: Check table for tax codes in Transfer Outgoing
    • OIH_J1B_ACSVAL : Brazil: Oil Access Values
    • OIH_J1B_TCI : Brazilian Tax Calculation Commands Items
    • OIH_J1B_PCK : Brazil: Check table for tax codes in Purchasing
    • OIH_J1B_SAL_2 : Brazil: ICMS Deferment
    • OIH_J_1BTXCI1 : Tax calc.: Complement of ICMS rules
    • OIH_J1B_ALC : Brazil: Percentage of alcohol in gasoline
    • OIH_J_1BATL4 : Tax Law PIS/COFINS
    • OIH_J1B_PPR : Brazil Tax: Pondered average price table for final consume
    • OIH_J_1BTREGX : Tax region
    • OIH_J_1BTXCI2 : Tax calc.: Complement of ICMS rules INSIDE CALCULATION
    • OIH_J1B_FAC : Brazil: Factor for calculation of PIS / COFINS ST
    • OIH_J1B_CON : Brazil: Convenio application rules per state
    • OIH_J1B_TIN : Brazil: Check table for tax codes in Transfer Incoming
    • OIH_J1B_TCH : Tax Calculation Commands Header
    • OIH_J_1BTXST1 : Tax calc.: Sub.Trib. rules
    • OIH2M_J1B : Check table for material tax group

    OIH_J1B_INC related transaction codes under SAP package OIH_CV_BR

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

    Related References

    Related Tutorials

    OIH_J1B_RAF SAP table for – Brazil: Refinery taxation table

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

    O4K_J1B_08 SAP tcode for – Maintain Incoming Taxation Table

    O4K_J1B_08 tcode in SAP IS-OIL (Downstream in IS-OIL) module. This transaction code is used for Maintain Incoming Taxation Table. See...

    OIH_J1B_PIS SAP table for – Brazil: PIS/COFINS taxation table (exactly one entry)

    OIH_J1B_PIS table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Brazil: PIS/COFINS taxation...

    OIH_J1B_TIN SAP table for – Brazil: Check table for tax codes in Transfer Incoming

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

    OIH_J1B_PIC SAP table for – Brazil: Printing exceptions for ICMS

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

    OIH_J1B_CPR SAP table for – Brazil: Posting exceptions for ICMS complement

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

    OIH_J1B_TOU SAP table for – Brazil: Check table for tax codes in Transfer Outgoing

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

    «
    »