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_SOCDIP
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_SOCDIP1332SSR Stocks - Dip readings historyService Station Retailing
SQL:  selectupdate insert create

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

SELECT MANDT, 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, PBLNR, RNBT FROM OIRC_SOCDIP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SOCNRSOC: Storage object characteristic segment numbernvarchar200CHAR(N' ')NoOIISOCKOII_SOCNR Allow NULL? 
3ETMSTMSSR Stocks - Tank dip time stampdecimal150DEC((0))NoOIRC_TMSTM
4SOCEVSOC eventnvarchar20CHAR(N' ')NoOIISOCEOII_SOCEV Allow NULL? 
5SLVNRSOC: Linear/volumetric conversion (strap) set numbernvarchar200CHAR(N' ')Yes*OII_SLVNR Allow NULL? 
6SLVINDSOC: recalibration index for strapping datanvarchar50NUMC(N'00000')YesOII_SLVIND Allow NULL? 
7TOTALHEIGHTTank dip, total heightdecimal133QUAN((0))YesOII_TOTALHEIGHT
8TOTALHEIGHT_FLTPSilo Mgmt: Tank strapping height in FLTPfloat1516FLTP((0))YesOII_HGT_FLTP
9WATERHEIGHTTank dip: water dip heightdecimal133QUAN((0))YesOII_WATERHEIGHT
10WATERHEIGHT_FLTPSilo Mgmt: Tank strapping height in FLTPfloat1516FLTP((0))YesOII_HGT_FLTP
11MDICHMaterial density (at ambient temperature)decimal133QUAN((0))YesOII_MATDENS
12DNSUNDensity UoM (Oil product/Silo)nvarchar30UNIT(N' ')Yes*OII_DNSUN Allow NULL? 
13QUAN_SKUQuantity in stock keeping unit/ base unit of measuredecimal133QUAN((0))YesOII_QUAN_SKU
14MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
15QUAN_LVCMaterial volume in LVC set UoMdecimal133QUAN((0))YesOII_QUAN_LVC
16WATR_LVCWater Volume in LVC set UoMdecimal133QUAN((0))YesOII_WATR_LVC
17SHTMPSilo shell temperaturefloat1516FLTP((0))YesOII_STTMP
18SHTEHSilo shell temperature unitnvarchar30UNIT(N' ')Yes*OII_STTEH Allow NULL? 
19UL_IN_INDDipping method (innage, ullage)char10CHAR(N' ')YesOII_UL_IN_IND Allow NULL? 
20VOLUNUoM - volumetric constant for lin./vol. conversion (BDRP)nvarchar30UNIT(N' ')Yes*OII_VOLUNC Allow NULL? 
21LENUNUoM - linear constant for lin./vol. conversion (BDRP)nvarchar30UNIT(N' ')Yes*OII_LENUNC Allow NULL? 
22UMRSLConversion Group (Oil, Natural Gas,..)nvarchar40CHAR(N' ')YesOIB01OIB_UMRSL Allow NULL? 
23CMODEConversion Modechar10CHAR(N' ')YesOIB_CMODE Allow NULL? 
24FDICHEHUnit for densities at standard/base conditionsnvarchar30UNIT(N' ')YesT006OIB_BDNEH Allow NULL? 
25FDICHFixed Densityfloat1516FLTP((0))YesOIB_FDICH
26COEFFQuantity Conversion Coefficientfloat1516FLTP((0))YesOIB_COEFF
27BDICHEHUnit for densities at standard/base conditionsnvarchar30UNIT(N' ')YesT006OIB_BDNEH Allow NULL? 
28BDICHOil/gas density at standard/base conditionsfloat1516FLTP((0))YesOIB_BDICH
29BHVALEHHeating value unit at standard/base conditions (natural gas)nvarchar30UNIT(N' ')YesT006OIB_BHVEH Allow NULL? 
30BHVALHeating value at standard/base conditions (natural gas)float1516FLTP((0))YesOIB_BHVAL
31TSTMPOil/Gas Test Temperature: Observed Densityfloat1516FLTP((0))YesOIB_TSTMP
32TSTEHTest Temperature Unit (Density): Measurementnvarchar30UNIT(N' ')YesT006OIB_TSTEH Allow NULL? 
33MTTMPOil/Gas Material Temperature: Observed Quantityfloat1516FLTP((0))YesOIB_MTTMP
34MTTEHOil/Gas Material Temperature Unit: Observed Quantitynvarchar30UNIT(N' ')YesT006OIB_MTTEH Allow NULL? 
35THVALHeating value at test conditions (natural gas): observedfloat1516FLTP((0))YesOIB_THVAL
36TDICHEHUnit for densities of petroleum products and natural gasnvarchar30UNIT(N' ')YesT006OIB_DNEH Allow NULL? 
37TDICHOil/Gas Test Densityfloat1516FLTP((0))YesOIB_TDICH
38MTPRESOil/gas material pressure: observed quantityfloat1516FLTP((0))YesOIB_MTPRES
39MTPRESEHOil/gas material pressure unit: observed quantitynvarchar30UNIT(N' ')YesT006OIB_MTPRESEH Allow NULL? 
40TPREDOil/gas test pressure: metering (obs. density)float1516FLTP((0))YesOIB_TPRED
41TPREDEHOil/Gas test press. unit: metering (density)nvarchar30UNIT(N' ')YesT006OIB_TPREDEH Allow NULL? 
42TPRHVNatural gas test pressure: combustion (obs. heating value )float1516FLTP((0))YesOIB_TPRHV
43TPRHVEHNatural gas test pressure unit: combustion ( heating value )nvarchar30UNIT(N' ')YesT006OIB_TPRHVEH Allow NULL? 
44TTMPHVNatural gas test temperature: combustion (obs. heat. value )float1516FLTP((0))YesOIB_TTMPHV
45TTMPHVEHNatural gas test temp. unit: combustion (heating value)nvarchar30UNIT(N' ')YesT006OIB_TTMPHVEH Allow NULL? 
46ATPRESAtmospheric pressure of the air surrounding a productfloat1516FLTP((0))YesOIB_ATPRES
47ATPRESEHAtmospheric pressure unitnvarchar30UNIT(N' ')YesT006OIB_ATPRESEH Allow NULL? 
48VAPRESVapor pressure of liquid petroleum gases (LPG)float1516FLTP((0))YesOIB_VAPRES
49VAPRESEHVapor pressure unit (LPG)nvarchar30UNIT(N' ')YesT006OIB_VAPRESEH Allow NULL? 
50THVALEHHeating value unitnvarchar30UNIT(N' ')YesT006OIB_HVEH Allow NULL? 
51MTCOMBTMPNatural gas material combustion temp.: observed quantityfloat1516FLTP((0))YesOIB_MTCOMBTMP
52MTCOMBTEHNatural gas material combustion temp. unit: obs. quantitynvarchar30UNIT(N' ')YesT006OIB_MTCOMBTEH Allow NULL? 
53MTCOMBPRESNatural gas material combustion pressure: observed quantityfloat1516FLTP((0))YesOIB_MTCOMBPRES
54MTCOMBPRESEHNatural gas material combustion pres. unit: oberved quantitynvarchar30UNIT(N' ')YesT006OIB_MTCOMBPRESEH Allow NULL? 
55TSTMPCALNatural gas: Calorimeter test temperature (density)float1516FLTP((0))YesOIB_TSTMPCAL
56TSTMPCALEHNatural gas: unit for calorimeter test temperature (density)nvarchar30UNIT(N' ')YesT006OIB_TSTMPCALEH Allow NULL? 
57TPREDCALNatural gas: Calorimeter test pressure (density)float1516FLTP((0))YesOIB_TPREDCAL
58TPREDCALEHNatural gas: Unit for calorimeter test pressure (density)nvarchar30UNIT(N' ')YesT006OIB_TPREDCALEH Allow NULL? 
59HYDROHydrometer Correction Indicatorchar10CHAR(N' ')YesOIB_HYDRO Allow NULL? 
60ABINDAir Bouyancy Indicatorchar10CHAR(N' ')YesOIB_ABIND Allow NULL? 
61ABFACAir Bouyancy Factordecimal31DEC((0))YesOIB_ABFAC
62MCFMeter correction factorfloat1516FLTP((0))YesOIB_MCF1
63BSWCNBSW %float1516FLTP((0))YesOIB_BSWCN
64BSWCNEHBSW % unit (volume %, mol %, mass % or proportion )nvarchar30UNIT(N' ')YesT006OIB_BSWCNEH Allow NULL? 
65HVCLSHeating value class (calorific value class)nvarchar20CHAR(N' ')YesOIB_HVCLS Allow NULL? 
66HVCLS_TOHeating value class (calorific value class)nvarchar20CHAR(N' ')YesOIB_HVCLS Allow NULL? 
67DEFAULT_GUIDGUID in 'CHAR' Format in Uppercasenvarchar320CHAR(N' ')YesGUID_32 Allow NULL? 
68ERDATDate record creatednvarchar80DATS(N'00000000')YesOII_ERDAT Allow NULL? 
69ERZEITTime record creatednvarchar60TIMS(N'000000')YesOII_ERZEIT Allow NULL? 
70ERNAMUser who created recordnvarchar120CHAR(N' ')YesOII_ERNAM Allow NULL? 
71AEDATDate record changednvarchar80DATS(N'00000000')YesOII_AEDAT Allow NULL? 
72AEZEITTime record changednvarchar60TIMS(N'000000')YesOII_AEZEIT Allow NULL? 
73AENAMUser who changed recordnvarchar120CHAR(N' ')YesOII_AENAM Allow NULL? 
74BLOINDBlocking indicatorchar10CHAR(N' ')YesOII_BLOIND Allow NULL? 
75DELINDDeletion indicatorchar10CHAR(N' ')YesOII_DELIND Allow NULL? 
76CH4RATIONatural gas CH4 content (ratio)float1516FLTP((0))YesOIB_CH4RAT
77N2RATIONatural gas N2 (nitrogen) content (ratio)float1516FLTP((0))YesOIB_N2RAT
78CO2RATIONatural gas CO2 content (ratio)float1516FLTP((0))YesOIB_CO2RAT
79C2H6RATIONatural gas C2H6 (ethane) content (ratio)float1516FLTP((0))YesOIB_C2H6RAT
80C3H8RATIONatural gas C3H8 (propane) content (ratio)float1516FLTP((0))YesOIB_C3H8RAT
81H2ORATIONatural gas H2O content (ratio)float1516FLTP((0))YesOIB_H2ORAT
82H2SRATIONatural gas H2S content (ratio)float1516FLTP((0))YesOIB_H2SRAT
83H2RATIONatural gas H2 (Hydrogen) content (ratio)float1516FLTP((0))YesOIB_H2RAT
84CORATIONatural gas CO content (ratio)float1516FLTP((0))YesOIB_CORAT
85O2RATIONatural gas oxygen (O2) content (ratio)float1516FLTP((0))YesOIB_O2RAT
86ISOC4H10RATIONatural gas ISO-C4H10 (iso-butane ) content (ratio)float1516FLTP((0))YesOIB_ISOC4H10RAT
87NC4H10RATIONatural gas n-C4H10 (n-butane ) content (ratio)float1516FLTP((0))YesOIB_NC4H10RAT
88ISOC5H12RATIONatural gas ISO-C5H12 (ISO-pentane ) content (ratio)float1516FLTP((0))YesOIB_ISOC5H12RAT
89NC5H12RATIONatural gas n-C5H12 (n-pentane ) content (ratio)float1516FLTP((0))YesOIB_NC5H12RAT
90C6H14RATIONatural gas C6H14 (n-hexane ) content (ratio)float1516FLTP((0))YesOIB_C6H14RAT
91C7H16RATIONatural gas C7H16 (n-heptane ) content (ratio)float1516FLTP((0))YesOIB_C7H16RAT
92C8H18RATIONatural gas C8H18 (n-octane ) content (ratio)float1516FLTP((0))YesOIB_C8H18RAT
93C9H20RATIONatural gas C9H20 (n-Nonane ) content (ratio)float1516FLTP((0))YesOIB_C9H20RAT
94C10H22RATIONatural gas C10H22 (n-Decane ) content (ratio)float1516FLTP((0))YesOIB_C10H22RAT
95HERATIONatural gas He (Helium) content (ratio)float1516FLTP((0))YesOIB_HERAT
96ARRATIONatural gas Argon content (ratio)float1516FLTP((0))YesOIB_ARRAT
97GASCOMPRATEHUnit (vol. %, mol % or mass % ) of natural gas compositionnvarchar30UNIT(N' ')YesT006OIB_GASCOMPRATEH Allow NULL? 
98MOLDENNatural gas molar density (mol/volume) at standard conditionfloat1516FLTP((0))YesOIB_MOLDEN
99MOLDENEHUnit for molar density at base conditions ( nat.gas)nvarchar30UNIT(N' ')YesT006OIB_MOLDENEH Allow NULL? 
100MOLWEIGHTMolecular weight of natural gas:return value from AGA c-codefloat1516FLTP((0))YesOIB_MOLWEIGHT
101HYDROCARBMOLFRACHydrocarbon mole fraction calculated from AGA c-codefloat1516FLTP((0))YesOIB_HYDROCARBMOLFRAC
102MOLWEIGHTEHUnit for molar massnvarchar30UNIT(N' ')YesT006OIB_MOLWEIGHTEH Allow NULL? 
103CUSTPARCHAR1Customer parameter character field 1nvarchar30CHAR(N' ')YesOIB_CUSTPARCHAR1 Allow NULL? 
104CUSTPARFLOAT1Customer parameter float 1float1516FLTP((0))YesOIB_CUSTPARFLOAT1
105CUSTEH1Customer parameter 1 unitnvarchar30UNIT(N' ')YesT006OIB_CUSTEH1 Allow NULL? 
106CUSTPARCHAR2Customer parameter character field 2nvarchar30CHAR(N' ')YesOIB_CUSTPARCHAR2 Allow NULL? 
107CUSTPARFLOAT2Customer parameter float 2float1516FLTP((0))YesOIB_CUSTPARFLOAT2
108CUSTEH2Customer parameter 2 unitnvarchar30UNIT(N' ')YesT006OIB_CUSTEH2 Allow NULL? 
109CUSTPARCHAR3Customer parameter character field 3nvarchar30CHAR(N' ')YesOIB_CUSTPARCHAR3 Allow NULL? 
110CUSTPARFLOAT3Customer parameter float 3float1516FLTP((0))YesOIB_CUSTPARFLOAT3
111CUSTEH3Customer parameter 3 unitnvarchar30UNIT(N' ')YesT006OIB_CUSTEH3 Allow NULL? 
112BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
113MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
114TNKNRSequence number of SO assigned to business locationnvarchar100CHAR(N' ')YesOII_BSEQNR Allow NULL? 
115DRDATESSR Fuels - local datenvarchar80DATS(N'00000000')YesOIRC_DATUM Allow NULL? 
116DRTIMESSR Fuels - Local timenvarchar60TIMS(N'000000')YesOIRC_UZEIT Allow NULL? 
117TIME_ZONESSR Fuels - Service station time zonenvarchar60CHAR(N' ')Yes*OIRC_TIMEZONE Allow NULL? 
118PR_NUMBERSSR Fuels - Process numbernvarchar100CHAR(N' ')YesOIRC_PR_NUMBER Allow NULL? 
119WERKSPlant for storage location assignment entry (IS-Oil MRN)nvarchar40CHAR(N' ')Yes*OIF_WERKSL Allow NULL? 
120LGORTStorage Locationnvarchar40CHAR(N' ')Yes*LGORT_D Allow NULL? 
121RELSTOCKSSR Stocks - related stock at time of tank dipdecimal133QUAN((0))YesOIRC_RELSTOCK
122QTYPERSSR Stocks - Tolerance Percentagedecimal62DEC((0))YesOIRC_QTYPER
123TOL_STATUSSSR Fuels - Tolerance status lightnvarchar40CHAR(N' ')YesOIRC_TOLST Allow NULL? 
124MM_QUANSSR Stocks - Difference Quantitydecimal133QUAN((0))YesOIRC_MM_QUAN
125LINKNRLink numbernvarchar100NUMC(N'0000000000')YesOIRA_LINKNR Allow NULL? 
126ITLINKNRItem link numbernvarchar60NUMC(N'000000')Yes*OIRA_ITLINKNR Allow NULL? 
127LINKYEARDocument link number yearnvarchar40NUMC(N'0000')YesOIRA_JAHR Allow NULL? 
128CHECK_STATUSSSR Fuels - Status check lightnvarchar40CHAR(N' ')YesOIRC_CHKST Allow NULL? 
129ACTSTOCKSSR Stocks - Actual book stockdecimal133QUAN((0))YesOIRC_ACTSTOCK
130MM_QUAN_POSTEDSSR Stocks - Posted Quantitydecimal133QUAN((0))YesOIRC_MM_QUAN_POSTED
131PROC_ONLINESSR Meters - On-line process indicatorchar10CHAR(N' ')YesOIRC_ONLINE Allow NULL? 
132PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100CHAR(N' ')Yes*OIF_PBLNR Allow NULL? 
133RNBTBusiness typenvarchar40CHAR(N' ')Yes*OIRA_RNBT Allow NULL? 
NamePrimaryUniqueTypeColumns
OIRC_SOCDIP~0YesYesCLUSTEREDSOCEV, ETMSTM, SOCNR, MANDT
OIRC_SOCDIP~PBLNoNoNONCLUSTEREDMATNR, PBLNR, RNBT, 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