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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Basis Components :: ABAP Workbench, Java IDE and Infrastructure :: Workbench Tools Editors, Painters, Modelers :: ABAP Test Frameworks ATC, CheckMan, Code Inspector
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CRM_ECLOG_SCR241Replicated Log Entries of a Script LineABAP Test Frameworks ATC, CheckMan, Code Inspector
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT SESSION_ID, LOGID, OBJ_LNR, SCRIPT_LNR, MOD_LNR, SCR_EXPAND, SCR_ERRCD, SCR_CNDCD, SCR_EXDATA, SCR_LEVEL, FUNC, OBJECT, PARAM_ID, SOFTKOMP, PATH, DEST, CMD_LIN, CMD_COL, STIM, RUNTIME, CMDTIME, RFCTIME, SUTTIME, SLOG_MODE FROM CRM_ECLOG_SCR
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1SESSION_IDCheck Results Management: Numberingnvarchar80NUMC(N'00000000')NoCRMSEQNBR Allow NULL? 
2LOGIDCurrent operation numbernvarchar100NUMC(N'0000000000')NoETLOG_ID Allow NULL? 
3OBJ_LNRCurrent Number of Objectnvarchar80NUMC(N'00000000')NoETOBJ_LNR Allow NULL? 
4SCRIPT_LNReCATT Current Number of Script Commandnvarchar100NUMC(N'0000000000')NoETSCR_LNR Allow NULL? 
5MOD_LNReCATT Current No. Nested ECATT in Test Configurationnvarchar100NUMC(N'0000000000')YesETMOD_LNR Allow NULL? 
6SCR_EXPANDeCATT Log Block-Expand Indicator (X = Expandable)char10CHAR(N' ')YesETLOG_EXPD Allow NULL? 
7SCR_ERRCDeCATT Log Error Codenvarchar40NUMC(N'0000')YesETLOG_ERCD Allow NULL? 
8SCR_CNDCDCondition Code X=not ok P=Passed F=Failed T=Traced E=Errorchar10CHAR(N' ')YesETLOG_CNDC Allow NULL? 
9SCR_EXDATAeCATT Log Data Expand Indicator (X = Expandable)char10CHAR(N' ')YesETLOG_EXDA Allow NULL? 
10SCR_LEVELNesting Depth of Recursive Call of eCATT Objectsnvarchar40NUMC(N'0000')YesETLOG_LEV Allow NULL? 
11FUNCName of Commandnvarchar300CHAR(N' ')YesETCMD_FUN Allow NULL? 
12OBJECTObject for functionnvarchar300CHAR(N' ')YesETCMD_OBJ Allow NULL? 
13PARAM_IDParameter Reference IDnvarchar300CHAR(N' ')YesETCMD_PAR Allow NULL? 
14SOFTKOMPTarget System (Key in System Data Container)nvarchar300CHAR(N' ')YesETCMP_CMP Allow NULL? 
15PATHName of Path for Script Variantsnvarchar300CHAR(N' ')YesETCMD_PATH Allow NULL? 
16DESTLogical Destination (Specified in Function Call)nvarchar320CHAR(N' ')Yes*RFCDEST Allow NULL? 
17CMD_LINCommand Position Rownvarchar80NUMC(N'00000000')YesETCMD_LINE Allow NULL? 
18CMD_COLCommand Position Columnnvarchar80NUMC(N'00000000')YesETCMD_POSI Allow NULL? 
19STIMStart timenvarchar60TIMS(N'000000')YesETLOG_STIM Allow NULL? 
20RUNTIMETotal Runtime in the Command Blockdecimal60DEC((0))YesETLOG_RUNTIME
21CMDTIMEInterpretation Time of an eCATT Commanddecimal63DEC((0))YesETLOG_CMDTIME
22RFCTIMERuntime of the Remote Functionalitydecimal63DEC((0))YesETLOG_RFCTIME
23SUTTIMERuntime of internal functionality called in SUTdecimal63DEC((0))YesETLOG_SUTTIME
24SLOG_MODEeCATT - Mode for Short Logchar10CHAR(N' ')YesETSHORTLOG_MODE Allow NULL? 
NamePrimaryUniqueTypeColumns
CRM_ECLOG_SCR~0YesYesCLUSTEREDSCRIPT_LNR, OBJ_LNR, LOGID, SESSION_ID