SAP Table OIISOCK
SOC: Storage object characteristic segment header
OIISOCK (SOC: Storage object characteristic segment header) 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 OIISOCK to other SAP tables.
OIISOCK table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
SOCNR
SOC: Storage object characteristic segment number
|
OII_SOCNR |
CHAR
|
20 | 0 | ||||||||||||
|
OBJNR
Object number
|
J_OBJNR | ONR00 |
CHAR
|
22 | 0 | |||||||||||
|
SOCAM
SOC access mode
|
OII_SOCAM | OIISOCAM |
CHAR
|
2 | 0 | |||||||||||
|
SOCKL
SOC: Storage object characteristic class
|
OII_SOCKL | OIISOCKL |
CHAR
|
10 | 0 | |||||||||||
|
SOCTYP
SOC: Storage object type
|
OII_SOCTYP | OIISOCTYP |
CHAR
|
10 | 0 | |||||||||||
|
EQUNR
Equipment number
|
OII_EQUNR | EQUI |
CHAR
|
18 | 0 | |||||||||||
|
TPLNR
Functional location ID
|
OII_TPLNR | IFLOT |
CHAR
|
30 | 0 | |||||||||||
|
HERST
Manufacturer of equipment
|
OII_HERST |
CHAR
|
30 | 0 | ||||||||||||
|
HERLD
Country of manufacturer
|
OII_HERLD | T005 |
CHAR
|
3 | 0 | |||||||||||
|
HZEIN
Manufacturer drawing number
|
OII_SHZEIN |
CHAR
|
30 | 0 | ||||||||||||
|
SERGE
Manufacturer serial number
|
OII_SSERGE |
CHAR
|
30 | 0 | ||||||||||||
|
TYPBZ
Manufacturer model number
|
OII_STYPBZ |
CHAR
|
20 | 0 | ||||||||||||
|
BAUJJ
Year of construction
|
OII_SBAUJJ |
CHAR
|
4 | 0 | ||||||||||||
|
BAUMM
Month of construction
|
OII_SBAUMM |
CHAR
|
2 | 0 | ||||||||||||
|
VOLUN
Volume UoM (Oil BDRP)
|
OII_VOLUN | T006 |
UNIT
|
3 | 0 | |||||||||||
|
MASUN
UoM - mass (Oil BDRP)
|
OII_MASUN | T006 |
UNIT
|
3 | 0 | |||||||||||
|
LENUN
Length UoM (Oil BDRP)
|
OII_LENUN | T006 |
UNIT
|
3 | 0 | |||||||||||
|
FRTUN
UoM - flow rate (Oil BDRP)
|
OII_FRTUN | T006 |
UNIT
|
3 | 0 | |||||||||||
|
TIMUN
UoM - time (Oil BDRP)
|
OII_TIMUN | T006 |
UNIT
|
3 | 0 | |||||||||||
|
TMPUN
UoM - temperature (Oil BDRP)
|
OII_TMPUN | T006 |
UNIT
|
3 | 0 | |||||||||||
|
DNSUN
Density UoM (Oil product/Silo)
|
OII_DNSUN | T006 |
UNIT
|
3 | 0 | |||||||||||
|
SPVUN
Specific volume (volume per height) UoM
|
OII_SPVUN | T006 |
UNIT
|
3 | 0 | |||||||||||
|
DNTYP
Density Type
|
OIB_DNTYP |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
KAPAZ
SO capacity (UoM VOL)
|
OII_KAPAZ |
QUAN
|
13 | 3 | ||||||||||||
|
MXMAS
Max. safety weight of SO (Uom MAS)
|
OII_MXMAS |
QUAN
|
13 | 3 | ||||||||||||
|
GXDAT
General SO usage expiry date
|
OII_GXDAT |
DATS
|
8 | 0 | ||||||||||||
|
GXTIM
General SO usage expiry time
|
OII_GXTIM |
TIMS
|
6 | 0 | ||||||||||||
|
GXREA
General expiry reason code of bulk storage object
|
OII_GXREA | OIILGXR |
CHAR
|
4 | 0 | |||||||||||
|
SOGRP
SO group indicator
|
OII_SOGRP |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ERDAT
Date record created
|
OII_ERDAT |
DATS
|
8 | 0 | ||||||||||||
|
ERZEIT
Time record created
|
OII_ERZEIT |
TIMS
|
6 | 0 | ||||||||||||
|
ERNAM
User who created record
|
OII_ERNAM |
CHAR
|
12 | 0 | ||||||||||||
|
AEDAT
Date record changed
|
OII_AEDAT |
DATS
|
8 | 0 | ||||||||||||
|
AEZEIT
Time record changed
|
OII_AEZEIT |
TIMS
|
6 | 0 | ||||||||||||
|
AENAM
User who changed record
|
OII_AENAM |
CHAR
|
12 | 0 | ||||||||||||
|
BLOIND
Blocking indicator
|
OII_BLOIND |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
DELIND
Deletion indicator
|
OII_DELIND |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ST_GAUGE_RT
Stop Gauge Calculation Routine
|
OIJ_STOP_GAUGE_RT | TOIJ_ST_GAUGE_RT |
CHAR
|
12 | 0 | |||||||||||
OIISOCK foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| OIISOCK | DNSUN | SYST | MANDT |
T006
Units of Measurement
|
MANDT |
| OIISOCK | DNSUN | OIISOCK | DNSUN |
T006
Units of Measurement
|
MSEHI |
| OIISOCK | EQUNR | OIISOCK | MANDT |
EQUI
Equipment master data
|
MANDT |
| OIISOCK | EQUNR | OIISOCK | EQUNR |
EQUI
Equipment master data
|
EQUNR |
| OIISOCK | FRTUN | SYST | MANDT |
T006
Units of Measurement
|
MANDT |
| OIISOCK | FRTUN | OIISOCK | FRTUN |
T006
Units of Measurement
|
MSEHI |
| OIISOCK | GXREA | OIISOCK | MANDT |
OIILGXR
SOC: Expiry reason code
|
MANDT |
| OIISOCK | GXREA | OIISOCK | GXREA |
OIILGXR
SOC: Expiry reason code
|
GXREA |
| OIISOCK | HERLD | OIISOCK | MANDT |
T005
Countries
|
MANDT |
| OIISOCK | HERLD | OIISOCK | HERLD |
T005
Countries
|
LAND1 |
| OIISOCK | LENUN | OIISOCK | MANDT |
T006
Units of Measurement
|
MANDT |
| OIISOCK | LENUN | OIISOCK | LENUN |
T006
Units of Measurement
|
MSEHI |
| OIISOCK | MANDT | OIISOCK | MANDT |
T000
Clients
|
MANDT |
| OIISOCK | MASUN | OIISOCK | MANDT |
T006
Units of Measurement
|
MANDT |
| OIISOCK | MASUN | OIISOCK | MASUN |
T006
Units of Measurement
|
MSEHI |
| OIISOCK | OBJNR | OIISOCK | MANDT |
ONR00
General Object Number
|
MANDT |
| OIISOCK | OBJNR | OIISOCK | OBJNR |
ONR00
General Object Number
|
OBJNR |
| OIISOCK | SOCAM | OIISOCK | SOCAM |
OIISOCAM
SOC: Storage object access modes
|
SOCAM |
| OIISOCK | SOCKL | OIISOCK | MANDT |
OIISOCKL
SOC: Storage object characteristic class
|
MANDT |
| OIISOCK | SOCKL | OIISOCK | SOCKL |
OIISOCKL
SOC: Storage object characteristic class
|
SOCKL |
| OIISOCK | SOCTYP | OIISOCK | MANDT |
OIISOCTYP
SOC: Storage object type
|
MANDT |
| OIISOCK | SOCTYP | OIISOCK | SOCTYP |
OIISOCTYP
SOC: Storage object type
|
SOCTYP |
| OIISOCK | SPVUN | SYST | MANDT |
T006
Units of Measurement
|
MANDT |
| OIISOCK | SPVUN | OIISOCK | SPVUN |
T006
Units of Measurement
|
MSEHI |
| OIISOCK | ST_GAUGE_RT | OIISOCK | ST_GAUGE_RT |
TOIJ_ST_GAUGE_RT
stores stop gauge calculation routines
|
STOP_GAUGE_RT |
| OIISOCK | TIMUN | OIISOCK | TIMUN |
T006
Units of Measurement
|
MSEHI |
| OIISOCK | TIMUN | SYST | MANDT |
T006
Units of Measurement
|
MANDT |
| OIISOCK | TMPUN | SYST | MANDT |
T006
Units of Measurement
|
MANDT |
| OIISOCK | TMPUN | OIISOCK | TMPUN |
T006
Units of Measurement
|
MSEHI |
| OIISOCK | TPLNR | OIISOCK | MANDT |
IFLOT
Functional Location (Table)
|
MANDT |
| OIISOCK | TPLNR | OIISOCK | TPLNR |
IFLOT
Functional Location (Table)
|
TPLNR |
| OIISOCK | VOLUN | OIISOCK | MANDT |
T006
Units of Measurement
|
MANDT |
| OIISOCK | VOLUN | OIISOCK | VOLUN |
T006
Units of Measurement
|
MSEHI |