OIH_J1B_CON SAP table for – Brazil: Convenio application rules per state

Here we would like to draw your attention to OIH_J1B_CON 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_CON is a SAP standard transp table used for storing Brazil: Convenio application rules per state related data in SAP. It comes under the package OIH_CV_BR.

SAP OIH_J1B_CON table

Table OIH_J1B_CON technical data

TableOIH_J1B_CON
Data storingBrazil: Convenio application rules per state
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_CON 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_CON 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
  • CONVENIO : Brazilian tax convention (“convenio”)
    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