OIRADBT SAP (Document base table) Table details

Dictionary Type: Table
Description: Document base table




ABAP Code to SELECT data from OIRADBT
Related tables to OIRADBT
Access table OIRADBT




Table field list including key, data, relationships and ABAP select examples

OIRADBT is a standard SAP Table which is used to store Document base table data and is available within R/3 SAP systems depending on the version and release level.

The OIRADBT table consists of various fields, each holding specific information or linking keys about Document base table data available in SAP. These include LINKNR (Link number), ITLINKNR (Item link number), LINKYEAR (Document link number year), PBLNR (Business location identifier (IS-Oil MRN)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP OIRADBT table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
LINKNRLink number OIRA_LINKNRNUMC10NUMC10
ITLINKNRItem link number OIRA_ITLINKNRNUMC6Assigned to domainPOSNR
LINKYEARDocument link number year OIRA_JAHRNUMC4GJAHRGJAHR
PBLNRBusiness location identifier (IS-Oil MRN) OIF_PBLNRCHAR10Assigned to domainALPHAOIF_PBLNROI0OIFB
DATATYPEData type OIRA_DATATYPECHAR3OIRA_DATATYPE
SRCETABSource table OIRA_SRCETABCHAR16OIRA_SRCETAB
RNBTBusiness type OIRA_RNBTCHAR4Assigned to domainOIRA_RNBTOIRA_0
PARFNMRN business partner role / relation type OIF_PARFNCHAR4Assigned to domainOIF_PARFN
FTMSTMStart of partner function validity period: time stamp OIF_FTMSTMNUMC14OIF_TMSTM
PARPOSPartner counter OIF_PARPOSNUMC3OIF_PARPOS
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
STYPService type OIRA_STYPCHAR4Assigned to domainOIRA_STYPOIR_ST
VKDATSSR PC: Sales date at the service station OIRE_VKDATDATS8DATSOIRE_VKDAT
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
CHOBJSSR PC: Clearing house OIRE_CHOBJCHAR6Assigned to domainOIRE_CHOBJ
SSR_CCINSSSR PC: Payment card type OIRE_CCINSCHAR4Assigned to domainOIRE_CCINSOIRE_CCINS
STORNOSSR PC: Reversal indicator OIRE_STORNOCHAR1CHAR1
COMPFLComplaint indicator for OIRADBT entries OIRA_COMPFLCHAR1CHAR1
VRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
DCINDDebit/Credit indicator OIRA_DCINDCHAR1OIRE_DCIND
KBETRRate (condition amount or percentage) KBETRCURR11(2) WERTV6
KONWARate unit (currency or percentage) KONWACUKY5Assigned to domainWAERS
KPEINCondition pricing unit KPEINDEC5KPEIN
KMEINCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
MENGESSR PC: Quantity sold at the business location OIRE_MENGEQUAN13(3) MENG13V
BRTWRSSR PC: Gross value OIRE_BRTWRCURR13(2) WERTV7
STPARTPROCPartially processed indicator for Settlement transmission OIRE_SETTRANPARTPROCCHAR1YESNO
SEQNRGMM: Sequence number of meter assigned to customer OII_GSEQNRCHAR10ALPHAOII_SEQNR
TNKNRSequence number of SO assigned to business location OII_BSEQNRCHAR10ALPHAOII_SEQNR
HDRNRSSR PC: DTF payment card transaction number (internal) OIRE_UPLNRCHAR10CHAR10OIRE_UPLNR
ITMNRItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
GMMNRGMM: Number of general meter OII_GMMNRCHAR20Assigned to domainALPHAOII_GMMNROIJ
ITMSTMUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
METREVSSR: Meter event type OIRC_METREVCHAR2Assigned to domainOIRC_METREV
TRANSYEARDocument link number year OIRA_JAHRNUMC4GJAHRGJAHR
SOCNRSOC: Storage object characteristic segment number OII_SOCNRCHAR20Assigned to domainOII_SOCNR
ETMSTMSSR Stocks - Tank dip time stamp OIRC_TMSTMDEC15TZNTSTMPS
SOCEVSOC event OII_SOCEVCHAR2Assigned to domainOII_SOCEV
KWAEHCondition currency (for cumulation fields) KWAEHCUKY5Assigned to domainWAERSFWS
SRCD_DATESSR - Source data date OIRA_SRCD_DATEDATS8DATUM
SRCD_TIMESSR - Source date time OIRA_SRCD_TIMETIMS6UZEIT
COUNTERTransaction counter OIRA_COUNTERINT410OIRA_COUNTER
PROCINDProcessed record indicator OIRA_PROCINDCHAR1OIRA_PROCIND
OIRA_CUSTDummy function in length 1 DUMMYCHAR1DUMMY
IS01Subsequent process indicator for document base table OIRA_INDCHAR1CHAR1
MM01Subsequent process indicator for document base table OIRA_INDCHAR1CHAR1
MM02Subsequent process indicator for document base table OIRA_INDCHAR1CHAR1
PC02Subsequent process indicator for document base table OIRA_INDCHAR1CHAR1

Key field Non-key field



How do I retrieve data from SAP table OIRADBT using ABAP code

The following ABAP code Example will allow you to do a basic selection on OIRADBT to SELECT all data from the table
DATA: WA_OIRADBT TYPE OIRADBT.

SELECT SINGLE *
FROM OIRADBT
INTO CORRESPONDING FIELDS OF WA_OIRADBT
WHERE...

How to access SAP table OIRADBT

Within an ECC or HANA version of SAP you can also view further information about OIRADBT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!