1. SAP Tutorial
  2. Oil & Gas

OIH_J1B_SAL_2 SAP table for – Brazil: ICMS Deferment

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

SAP OIH_J1B_SAL_2 table

Table OIH_J1B_SAL_2 technical data

TableOIH_J1B_SAL_2
Data storingBrazil: ICMS Deferment
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TDP
SAP PackageOIH_CV_BR
Delivery ClassG – Customer table, SAP may insert new data records but may not overwrite or delete existing ones
ComponentIS-OIL
Table CategoryTRANSP

SAP OIH_J1B_SAL_2 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_SAL_2 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
  • KUNNR : Customer Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • CUST_GROUP : Customer tax group
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • OPTYPE : Inter / intra operation type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • ORDER_TYPE : Sales Document Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • ITEM_CAT : Sales document item category
    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
  • TAX_CODE : SD tax code
    Its data type is CHAR (Character String) with field length 2
  • 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_SAL_2 related tables

    • OIH_J1B_CPR : Brazil: Posting exceptions for ICMS complement
    • OIH_J1B_RAF : Brazil: Refinery taxation table
    • OIH_J1B_PCK : Brazil: Check table for tax codes in Purchasing
    • OIH_J1B_ZFD : Brazil tax: Sub. Trib. Discount for Zona Franca de Manaus
    • OIH2M_J1B : Check table for material tax group
    • OIH2C_J1B : Check table for customer tax group
    • OIH_J_1BMSEG_NF : Link between Gain and Losses Movements and Nota Fiscal
    • OIH_J_1BTREGX : Tax region
    • OIH_J_1BTXIC2 : Tax calc.: ICMS rules (exceptions)
    • OIH_J1B_SAL : Brazil: Check table for tax codes in sales process
    • OIH_J1B_TOU : Brazil: Check table for tax codes in Transfer Outgoing
    • OIH_J_1BATL4T : Tax Law ICMS – Texts
    • OIH_J1B_COP : Brazil: Controled prices table
    • OIH_J1B_ACSDEF : Brazil: Oil Access Defintion
    • OIH_J1B_TIN : Brazil: Check table for tax codes in Transfer Incoming
    • OIH2V_J1B : Check table for vendor tax group
    • OIH_J1B_FAC : Brazil: Factor for calculation of PIS / COFINS ST
    • OIH_J1B_TCH : Tax Calculation Commands Header
    • OIH_J_1BTXCI1 : Tax calc.: Complement of ICMS rules
    • OIH_J_1BTXST1 : Tax calc.: Sub.Trib. rules

    OIH_J1B_SAL_2 related transaction codes under SAP package OIH_CV_BR

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

    Related References

    Related Tutorials

    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_J_1BATL4T SAP table for – Tax Law ICMS – Texts

    OIH_J_1BATL4T table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Tax Law 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_J1B_SDTXCD SAP table for – SD tax code for ICMS ST calculation

    OIH_J1B_SDTXCD table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of SD tax code...

    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...

    O4K_J1B_20 SAP tcode for – Maintain Post. exp. for ICMS compl.

    O4K_J1B_20 tcode in SAP IS-OIL (Downstream in IS-OIL) module. This transaction code is used for Maintain Post. exp. for ICMS...

    «
    »