E2OILPS SAP (Storage objects) Structure details

Dictionary Type: Structure
Description: Storage objects




ABAP Code to SELECT data from E2OILPS
Related tables to E2OILPS
Access table E2OILPS




Structure field list including key, data, relationships and ABAP select examples

E2OILPS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Storage objects" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_E2OILPS TYPE E2OILPS.

The E2OILPS table consists of various fields, each holding specific information or linking keys about Storage objects data available in SAP. These include SOCNR (SOC: Storage object characteristic segment number), SOCKL (SOC: Storage object characteristic class), SOCTYP (SOC: Storage object type), EQUNR (Equipment number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP E2OILPS structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
SEQNRSequence number of SO assigned to customer OII_KSEQNRCHAR10ALPHAOII_SEQNR
SOCNRSOC: Storage object characteristic segment number OII_SOCNRCHAR20Assigned to domainOII_SOCNR
SOCKLSOC: Storage object characteristic class OII_SOCKLCHAR10Assigned to domainOII_SOCKL
SOCTYPSOC: Storage object type OII_SOCTYPCHAR10Assigned to domainOII_SOCTYP
EQUNREquipment number OII_EQUNRCHAR18Assigned to domainALPHAEQUNR
TPLNRFunctional location ID OII_TPLNRCHAR30Assigned to domainTPLNRTPLNRIFL
HZEINManufacturer drawing number OII_SHZEINCHAR30CHAR30
SERGEManufacturer serial number OII_SSERGECHAR30CHAR30
TYPBZManufacturer model number OII_STYPBZCHAR20CHAR20
BAUJJYear of construction OII_SBAUJJCHAR4CHAR4
BAUMMMonth of construction OII_SBAUMMCHAR2CHAR2
VOLUN3-Byte field CHAR3CHAR3CHAR3
MASUN3-Byte field CHAR3CHAR3CHAR3
LENUN3-Byte field CHAR3CHAR3CHAR3
FRTUN3-Byte field CHAR3CHAR3CHAR3
TIMUN3-Byte field CHAR3CHAR3CHAR3
TMPUN3-Byte field CHAR3CHAR3CHAR3
KAPAZChar 15 CHAR15CHAR15CHAR15
MXMASChar 15 CHAR15CHAR15CHAR15
GXDATGeneral SO usage expiry date OII_GXDATDATS8DATS
GXTIMGeneral SO usage expiry time OII_GXTIMTIMS6TIME
GXREAGeneral expiry reason code of bulk storage object OII_GXREACHAR4Assigned to domainOII_GXREA
SOGRPSO group indicator OII_SOGRPCHAR1XFELD
SLVNRSOC: Linear/volumetric conversion (strap) set number OII_SLVNRCHAR20Assigned to domainOII_SLVNR
MAXDPChar 15 CHAR15CHAR15CHAR15
MINDPChar 15 CHAR15CHAR15CHAR15
MAXINChar 15 CHAR15CHAR15CHAR15
MAXOUTChar 15 CHAR15CHAR15CHAR15
UNPKZChar 15 CHAR15CHAR15CHAR15
UNPPCCharacter field of length 6 CHAR6CHAR6CHAR6
WASKZChar 15 CHAR15CHAR15CHAR15
WASPCCharacter field of length 6 CHAR6CHAR6CHAR6
FLMASChar 15 CHAR15CHAR15CHAR15
GFLAGAbove/below ground indicator OII_GFLAGCHAR1XFELD
HFLAGTank is heated flag OII_HFLAGCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP structure E2OILPS using ABAP code?

As E2OILPS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on E2OILPS as there is no data to select.

How to access SAP table E2OILPS

Within an ECC or HANA version of SAP you can also view further information about E2OILPS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!