OIH_J1B_APR SAP table for – Brazil tax: Acquisition price table

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

SAP OIH_J1B_APR table

Table OIH_J1B_APR technical data

TableOIH_J1B_APR
Data storingBrazil tax: Acquisition price 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_APR 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_APR table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PLANT : Plant
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • TXREG : Tax Region
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • PRODUCT : 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
  • VENDOR : Account Number of Vendor or Creditor
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • 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
  • APRICE : Acquisition price per unit
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • APRICE_P : Acq.price including charges per unit
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • FACTOR : Number of units for Sub.Trib. calc. (price per n units)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • UNIT : Unit for price (Brazil tax)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • OPTYPE : Inter / intra operation type
    Its data type is CHAR (Character String) with field length 1
  • LOWEST_APR : Indicator lowest Acquisition price
    Its data type is CHAR (Character String) with field length 1