SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | GVD_SESSION
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Basis Components :: Use Subcomponents :: Monitoring :: Performance Monitors TCC
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0GVD_SESSION491Oracle monitoring: Snapshot table for GV$SESSIONPerformance Monitors TCC
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT SNAPSHOT_ID, INST_ID, SADDR, SID, SERIAL, AUDSID, PADDR, OUSER, USERNAME, COMMAND, OWNERID, TADDR, LOCKWAIT, STATUS, SERVER, OSCHEMA, SCHEMANAME, OSUSER, PROCESS, MACHINE, TERMINAL, OPROGRAM, TYPE, SQL_ADDRESS, SQL_HASH_VALUE, PREV_SQL_ADDR, PREV_HASH_VALUE, OMODULE, MODULE_HASH, ACTION, ACTION_HASH, CLIENT_INFO, FIXED_TABLE_SEQU, ROW_WAIT_OBJ, ROW_WAIT_FILE, ROW_WAIT_BLOCK, ROW_WAIT_ROW, LOGON_TIME, LAST_CALL_ET, PDML_ENABLED, FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER, RESOURCE_CONSUME, PDML_STATUS, PDDL_STATUS, PQ_STATUS, CURRENT_QUEUE_DU, CLIENT_IDENTIFIE FROM GVD_SESSION
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1SNAPSHOT_IDOracle monitor: snapshot IDnvarchar100NUMC(N'0000000000')No*ORA_SNAPSHOT_ID Allow NULL? 
2INST_IDOracle monitor: Instance IDdecimal220DEC((0))NoORA_INST_ID
3SADDROracle monitoring: Session addressvarbinary80RAWNoORA_SADDR
4SIDOracle monitoring: SID (Session)decimal220DEC((0))NoORA_SID
5SERIALOracle monitoring: SERIAL#: Session serial numberdecimal220DEC((0))YesORA_SERIAL
6AUDSIDOracle monitoring: AUDSID: Auditing session IDdecimal220DEC((0))YesORA_AUDSID
7PADDROracle monitoring: PADDR: Address of proc. owning the sess.varbinary80RAWYesORA_PADDR
8OUSEROracle monitoring: USER#: Oracle user identifierdecimal220DEC((0))YesORA_USER
9USERNAMEOracle monitoring: USERNAME: Oracle usernamenvarchar300CHAR(N' ')YesORA_USERNAME Allow NULL? 
10COMMANDOracle monitoring: COMMAND: Command in progressdecimal220DEC((0))YesORA_COMMAND
11OWNERIDOracle monitoring: OWNERID: session ownerdecimal220DEC((0))YesORA_OWNERID
12TADDROracle monitoring: TADDR: Address of transaction state obj.nvarchar160CHAR(N' ')YesORA_TADDR Allow NULL? 
13LOCKWAITOracle monitoring: LOCKWAIT: Address of lock waiting fornvarchar160CHAR(N' ')YesORA_LOCKWAIT Allow NULL? 
14STATUSOracle monitoring: STATUS: Status of the sessionnvarchar80CHAR(N' ')YesORA_SSTATUS Allow NULL? 
15SERVEROracle monitoring: SERVER: Server typenvarchar90CHAR(N' ')YesORA_SERVER Allow NULL? 
16OSCHEMAOracle monitoring: SCHEMA#: Schema user identifierdecimal220DEC((0))YesORA_SCHEMA
17SCHEMANAMEOracle monitoring: SCHEMANAME: Schema user namenvarchar300CHAR(N' ')YesORA_SCHEMANAME Allow NULL? 
18OSUSEROracle monitoring: OSUSER: Operating system client user namenvarchar300CHAR(N' ')YesORA_OSUSER Allow NULL? 
19PROCESSOracle monitoring: OS Process Idnvarchar120CHAR(N' ')YesORA_PROCESS Allow NULL? 
20MACHINEOracle monitoring: MACHINE: Operating system machine namenvarchar640CHAR(N' ')YesORA_MACHINE Allow NULL? 
21TERMINALOracle monitoring: MACHINE: Operating system machine namenvarchar300CHAR(N' ')YesORA_TERMINAL Allow NULL? 
22OPROGRAMOracle monitoring: PROGRAM: Operating system program namenvarchar480CHAR(N' ')YesORA_PROGRAM Allow NULL? 
23TYPEOracle monitoring: TYPE: Session typenvarchar100CHAR(N' ')YesORA_STYPE Allow NULL? 
24SQL_ADDRESSOracle monitoring: SQL_ADDRESS: SQL Statement IDvarbinary80RAWYesORA_SQL_ADDRESS
25SQL_HASH_VALUEOracle monitoring: SQL_HASH_VALUE: SQL statement hashdecimal220DEC((0))YesORA_SQL_HASH_VALUE
26PREV_SQL_ADDROracle monitoring: PREV_SQL_ADDR: Prev. SQL Statement IDvarbinary80RAWYesORA_PREV_SQL_ADDR
27PREV_HASH_VALUEOracle monitoring: PREV_HASH_VALUE: Prev. SQL Statement hashdecimal220DEC((0))YesORA_PREV_HASH_VALUE
28OMODULEOracle monitoring: MODULE: currently executing modulenvarchar480CHAR(N' ')YesORA_MODULE Allow NULL? 
29MODULE_HASHOracle monitoring: MODULE_HASH: curr. executing module hashdecimal220DEC((0))YesORA_MODULE_HASH
30ACTIONOracle monitoring: ACTION: Currently executing actionnvarchar320CHAR(N' ')YesORA_ACTION Allow NULL? 
31ACTION_HASHOracle monitoring: ACTION: Currently executing action hashdecimal220DEC((0))YesORA_ACTION_HASH
32CLIENT_INFOOracle monitoring: CLIENT_INFOnvarchar640CHAR(N' ')YesORA_CLIENT_INFO Allow NULL? 
33FIXED_TABLE_SEQUOracle monitoring: ORA_FIXED_TABLE_SEQUENCEdecimal220DEC((0))YesORA_FIXED_TABLE_SEQUENCE
34ROW_WAIT_OBJOracle monitoring: ROW_WAIT_OBJdecimal220DEC((0))YesORA_ROW_WAIT_OBJ
35ROW_WAIT_FILEOracle monitoring: ROW_WAIT_FILEdecimal220DEC((0))YesORA_ROW_WAIT_FILE
36ROW_WAIT_BLOCKOracle monitoring: ROW_WAIT_BLOCKdecimal220DEC((0))YesORA_ROW_WAIT_BLOCK
37ROW_WAIT_ROWOracle monitoring: ROW_WAIT_ROWdecimal220DEC((0))YesORA_ROW_WAIT_ROW
38LOGON_TIMEOracle monitoring: LOGON_TIME (Time): Time of logonnvarchar60TIMS(N'000000')YesORA_LOGON_TIME Allow NULL? 
39LAST_CALL_ETOracle monitoring:LAST_CALL_ET: The last calldecimal220DEC((0))YesORA_LAST_CALL_ET
40PDML_ENABLEDOracle monitoring: PDML_ENABLEDnvarchar30CHAR(N' ')YesORA_PDML_ENABLED Allow NULL? 
41FAILOVER_TYPEOracle monitoring: FAILOVER_TYPE: Failover type for sessionnvarchar130CHAR(N' ')YesORA_FAILOVER_TYPE Allow NULL? 
42FAILOVER_METHODOracle monitoring: FAILOVER_METHO: Failover method for sess.nvarchar100CHAR(N' ')YesORA_FAILOVER_METHOD Allow NULL? 
43FAILED_OVEROracle monitoring: FAILED_OVER: Sess. in Failover Modenvarchar30CHAR(N' ')YesORA_FAILED_OVER Allow NULL? 
44RESOURCE_CONSUMEOracle monitoring: RESOURCE_CONSUMER_GROUPnvarchar320CHAR(N' ')YesORA_RESOURCE_CONSUMER_GROUP Allow NULL? 
45PDML_STATUSOracle monitoring: PDML_STATUS: Parallel DML statusnvarchar80CHAR(N' ')YesORA_PDML_STATUS Allow NULL? 
46PDDL_STATUSOracle monitoring: PDML_STATUS: Parallel DDL statusnvarchar80CHAR(N' ')YesORA_PDDL_STATUS Allow NULL? 
47PQ_STATUSOracle monitoring: PDML_STATUS: Parallel QUERY statusnvarchar80CHAR(N' ')YesORA_PQ_STATUS Allow NULL? 
48CURRENT_QUEUE_DUOracle monitoring: CURRENT_QUEUE_DURATIONdecimal220DEC((0))YesORA_CURRENT_QUEUE_DURATION
49CLIENT_IDENTIFIEOracle monitoring: ORA_CLIENT_IDENTIFIERnvarchar640CHAR(N' ')YesORA_CLIENT_IDENTIFIER Allow NULL? 
NamePrimaryUniqueTypeColumns
GVD_SESSION~0YesYesCLUSTEREDSID, SADDR, INST_ID, SNAPSHOT_ID

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy