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

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Basis Components :: Use Subcomponents :: Monitoring :: Performance Monitors TCC
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0GVD_DATABASE391Copy of GV$DATABASE (currently not provided with snapshots)Performance 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, DBID, NAME, CREATED_D, CREATED_T, RESETLOGS_CHANGE, RESETLOGS_DATE, RESETLOGS_TIME, PR_RESETLGS_CHG, PR_RESETLGS_DATE, PR_RESETLGS_TIME, LOG_MODE, CHECKPOINT_CHANG, ARCHIVE_CHANGE, CONTROLFILE_TYPE, CONTROLFILE_CR_D, CONTROLFILE_CR_T, CONTROLFILE_SEQU, CONTROLFILE_CHAN, CONTROLFILE_TIMD, CONTROLFILE_TIMT, OPEN_RESETLOGS, VERSION_TIME_D, VERSION_TIME_T, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, REMOTE_ARCHIVE, ACTIVATION, DATABASE_ROLE, ARCHIVELOG_CHANG, SWITCHOVER_STATU, DATAGUARD_BROKER, GUARD_STATUS, SUPP_LG_DATA_MIN, SUPP_LOG_DATA_PK, SUPP_LOG_DATA_UI, FORCE_LOGGING FROM GVD_DATABASE
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
3DBIDOracle monitoring: database iddecimal220DEC((0))NoORA_DBID
4NAMEOracle monitoring: database namenvarchar90CHAR(N' ')YesORA_NAME_DB Allow NULL? 
5CREATED_DOracle monitoring: db creation datenvarchar80DATS(N'00000000')YesORA_CREATED Allow NULL? 
6CREATED_TOracle monitoring: db creation timenvarchar60TIMS(N'000000')YesORA_CREATET Allow NULL? 
7RESETLOGS_CHANGEOracle monitoring: resetlogs change numberdecimal220DEC((0))YesORA_RESETLOGS_CHANGE
8RESETLOGS_DATEOracle monitoring: resetlogs datenvarchar80DATS(N'00000000')YesORA_RESETLOGS_DATE Allow NULL? 
9RESETLOGS_TIMEOracle monitoring: resetlogs timenvarchar60TIMS(N'000000')YesORA_RESETLOGS_TIME Allow NULL? 
10PR_RESETLGS_CHGOracle monitoring: prior resetlogs change numberdecimal220DEC((0))YesORA_PRIOR_RESETLOGS_CHANGE
11PR_RESETLGS_DATEOracle monitoring: prior resetlogs datenvarchar80DATS(N'00000000')YesORA_PRIOR_RESETLOGS_DATE Allow NULL? 
12PR_RESETLGS_TIMEOracle monitoring: prior resetlogs timenvarchar60TIMS(N'000000')YesORA_PRIOR_RESETLOGS_TIME Allow NULL? 
13LOG_MODEOracle monitoring: db log modenvarchar120CHAR(N' ')YesORA_LOG_MODE Allow NULL? 
14CHECKPOINT_CHANGOracle Monitoring: checkpoint change#decimal220DEC((0))YesORA_CHECKPOINT_CHANGE
15ARCHIVE_CHANGEOracle monitoring: archive change numberdecimal220DEC((0))YesORA_ARCHIVE_CHANGE
16CONTROLFILE_TYPEOracle monitoring: db controlfile typenvarchar70CHAR(N' ')YesORA_CONTROLFILE_TYPE Allow NULL? 
17CONTROLFILE_CR_DOracle monitoring: db controlfile creation datenvarchar80DATS(N'00000000')YesORA_CONTROLFILE_CREATED Allow NULL? 
18CONTROLFILE_CR_TOracle monitoring: db controlfile creation timenvarchar60TIMS(N'000000')YesORA_CONTROLFILE_CREATET Allow NULL? 
19CONTROLFILE_SEQUOracle monitoring: db controlfile sequence numberdecimal220DEC((0))YesORA_CONTROLFILE_SEQUENCE
20CONTROLFILE_CHANOracle monitoring: controlfile change numberdecimal220DEC((0))YesORA_CONTROLFILE_CHANGE
21CONTROLFILE_TIMDOracle monitoring: db controlfile time (date value)nvarchar80DATS(N'00000000')YesORA_CONTROLFILE_TIMD Allow NULL? 
22CONTROLFILE_TIMTOracle monitoring: db controlfile timenvarchar60TIMS(N'000000')YesORA_CONTROLFILE_TIME Allow NULL? 
23OPEN_RESETLOGSOracle monitoring: db open reset logsnvarchar110CHAR(N' ')YesORA_OPEN_RESETLOGS Allow NULL? 
24VERSION_TIME_DOracle monitoring: db version time (date value)nvarchar80DATS(N'00000000')YesORA_VERSION_TIMD Allow NULL? 
25VERSION_TIME_TOracle monitoring: db version timenvarchar60TIMS(N'000000')YesORA_VERSION_TIME Allow NULL? 
26OPEN_MODEOracle monitoring: db open modenvarchar100CHAR(N' ')YesORA_OPEN_MODE Allow NULL? 
27PROTECTION_MODEOracle monitoring: db protection modenvarchar200CHAR(N' ')YesORA_PROTECTION_MODE Allow NULL? 
28PROTECTION_LEVELOracle monitoring: db protection levelnvarchar200CHAR(N' ')YesORA_PROTECTION_LEVEL Allow NULL? 
29REMOTE_ARCHIVEOracle monitoring: db remote archivenvarchar80CHAR(N' ')YesORA_REMOTE_ARCHIVE Allow NULL? 
30ACTIVATIONOracle monitoring: db activation numberdecimal220DEC((0))YesORA_ACTIVATION
31DATABASE_ROLEOracle monitoring: database rolenvarchar160CHAR(N' ')YesORA_DATABASE_ROLE Allow NULL? 
32ARCHIVELOG_CHANGOracle monitoring: db archivelog chg nbdecimal220DEC((0))YesORA_ARCHIVELOG_CHANGE
33SWITCHOVER_STATUOracle monitoring: db switchover statusnvarchar180CHAR(N' ')YesORA_SWITCHOVER_STATUS Allow NULL? 
34DATAGUARD_BROKEROracle monitoring: db dataguard brokernvarchar80CHAR(N' ')YesORA_DATAGUARD_BROKER Allow NULL? 
35GUARD_STATUSOracle monitoring: db guard statusnvarchar70CHAR(N' ')YesORA_GUARD_STATUS Allow NULL? 
36SUPP_LG_DATA_MINOracle monitoring: db supplemental log data minnvarchar30CHAR(N' ')YesORA_SUPPLEMENTAL_LOG_DATA_MIN Allow NULL? 
37SUPP_LOG_DATA_PKOracle monitoring: db supplemental log data pknvarchar30CHAR(N' ')YesORA_SUPPLEMENTAL_LOG_DATA_PK Allow NULL? 
38SUPP_LOG_DATA_UIOracle monitoring: db log data uinvarchar30CHAR(N' ')YesORA_LOG_DATA_UI Allow NULL? 
39FORCE_LOGGINGOracle monitoring: db force loggingnvarchar30CHAR(N' ')YesORA_FORCE_LOGGING Allow NULL? 
NamePrimaryUniqueTypeColumns
GVD_DATABASE~0YesYesCLUSTEREDDBID, 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