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 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||||
| 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 |
Possible values
|
||||||||||
| 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 |
Possible values
|
||||||||||
| DELIND | Deletion indicator | OII_DELIND | CHAR | 1 | 0 |
Possible values
|
||||||||||
| 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 | OIISOCK | SPVUN | T006 | Units of Measurement | MSEHI |
| OIISOCK | SPVUN | SYST | MANDT | T006 | Units of Measurement | MANDT |
| OIISOCK | ST_GAUGE_RT | OIISOCK | ST_GAUGE_RT | TOIJ_ST_GAUGE_RT | stores stop gauge calculation routines | STOP_GAUGE_RT |
| OIISOCK | TIMUN | SYST | MANDT | T006 | Units of Measurement | MANDT |
| OIISOCK | TIMUN | OIISOCK | TIMUN | T006 | Units of Measurement | MSEHI |
| 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 |
