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

Home | ERP 6.0  | BORGR_PROFILE
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
Logistics - General :: Service Parts Management :: Goods Receipt Process
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0BORGR_PROFILE471Goods Receipt Automotive: ProfilesGoods Receipt Process
SQL:  selectupdate insert create

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

SELECT MANDT, PROFILE, FUNCTION_PROFILE, OBJECT_PROFILE, SEL_PROFILE, FILTER_PROFILE, CONFIG_PROFILE, COLUMN_PROFILE, SAVE_CHANGES, COLUMNS_CHANGE, TREE_VIS, SEC_TREE_VISIBLE, HU_TREE_CHANGE, PROFILE_TYPE, SHOW_INCON_SHPM, SHP_SIGN, SHP_SHOW, DIV_CHANGES, OPT_COM, OPT_SHP, OPT_DEL, SELECT, MESSAGE, SEARCH, URL, SETTING, DATE_SHOW, SHP_CLK, SHP_SEARCH, ASSIGN_DEL, CHECK_SETTING, DEL_CLK, DEL_SEARCH, DEL_UPOS, DEL_INPUT, FILTER_SHOW, VSTEL_SHOW, LGNUM_SHOW, LGTOR_SHOW, LGBZO_SHOW, WERKS_SHOW, LGORT_SHOW, DELVT_SHOW, TONOW_SHOW, KALEN_SHOW, DAYS_SHOW, SHIP_SHOW FROM BORGR_PROFILE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PROFILEProfilenvarchar200CHAR(N' ')NoBOR_PROFILE Allow NULL? 
3FUNCTION_PROFILEProfilenvarchar200CHAR(N' ')YesBORGR_PROFCODE_HBOR_PROFILE Allow NULL? 
4OBJECT_PROFILEProfilenvarchar200CHAR(N' ')YesBORGR_PROFOBJ_HBOR_PROFILE Allow NULL? 
5SEL_PROFILEProfilenvarchar200CHAR(N' ')YesBORGR_PROF_SEL_HBOR_PROFILE Allow NULL? 
6FILTER_PROFILEProfilenvarchar200CHAR(N' ')YesBORGR_FILTER_PROBOR_PROFILE Allow NULL? 
7CONFIG_PROFILEProfilenvarchar200CHAR(N' ')YesBORGR_DIALOG_PROBOR_PROFILE Allow NULL? 
8COLUMN_PROFILEProfilenvarchar200CHAR(N' ')YesBORGR_TREE_COL_HBOR_PROFILE Allow NULL? 
9SAVE_CHANGESSave Screen Settingschar10CHAR(N' ')YesBOR_SAVE_CHANGES_DIAL Allow NULL? 
10COLUMNS_CHANGEArrangement of Columns in Treechar10CHAR(N' ')YesBOR_COLUMNS_CHANGE Allow NULL? 
11TREE_VISTree Visiblechar10CHAR(N' ')YesBOR_TREE_VIS Allow NULL? 
12SEC_TREE_VISIBLEDisplay of Second Treechar10CHAR(N' ')YesBOR_SEC_TREE_VIS Allow NULL? 
13HU_TREE_CHANGEArrangement of Columns in Treechar10CHAR(N' ')YesBOR_COLUMNS_CHANGE Allow NULL? 
14PROFILE_TYPEType of Profilechar10CHAR(N' ')YesBOR_PROFILE_TYPE Allow NULL? 
15SHOW_INCON_SHPMDisplay of Inconsistent Shipmentschar10CHAR(N' ')YesSHOW_INCON_SHPM Allow NULL? 
16SHP_SIGNSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
17SHP_SHOWSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
18DIV_CHANGESSettings in the Dialognvarchar20CHAR(N' ')YesBOR_DIALOG_CHANGE Allow NULL? 
19OPT_COMSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
20OPT_SHPSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
21OPT_DELSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
22SELECTSettings for Worklistchar10CHAR(N' ')YesBOR_OPT_COM_SELECT Allow NULL? 
23MESSAGESettings for Message Displaychar10CHAR(N' ')YesBOR_OPT_COM_MESSAGE Allow NULL? 
24SEARCHSettings for Arrangement of Search Fieldschar10CHAR(N' ')YesBOR_OPT_COM_SEARCH Allow NULL? 
25URLSettings for Display of an URLchar10CHAR(N' ')YesBOR_OPT_COM_URL Allow NULL? 
26SETTINGSettings for Special Display Areaschar10CHAR(N' ')YesBOR_OPT_COM_SETTINGS Allow NULL? 
27DATE_SHOWSettings for Date Displaychar10CHAR(N' ')YesBOR_OPT_SHP_DATE_SHOW Allow NULL? 
28SHP_CLKSettings for Double-Click Actionschar10CHAR(N' ')YesBOR_OPT_SHP_CLK Allow NULL? 
29SHP_SEARCHSettings for Searchchar10CHAR(N' ')YesBOR_OPT_SHP_SEARCH Allow NULL? 
30ASSIGN_DELSettings for Assignment of Inbound Deliverieschar10CHAR(N' ')YesBOR_OPT_SHP_ASSIGN_DEL Allow NULL? 
31CHECK_SETTINGSettings Special Inbound Delivery Assignmentchar10CHAR(N' ')YesBOR_OPT_SHP_CHECK_SETTING Allow NULL? 
32DEL_CLKSettings for Double-Click Actionschar10CHAR(N' ')YesBOR_OPT_DEL_CLK Allow NULL? 
33DEL_SEARCHSettings for Search Functionchar10CHAR(N' ')YesBOR_OPT_DEL_SEARCH Allow NULL? 
34DEL_UPOSSettings for Sub-Itemschar10CHAR(N' ')YesBOR_OPT_DEL_UPOS Allow NULL? 
35DEL_INPUTSettings for Entry of Inbound Deliverieschar10CHAR(N' ')YesBOR_OPT_DEL_INPUT Allow NULL? 
36FILTER_SHOWSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
37VSTEL_SHOWSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
38LGNUM_SHOWSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
39LGTOR_SHOWSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
40LGBZO_SHOWSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
41WERKS_SHOWSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
42LGORT_SHOWSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
43DELVT_SHOWSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
44TONOW_SHOWSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
45KALEN_SHOWSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
46DAYS_SHOWSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
47SHIP_SHOWSettings for GR Dialog Automotivechar10CHAR(N' ')YesBOR_PROFCHAR Allow NULL? 
NamePrimaryUniqueTypeColumns
BORGR_PROFILE~0YesYesCLUSTEREDPROFILE, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy