1. SAP Tutorial
  2. Oil & Gas

OIH_J1B_SAL SAP table for – Brazil: Check table for tax codes in sales process

Here we would like to draw your attention to OIH_J1B_SAL 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 is a SAP standard transp table used for storing Brazil: Check table for tax codes in sales process related data in SAP. It comes under the package OIH_CV_BR.

SAP OIH_J1B_SAL table

Table OIH_J1B_SAL technical data

TableOIH_J1B_SAL
Data storingBrazil: Check table for tax codes in sales process
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 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 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INT_OP : Inter / intra operation type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • OIHVTYPE : Vendor type (refinery/mill/other) (Brazil)
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • CUST_GROUP : Customer tax group
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • MAT_TAX_GR : Material tax group
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • PRICE_CONTROL : Price controlled
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • TAXATION_ORIG : Taxation at origin
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • TAXATION_DEST : Taxation at destination
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • OIHCV03 : Convenio 03
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • OIHCV80O : Convenio 80 at origin
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • OIHCV80D : Convenio 80 at destin.
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • ZONA_FRANCA : Flag indicating whether operation involves Zona Franca
    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
  • TAX_CODE : SD tax code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • OIHCREDIPI : IPI credit allowed
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • DEFAULT_TXCD : Default Tax Code for Brazil Localization
    Its data type is CHAR (Character String) with field length 1
  • 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
  • LEG_CLAIM : Indicator: customer is legal claimant for this case
    Its data type is CHAR (Character String) with field length 1
  • PUR_NOTAX : Indicator: for this oper. no tax paid when purchasing
    Its data type is CHAR (Character String) with field length 1
  • PISCOF_EXC : PIS/COFINS exception for reading OIH_J1B_PIS
    Its data type is CHAR (Character String) with field length 1
  • 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 related tables

    • OIH_J1B_SSTAD : Brazil tax: Determines Accounts for posting Split of S. T.
    • OIH_J1B_PIC : Brazil: Printing exceptions for ICMS
    • OIH_J_1BTXST1 : Tax calc.: Sub.Trib. rules
    • OIH_J_1BTXIX1 : Tax calc.: ISS rules for sales and purchasing exeptions
    • OIH_J1B_RAF : Brazil: Refinery taxation table
    • OIH_J1B_ACSDEF : Brazil: Oil Access Defintion
    • OIH_J1B_SAL_2 : Brazil: ICMS Deferment
    • OIH_J1B_ZFD : Brazil tax: Sub. Trib. Discount for Zona Franca de Manaus
    • OIH_J1B_PPR : Brazil Tax: Pondered average price table for final consume
    • OIH2V_J1B : Check table for vendor tax group
    • OIH_J1B_ALC : Brazil: Percentage of alcohol in gasoline
    • OIH2C_J1B : Check table for customer tax group
    • OIH_J1B_SDTXCD : SD tax code for ICMS ST calculation
    • OIH_J1B_TIN : Brazil: Check table for tax codes in Transfer Incoming
    • OIH_J1B_PCK : Brazil: Check table for tax codes in Purchasing
    • OIH_J1B_TCI : Brazilian Tax Calculation Commands Items
    • OIH_J1B_COP : Brazil: Controled prices table
    • OIH_J_1BTXIS1 : Tax calc.: ISS rules for sales exeptions
    • OIH_J1B_APR : Brazil tax: Acquisition price table
    • OIH_J_1BATL4 : Tax Law PIS/COFINS

    OIH_J1B_SAL related transaction codes under SAP package OIH_CV_BR

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

    Related References

    Related Tutorials

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

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

    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_SSTAD SAP table for – Brazil tax: Determines Accounts for posting Split of S. T.

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

    OIH_J1B_ZFD SAP table for – Brazil tax: Sub. Trib. Discount for Zona Franca de Manaus

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

    OIH_J1B_APR SAP table for – Brazil tax: Acquisition price table

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

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

    «
    »