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
Industry Specific :: Industry Solution Oil :: Downstream :: Traders and Schedulers Workbench
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0OIRARNBT141Retail Network Business TypesTraders and Schedulers Workbench
SQL:  selectupdate insert create

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

SELECT MANDT, RNBT, KALVG, APPBK, APPMC, APPCW, APPNN, ICONNAME, RFCDEST_REM, RFCDEST, URL, USE_HR_RETAIL, ORGSTR_CHECK, EXT_PRIC_TOOL FROM OIRARNBT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2RNBTBusiness typenvarchar40CHAR(N' ')NoOIRA_RNBT Allow NULL? 
3KALVGSSR Pricing - Margins procedure assigned to business typechar10CHAR(N' ')YesOIRCTVKVOIRC_KALVG Allow NULL? 
4APPBKApplication flag: Business type relates to bulk businesschar10CHAR(N' ')YesOIRA_APPBK Allow NULL? 
5APPMCApplication flag: Business type relates to merchandising buschar10CHAR(N' ')YesOIRA_APPMC Allow NULL? 
6APPCWApplication flag: Business type relates to car wash businesschar10CHAR(N' ')YesOIRA_APPCW Allow NULL? 
7APPNNApplication flag : Business type not related to a businesschar10CHAR(N' ')YesOIRA_APPNN Allow NULL? 
8ICONNAMEIcon name for retail network business typenvarchar250CHAR(N' ')YesOIRA_RNBTICON Allow NULL? 
9RFCDEST_REMRFC dest. (Retail system) with remote usernvarchar320CHAR(N' ')YesRFCDESOIRA_RFCDEST_NO_USR Allow NULL? 
10RFCDESTRFC destination (Retail system)nvarchar320CHAR(N' ')YesRFCDESOIRA_RFCDEST Allow NULL? 
11URLIS-Oil SSR - Store Workbench WebGate URLnvarchar1320CHAR(N' ')YesOIRH_WGURL Allow NULL? 
12USE_HR_RETAILLogin for system; "URL" is (x = EQ, ' ' = NE) as in oilchar10CHAR(N' ')YesOIRH_LOG Allow NULL? 
13ORGSTR_CHECKOrganization structure check (1=No, 2=Oil, 3=Retail)char10CHAR(N' ')YesOIRB_ORGSTR Allow NULL? 
14EXT_PRIC_TOOLExternal Price Optimizer Activechar10CHAR(N' ')YesOIRB_EXTPRICETOOL Allow NULL? 
NamePrimaryUniqueTypeColumns
OIRARNBT~0YesYesCLUSTEREDRNBT, MANDT