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 :: Enterprise Service Infrastructure :: Web Service Infrastructure :: Web Service and SOAP - ABAP
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0SRT_MONLOG_DATA2567SOAP Runtime Table for Monitoring and Log Data RecordsWeb Service and SOAP - ABAP
SQL:  selectupdate insert create

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

SELECT CALL_ID, TS_CALL, DURATION, NETHDRTIME, PARENT_CALLID, CDP_TYPE, COMPLETE, USERNAME, SYS_SID, SYS_NR, SAPCLIENT, HOSTNAME, APPLSERVER, CALL_STATE, ERRORTYPE, ERRORAREA, MSG_STATE, PROC_STATE, TERM_STATE, LOCATION, ISRESUME, DIRECTION, IS_ASYNC, IS_SHORTCUT, CALLEDPROG, SESSION_ID, COMM_PATT, SOAP_APPL, DT_OBJ, IF_NAME_I, IF_NAME_E, IF_NS_E, RESP_SIZE, REQ_SIZE, MEMCONSUMP, REQ_ID, RESP_ID, PERSIST_ID, SOAP_SEQID, WSRM_SEQID, TRC_PATT, TRC_KEY, PASSPORT_VERS, REQ_BASED, TRC_SSID, TRC_USER, TRC_TS, TRC_COUNT, TRC_EXT, OP_NAME, OP_NS, LP_NAME, CONF_ID, BIND_ID, REMADDR, LT_RECORDS FROM SRT_MONLOG_DATA2
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CALL_IDGUID_32 as ID for Part of Web Service Callnvarchar320CHAR(N' ')NoSRT_MONI_ID Allow NULL? 
2TS_CALLUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217DEC((0))YesTIMESTAMPL
3DURATIONNatural Numberint100INT4((0))YesINT4 Allow NULL? 
4NETHDRTIMENatural Numberint100INT4((0))YesINT4 Allow NULL? 
5PARENT_CALLIDGUID in 'CHAR' Format in Uppercasenvarchar320CHAR(N' ')YesGUID_32 Allow NULL? 
6CDP_TYPEType of Context Data Providernvarchar200CHAR(N' ')YesSRT_MONI_CTX_DATAPROVIDER_TYPE Allow NULL? 
7COMPLETEnvarchar20(N' ')Yes Allow NULL? 
8USERNAMEUser Namenvarchar120CHAR(N' ')YesSYUNAME Allow NULL? 
9SYS_SIDName of SAP Systemnvarchar80CHAR(N' ')YesSYSYSID Allow NULL? 
10SYS_NRSystem Numbernvarchar20CHAR(N' ')YesSRT_MONI_SYSNR Allow NULL? 
11SAPCLIENTClient IDnvarchar30CLNT(N'000')Yes*SYMANDT Allow NULL? 
12HOSTNAMEApplication Servernvarchar320CHAR(N' ')YesSYHOST Allow NULL? 
13APPLSERVERApplication Server in ABAP Systemnvarchar400CHAR(N' ')YesSRT_MONI_APPLSERVER Allow NULL? 
14CALL_STATESOAP Monitoring Status Informationchar10CHAR(N' ')YesSRT_MONI_STATUS Allow NULL? 
15ERRORTYPEError Type for Web Service Monitoringnvarchar100CHAR(N' ')YesSRT_MONI_ERRORTYPE Allow NULL? 
16ERRORAREAError Area for Web Service Monitoringnvarchar100CHAR(N' ')YesSRT_MONI_ERRORAREA Allow NULL? 
17MSG_STATEIntegration Engine: Message Statusnvarchar30NUMC(N'000')Yes*SXMSPMSTAT Allow NULL? 
18PROC_STATESoap sequence process statuschar10CHAR(N' ')YesSRT_SEQ_PROCESS_STATE Allow NULL? 
19TERM_STATESoap sequence termination statechar10CHAR(N' ')YesSRT_SEQ_TERMINATION_STATE Allow NULL? 
20LOCATIONSOAP Web Service Component Localizationchar10CHAR(N' ')YesSRT_MONI_LOC Allow NULL? 
21ISRESUMEBoolean Variable (X=True, -=False, Space=Unknown)char10CHAR(N' ')YesBOOLEAN Allow NULL? 
22DIRECTIONSOAP Web Service Direction (Inbound, Outbound)char10CHAR(N' ')YesSRT_MONI_DIRECTION Allow NULL? 
23IS_ASYNCBoolean Variable (X=True, -=False, Space=Unknown)char10CHAR(N' ')YesBOOLEAN Allow NULL? 
24IS_SHORTCUTBoolean Variable (X=True, -=False, Space=Unknown)char10CHAR(N' ')YesBOOLEAN Allow NULL? 
25CALLEDPROGnvarchar2550(N'')Yes Allow NULL? 
26SESSION_IDSession IDnvarchar400CHAR(N' ')YesSRT_MONI_SESSIONID Allow NULL? 
27COMM_PATTnvarchar2550(N'')Yes Allow NULL? 
28SOAP_APPLSOAP Application Name of SOAP Runtimenvarchar600CHAR(N' ')YesSRT_MONI_APPLICATION Allow NULL? 
29DT_OBJnvarchar2550(N'')Yes Allow NULL? 
30IF_NAME_ISOAP Runtime Interface Name (Internal Name)nvarchar300CHAR(N' ')YesSRT_MONI_IFNAME Allow NULL? 
31IF_NAME_Envarchar2550(N'')Yes Allow NULL? 
32IF_NS_Envarchar2550(N'')Yes Allow NULL? 
33RESP_SIZENatural Numberint100INT4((0))YesINT4 Allow NULL? 
34REQ_SIZENatural Numberint100INT4((0))YesINT4 Allow NULL? 
35MEMCONSUMPDEC type that is suitable for 64 bit integerdecimal200DEC((0))YesABAP_MSIZE
36REQ_IDGUID in 'CHAR' Format in Uppercasenvarchar320CHAR(N' ')YesGUID_32 Allow NULL? 
37RESP_IDGUID in 'CHAR' Format in Uppercasenvarchar320CHAR(N' ')YesGUID_32 Allow NULL? 
38PERSIST_IDGUID in 'CHAR' Format in Uppercasenvarchar320CHAR(N' ')YesGUID_32 Allow NULL? 
39SOAP_SEQIDGUID in 'CHAR' Format in Uppercasenvarchar320CHAR(N' ')YesGUID_32 Allow NULL? 
40WSRM_SEQIDAny URInvarchar2550(N'')YesANYURI Allow NULL? 
41TRC_PATTSOAP Runtime Trace Context Patternntext10737418230YesSRT_MONI_TRC_PATTERN
42TRC_KEYSOAP Runtime Trace Context Keynvarchar320CHAR(N' ')YesSRT_MONI_TRC_KEY Allow NULL? 
43PASSPORT_VERSPassport Versionsmallint50INT2((0))YesSRT_MONI_PP_VERSION
44REQ_BASEDBoolean Variable (X=True, -=False, Space=Unknown)char10CHAR(N' ')YesBOOLEAN Allow NULL? 
45TRC_SSIDSource System SIDnvarchar120CHAR(N' ')YesSRT_MONI_SSID Allow NULL? 
46TRC_USERUser Namenvarchar120CHAR(N' ')YesSRT_MONI_USER Allow NULL? 
47TRC_TSUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217DEC((0))YesTIMESTAMPL
48TRC_COUNTSOAP Runtime Trace Context Counternvarchar20NUMC(N'00')YesSRT_MONI_TRC_COUNTER Allow NULL? 
49TRC_EXTBoolean Variable (X=True, -=False, Space=Unknown)char10CHAR(N' ')YesBOOLEAN Allow NULL? 
50OP_NAMEnvarchar2550(N'')Yes Allow NULL? 
51OP_NSnvarchar2550(N'')Yes Allow NULL? 
52LP_NAMELogical Port Namenvarchar600CHAR(N' ')YesSRT_LP_NAME Allow NULL? 
53CONF_IDGUID in 'CHAR' Format in Uppercasenvarchar320CHAR(N' ')YesGUID_32 Allow NULL? 
54BIND_IDGUID in 'CHAR' Format in Uppercasenvarchar320CHAR(N' ')YesGUID_32 Allow NULL? 
55REMADDRRemote IP Address of Consumernvarchar450CHAR(N' ')YesSRT_MONI_REM_IPADDR Allow NULL? 
56LT_RECORDSimage21474836470Yes
NamePrimaryUniqueTypeColumns
SRT_MONLOG_DATA2~0YesYesCLUSTEREDCALL_ID
SRT_MONLOG_DATA2~1NoNoNONCLUSTEREDSAPCLIENT, APPLSERVER, DT_OBJ, USERNAME, NETHDRTIME, CALL_STATE, TS_CALL
SRT_MONLOG_DATA2~2NoNoNONCLUSTEREDRESP_ID
SRT_MONLOG_DATA2~3NoNoNONCLUSTEREDREQ_ID
SRT_MONLOG_DATA2~4NoNoNONCLUSTEREDSOAP_SEQID
SRT_MONLOG_DATA2~5NoNoNONCLUSTEREDSESSION_ID
SRT_MONLOG_DATA2~6NoNoNONCLUSTEREDTS_CALL, TRC_KEY