SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | OIRC_DRREJ
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: Industry Solution Oil :: Downstream :: Service Station Retailing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0OIRC_DRREJ1411SSR Stocks - Dip readings rejected recordsService Station Retailing
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, PBLNR, RNBT, REC_SEQNR, SOCNR, ETMSTM, SOCEV, SLVNR, SLVIND, TOTALHEIGHT, TOTALHEIGHT_FLTP, WATERHEIGHT, WATERHEIGHT_FLTP, MDICH, DNSUN, QUAN_SKU, MEINS, QUAN_LVC, WATR_LVC, SHTMP, SHTEH, UL_IN_IND, VOLUN, LENUN, UMRSL, CMODE, FDICHEH, FDICH, COEFF, BDICHEH, BDICH, BHVALEH, BHVAL, TSTMP, TSTEH, MTTMP, MTTEH, THVAL, TDICHEH, TDICH, MTPRES, MTPRESEH, TPRED, TPREDEH, TPRHV, TPRHVEH, TTMPHV, TTMPHVEH, ATPRES, ATPRESEH, VAPRES, VAPRESEH, THVALEH, MTCOMBTMP, MTCOMBTEH, MTCOMBPRES, MTCOMBPRESEH, TSTMPCAL, TSTMPCALEH, TPREDCAL, TPREDCALEH, HYDRO, ABIND, ABFAC, MCF, BSWCN, BSWCNEH, HVCLS, HVCLS_TO, DEFAULT_GUID, ERDAT, ERZEIT, ERNAM, AEDAT, AEZEIT, AENAM, BLOIND, DELIND, CH4RATIO, N2RATIO, CO2RATIO, C2H6RATIO, C3H8RATIO, H2ORATIO, H2SRATIO, H2RATIO, CORATIO, O2RATIO, ISOC4H10RATIO, NC4H10RATIO, ISOC5H12RATIO, NC5H12RATIO, C6H14RATIO, C7H16RATIO, C8H18RATIO, C9H20RATIO, C10H22RATIO, HERATIO, ARRATIO, GASCOMPRATEH, MOLDEN, MOLDENEH, MOLWEIGHT, HYDROCARBMOLFRAC, MOLWEIGHTEH, CUSTPARCHAR1, CUSTPARFLOAT1, CUSTEH1, CUSTPARCHAR2, CUSTPARFLOAT2, CUSTEH2, CUSTPARCHAR3, CUSTPARFLOAT3, CUSTEH3, BUKRS, MATNR, TNKNR, DRDATE, DRTIME, TIME_ZONE, PR_NUMBER, WERKS, LGORT, RELSTOCK, QTYPER, TOL_STATUS, MM_QUAN, LINKNR, ITLINKNR, LINKYEAR, CHECK_STATUS, ACTSTOCK, MM_QUAN_POSTED, PROC_ONLINE, PROC_TYPE, STCODE, BEZEI, BLOCK, BLOCK_RELEASE, USR_IND, MAKTX FROM OIRC_DRREJ
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100CHAR(N' ')NoOIFSPBLOIF_PBLNR Allow NULL? 
3RNBTBusiness typenvarchar40CHAR(N' ')NoOIRARNBTOIRA_RNBT Allow NULL? 
4REC_SEQNRSSR Fuels - Sequential numbernvarchar50NUMC(N'00000')NoOIRC_SEQNR Allow NULL? 
5SOCNRSOC: Storage object characteristic segment numbernvarchar200CHAR(N' ')YesOIISOCKOII_SOCNR Allow NULL? 
6ETMSTMSSR Stocks - Tank dip time stampdecimal150DEC((0))YesOIRC_TMSTM
7SOCEVSOC eventnvarchar20CHAR(N' ')YesOIISOCEOII_SOCEV Allow NULL? 
8SLVNRSOC: Linear/volumetric conversion (strap) set numbernvarchar200CHAR(N' ')Yes*OII_SLVNR Allow NULL? 
9SLVINDSOC: recalibration index for strapping datanvarchar50NUMC(N'00000')YesOII_SLVIND Allow NULL? 
10TOTALHEIGHTTank dip, total heightdecimal133QUAN((0))YesOII_TOTALHEIGHT
11TOTALHEIGHT_FLTPSilo Mgmt: Tank strapping height in FLTPfloat1516FLTP((0))YesOII_HGT_FLTP
12WATERHEIGHTTank dip: water dip heightdecimal133QUAN((0))YesOII_WATERHEIGHT
13WATERHEIGHT_FLTPSilo Mgmt: Tank strapping height in FLTPfloat1516FLTP((0))YesOII_HGT_FLTP
14MDICHMaterial density (at ambient temperature)decimal133QUAN((0))YesOII_MATDENS
15DNSUNDensity UoM (Oil product/Silo)nvarchar30UNIT(N' ')Yes*OII_DNSUN Allow NULL? 
16QUAN_SKUQuantity in stock keeping unit/ base unit of measuredecimal133QUAN((0))YesOII_QUAN_SKU
17MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
18QUAN_LVCMaterial volume in LVC set UoMdecimal133QUAN((0))YesOII_QUAN_LVC
19WATR_LVCWater Volume in LVC set UoMdecimal133QUAN((0))YesOII_WATR_LVC
20SHTMPSilo shell temperaturefloat1516FLTP((0))YesOII_STTMP
21SHTEHSilo shell temperature unitnvarchar30UNIT(N' ')Yes*OII_STTEH Allow NULL? 
22UL_IN_INDDipping method (innage, ullage)char10CHAR(N' ')YesOII_UL_IN_IND Allow NULL? 
23VOLUNUoM - volumetric constant for lin./vol. conversion (BDRP)nvarchar30UNIT(N' ')Yes*OII_VOLUNC Allow NULL? 
24LENUNUoM - linear constant for lin./vol. conversion (BDRP)nvarchar30UNIT(N' ')Yes*OII_LENUNC Allow NULL? 
25UMRSLConversion Group (Oil, Natural Gas,..)nvarchar40CHAR(N' ')YesOIB01OIB_UMRSL Allow NULL? 
26CMODEConversion Modechar10CHAR(N' ')YesOIB_CMODE Allow NULL? 
27FDICHEHUnit for densities at standard/base conditionsnvarchar30UNIT(N' ')YesT006OIB_BDNEH Allow NULL? 
28FDICHFixed Densityfloat1516FLTP((0))YesOIB_FDICH
29COEFFQuantity Conversion Coefficientfloat1516FLTP((0))YesOIB_COEFF
30BDICHEHUnit for densities at standard/base conditionsnvarchar30UNIT(N' ')YesT006OIB_BDNEH Allow NULL? 
31BDICHOil/gas density at standard/base conditionsfloat1516FLTP((0))YesOIB_BDICH
32BHVALEHHeating value unit at standard/base conditions (natural gas)nvarchar30UNIT(N' ')YesT006OIB_BHVEH Allow NULL? 
33BHVALHeating value at standard/base conditions (natural gas)float1516FLTP((0))YesOIB_BHVAL
34TSTMPOil/Gas Test Temperature: Observed Densityfloat1516FLTP((0))YesOIB_TSTMP
35TSTEHTest Temperature Unit (Density): Measurementnvarchar30UNIT(N' ')YesT006OIB_TSTEH Allow NULL? 
36MTTMPOil/Gas Material Temperature: Observed Quantityfloat1516FLTP((0))YesOIB_MTTMP
37MTTEHOil/Gas Material Temperature Unit: Observed Quantitynvarchar30UNIT(N' ')YesT006OIB_MTTEH Allow NULL? 
38THVALHeating value at test conditions (natural gas): observedfloat1516FLTP((0))YesOIB_THVAL
39TDICHEHUnit for densities of petroleum products and natural gasnvarchar30UNIT(N' ')YesT006OIB_DNEH Allow NULL? 
40TDICHOil/Gas Test Densityfloat1516FLTP((0))YesOIB_TDICH
41MTPRESOil/gas material pressure: observed quantityfloat1516FLTP((0))YesOIB_MTPRES
42MTPRESEHOil/gas material pressure unit: observed quantitynvarchar30UNIT(N' ')YesT006OIB_MTPRESEH Allow NULL? 
43TPREDOil/gas test pressure: metering (obs. density)float1516FLTP((0))YesOIB_TPRED
44TPREDEHOil/Gas test press. unit: metering (density)nvarchar30UNIT(N' ')YesT006OIB_TPREDEH Allow NULL? 
45TPRHVNatural gas test pressure: combustion (obs. heating value )float1516FLTP((0))YesOIB_TPRHV
46TPRHVEHNatural gas test pressure unit: combustion ( heating value )nvarchar30UNIT(N' ')YesT006OIB_TPRHVEH Allow NULL? 
47TTMPHVNatural gas test temperature: combustion (obs. heat. value )float1516FLTP((0))YesOIB_TTMPHV
48TTMPHVEHNatural gas test temp. unit: combustion (heating value)nvarchar30UNIT(N' ')YesT006OIB_TTMPHVEH Allow NULL? 
49ATPRESAtmospheric pressure of the air surrounding a productfloat1516FLTP((0))YesOIB_ATPRES
50ATPRESEHAtmospheric pressure unitnvarchar30UNIT(N' ')YesT006OIB_ATPRESEH Allow NULL? 
51VAPRESVapor pressure of liquid petroleum gases (LPG)float1516FLTP((0))YesOIB_VAPRES
52VAPRESEHVapor pressure unit (LPG)nvarchar30UNIT(N' ')YesT006OIB_VAPRESEH Allow NULL? 
53THVALEHHeating value unitnvarchar30UNIT(N' ')YesT006OIB_HVEH Allow NULL? 
54MTCOMBTMPNatural gas material combustion temp.: observed quantityfloat1516FLTP((0))YesOIB_MTCOMBTMP
55MTCOMBTEHNatural gas material combustion temp. unit: obs. quantitynvarchar30UNIT(N' ')YesT006OIB_MTCOMBTEH Allow NULL? 
56MTCOMBPRESNatural gas material combustion pressure: observed quantityfloat1516FLTP((0))YesOIB_MTCOMBPRES
57MTCOMBPRESEHNatural gas material combustion pres. unit: oberved quantitynvarchar30UNIT(N' ')YesT006OIB_MTCOMBPRESEH Allow NULL? 
58TSTMPCALNatural gas: Calorimeter test temperature (density)float1516FLTP((0))YesOIB_TSTMPCAL
59TSTMPCALEHNatural gas: unit for calorimeter test temperature (density)nvarchar30UNIT(N' ')YesT006OIB_TSTMPCALEH Allow NULL? 
60TPREDCALNatural gas: Calorimeter test pressure (density)float1516FLTP((0))YesOIB_TPREDCAL
61TPREDCALEHNatural gas: Unit for calorimeter test pressure (density)nvarchar30UNIT(N' ')YesT006OIB_TPREDCALEH Allow NULL? 
62HYDROHydrometer Correction Indicatorchar10CHAR(N' ')YesOIB_HYDRO Allow NULL? 
63ABINDAir Bouyancy Indicatorchar10CHAR(N' ')YesOIB_ABIND Allow NULL? 
64ABFACAir Bouyancy Factordecimal31DEC((0))YesOIB_ABFAC
65MCFMeter correction factorfloat1516FLTP((0))YesOIB_MCF1
66BSWCNBSW %float1516FLTP((0))YesOIB_BSWCN
67BSWCNEHBSW % unit (volume %, mol %, mass % or proportion )nvarchar30UNIT(N' ')YesT006OIB_BSWCNEH Allow NULL? 
68HVCLSHeating value class (calorific value class)nvarchar20CHAR(N' ')YesOIB_HVCLS Allow NULL? 
69HVCLS_TOHeating value class (calorific value class)nvarchar20CHAR(N' ')YesOIB_HVCLS Allow NULL? 
70DEFAULT_GUIDGUID in 'CHAR' Format in Uppercasenvarchar320CHAR(N' ')YesGUID_32 Allow NULL? 
71ERDATDate record creatednvarchar80DATS(N'00000000')YesOII_ERDAT Allow NULL? 
72ERZEITTime record creatednvarchar60TIMS(N'000000')YesOII_ERZEIT Allow NULL? 
73ERNAMUser who created recordnvarchar120CHAR(N' ')YesOII_ERNAM Allow NULL? 
74AEDATDate record changednvarchar80DATS(N'00000000')YesOII_AEDAT Allow NULL? 
75AEZEITTime record changednvarchar60TIMS(N'000000')YesOII_AEZEIT Allow NULL? 
76AENAMUser who changed recordnvarchar120CHAR(N' ')YesOII_AENAM Allow NULL? 
77BLOINDBlocking indicatorchar10CHAR(N' ')YesOII_BLOIND Allow NULL? 
78DELINDDeletion indicatorchar10CHAR(N' ')YesOII_DELIND Allow NULL? 
79CH4RATIONatural gas CH4 content (ratio)float1516FLTP((0))YesOIB_CH4RAT
80N2RATIONatural gas N2 (nitrogen) content (ratio)float1516FLTP((0))YesOIB_N2RAT
81CO2RATIONatural gas CO2 content (ratio)float1516FLTP((0))YesOIB_CO2RAT
82C2H6RATIONatural gas C2H6 (ethane) content (ratio)float1516FLTP((0))YesOIB_C2H6RAT
83C3H8RATIONatural gas C3H8 (propane) content (ratio)float1516FLTP((0))YesOIB_C3H8RAT
84H2ORATIONatural gas H2O content (ratio)float1516FLTP((0))YesOIB_H2ORAT
85H2SRATIONatural gas H2S content (ratio)float1516FLTP((0))YesOIB_H2SRAT
86H2RATIONatural gas H2 (Hydrogen) content (ratio)float1516FLTP((0))YesOIB_H2RAT
87CORATIONatural gas CO content (ratio)float1516FLTP((0))YesOIB_CORAT
88O2RATIONatural gas oxygen (O2) content (ratio)float1516FLTP((0))YesOIB_O2RAT
89ISOC4H10RATIONatural gas ISO-C4H10 (iso-butane ) content (ratio)float1516FLTP((0))YesOIB_ISOC4H10RAT
90NC4H10RATIONatural gas n-C4H10 (n-butane ) content (ratio)float1516FLTP((0))YesOIB_NC4H10RAT
91ISOC5H12RATIONatural gas ISO-C5H12 (ISO-pentane ) content (ratio)float1516FLTP((0))YesOIB_ISOC5H12RAT
92NC5H12RATIONatural gas n-C5H12 (n-pentane ) content (ratio)float1516FLTP((0))YesOIB_NC5H12RAT
93C6H14RATIONatural gas C6H14 (n-hexane ) content (ratio)float1516FLTP((0))YesOIB_C6H14RAT
94C7H16RATIONatural gas C7H16 (n-heptane ) content (ratio)float1516FLTP((0))YesOIB_C7H16RAT
95C8H18RATIONatural gas C8H18 (n-octane ) content (ratio)float1516FLTP((0))YesOIB_C8H18RAT
96C9H20RATIONatural gas C9H20 (n-Nonane ) content (ratio)float1516FLTP((0))YesOIB_C9H20RAT
97C10H22RATIONatural gas C10H22 (n-Decane ) content (ratio)float1516FLTP((0))YesOIB_C10H22RAT
98HERATIONatural gas He (Helium) content (ratio)float1516FLTP((0))YesOIB_HERAT
99ARRATIONatural gas Argon content (ratio)float1516FLTP((0))YesOIB_ARRAT
100GASCOMPRATEHUnit (vol. %, mol % or mass % ) of natural gas compositionnvarchar30UNIT(N' ')YesT006OIB_GASCOMPRATEH Allow NULL? 
101MOLDENNatural gas molar density (mol/volume) at standard conditionfloat1516FLTP((0))YesOIB_MOLDEN
102MOLDENEHUnit for molar density at base conditions ( nat.gas)nvarchar30UNIT(N' ')YesT006OIB_MOLDENEH Allow NULL? 
103MOLWEIGHTMolecular weight of natural gas:return value from AGA c-codefloat1516FLTP((0))YesOIB_MOLWEIGHT
104HYDROCARBMOLFRACHydrocarbon mole fraction calculated from AGA c-codefloat1516FLTP((0))YesOIB_HYDROCARBMOLFRAC
105MOLWEIGHTEHUnit for molar massnvarchar30UNIT(N' ')YesT006OIB_MOLWEIGHTEH Allow NULL? 
106CUSTPARCHAR1Customer parameter character field 1nvarchar30CHAR(N' ')YesOIB_CUSTPARCHAR1 Allow NULL? 
107CUSTPARFLOAT1Customer parameter float 1float1516FLTP((0))YesOIB_CUSTPARFLOAT1
108CUSTEH1Customer parameter 1 unitnvarchar30UNIT(N' ')YesT006OIB_CUSTEH1 Allow NULL? 
109CUSTPARCHAR2Customer parameter character field 2nvarchar30CHAR(N' ')YesOIB_CUSTPARCHAR2 Allow NULL? 
110CUSTPARFLOAT2Customer parameter float 2float1516FLTP((0))YesOIB_CUSTPARFLOAT2
111CUSTEH2Customer parameter 2 unitnvarchar30UNIT(N' ')YesT006OIB_CUSTEH2 Allow NULL? 
112CUSTPARCHAR3Customer parameter character field 3nvarchar30CHAR(N' ')YesOIB_CUSTPARCHAR3 Allow NULL? 
113CUSTPARFLOAT3Customer parameter float 3float1516FLTP((0))YesOIB_CUSTPARFLOAT3
114CUSTEH3Customer parameter 3 unitnvarchar30UNIT(N' ')YesT006OIB_CUSTEH3 Allow NULL? 
115BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
116MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
117TNKNRSequence number of SO assigned to business locationnvarchar100CHAR(N' ')YesOII_BSEQNR Allow NULL? 
118DRDATESSR Fuels - local datenvarchar80DATS(N'00000000')YesOIRC_DATUM Allow NULL? 
119DRTIMESSR Fuels - Local timenvarchar60TIMS(N'000000')YesOIRC_UZEIT Allow NULL? 
120TIME_ZONESSR Fuels - Service station time zonenvarchar60CHAR(N' ')Yes*OIRC_TIMEZONE Allow NULL? 
121PR_NUMBERSSR Fuels - Process numbernvarchar100CHAR(N' ')YesOIRC_PR_NUMBER Allow NULL? 
122WERKSPlant for storage location assignment entry (IS-Oil MRN)nvarchar40CHAR(N' ')YesT001WOIF_WERKSL Allow NULL? 
123LGORTStorage Locationnvarchar40CHAR(N' ')YesT001LLGORT_D Allow NULL? 
124RELSTOCKSSR Stocks - related stock at time of tank dipdecimal133QUAN((0))YesOIRC_RELSTOCK
125QTYPERSSR Stocks - Tolerance Percentagedecimal62DEC((0))YesOIRC_QTYPER
126TOL_STATUSSSR Fuels - Tolerance status lightnvarchar40CHAR(N' ')YesOIRC_TOLST Allow NULL? 
127MM_QUANSSR Stocks - Difference Quantitydecimal133QUAN((0))YesOIRC_MM_QUAN
128LINKNRLink numbernvarchar100NUMC(N'0000000000')YesOIRA_LINKNR Allow NULL? 
129ITLINKNRItem link numbernvarchar60NUMC(N'000000')Yes*OIRA_ITLINKNR Allow NULL? 
130LINKYEARDocument link number yearnvarchar40NUMC(N'0000')YesOIRA_JAHR Allow NULL? 
131CHECK_STATUSSSR Fuels - Status check lightnvarchar40CHAR(N' ')YesOIRC_CHKST Allow NULL? 
132ACTSTOCKSSR Stocks - Actual book stockdecimal133QUAN((0))YesOIRC_ACTSTOCK
133MM_QUAN_POSTEDSSR Stocks - Posted Quantitydecimal133QUAN((0))YesOIRC_MM_QUAN_POSTED
134PROC_ONLINESSR Meters - On-line process indicatorchar10CHAR(N' ')YesOIRC_ONLINE Allow NULL? 
135PROC_TYPESSR Fuels - Process typechar10CHAR(N' ')YesOIRC_IND_PROC Allow NULL? 
136STCODESSR Fuels - Status codenvarchar20CHAR(N' ')Yes*OIRC_STCODE_SAP Allow NULL? 
137BEZEIDescriptionnvarchar400CHAR(N' ')YesBEZEI40 Allow NULL? 
138BLOCKSSR Fuels - Indicator that identifies a blocking statuschar10CHAR(N' ')YesOIRC_IND_BLK Allow NULL? 
139BLOCK_RELEASESSR Fuels - Indicator for blocking status releasechar10CHAR(N' ')YesOIRC_IND_BLKRLS Allow NULL? 
140USR_INDSSR Fuels - User error indicatorchar10CHAR(N' ')YesOIRC_USR_IND Allow NULL? 
141MAKTXMaterial Description (Short Text)nvarchar400CHAR(N' ')YesMAKTX Allow NULL? 
NamePrimaryUniqueTypeColumns
OIRC_DRREJ~0YesYesCLUSTEREDREC_SEQNR, RNBT, PBLNR, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy