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
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
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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2WEB_UI_PROFILEID of the Web User Interface Profilenvarchar100CHAR(N' ')No/MRSS/T_SGX_WEBUI_ID Allow NULL? 
3FACTORY_CALENDARFactory Calendarnvarchar20CHAR(N' ')Yes*/MRSS/T_SGU_WFCID Allow NULL? 
4STD_SCALINGIdentifies a Scaletinyint30INT1((0))Yes*/MRSS/T_SGX_DEFAULT_SCALE
5START_RESOURCE_VDefines the Type of Resources View to Be Shown at the Startchar10CHAR(N' ')Yes/MRSS/T_SGX_START_RES_VIEW Allow NULL? 
6SHOW_ASSIGNMENTDisplay Assignmentschar10CHAR(N' ')Yes/MRSS/T_SGU_VIEW_ASSIGNMENT Allow NULL? 
7SHOW_TIMEDATADisplay Time Datachar10CHAR(N' ')Yes/MRSS/T_SGU_VIEW_CLOCK_INF Allow NULL? 
8SHOW_TEAMSDisplay Teamschar10CHAR(N' ')Yes/MRSS/T_SGU_VIEW_TEAM Allow NULL? 
9SHOW_TIMELINEDisplay Time-Now linechar10CHAR(N' ')Yes/MRSS/T_TIME_NOW Allow NULL? 
10SHOW_CAPAShow Capacitive Linechar10CHAR(N' ')Yes/MRSS/T_SGX_SHOW_CAPA Allow NULL? 
11GRAPH_BG_COLORBackground Color of the Time Periodnvarchar200CHAR(N' ')Yes/MRSS/T_SGX_COLOR_BG_GRAPH Allow NULL? 
12TABLE_HEAD_LABELText Formatting of Table Headingnvarchar200CHAR(N' ')Yes/MRSS/T_SGX_TABLE_HEAD_LABEL Allow NULL? 
13TABLE_LABELText Formatting of Table Linesnvarchar200CHAR(N' ')Yes/MRSS/T_SGX_TABLE_LABEL Allow NULL? 
14TIMESCALE_COLORScale Background Colornvarchar200CHAR(N' ')Yes/MRSS/T_SGX_COLOR_TIMESCALE Allow NULL? 
15TIMESCALE_LABELTimeline Scale Text Formattingnvarchar200CHAR(N' ')Yes/MRSS/T_SGX_LABEL_TIMESCALE Allow NULL? 
16SEP_COLORColor of the Separators in the Timelinenvarchar200CHAR(N' ')Yes/MRSS/T_SGX_COLOR_SEP Allow NULL? 
17EXTERNAL_WINDOWFlag for Starting Gantt Chart in External Windowchar10CHAR(N' ')Yes/MRSS/T_SGX_EXTERNAL_WINDOW Allow NULL? 
18EXT_WINDOW_EMPLEmployee Qualification Profile in External Windowchar10CHAR(N' ')Yes/MRSS/T_SGX_EXT_WIN_EMPL_PROFI Allow NULL? 
19COMP_DISPLAYCompressed Representationchar10CHAR(N' ')Yes/MRSS/T_SGX_COMP_DISPLAY Allow NULL? 
20TIME_SEP_COLORColor of the Lines That Separate the Time Columnsnvarchar200CHAR(N' ')Yes/MRSS/T_SGX_COLOR_SEP_TIME Allow NULL? 
21ROW_SEP_COLORColor of the Lines That Separate Rowsnvarchar200CHAR(N' ')Yes/MRSS/T_SGX_COLOR_SEP_ROW Allow NULL? 
22HIDE_NONWORKINGDisplay of Non-Working Timeschar10CHAR(N' ')Yes/MRSS/T_SGX_WORKTIME_VIEW Allow NULL? 
23DAILY_STARTWorking Time: Startnvarchar60TIMS(N'000000')Yes/MRSS/T_SGX_DAILY_START Allow NULL? 
24DAILY_ENDWorking Time: Endnvarchar60TIMS(N'000000')Yes/MRSS/T_SGX_DAILY_END Allow NULL? 
25CREATE_ASG_DAYBCreate New Assignments Day-Basedchar10CHAR(N' ')Yes/MRSS/T_SGU_CREATE_ASG_DAYB Allow NULL? 
26SEL_NODE_DEFAULTStandard Selection Bar Typenvarchar200CHAR(N' ')Yes/MRSS/T_SGX_DEL_SEL_TYPE_NODE Allow NULL? 
27ABSOLUTE_AVAILHide Absolute Availabilitychar10CHAR(N' ')Yes/MRSS/T_HIDE_ABS_AVAIL Allow NULL? 
28RELATIVE_AVAILHide Relative Availabilitychar10CHAR(N' ')Yes/MRSS/T_HIDE_REL_AVAIL Allow NULL? 
29GANTT_HEIGHTGantt Height in Pixelsnvarchar30NUMC(N'000')Yes/MRSS/T_SGX_GANTT_HEIGHT_STD Allow NULL? 
30HIGHLIGHT_COLORName of Color Definitionnvarchar200CHAR(N' ')Yes/MRSS/T_SGX_TYPE_COLOR Allow NULL? 
31ZOOM_PERCENTZoom Percentagenvarchar30NUMC(N'000')Yes/MRSS/T_SGX_GANTT_ZOOM Allow NULL? 
32DRAWIN_SELECTIONDrawing Selection in Resource Viewtinyint30INT1((0))Yes/MRSS/T_SGX_DRAW_SELECTION
33DEM_VIEW_BAR_SELShow Bars in Demand Viewtinyint30INT1((0))Yes/MRSS/T_SGX_DEM_BAR_SEL
34DEMAND_SELECTIONCopy Demand Selection in Demand Viewchar10CHAR(N' ')Yes/MRSS/T_SGX_COPY_DEM_SEL Allow NULL? 
35DIRECT_SPLITCustom Splitchar10CHAR(N' ')Yes/MRSS/T_SGX_DIRECT_SPLIT Allow NULL? 
36DEMAND_VIEWShow Demand Viewchar10CHAR(N' ')Yes/MRSS/T_SGX_SHOW_DEM_VIEW Allow NULL? 
37DEMAND_LISTShow Demand Listchar10CHAR(N' ')Yes/MRSS/T_SGX_SHOW_DEM_LIST Allow NULL? 
38FILTER_RES_VIEWShow Filter Row in Resource Viewchar10CHAR(N' ')Yes/MRSS/T_SGX_RES_FILTER_ROW_SHW Allow NULL? 
39FILTER_DEM_VIEWShow Filter Row in Demand Viewchar10CHAR(N' ')Yes/MRSS/T_SGX_DEM_FILTER_ROW_SHW Allow NULL? 
40ASGN_FOLLOW_DEMAAssignment Follows Demandchar10CHAR(N' ')Yes/MRSS/T_SGX_ASGN_FOLLOWS_DEM Allow NULL? 
41SHOW_STAFF_VIEWShow Staffing Viewchar10CHAR(N' ')Yes/MRSS/T_SGX_SHOW_STAFF_VIEW Allow NULL? 
42EDIT_STAFF_VIEWEdit Staffing Viewchar10CHAR(N' ')Yes/MRSS/T_SGX_EDIT_STAFF_VIEW Allow NULL? 
43DEFAULT_ASG_TYPEAssignment Typechar10CHAR(N' ')Yes/MRSS/T_SGX_ASSIGNMENT_TYPE Allow NULL? 
44RESOURCE_PRIORPersonnel Resource Prioritytinyint30INT1((0))Yes/MRSS/T_SGX_RESOURCE_PRIORITY
45TOOL_PRIORITYTool Prioritytinyint30INT1((0))Yes/MRSS/T_SGX_TOOL_PRIORITY
46TEAM_PRIORITYTeam Prioritytinyint30INT1((0))Yes/MRSS/T_SGX_TEAM_PRIORITY
47NN_RES_PRIORITYN.N. Resource Prioritytinyint30INT1((0))Yes/MRSS/T_SGX_NN_RES_PRIORITY
48SHOW_BUNDLEShow Demand Bundleschar10CHAR(N' ')Yes/MRSS/T_SGX_SHOW_BUNDLE Allow NULL? 
49DEFAULT_VIEWDefault Viewchar10CHAR(N' ')Yes/MRSS/T_SGX_DEFAULT_VIEW Allow NULL? 
50SHOW_ASSOC_RESShow Resourceschar10CHAR(N' ')Yes/MRSS/T_SGX_SHOW_ASSOC_RES Allow NULL? 
51SHOW_ASSOC_DEMShow Demandschar10CHAR(N' ')Yes/MRSS/T_SGX_SHOW_ASSOC_DEM Allow NULL? 
52TOOL_LOAD_OPTIONLoad Toolschar10CHAR(N' ')Yes/MRSS/T_SGX_TOOL_LOAD_OPTIONS Allow NULL? 
53TEAM_LOAD_OPTIONLoad Teamschar10CHAR(N' ')Yes/MRSS/T_SGX_TEAM_DISPLAY Allow NULL? 
54SHIFT_TIMEZONEActivate Alternative Time Zonechar10CHAR(N' ')Yes/MRSS/T_SGX_SHIFTTMZN Allow NULL? 
55COLL_ACTIVE_RESDisplay Collisions in Resource Ganttchar10CHAR(N' ')Yes/MRSS/T_SGX_COLL_RES_ACTIVE Allow NULL? 
56COLL_ACTIVE_DEMDisplay Collisions in Demand Ganttchar10CHAR(N' ')Yes/MRSS/T_SGX_COLL_DEM_ACTIVE Allow NULL? 
57HIDE_LIST_VIEWHide List Viewchar10CHAR(N' ')Yes/MRSS/T_SGX_HIDE_LIST_VIEW Allow NULL? 
58RET_ONLY_ERR_MSGSuppress Information and Warning Messageschar10CHAR(N' ')Yes/MRSS/T_SGX_RET_ONLY_ERR_MSG Allow NULL? 
59DEM_CUST_CO_ACTDisplay Custom Fields in Demand Detailschar10CHAR(N' ')Yes/MRSS/T_SGX_ENABLE_DEM_CUST_FI Allow NULL? 
60DEM_CUST_CO_NAMEWeb Dynpro Component for Custom Fieldsnvarchar300CHAR(N' ')Yes/MRSS/T_SGX_DEM_CUST_COMP_NAME Allow NULL? 
61SHOW_WC_RESShow Work Center Resourceschar10CHAR(N' ')Yes/MRSS/T_SGX_SHOW_WC_RES_DEF 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