1. Home
  2. Resources
  3. SAP Tables
  4. OIRADBT - Document base table

SAP Table OIRADBT

Document base table

OIRADBT (Document base table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIRADBT to other SAP tables.

Source: OIRADBT (Document base table)

OIRADBT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
LINKNR Link number OIRA_LINKNR NUMC 10 0
ITLINKNR Item link number OIRA_ITLINKNR NUMC 6 0
LINKYEAR Document link number year OIRA_JAHR NUMC 4 0
PBLNR Business location identifier (IS-Oil MRN) OIF_PBLNR CHAR 10 0
DATATYPE Data type OIRA_DATATYPE CHAR 3 0
PC Payment Cards
MR Meter readings
DR Dip readings
SRCETAB Source table OIRA_SRCETAB CHAR 16 0
RNBT Business type OIRA_RNBT CHAR 4 0
PARFN MRN business partner role / relation type OIF_PARFN CHAR 4 0
FTMSTM Start of partner function validity period: time stamp OIF_FTMSTM NUMC 14 0
PARPOS Partner counter OIF_PARPOS NUMC 3 0
MATNR Material Number MATNR CHAR 18 0
STYP Service type OIRA_STYP CHAR 4 0
VKDAT SSR PC: Sales date at the service station OIRE_VKDAT DATS 8 0
WERKS Plant WERKS_D CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
BUKRS Company Code BUKRS CHAR 4 0
CHOBJ SSR PC: Clearing house OIRE_CHOBJ CHAR 6 0
SSR_CCINS SSR PC: Payment card type OIRE_CCINS CHAR 4 0
STORNO SSR PC: Reversal indicator OIRE_STORNO CHAR 1 0
COMPFL Complaint indicator for OIRADBT entries OIRA_COMPFL CHAR 1 0
VRKME Sales unit VRKME UNIT 3 0
DCIND Debit/Credit indicator OIRA_DCIND CHAR 1 0
D Debit
C Credit
KBETR Rate (condition amount or percentage) KBETR CURR 11 2
KONWA Rate unit (currency or percentage) KONWA CUKY 5 0
KPEIN Condition pricing unit KPEIN DEC 5 0
KMEIN Condition unit KMEIN UNIT 3 0
MENGE SSR PC: Quantity sold at the business location OIRE_MENGE QUAN 13 3
BRTWR SSR PC: Gross value OIRE_BRTWR CURR 13 2
STPARTPROC Partially processed indicator for Settlement transmission OIRE_SETTRANPARTPROC CHAR 1 0
X Yes
NULL No
SEQNR GMM: Sequence number of meter assigned to customer OII_GSEQNR CHAR 10 0
TNKNR Sequence number of SO assigned to business location OII_BSEQNR CHAR 10 0
HDRNR SSR PC: DTF payment card transaction number (internal) OIRE_UPLNR CHAR 10 0
ITMNR Item number of the SD document POSNR NUMC 6 0
GMMNR GMM: Number of general meter OII_GMMNR CHAR 20 0
ITMSTM UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
METREV SSR: Meter event type OIRC_METREV CHAR 2 0
TRANSYEAR Document link number year OIRA_JAHR NUMC 4 0
SOCNR SOC: Storage object characteristic segment number OII_SOCNR CHAR 20 0
ETMSTM SSR Stocks - Tank dip time stamp OIRC_TMSTM DEC 15 0
SOCEV SOC event OII_SOCEV CHAR 2 0
KWAEH Condition currency (for cumulation fields) KWAEH CUKY 5 0
SRCD_DATE SSR - Source data date OIRA_SRCD_DATE DATS 8 0
SRCD_TIME SSR - Source date time OIRA_SRCD_TIME TIMS 6 0
COUNTER Transaction counter OIRA_COUNTER INT4 10 0
PROCIND Processed record indicator OIRA_PROCIND CHAR 1 0
X Record has been processed
NULL Record has not been processed
OIRA_CUST Dummy function in length 1 DUMMY CHAR 1 0
IS01 Subsequent process indicator for document base table OIRA_IND CHAR 1 0
MM01 Subsequent process indicator for document base table OIRA_IND CHAR 1 0
MM02 Subsequent process indicator for document base table OIRA_IND CHAR 1 0
PC02 Subsequent process indicator for document base table OIRA_IND CHAR 1 0