S114E SAP () Table details

Dictionary Type: Table
Description:




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




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

S114E is a standard SAP Table which is used to store data and is available within R/3 SAP systems depending on the version and release level.

The S114E table consists of various fields, each holding specific information or linking keys about data available in SAP. These include SSOUR (Statistic(s) origin), UNSYS (Unit System), SWERK (Maintenance plant), EQTYP (Equipment category).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP S114E table 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
MANDTClient MANDTCLNT3T000MANDT
SSOURStatistic(s) origin SSOURCHAR4SSOUR
UNSYSUnit System DUNSYSCHAR3CHAR3
SWERKMaintenance plant SWERKCHAR4T001WWERKSSWK
EQTYPEquipment category EQTYPCHAR1T370TEQTYPEQT
EQARTType of Technical Object EQARTCHAR10T370KEQART
IWERKMaintenance Planning Plant IWERKCHAR4T399IWERKSIWK
HERSTManufacturer of asset HERSTCHAR30TEXT30
TYPBZManufacturer model number TYPBZCHAR20TYPBZ
BAUJJYear of construction BAUJJCHAR4GJAHRCJAHR
EQUNREquipment Number EQUNRCHAR18EQUIALPHAEQUNREQNEQUI
DUNITPMIS: Unit Field for Distance Covered DDUNITUNIT3T006CUNITMEINS
TUNITPMIS: Unit Field for Operating Hours DTUNITUNIT3T006CUNITMEINS
FUNITPMIS: Unit Field for Fuel Volumes DFUNITUNIT3T006CUNITMEINS
MUNITPMIS: Unit Field for Volume Mass DMUNITUNIT3T006CUNITMEINS
FDUNITPMIS: Unit Field for Fuel Consumption per Route DFDUNITUNIT3T006CUNITMEINS
FTUNITPMIS: Unit for Fuel Consumption per Hour of Operation DFTUNITUNIT3T006CUNITMEINS
MDUNITPMIS: Unit Field for Fuel Mass per Route DMDUNITUNIT3T006CUNITMEINS
MTUNITPMIS: Unit Field for Fuel Mass per Operating Hour DMTUNITUNIT3T006CUNITMEINS
CDUNITPMIS: Unit for Actual Costs per Reserved Route DCDUNITUNIT3T006CUNITMEINS
CTUNITPMIS: Unit for Actual Costs per Operating Hour DCTUNITUNIT3T006CUNITMEINS
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
UDUNITConversion factor: quantities UMREFFFLTP16(16) FLTP
UTUNITConversion factor: quantities UMREFFFLTP16(16) FLTP
UFUNITConversion factor: quantities UMREFFFLTP16(16) FLTP
UMUNITConversion factor: quantities UMREFFFLTP16(16) FLTP
UFDUNITConversion factor: quantities UMREFFFLTP16(16) FLTP
UFTUNITConversion factor: quantities UMREFFFLTP16(16) FLTP
UMDUNITConversion factor: quantities UMREFFFLTP16(16) FLTP
UMTUNITConversion factor: quantities UMREFFFLTP16(16) FLTP
UCDUNITConversion factor: quantities UMREFFFLTP16(16) FLTP
UCTUNITConversion factor: quantities UMREFFFLTP16(16) FLTP
UWAERSConversion factor: quantities UMREFFFLTP16(16) FLTP
PLOBJPlanning object PLOBJCHAR18CHAR18
PERKZPeriod indicator PERVRCHAR1PERVR
PERIVFiscal Year Variant PERIVCHAR2T009PERIV
PLTKZIndicator: element used in planning PLTKZCHAR1CHAR01
ANTEIProportional factor (%) for disaggregation of product group DANTEFFLTP16(16) FLTP

Key field Non-key field



How do I retrieve data from SAP table S114E using ABAP code

The following ABAP code Example will allow you to do a basic selection on S114E to SELECT all data from the table
DATA: WA_S114E TYPE S114E.

SELECT SINGLE *
FROM S114E
INTO CORRESPONDING FIELDS OF WA_S114E
WHERE...

How to access SAP table S114E

Within an ECC or HANA version of SAP you can also view further information about S114E 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!