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_SGU_PRO
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
Plant Maintenance :: Maintenance Processing :: Maintenance Orders
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/MRSS/C_SGU_PRO591UI Planning ProfilesMaintenance Orders
SQL:  selectupdate insert create

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

SELECT MANDT, ID, PRF_GRUPPE, PRF_NAME, PRF_INDEX, VIEW_ID, ZOOM_LEVEL, TICK_SIZE, TIME_COMPRESS, TICK_SIZE_COMPR, DAILY_START, DAILY_END, DEFAULT_MODE, FACTORY_CALENDAR, SCALING_UNIT, ITEM_WORKL_MULT, UTILTHRESH_DAY, UTILTHRESH_WEEK, PERCENTAGE_LINE, PN_VEW_TYPE, GRAPH_COLOR_FILL, ROW_WIDTH, ROW_WIDTH_ABS, FONT_SIZE, MAX_LIMIT, MAX_LIMIT_ABS, MIN_LIMIT, MIN_LIMIT_ABS, PN_GRAPH_TYPE, RESTR_START_TYPE, RESTR_END_TYPE, USE_WL_MENU, ABS_AVAIL_DISP, RES_IN_DISPGANTT, SET_DISPATCH, JUMP_TO_DATE, JUMP_START_SIGN, JUMP_START_DATE, DAY_WISE_CG, CAP_IN_PLANLINE, CREATE_ASG_DAYB, OPTIMIZER_PRVENT, SUMBAR_DISPLAY, MAXIMIZE_GANTT, VIEW_ASSIGNMENT, VIEW_TIMESPEC, VIEW_TEAM, HIDE_ASG_FOL_DEM, HIDE_TEAM_MEM, ASG_AT_DROP_TIME, NUM_PROPOSAL, SHOW_AVAIL_VIEW, AVAIL_VIEW_DEFAU, SHOW_ASSOC_RES, SHOW_ASSOC_DEM, SHOW_ASC_DEM_MGR, SHIFT_TIMEZONE, CONSIDER_NON_GAN, RET_ONLY_ERR_MSG FROM /MRSS/C_SGU_PRO
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2IDUser Interface Profilenvarchar100 Allow NULL? 
3PRF_GRUPPEProfile group (sort graphics profiles)nvarchar40 Allow NULL? 
4PRF_NAMEName of graphics profilenvarchar120 Allow NULL? 
5PRF_INDEXProfile index for the graphics profilechar10 Allow NULL? 
6VIEW_IDView Profile IDnvarchar30 Allow NULL? 
7ZOOM_LEVELZoom Factornvarchar30 Allow NULL? 
8TICK_SIZEWidth of Area in Time Axis of Bar Chartnvarchar40 Allow NULL? 
9TIME_COMPRESSCompressed Display of Non-Working Timeschar10 Allow NULL? 
10TICK_SIZE_COMPRWidth of a Compressed, Displayed Areanvarchar40 Allow NULL? 
11DAILY_STARTDaily Start of Working Timenvarchar60 Allow NULL? 
12DAILY_ENDDaily End of Working Timenvarchar60 Allow NULL? 
13DEFAULT_MODEStandard Mode for Planning Boardnvarchar40 Allow NULL? 
14FACTORY_CALENDARFactory Calendarnvarchar20 Allow NULL? 
15SCALING_UNITScaling unitnvarchar100 Allow NULL? 
16ITEM_WORKL_MULTEnable multi select of item worklistchar10 Allow NULL? 
17UTILTHRESH_DAYDefault utilization thresholdtinyint30
18UTILTHRESH_WEEKDefault utilization threshold per Weektinyint30
19PERCENTAGE_LINEPercentage Line for Planning Node Ganttdecimal30
20PN_VEW_TYPEPlanning Node Gantt View Typechar10 Allow NULL? 
21GRAPH_COLOR_FILLPlanning Node Gantt Color Fillchar10 Allow NULL? 
22ROW_WIDTHPlanning Node Gantt Row Widthnvarchar20 Allow NULL? 
23ROW_WIDTH_ABSPlanning Node Gantt Row Width for ABS displaynvarchar30 Allow NULL? 
24FONT_SIZEPlanning Node Gantt Font Sizenvarchar20 Allow NULL? 
25MAX_LIMITMaximum Graph limit for Y axis of Planning Node Ganttdecimal30
26MAX_LIMIT_ABSMaximum Graph limit for Y axis of Planning Node Gantt ABSdecimal30
27MIN_LIMITMinimum Graph limit for Y axis of Planning Node Ganttdecimal30
28MIN_LIMIT_ABSMinimum Graph limit for Y axis of Planning Node Gantt ABSdecimal30
29PN_GRAPH_TYPEPlanning Node Gantt Graph Typechar10 Allow NULL? 
30RESTR_START_TYPEDemand Start Restrictionchar10 Allow NULL? 
31RESTR_END_TYPEDemand End Restrictionchar10 Allow NULL? 
32USE_WL_MENUUse Enhanced context menu for Demand Ganttchar10 Allow NULL? 
33ABS_AVAIL_DISPDisplay Absolute Availabilitychar10 Allow NULL? 
34RES_IN_DISPGANTTDisplay Resources in Dispatching Ganttchar10 Allow NULL? 
35SET_DISPATCHSet Dispatch Statuschar10 Allow NULL? 
36JUMP_TO_DATESet Plb Start Datechar10 Allow NULL? 
37JUMP_START_SIGNSign for Gantt Start Datechar10 Allow NULL? 
38JUMP_START_DATEJump to Current Datenvarchar30 Allow NULL? 
39DAY_WISE_CGHide Non-Working Timeschar10 Allow NULL? 
40CAP_IN_PLANLINEShow Capacitive Assignments in Planning Rowchar10 Allow NULL? 
41CREATE_ASG_DAYBCreate New Assignments Day-Basedchar10 Allow NULL? 
42OPTIMIZER_PRVENTHide Optimization Icon in Planning Boardchar10 Allow NULL? 
43SUMBAR_DISPLAYDisplay of Sumbarnvarchar100 Allow NULL? 
44MAXIMIZE_GANTTMaximize gantt on Big Screenchar10 Allow NULL? 
45VIEW_ASSIGNMENTDisplay Assignmentschar10 Allow NULL? 
46VIEW_TIMESPECDisplay Time Allocationchar10 Allow NULL? 
47VIEW_TEAMDisplay Teamschar10 Allow NULL? 
48HIDE_ASG_FOL_DEMHide Assignment follows demand checkboxchar10 Allow NULL? 
49HIDE_TEAM_MEMDisplay Team Name Onlychar10 Allow NULL? 
50ASG_AT_DROP_TIMECreate Assignment for the Time Slot onto Which It Is Droppedchar10 Allow NULL? 
51NUM_PROPOSALNumber of Proposed Slots for Shifting Demandsnvarchar20 Allow NULL? 
52SHOW_AVAIL_VIEWShow Availability View Button in Planning Boardchar10 Allow NULL? 
53AVAIL_VIEW_DEFAUSet Availability View as Defaultchar10 Allow NULL? 
54SHOW_ASSOC_RESShow Resourceschar10 Allow NULL? 
55SHOW_ASSOC_DEMShow Demandschar10 Allow NULL? 
56SHOW_ASC_DEM_MGRShow Demands in Manager Planning Boardchar10 Allow NULL? 
57SHIFT_TIMEZONEActivate Alternative Time Zonechar10 Allow NULL? 
58CONSIDER_NON_GANConsider Order and Item Worklists for Status Buttonschar10 Allow NULL? 
59RET_ONLY_ERR_MSGSuppress Information and Warning Messages in Planning Boardchar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
/MRSS/C_SGU_PRO~0YesYesCLUSTEREDID, 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