OIA10 SAP table for – Exchange – Netting document item

Here we would like to draw your attention to OIA10 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). OIA10 is a SAP standard transp table used for storing Exchange – Netting document item related data in SAP. It comes under the package OIA_FI.

SAP OIA10 table

Table OIA10 technical data

TableOIA10
Data storingExchange – Netting document item
ModuleIS-OIL
Sub ModuleIS-OIL-DS-EXG
SAP PackageOIA_FI
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIA10 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 OIA10 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • NETNUM : Exchange – netting document number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • NJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • ITNO : Exchange – netting document item number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • ITCAT : Exchange – netting document item type
    Its data type is CHAR (Character String) with field length 1
  • FIDOC : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • FIJAHR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FIBUKR : Company Code
    Its data type is CHAR (Character String) with field length 4
  • BUZEI : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DMBTR : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • SHKZG : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • LIFNR : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10
  • FIBUD : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FIBLA : Document type
    Its data type is CHAR (Character String) with field length 2
  • FIBSL : Posting Key
    Its data type is CHAR (Character String) with field length 2