OIRADBT SAP table for – Document base table

Here we would like to draw your attention to OIRADBT 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). OIRADBT is a SAP standard transp table used for storing Document base table related data in SAP. It comes under the package OIR.

SAP OIRADBT table

Table OIRADBT technical data

TableOIRADBT
Data storingDocument base table
ModuleIS-OIL
Sub ModuleIS-OIL-DS-SSR
SAP PackageOIR
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LINKNR : Link number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • ITLINKNR : Item link number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • LINKYEAR : Document link number year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Document Base Table data fields
  • PBLNR : Business location identifier (IS-Oil MRN)
    Its data type is CHAR (Character String) with field length 10
  • DATATYPE : Data type
    Its data type is CHAR (Character String) with field length 3
  • SRCETAB : Source table
    Its data type is CHAR (Character String) with field length 16
  • RNBT : Business type
    Its data type is CHAR (Character String) with field length 4
  • PARFN : MRN business partner role / relation type
    Its data type is CHAR (Character String) with field length 4
  • FTMSTM : Start of partner function validity period: time stamp
    Its data type is NUMC (Character String with Digits Only) with field length 14
  • PARPOS : Partner counter
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • STYP : Service type
    Its data type is CHAR (Character String) with field length 4
  • VKDAT : SSR PC: Sales date at the service station
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • LGORT : Storage location
    Its data type is CHAR (Character String) with field length 4
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • CHOBJ : SSR PC: Clearing house
    Its data type is CHAR (Character String) with field length 6
  • SSR_CCINS : SSR PC: Payment card type
    Its data type is CHAR (Character String) with field length 4
  • STORNO : SSR PC: Reversal indicator
    Its data type is CHAR (Character String) with field length 1
  • COMPFL : Complaint indicator for OIRADBT entries
    Its data type is CHAR (Character String) with field length 1
  • VRKME : Sales unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DCIND : Debit/Credit indicator
    Its data type is CHAR (Character String) with field length 1
  • KBETR : Rate (condition amount or percentage)
    Its data type is CURR (Currency Field) with field length 11
  • KONWA : Rate unit (currency or percentage)
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • KPEIN : Condition pricing unit
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • KMEIN : Condition Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MENGE : SSR PC: Quantity sold at the business location
    Its data type is QUAN (Quantity field) with field length 13
  • BRTWR : SSR PC: Gross value
    Its data type is CURR (Currency Field) with field length 13
  • STPARTPROC : Partially processed indicator for Settlement transmission
    Its data type is CHAR (Character String) with field length 1
  • SEQNR : GMM: Sequence number of meter assigned to customer
    Its data type is CHAR (Character String) with field length 10
  • TNKNR : Sequence number of SO assigned to business location
    Its data type is CHAR (Character String) with field length 10
  • HDRNR : SSR PC: DTF payment card transaction number (internal)
    Its data type is CHAR (Character String) with field length 10
  • ITMNR : Item number of the SD document
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • GMMNR : GMM: Number of general meter
    Its data type is CHAR (Character String) with field length 20
  • ITMSTM : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • METREV : SSR: Meter event type
    Its data type is CHAR (Character String) with field length 2
  • TRANSYEAR : Document link number year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SOCNR : SOC: Storage object characteristic segment number
    Its data type is CHAR (Character String) with field length 20
  • ETMSTM : SSR Stocks – Tank dip time stamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SOCEV : SOC event
    Its data type is CHAR (Character String) with field length 2
  • KWAEH : Condition currency (for cumulation fields)
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • SRCD_DATE : SSR – Source data date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SRCD_TIME : SSR – Source date time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • COUNTER : Transaction counter
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PROCIND : Processed record indicator
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Customer fields in the DBT
  • OIRA_CUST : Dummy function in length 1
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Indicator fields for DBT
  • IS01 : Subsequent process indicator for document base table
    Its data type is CHAR (Character String) with field length 1
  • MM01 : Subsequent process indicator for document base table
    Its data type is CHAR (Character String) with field length 1
  • MM02 : Subsequent process indicator for document base table
    Its data type is CHAR (Character String) with field length 1
  • PC02 : Subsequent process indicator for document base table
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes