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