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
1ERP EHP76.0/BOBF/D_CC_LOG_H324BOPF Contract Compliance Check Log header
SQL:  selectupdate insert create

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

SELECT CLNT, LOG_UUID, IF_NAME, METH_NAME, IN_OR_OUT, BO_NAME, CONTENT_CAT, CONTENT_KEY, LOG_DATE, LOG_TIME, CR_USER, BATCH, CPROG, SESSION_ID, SEQ_NO, CALL_STACK, CONTEXT_STACK, REQUEST, RESPONSE, ECATT_LOGID, XI_IB_MESSAGE_ID, TRANSACTION_TYPE, ROOT_CAUSE_TYPE, BOUM_PS_SCR_ID, BOUM_PS_SCR_VAR, BOUM_PS_SCR_RUN, BOUM_PS_ST_NR, BOUM_SC_SCR_ID, BOUM_SC_SCR_VAR, BOUM_SC_SCR_RUN, BOUM_SC_ST_NR, ECATT_INFO FROM /BOBF/D_CC_LOG_H
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1CLNTClientnvarchar30 Allow NULL? 
2LOG_UUIDGlobal Unique ID for tablevarbinary160
3IF_NAMEObject Type Namenvarchar300 Allow NULL? 
4METH_NAMEComponent namenvarchar300 Allow NULL? 
5IN_OR_OUTBOPF Contract Compliance Check Directionchar10 Allow NULL? 
6BO_NAMENamenvarchar300 Allow NULL? 
7CONTENT_CATEntity Categorychar10 Allow NULL? 
8CONTENT_KEYNodeIDvarbinary160
9LOG_DATESystem Datenvarchar80 Allow NULL? 
10LOG_TIMESystem Timenvarchar60 Allow NULL? 
11CR_USERUser Namenvarchar120 Allow NULL? 
12BATCHBackground Processing Activechar10 Allow NULL? 
13CPROGCalling Programnvarchar400 Allow NULL? 
14SESSION_IDGlobal Unique ID for tablevarbinary160
15SEQ_NOint100 Allow NULL? 
16CALL_STACKimage21474836470
17CONTEXT_STACKimage21474836470
18REQUESTimage21474836470
19RESPONSEimage21474836470
20ECATT_LOGIDETLOG_IDnvarchar100 Allow NULL? 
21XI_IB_MESSAGE_IDcorresponds to SXMSMGUIDvarbinary160
22TRANSACTION_TYPEcorresponds to APESICC_TRANSACTION_TYPEnvarchar40 Allow NULL? 
23ROOT_CAUSE_TYPEcorresponds to APESICC_ROOT_CAUSE_TYPEnvarchar40 Allow NULL? 
24BOUM_PS_SCR_IDcorresponds to APESICC_BOUM_TD_IDnvarchar300 Allow NULL? 
25BOUM_PS_SCR_VARcorresponds to APESICC_BOUM_TD_VARnvarchar300 Allow NULL? 
26BOUM_PS_SCR_RUNnvarchar2550 Allow NULL? 
27BOUM_PS_ST_NRcorresponds to APESICC_BOUM_STATEMENT_NRint100 Allow NULL? 
28BOUM_SC_SCR_IDcorresponds to APESICC_BOUM_TD_IDnvarchar300 Allow NULL? 
29BOUM_SC_SCR_VARcorresponds to APESICC_BOUM_TD_VARnvarchar300 Allow NULL? 
30BOUM_SC_SCR_RUNnvarchar2550 Allow NULL? 
31BOUM_SC_ST_NRcorresponds to APESICC_BOUM_STATEMENT_NRint100 Allow NULL? 
32ECATT_INFOimage21474836470
NamePrimaryUniqueTypeColumns
/BOBF/D_CC_LOG_HBONoNoNONCLUSTEREDBO_NAME, CLNT
/BOBF/D_CC_LOG_HDANoNoNONCLUSTEREDLOG_TIME, LOG_DATE, CLNT
/BOBF/D_CC_LOG_HSENoNoNONCLUSTEREDSEQ_NO, SESSION_ID, CLNT
/BOBF/D_CC_LOG_H~0YesYesCLUSTEREDLOG_UUID, CLNT