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
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

73 columns | Print definition?ERP 6.0  | SESSION_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CIDEON/LOGLogtabelle4SESSION_IDnvarchar320
2/IXOS/RSA_STATUSAdditional information for status protocol3SESSION_IDData Element: JSessionIDnvarchar500
3/MRSS/D_CH_DEMSignatures and Change Date/Time for Demands5SESSION_IDUnique ID to identify the logon session of a usernvarchar400
4/SAPSRM/C_OCI_SESecure Catalog Launch Credentials1SESSION_IDCharacter field, length 32nvarchar320
5CNVCMIS_U_LANGUCMIS: Store for process language entries2SESSION_IDMBT PCL: Session IDnvarchar200
6CNVMBTSESSIONIDMBT PCL Session ID level4SESSION_IDMBT PCL: Session IDnvarchar200
7CNVMBTSTATEStatus table for execution of all activities and history28SESSION_IDMBT PCL: Session IDnvarchar200
8CNVMBTSUBSTATEStatus table for execution of all subactivities and histor2SESSION_IDMBT PCL: Session IDnvarchar200
9DOCR_LOG_HEADERDBOSC-CR: Log Header7SESSION_IDnvarchar400
10DOCR_TRC_HEADERDBOSC-CR: Trace Header4SESSION_IDnvarchar400
11DOCR_TRC_RECORDDBOSC-CR: Trace Records1SESSION_IDnvarchar400
12ECWD_TRACEeCATT - Trace for Web Dynpro Recording1SESSION_IDnvarchar320
13EPIC_EBOE_HISTTable of EBoE History2SESSION_IDTransaction IDnvarchar100
14IUUC_CLONE_PIT_OClone PIT determination auxiliary table2SESSION_IDint100
15SRAL_TRACE_FUNCSRAL Functional Trace2SESSION_IDUUID in character formnvarchar320
16SRAL_TRACE_HDRSRAL Trace Header Data2SESSION_IDUUID in character formnvarchar320
17SRAL_TRACE_PERFSRAL Performance Trace2SESSION_IDUUID in character formnvarchar320
18STC_SESSION_BPTask List Run Breakpoint2SESSION_IDTask List Runnvarchar500
19WDR_USAGE_LOGWeb Dynpro: Recording of Usage Log Data2SESSION_IDGlobal Unique ID for tablevarbinary160
20/BOBF/D_CC_LOG_HBOPF Contract Compliance Check Log header14SESSION_IDGlobal Unique ID for tablevarbinary160
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
21CRMRSFACMPResult of a Comparision with FA Reference DB13SESSION_IDMode IDnvarchar330
22CRM_CATJCATT - Log Index1SESSION_IDCheck Results Management: Numberingnvarchar80
23CRM_CATLCATT: Log Process Data1SESSION_IDCheck Results Management: Numberingnvarchar80
24CRM_CATMCATT: Log for model and function data1SESSION_IDCheck Results Management: Numberingnvarchar80
25CRM_CATTTCK: CATT State Data for Checkman16SESSION_IDCheck Results Management: Numberingnvarchar80
26CRM_CATT_LOGSCATT Data, Prepared for Conversion9SESSION_IDCheck Results Management: Numberingnvarchar80
27CRM_CATT_MSGCATT Messages (prepared for Conversion in CHECKMAN)16SESSION_IDCheck Results Management: Numberingnvarchar80
28CRM_ECATTTCK: eCATT State Data for Checkman16SESSION_IDCheck Results Management: Numberingnvarchar80
29CRM_ECATT_LOGSeCATT Data, Prepared for Conversion4SESSION_IDCheck Results Management: Numberingnvarchar80
30CRM_ECATT_MSGeCATT Messages (Prepared for Conversion in CHECKMAN)15SESSION_IDCheck Results Management: Numberingnvarchar80
31CRM_ECLOG_DATAReplicated Runtime Data of the Script1SESSION_IDCheck Results Management: Numberingnvarchar80
32CRM_ECLOG_HEADTable for Replicated eCATT Log Header1SESSION_IDCheck Results Management: Numberingnvarchar80
33CRM_ECLOG_SCNTReplicated Log Additional Lines for a Script Line1SESSION_IDCheck Results Management: Numberingnvarchar80
34CRM_ECLOG_SCRReplicated Log Entries of a Script Line1SESSION_IDCheck Results Management: Numberingnvarchar80
35CRM_ECLOG_XDATReplicated Runtime Data of the Script1SESSION_IDCheck Results Management: Numberingnvarchar80
36CRM_EC_SESSIONSSession Info for eCATT Conversion1SESSION_IDCheck Results Management: Numberingnvarchar80
37CRM_VERI_LOGSVERI Data, Prepared for Conversion4SESSION_IDCheck Results Management: Numberingnvarchar80
38SATC_RT_RUN_KEYMovement data (runtime repository) - Entity keys10SESSION_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
TOPATC extensions for Technical Check
39SATC_AC_RESULTVCResults of comparision with RefDB18SESSION_IDnvarchar330
TOPAuthentication and SSO
40TRACE_MESSAGEContains trace messages3SESSION_ID64-bit integerdecimal200
41TRACE_SESSIONKeeps an informaton for the trace sessions2SESSION_ID64-bit integerdecimal200
TOPBasic Functions
42MMPUROCI_SEMM Purchasing Secure Catalog Launch Credentials1SESSION_IDCharacter field, length 32nvarchar320
TOPCross-Application Components
43FRE_ORD_FILE_OUTFilenames of saved files from Outbound2SESSION_IDChar 15nvarchar150
TOPEasy Enhancement Workbench
44AXT_EXT_GENTo be generated extension1SESSION_IDGUIDnvarchar320
TOPeCATT Extended Computer Aided Test Tool
45ECWD_APP_TERMTable of Completed WD Applications During Recording2SESSION_IDGUID in 'CHAR' Format in Uppercasenvarchar320
46ECWD_APP_TERM2Table of Completed WD Applications During Recording2SESSION_IDGUID in 'CHAR' Format in Uppercasenvarchar320
47ECWD_RECORDTable for Recording Data Transfer to WebDynpro2SESSION_IDGUID in 'CHAR' Format in Uppercasenvarchar320
48ECWD_RECORD2Table for Recording Data Transfer to WebDynpro2SESSION_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPGENeric Integer Optimizer System
49GENIOSD_INDCONSTGENIOS: Indicator Constraints2SESSION_IDGENIOS: Session IDnvarchar220
50GENIOSD_LINCONSTGENIOS: Linear Constraints2SESSION_IDGENIOS: Session IDnvarchar220
51GENIOSD_LINMONOMGENIOS: Linear Constraint Monomes2SESSION_IDGENIOS: Session IDnvarchar220
52GENIOSD_LOG_RUNGENIOS: Log Solver Run2SESSION_IDGENIOS: Session IDnvarchar220
53GENIOSD_OBJECTIVGENIOS: Objectives2SESSION_IDGENIOS: Session IDnvarchar220
54GENIOSD_OBJMONOMGENIOS: Objective Monomes2SESSION_IDGENIOS: Session IDnvarchar220
55GENIOSD_VARIABLEGENIOS: Variables2SESSION_IDGENIOS: Session IDnvarchar220
TOPNetWeaver Enterprise Search
56ESH_QL_QLOGQuery Log3SESSION_IDSearch Session IDnvarchar320
TOPPerformance Monitors TCC
57GVD_LOCKED_OBJECCopy of GV$LOCKED_OBJECT7SESSION_IDOracle monitoring: Session IDdecimal220
58ORA_RESUMABLEOracle monitor: Copy of DBA_RESUMABLE3SESSION_IDOracle monitor: Session iddecimal220
TOPRecords and Case Management
59RMPS_AI_SESSSave Session4SESSION_IDTechnical Key of Operation (GUID)nvarchar320
60RMPS_AI_SESS_DOCDocuments for Saving Session2SESSION_IDTechnical Key of Operation (GUID)nvarchar320
TOPRuntime for ABAP based automated TC
61STC_SESSIONTask List Runs2SESSION_IDTask List Runnvarchar500
62STC_SESSION_EXIMTask List Runs for Refresh2SESSION_IDTask List Runnvarchar500
63STC_TM_EXECUTIONTemporary Task List Run Execution Control2SESSION_IDTask List Runnvarchar500
TOPSAP Query
64AQPROTQuery Logging2SESSION_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPVirtual Machine Container
65CPT_REQ_METACPT Request Metadata6SESSION_IDntext10737418230
TOPWeb Service and SOAP - ABAP
66SRT_CFG_LOG_HDRTable for WebService Configuration Logging2SESSION_IDSession Id for Loggingnvarchar320
67SRT_CFG_LOG_ITEMSRT Logging: Item Table2SESSION_IDSession Id for Loggingnvarchar320
68SRT_CFG_LOG_SRCHSRT Logging: Search Table for Attributes2SESSION_IDSession Id for Loggingnvarchar320
69SRT_LOG_TENANT_RSRT Config: Log Session and Tenant Relationship2SESSION_IDSession Id for Loggingnvarchar320
70SRT_MONILOG_DATASOAP Runtime Table for Monitoring and Log Data Records26SESSION_IDSession IDnvarchar400
71SRT_MONLOG_DATA2SOAP Runtime Table for Monitoring and Log Data Records26SESSION_IDSession IDnvarchar400
72SRT_SOAM_CONNECTSOAManager Connectivity : Application data for distribution7SESSION_IDSOAManager Connectivity : Identifier (GUID)nvarchar320
TOPWorkbench Utilities
73RLB_DB_SCReuse Library: Statistics1SESSION_IDGUID in 'CHAR' Format in Uppercasenvarchar320