SAP table OIRADBT has 4 primary key fields being MANDT,LINKNR,ITLINKNR,LINKYEAR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
MANDT
Client
CLNT
3
0
MANDT
LINKNR
Link number
NUMC
10
0
OIRA_LINKNR
ITLINKNR
Item link number
NUMC
6
0
OIRA_ITLINKNR
LINKYEAR
Document link number year
NUMC
4
0
OIRA_JAHR
PBLNR
Business location identifier (IS-Oil MRN)
CHAR
10
0
OIF_PBLNR
DATATYPE
Data type
CHAR
3
0
OIRA_DATATYPE
DR
Dip readings
MR
Meter readings
PC
Payment Cards
SRCETAB
Source table
CHAR
16
0
OIRA_SRCETAB
RNBT
Business type
CHAR
4
0
*
OIRA_RNBT
PARFN
MRN business partner role / relation type
CHAR
4
0
*
OIF_PARFN
FTMSTM
Start of partner function validity period: time stamp
NUMC
14
0
OIF_FTMSTM
PARPOS
Partner counter
NUMC
3
0
OIF_PARPOS
MATNR
Material Number
CHAR
40
0
MATNR
STYP
Service type
CHAR
4
0
*
OIRA_STYP
VKDAT
SSR PC: Sales date at the service station
DATS
8
0
OIRE_VKDAT
WERKS
Plant
CHAR
4
0
WERKS_D
LGORT
Storage location
CHAR
4
0
*
LGORT_D
BUKRS
Company Code
CHAR
4
0
BUKRS
CHOBJ
SSR PC: Clearing house
CHAR
6
0
*
OIRE_CHOBJ
SSR_CCINS
SSR PC: Payment card type
CHAR
4
0
*
OIRE_CCINS
STORNO
SSR PC: Reversal indicator
CHAR
1
0
OIRE_STORNO
COMPFL
Complaint indicator for OIRADBT entries
CHAR
1
0
OIRA_COMPFL
VRKME
Sales unit
UNIT
3
0
*
VRKME
DCIND
Debit/Credit indicator
CHAR
1
0
OIRA_DCIND
KBETR
Condition Amount or Percentage
CURR
11
2
KBETR
KONWA
Condition Unit (Currency or Percentage)
CUKY
5
0
*
KONWA
KPEIN
Condition Pricing Unit
DEC
5
0
KPEIN
KMEIN
Condition Unit
UNIT
3
0
*
KMEIN
MENGE
SSR PC: Quantity sold at the business location
QUAN
13
3
OIRE_MENGE
BRTWR
SSR PC: Gross value
CURR
13
2
OIRE_BRTWR
STPARTPROC
Partially processed indicator for Settlement transmission
CHAR
1
0
OIRE_SETTRANPARTPROC
SEQNR
GMM: Sequence number of meter assigned to customer
CHAR
10
0
OII_GSEQNR
TNKNR
Sequence number of SO assigned to business location
CHAR
10
0
OII_BSEQNR
HDRNR
SSR PC: DTF payment card transaction number (internal)
CHAR
10
0
OIRE_UPLNR
ITMNR
Item number of the SD document
NUMC
6
0
POSNR
GMMNR
GMM: Number of general meter
CHAR
20
0
*
OII_GMMNR
ITMSTM
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
DEC
15
0
TIMESTAMP
METREV
SSR: Meter event type
CHAR
2
0
*
OIRC_METREV
TRANSYEAR
Document link number year
NUMC
4
0
OIRA_JAHR
SOCNR
SOC: Storage object characteristic segment number
CHAR
20
0
*
OII_SOCNR
ETMSTM
SSR Stocks - Tank dip time stamp
DEC
15
0
OIRC_TMSTM
SOCEV
SOC event
CHAR
2
0
*
OII_SOCEV
KWAEH
Condition Currency (for Cumulation Fields)
CUKY
5
0
*
KWAEH
SRCD_DATE
SSR - Source data date
DATS
8
0
OIRA_SRCD_DATE
SRCD_TIME
SSR - Source date time
TIMS
6
0
OIRA_SRCD_TIME
COUNTER
Transaction counter
INT4
10
0
OIRA_COUNTER
PROCIND
Processed record indicator
CHAR
1
0
OIRA_PROCIND
Record has not been processed
X
Record has been processed
OIRA_CUST
Dummy function in length 1
CHAR
1
0
DUMMY
IS01
Subsequent process indicator for document base table
CHAR
1
0
OIRA_IND
MM01
Subsequent process indicator for document base table
CHAR
1
0
OIRA_IND
MM02
Subsequent process indicator for document base table
CHAR
1
0
OIRA_IND
PC02
Subsequent process indicator for document base table