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  | /MRSS/C_SGX_WPRO
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
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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Cross-Application Components :: SAP Multiresource Scheduling
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/MRSS/C_SGX_WPRO611Header Table of the Web UI ProfileSAP Multiresource Scheduling
SQL:  selectupdate insert create

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

SELECT MANDT, WEB_UI_PROFILE, FACTORY_CALENDAR, STD_SCALING, START_RESOURCE_V, SHOW_ASSIGNMENT, SHOW_TIMEDATA, SHOW_TEAMS, SHOW_TIMELINE, SHOW_CAPA, GRAPH_BG_COLOR, TABLE_HEAD_LABEL, TABLE_LABEL, TIMESCALE_COLOR, TIMESCALE_LABEL, SEP_COLOR, EXTERNAL_WINDOW, EXT_WINDOW_EMPL, COMP_DISPLAY, TIME_SEP_COLOR, ROW_SEP_COLOR, HIDE_NONWORKING, DAILY_START, DAILY_END, CREATE_ASG_DAYB, SEL_NODE_DEFAULT, ABSOLUTE_AVAIL, RELATIVE_AVAIL, GANTT_HEIGHT, HIGHLIGHT_COLOR, ZOOM_PERCENT, DRAWIN_SELECTION, DEM_VIEW_BAR_SEL, DEMAND_SELECTION, DIRECT_SPLIT, DEMAND_VIEW, DEMAND_LIST, FILTER_RES_VIEW, FILTER_DEM_VIEW, ASGN_FOLLOW_DEMA, SHOW_STAFF_VIEW, EDIT_STAFF_VIEW, DEFAULT_ASG_TYPE, RESOURCE_PRIOR, TOOL_PRIORITY, TEAM_PRIORITY, NN_RES_PRIORITY, SHOW_BUNDLE, DEFAULT_VIEW, SHOW_ASSOC_RES, SHOW_ASSOC_DEM, TOOL_LOAD_OPTION, TEAM_LOAD_OPTION, SHIFT_TIMEZONE, COLL_ACTIVE_RES, COLL_ACTIVE_DEM, HIDE_LIST_VIEW, RET_ONLY_ERR_MSG, DEM_CUST_CO_ACT, DEM_CUST_CO_NAME, SHOW_WC_RES FROM /MRSS/C_SGX_WPRO
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2WEB_UI_PROFILEID of the Web User Interface Profilenvarchar100 Allow NULL? 
3FACTORY_CALENDARFactory Calendarnvarchar20 Allow NULL? 
4STD_SCALINGIdentifies a Scaletinyint30
5START_RESOURCE_VDefines the Type of Resources View to Be Shown at the Startchar10 Allow NULL? 
6SHOW_ASSIGNMENTDisplay Assignmentschar10 Allow NULL? 
7SHOW_TIMEDATADisplay Time Datachar10 Allow NULL? 
8SHOW_TEAMSDisplay Teamschar10 Allow NULL? 
9SHOW_TIMELINEDisplay Time-Now linechar10 Allow NULL? 
10SHOW_CAPAShow Capacitive Linechar10 Allow NULL? 
11GRAPH_BG_COLORBackground Color of the Time Periodnvarchar200 Allow NULL? 
12TABLE_HEAD_LABELText Formatting of Table Headingnvarchar200 Allow NULL? 
13TABLE_LABELText Formatting of Table Linesnvarchar200 Allow NULL? 
14TIMESCALE_COLORScale Background Colornvarchar200 Allow NULL? 
15TIMESCALE_LABELTimeline Scale Text Formattingnvarchar200 Allow NULL? 
16SEP_COLORColor of the Separators in the Timelinenvarchar200 Allow NULL? 
17EXTERNAL_WINDOWFlag for Starting Gantt Chart in External Windowchar10 Allow NULL? 
18EXT_WINDOW_EMPLEmployee Qualification Profile in External Windowchar10 Allow NULL? 
19COMP_DISPLAYCompressed Representationchar10 Allow NULL? 
20TIME_SEP_COLORColor of the Lines That Separate the Time Columnsnvarchar200 Allow NULL? 
21ROW_SEP_COLORColor of the Lines That Separate Rowsnvarchar200 Allow NULL? 
22HIDE_NONWORKINGDisplay of Non-Working Timeschar10 Allow NULL? 
23DAILY_STARTWorking Time: Startnvarchar60 Allow NULL? 
24DAILY_ENDWorking Time: Endnvarchar60 Allow NULL? 
25CREATE_ASG_DAYBCreate New Assignments Day-Basedchar10 Allow NULL? 
26SEL_NODE_DEFAULTStandard Selection Bar Typenvarchar200 Allow NULL? 
27ABSOLUTE_AVAILHide Absolute Availabilitychar10 Allow NULL? 
28RELATIVE_AVAILHide Relative Availabilitychar10 Allow NULL? 
29GANTT_HEIGHTGantt Height in Pixelsnvarchar30 Allow NULL? 
30HIGHLIGHT_COLORName of Color Definitionnvarchar200 Allow NULL? 
31ZOOM_PERCENTZoom Percentagenvarchar30 Allow NULL? 
32DRAWIN_SELECTIONDrawing Selection in Resource Viewtinyint30
33DEM_VIEW_BAR_SELShow Bars in Demand Viewtinyint30
34DEMAND_SELECTIONCopy Demand Selection in Demand Viewchar10 Allow NULL? 
35DIRECT_SPLITCustom Splitchar10 Allow NULL? 
36DEMAND_VIEWShow Demand Viewchar10 Allow NULL? 
37DEMAND_LISTShow Demand Listchar10 Allow NULL? 
38FILTER_RES_VIEWShow Filter Row in Resource Viewchar10 Allow NULL? 
39FILTER_DEM_VIEWShow Filter Row in Demand Viewchar10 Allow NULL? 
40ASGN_FOLLOW_DEMAAssignment Follows Demandchar10 Allow NULL? 
41SHOW_STAFF_VIEWShow Staffing Viewchar10 Allow NULL? 
42EDIT_STAFF_VIEWEdit Staffing Viewchar10 Allow NULL? 
43DEFAULT_ASG_TYPEAssignment Typechar10 Allow NULL? 
44RESOURCE_PRIORPersonnel Resource Prioritytinyint30
45TOOL_PRIORITYTool Prioritytinyint30
46TEAM_PRIORITYTeam Prioritytinyint30
47NN_RES_PRIORITYN.N. Resource Prioritytinyint30
48SHOW_BUNDLEShow Demand Bundleschar10 Allow NULL? 
49DEFAULT_VIEWDefault Viewchar10 Allow NULL? 
50SHOW_ASSOC_RESShow Resourceschar10 Allow NULL? 
51SHOW_ASSOC_DEMShow Demandschar10 Allow NULL? 
52TOOL_LOAD_OPTIONLoad Toolschar10 Allow NULL? 
53TEAM_LOAD_OPTIONLoad Teamschar10 Allow NULL? 
54SHIFT_TIMEZONEActivate Alternative Time Zonechar10 Allow NULL? 
55COLL_ACTIVE_RESDisplay Collisions in Resource Ganttchar10 Allow NULL? 
56COLL_ACTIVE_DEMDisplay Collisions in Demand Ganttchar10 Allow NULL? 
57HIDE_LIST_VIEWHide List Viewchar10 Allow NULL? 
58RET_ONLY_ERR_MSGSuppress Information and Warning Messageschar10 Allow NULL? 
59DEM_CUST_CO_ACTDisplay Custom Fields in Demand Detailschar10 Allow NULL? 
60DEM_CUST_CO_NAMEWeb Dynpro Component for Custom Fieldsnvarchar300 Allow NULL? 
61SHOW_WC_RESShow Work Center Resourceschar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
/MRSS/C_SGX_WPRO~0YesYesCLUSTEREDWEB_UI_PROFILE, 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