/SDF/ORA_083_DBSNP SAP (Structure used by report /SDF/RSORA083 (=ORA_083_DBSNP)) Structure details

Dictionary Type: Structure
Description: Structure used by report /SDF/RSORA083 (=ORA_083_DBSNP)




ABAP Code to SELECT data from /SDF/ORA_083_DBSNP
Related tables to /SDF/ORA_083_DBSNP
Access table /SDF/ORA_083_DBSNP




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

/SDF/ORA_083_DBSNP 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 "Structure used by report /SDF/RSORA083 (=ORA_083_DBSNP)" 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_/SDF/ORA_083_DBSNP TYPE /SDF/ORA_083_DBSNP.

The /SDF/ORA_083_DBSNP table consists of various fields, each holding specific information or linking keys about Structure used by report /SDF/RSORA083 (=ORA_083_DBSNP) data available in SAP. These include RECORDTIME (Time), DB_INSTANC (Database instance (OPS)), BUSYWAITS (DB snapshot), WAITTIME (DB snapshot).. 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: Not classified


SAP /SDF/ORA_083_DBSNP 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
RECORDDATEDate DATUMDATS8DATUM
RECORDTIMETime UZEITTIMS6UZEIT
DB_INSTANCDatabase instance (OPS) DB_INSTANCCHAR16CHAR16
BUSYWAITSDB snapshot SNAPSHOTDEC16SNAPSHOT
WAITTIMEDB snapshot SNAPSHOTDEC16SNAPSHOT
CONSISTGETDB snapshot SNAPSHOTDEC16SNAPSHOT
BLOCKGETSDB snapshot SNAPSHOTDEC16SNAPSHOT
PARSECOUNTDB snapshot SNAPSHOTDEC16SNAPSHOT
PHYSIREADSDB snapshot SNAPSHOTDEC16SNAPSHOT
PHYSIWRITEDB snapshot SNAPSHOTDEC16SNAPSHOT
RECURCALLSDB snapshot SNAPSHOTDEC16SNAPSHOT
REDOBLKWRIDB snapshot SNAPSHOTDEC16SNAPSHOT
REDOWTIMEDB snapshot SNAPSHOTDEC16SNAPSHOT
FETCHROWIDDB snapshot SNAPSHOTDEC16SNAPSHOT
FETCONTROWDB snapshot SNAPSHOTDEC16SNAPSHOT
SCANBLKGOTDB snapshot SNAPSHOTDEC16SNAPSHOT
SCANROWGOTDB snapshot SNAPSHOTDEC16SNAPSHOT
SCANLONGDB snapshot SNAPSHOTDEC16SNAPSHOT
SCANSHORTDB snapshot SNAPSHOTDEC16SNAPSHOT
USERCALLSDB snapshot SNAPSHOTDEC16SNAPSHOT
USERCOMMITDB snapshot SNAPSHOTDEC16SNAPSHOT
USRROLLBACDB snapshot SNAPSHOTDEC16SNAPSHOT
WEEKDAY Weekday0
USER_PER_RECURCALLS user per recurrsive calls0
READS_PER_USERCALLS reads per user calls0
LOGICAL_READS logical reads0
BUFFER_QUALITY buffer quality0
AVG_WRITE_TIME average write time0
AVG_WAIT_TIME average wait time0

Key field Non-key field



How do I retrieve data from SAP structure /SDF/ORA_083_DBSNP using ABAP code?

As /SDF/ORA_083_DBSNP 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 /SDF/ORA_083_DBSNP as there is no data to select.

How to access SAP table /SDF/ORA_083_DBSNP

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