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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
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 TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1SNAPSHOT_IDOracle monitor: snapshot IDnvarchar100 Allow NULL? 
2INST_IDOracle monitor: Instance IDdecimal220
3SADDROracle monitoring: Session addressvarbinary80
4SIDOracle monitoring: SID (Session)decimal220
5SERIALOracle monitoring: SERIAL#: Session serial numberdecimal220
6AUDSIDOracle monitoring: AUDSID: Auditing session IDdecimal220
7PADDROracle monitoring: PADDR: Address of proc. owning the sess.varbinary80
8OUSEROracle monitoring: USER#: Oracle user identifierdecimal220
9USERNAMEOracle monitoring: USERNAME: Oracle usernamenvarchar300 Allow NULL? 
10COMMANDOracle monitoring: COMMAND: Command in progressdecimal220
11OWNERIDOracle monitoring: OWNERID: session ownerdecimal220
12TADDROracle monitoring: TADDR: Address of transaction state obj.nvarchar160 Allow NULL? 
13LOCKWAITOracle monitoring: LOCKWAIT: Address of lock waiting fornvarchar160 Allow NULL? 
14STATUSOracle monitoring: STATUS: Status of the sessionnvarchar80 Allow NULL? 
15SERVEROracle monitoring: SERVER: Server typenvarchar90 Allow NULL? 
16OSCHEMAOracle monitoring: SCHEMA#: Schema user identifierdecimal220
17SCHEMANAMEOracle monitoring: SCHEMANAME: Schema user namenvarchar300 Allow NULL? 
18OSUSEROracle monitoring: OSUSER: Operating system client user namenvarchar300 Allow NULL? 
19PROCESSOracle monitoring: OS Process Idnvarchar120 Allow NULL? 
20MACHINEOracle monitoring: MACHINE: Operating system machine namenvarchar640 Allow NULL? 
21TERMINALOracle monitoring: MACHINE: Operating system machine namenvarchar300 Allow NULL? 
22OPROGRAMOracle monitoring: PROGRAM: Operating system program namenvarchar480 Allow NULL? 
23TYPEOracle monitoring: TYPE: Session typenvarchar100 Allow NULL? 
24SQL_ADDRESSOracle monitoring: SQL_ADDRESS: SQL Statement IDvarbinary80
25SQL_HASH_VALUEOracle monitoring: SQL_HASH_VALUE: SQL statement hashdecimal220
26PREV_SQL_ADDROracle monitoring: PREV_SQL_ADDR: Prev. SQL Statement IDvarbinary80
27PREV_HASH_VALUEOracle monitoring: PREV_HASH_VALUE: Prev. SQL Statement hashdecimal220
28OMODULEOracle monitoring: MODULE: currently executing modulenvarchar480 Allow NULL? 
29MODULE_HASHOracle monitoring: MODULE_HASH: curr. executing module hashdecimal220
30ACTIONOracle monitoring: ACTION: Currently executing actionnvarchar320 Allow NULL? 
31ACTION_HASHOracle monitoring: ACTION: Currently executing action hashdecimal220
32CLIENT_INFOOracle monitoring: CLIENT_INFOnvarchar640 Allow NULL? 
33FIXED_TABLE_SEQUOracle monitoring: ORA_FIXED_TABLE_SEQUENCEdecimal220
34ROW_WAIT_OBJOracle monitoring: ROW_WAIT_OBJdecimal220
35ROW_WAIT_FILEOracle monitoring: ROW_WAIT_FILEdecimal220
36ROW_WAIT_BLOCKOracle monitoring: ROW_WAIT_BLOCKdecimal220
37ROW_WAIT_ROWOracle monitoring: ROW_WAIT_ROWdecimal220
38LOGON_TIMEOracle monitoring: LOGON_TIME (Time): Time of logonnvarchar60 Allow NULL? 
39LAST_CALL_ETOracle monitoring:LAST_CALL_ET: The last calldecimal220
40PDML_ENABLEDOracle monitoring: PDML_ENABLEDnvarchar30 Allow NULL? 
41FAILOVER_TYPEOracle monitoring: FAILOVER_TYPE: Failover type for sessionnvarchar130 Allow NULL? 
42FAILOVER_METHODOracle monitoring: FAILOVER_METHO: Failover method for sess.nvarchar100 Allow NULL? 
43FAILED_OVEROracle monitoring: FAILED_OVER: Sess. in Failover Modenvarchar30 Allow NULL? 
44RESOURCE_CONSUMEOracle monitoring: RESOURCE_CONSUMER_GROUPnvarchar320 Allow NULL? 
45PDML_STATUSOracle monitoring: PDML_STATUS: Parallel DML statusnvarchar80 Allow NULL? 
46PDDL_STATUSOracle monitoring: PDML_STATUS: Parallel DDL statusnvarchar80 Allow NULL? 
47PQ_STATUSOracle monitoring: PDML_STATUS: Parallel QUERY statusnvarchar80 Allow NULL? 
48CURRENT_QUEUE_DUOracle monitoring: CURRENT_QUEUE_DURATIONdecimal220
49CLIENT_IDENTIFIEOracle monitoring: ORA_CLIENT_IDENTIFIERnvarchar640 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