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

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

28 columns | Print definition?ERP 6.0  | SESSIONID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GUI_E2E_TRACES_RGUI Epp Traces Used Root Context IDs2SESSIONIDTrace Session IDnvarchar320
2PYD_D_USPayroll Data Source Framework: User Session3SESSIONIDPayroll Data Source Framework: Session IDvarbinary160
3STFUTRACEORATrace Switch for Oracle4SESSIONIDint100
4STRACEORAPL/SQL Trace Output - Oracle3SESSIONIDint100
5HRP1721DB Table for Infotype 172122SESSIONIDExternal Academic Sessionnvarchar40
6HRT1719Table Section for Infotype 171921SESSIONIDExternal Academic Sessionnvarchar40
7T7PIQTREXTSESExternal Academic Sessions2SESSIONIDExternal Academic Sessionnvarchar40
8T7PIQTREXTSESTText Table for External Academic Sessions3SESSIONIDExternal Academic Sessionnvarchar40
9T7PIQ_US_SESNMAPNCAA Sessions Mapping2SESSIONIDAcademic Sessionnvarchar30
TOPClientServer Technology
10GUI_E2E_TRACESGui Epp Traces2SESSIONIDTrace Session IDnvarchar320
TOPCustomer Interaction Center
11CCMLOGActivity log2SESSIONIDSession identifiernvarchar100
12CCMSESSIONCall management sessions2SESSIONIDSession identifiernvarchar100
TOPEngineering Desktop
13EDESK_URL_PARAME-Desktop: URL-Parameter1SESSIONIDSession ID in Engineering Desktopnvarchar320
TOPeXternal Management Interface Framework
14BAPIXMLOGRBAPI XMI: Logon information on actions of external mgt tools9SESSIONIDID of XMI sessionnvarchar240
15TXMILOGRAWLog Information on Actions of External Management Tools9SESSIONIDID of XMI sessionnvarchar240
TOPOLAP Technology
16ARCH_IDX_PROTIndex Table for Log Archiving for BI Authorizations4SESSIONIDUUID in character formnvarchar320
17RSECHIE_CLAuthorization Hierarchies Changes Change Log1SESSIONIDUUID in character formnvarchar320
18RSECLOG_CLAnalysis Authorizations BI: Logging Active for User1SESSIONIDUUID in character formnvarchar320
19RSECLOPDLOGFLOPD Protocol: Filter1SESSIONIDUUID in character formnvarchar320
20RSECLOPDLOGHLOPD Logs: Control Data1SESSIONIDUUID in character formnvarchar320
21RSECLOPDLOGILOPD Log: Details1SESSIONIDUUID in character formnvarchar320
22RSECLOPDLOG_CLCopy of RSECLOG_CL1SESSIONIDUUID in character formnvarchar320
23RSECSESSION_CLSession IDs1SESSIONIDUUID in character formnvarchar320
24RSECTXT_CLChange Documents for Document Texts1SESSIONIDUUID in character formnvarchar320
25RSECUSERAUTH_CLBI AS Authorizations: Assignment of User Auth (Change Log)1SESSIONIDUUID in character formnvarchar320
26RSECVAL_CLAuthorization Value Change (Change Log)1SESSIONIDUUID in character formnvarchar320
27RSUDOLOGLogging for Execution As Other User1SESSIONIDUUID in character formnvarchar320
TOPProduct Safety
28TCGSGPEHS: Search parameter (reproduction from SET/GET memory)5SESSIONIDSession Identifiernvarchar200