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

38 columns | Print definition?ERP 6.0  | LOG_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DBA_LOG_DETAILDBA: Details for Audit/Trace Log for DBA Cockpit1LOG_IDnvarchar320
2DBA_LOG_HEADERDBA: Audit/Trace Log for DBA Cockpit1LOG_IDnvarchar320
3DOCR_LOG_HEADERDBOSC-CR: Log Header1LOG_IDDBOSC-CR: Generated ID (8)nvarchar80
4DOCR_LOG_RECORDDBOSC-CR: Log Records1LOG_IDDBOSC-CR: Generated ID (8)nvarchar80
5SRAL_CFG_LNKRead Access Logging: Used configuration in log entry2LOG_IDRead Access Logging: Log IDnvarchar320
6SRAL_DATARead Access Logging: Data2LOG_IDRead Access Logging: Log IDnvarchar320
7SRAL_EXP_DATARAL expanded log - data4LOG_IDRead Access Logging: Log IDnvarchar320
8SRAL_EXP_ENVRAL expanded log - env4LOG_IDRead Access Logging: Log IDnvarchar320
9SRAL_EXP_LOGRAL expanded log - header table4LOG_IDRead Access Logging: Log IDnvarchar320
10SRAL_LOGRead Access Logging: Log2LOG_IDRead Access Logging: Log IDnvarchar320
11SRAL_LOG_ENVRead Access Logging: Access Environment2LOG_IDRead Access Logging: Log IDnvarchar320
12SRAL_LOG_PERFRead Access Logging: Log (modified version for performance)2LOG_IDnvarchar320
TOPAccounting Engine
13/EACC/TDR_STEPSDerivation Steps4LOG_IDLogical ID of a Derivation Stepnvarchar300
TOPData Basis
14RSBREQUIDOpen Hub: Requests17LOG_IDLog-ID of a Process Chain Runnvarchar250
TOPData Staging
15RSMONPCLoad-Monitor Connection of Process Runs2LOG_IDLog-ID of a Process Chain Runnvarchar250
16RSPCABAPASYNCLogging for ABAP Processes(Synchronously and Asynchronously)3LOG_IDLog-ID of a Process Chain Runnvarchar250
17RSPCACTIVECHECKResults of Active Check with PC_ACTIVE Process Type3LOG_IDLog-ID of a Process Chain Runnvarchar250
18RSPCEXORExcluding Or: Log Table2LOG_IDLog-ID of a Process Chain Runnvarchar250
19RSPCINTERRUPTLOGTable for Interrupt Processes3LOG_IDLog-ID of a Process Chain Runnvarchar250
20RSPCKILLRuns to be Terminated1LOG_IDLog-ID of a Process Chain Runnvarchar250
21RSPCLOGCHAINCross-Table Log ID / Chain ID2LOG_IDLog-ID of a Process Chain Runnvarchar250
22RSPCPROCESSLOGLogs for the Chain Runs1LOG_IDLog-ID of a Process Chain Runnvarchar250
23RSPCSYNCLOCKDummy Table for Locks for Synchronous Execution1LOG_IDLog-ID of a Process Chain Runnvarchar250
24RSPC_BUFFERShared Buffer for Processes (Esp. Customer Programs)5LOG_IDLog-ID of a Process Chain Runnvarchar250
TOPGovernance, Risk and Compliance
25GRFNREPLOGSETReport: Log settings for further check2LOG_IDReporting: Log IDnvarchar320
TOPHierarchy Storage
26TTREE_FLPHierarchy tool: Link between filter, log. and phys. str.2LOG_IDUnique ID - 32 charactersnvarchar320
TOPOLAP Technology
27RSDDSTATDTPTable for WHM Statistics. Details DTP3LOG_IDLog-ID of a Process Chain Runnvarchar250
28RSR_CACHE_CLUCache Cluster Storage for Data2LOG_IDCharacter field, length 32nvarchar320
29RSR_CACHE_LOGOLAP Cache Table for Saving Log Entries10LOG_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPPatient Management
30N1TC_ACCESS_LOGLog of Access to Treatment Contracts Applied for2LOG_IDID of Log Entry of Treatment Contractnvarchar320
TOPProcess Controls
31GRPCRMPLANLOGRM plan action logs2LOG_IDGUIDvarbinary160
32GRPCTLLOGtestlog action logs2LOG_IDGUIDvarbinary160
TOPSAP Utilities
33TEAMI_LOG_DATALog for Service Communication in AMI Environment2LOG_IDInternal Number of AMI Log Entrynvarchar220
34TEAMI_LOG_MSGMessages for AMI Communication (TEAMI_LOG_DATA)2LOG_IDInternal Number of AMI Log Entrynvarchar220
TOPService Data Download
35/SOMO/JOSCHEDLJob scheduling table for business process monitoring80LOG_IDnvarchar250
TOPTransaction Manager
36TEXT_COMM_LOGCommunication log3LOG_IDCommunication log IDnvarchar150
TOPTranslation Tools
37LXE_OBJ_EXP_LOGObject export log2LOG_IDLog IDnvarchar70
TOPWorkforce Management Core
38WFMFC_OPTIMZLOGSOptimization Logs2LOG_IDLog Idnvarchar500