S065 SAP (Object statistics) Table details

Dictionary Type: Table
Description: Object statistics




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




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

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

The S065 table consists of various fields, each holding specific information or linking keys about Object statistics data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), SPMON (Period to analyze - month), SPTAG (Period to analyze - current date).. 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: Can be enhanced (character-type or numeric)


SAP S065 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
VRSIOVersion number in the information structure VRSIOCHAR3Assigned to domainVRSIOMCV
SPMONPeriod to analyze - month SPMONNUMC6PERIMCPERIOD
SPTAGPeriod to analyze - current date SPTAGDATS8DATUM
SPWOCPeriod to analyze - week SPWOCNUMC6PERIMCPERIOD
SPBUPPeriod to analyze - posting period SPBUPNUMC6PERIMCPERIOD
SKLSOBPMIS: Object class SKLSOBCHAR18SKLOBJ
SUBMTMaterial number for equipment SSUBMTCHAR18MARAMATN1MATNRMAT
HERSTManufacturer of asset HERSTCHAR30TEXT30
BAUJJYear of construction BAUJJCHAR4GJAHRCJAHR
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
STWAEStatistics currency STWAECUKY5Assigned to domainWAERS
SUNITUnit for Breakdown Duration MAUEHUNIT3Assigned to domainCUNITMEINS
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
SNUMTPPMIS: Total number of functional locations SNUMTPDEC9MCZAEHLER
STPEENPMIS: No.of functional locations w.individual installation STPEENDEC9MCZAEHLER
STPOENPMIS: No. of functional locations w/o equipment installed STPOENDEC9MCZAEHLER
STPSENPMIS: No.of functional locations w.collective installation STPSENDEC9MCZAEHLER
SNUMEQPMIS: Total number of pieces of equipment SNUMEQDEC9MCZAEHLER
ANSWTAcquisition Value ANSWTCURR13(2) WERT
SMOFNNo.of recorded notifications SMOFNDEC9MCZAEHLER
SMMABNo. of completed notifications SMMABDEC9MCZAEHLER
SABTGNo. processing days creation to completion SABTGDEC9MCZAEHLER
SGMSAUSNumber of machine breakdowns reported SGMSAUSDEC9MCZAEHLER
SGAUSZTDowntime entered SGAUSZTQUAN13(3) MENG13
SSCODEPMIS: No.of damages SSCODEDEC9MCZAEHLER
SACODEPMIS: number of activity codes SACODEDEC9MCZAEHLER
SUCODEPMIS: No. of cause of damage codes SUCODEDEC9MCZAEHLER
IAOFNPMIS: number of maintenance orders created IAOFNDEC9MCZAEHLER
IASOFPMIS: no. of maintenance tasks to be performed immediately IASOFORTDEC9MCZAEHLER
IAPLANMPMIS: number of planned maintenance orders IAPLANMDEC9MCZAEHLER
IAUNGPLPMIS: number of unplanned maintenance orders IAUNGPLDEC9MCZAEHLER
IAABGPMIS: number of completed maintenance orders IAABGDEC9MCZAEHLER
IAKOSPLANTotal plant maintenance costs (planned) DGESKOPLANCURR15(2) WERTV8
IAKOSISTTotal(actual) maintenance costs DGESKOSISTCURR15(2) WERTV8
IAPERKOSEPMIS: PM costs for internal wages DPERKOSEIGCURR15(2) WERTV8
IAPERKOSFPMIS: PM costs for external wages DPERKOSFRDCURR15(2) WERTV8
IAMATKOSEPMIS: PM costs for internal material DMATKOSEIGCURR15(2) WERTV8
IAMATKOSFPMIS: PM costs for external material DMATKOSFRDCURR15(2) WERTV8
IADIENKOSPMIS: PM costs for services DDIENLKOSTCURR15(2) WERTV8
IASONKOSTPMIS: Miscellaneous PM costs DSONSTKOSTCURR15(2) WERTV8
IAERTRAGTotal plant maintenance revenues (actual) DGESERTRAGCURR15(2) WERTV8

Key field Non-key field



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

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

SELECT SINGLE *
FROM S065
INTO CORRESPONDING FIELDS OF WA_S065
WHERE...

How to access SAP table S065

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