SAP Table OII_STOCK_OVERVIEW
Silo Management, structure for stock overview data
OII_STOCK_OVERVIEW (Silo Management, structure for stock overview data) 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 OII_STOCK_OVERVIEW to other SAP tables.
Source: OII_STOCK_OVERVIEW (Silo Management, structure for stock overview data)
OII_STOCK_OVERVIEW table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
WERKS | Plant | WERKS_D | CHAR | 4 | 0 | |||
LGORT | Storage Location | LGORT_D | CHAR | 4 | 0 | |||
SEQNR | Sequence number of SO assigned to storage location | OII_SSEQNR | CHAR | 10 | 0 | |||
SOCNR | SOC: Storage object characteristic segment number | OII_SOCNR | CHAR | 20 | 0 | |||
RELSTOCK | Silo Mgmt: related book stock at time of tank dip | OIB_RELSTOCK | QUAN | 13 | 3 | |||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | 0 | |||
KAPAZ | SO capacity (UoM VOL) | OII_KAPAZ | QUAN | 13 | 3 | |||
TNKMENGE | SO capacity (UoM VOL) | OII_KAPAZ | QUAN | 13 | 3 | |||
FREETANK | SO capacity (UoM VOL) | OII_KAPAZ | QUAN | 13 | 3 | |||
VOLUN | Volume UoM (Oil BDRP) | OII_VOLUN | UNIT | 3 | 0 | |||
FREEVOLUN | Volume UoM (Oil BDRP) | OII_VOLUN | UNIT | 3 | 0 | |||
TNKVOLUN | Volume UoM (Oil BDRP) | OII_VOLUN | UNIT | 3 | 0 | |||
UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | OIB_UOMGR | CHAR | 3 | 0 | |||
CUST1 | Customer field | OII_CUST_FIELD | CHAR | 40 | 0 | |||
CUST2 | Customer field | OII_CUST_FIELD | CHAR | 40 | 0 | |||
CUST3 | Customer field | OII_CUST_FIELD | CHAR | 40 | 0 | |||
CUST4 | Customer field | OII_CUST_FIELD | CHAR | 40 | 0 | |||
CUST5 | Customer field | OII_CUST_FIELD | CHAR | 40 | 0 | |||
CUST6 | Customer field | OII_CUST_FIELD | CHAR | 40 | 0 | |||
CUST7 | Customer field | OII_CUST_FIELD | CHAR | 40 | 0 | |||
TOTALHEIGHT_FT | Silo Mgmt.: customer fields for total dip height (feet) | OII_TOTALHEIGHT_FEET | CHAR | 15 | 0 | |||
TOTALHEIGHT_IN | Silo Mgmt.: customer fields for total dip height (inches) | OII_TOTALHEIGHT_INCH | CHAR | 15 | 0 | |||
TOTALHEIGHT_FR | Silo Mgmt.: customer fields for total dip height (fractions) | OII_TOTALHEIGHT_FRACTION | CHAR | 15 | 0 | |||
WATERHEIGHT_FT | Silo Mgmt.: customer fields for water dip height (feet) | OII_WATERHEIGHT_FEET | CHAR | 15 | 0 | |||
WATERHEIGHT_IN | Silo Mgmt.: customer fields for water dip height (inches) | OII_WATERHEIGHT_INCH | CHAR | 15 | 0 | |||
WATERHEIGHT_FR | Silo Mgmt.: customer fields for water dip height (fractions) | OII_WATERHEIGHT_FRACTION | CHAR | 15 | 0 |