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_SGE_PR
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
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
10OINM101Whse Journal
Plant Maintenance :: Maintenance Processing :: Maintenance Orders
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/MRSS/C_SGE_PR821Scheduling Engine ProfileMaintenance Orders
SQL:  selectupdate insert create

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

SELECT CLIENT, PROFILE, RES_LOCK, MANUAL_LOCKING, ORD_LOCK, TMZ, SPLT_MIN_DUR, SPLT_MIN_DUR_UN, OVRTM_MAX, OVRTM_MAX_UNIT, OVRTM_MAX_RATIO, SPLT_MAX_GAP, SPLT_MAX_GAP_UN, CHECK_PROFILE, ALERT_PROFILE, WL_PROFILE, UI_PROFILE, MIN_ASS_DUR, TIME_GRAN, REFRESH_PERIOD, REFRESH_WL, ACTIVE_CLOCK, ACTIVE_TEAM, ACTIVE_LINK, CLOCK_EXTRAPOL, CHECK_QUAL, INTL_SHIFT_ACTV, MAX_SCALE_FACTOR, AUTO_SAVE, TIMER_BASED, NO_AUTO_SAVE, TIMER_TOGGLE, SHOW_ORGUNIT, TIMER_PERIOD, RESEL_DEM_NODE, RESEL_DEM_HIER, RESEL_EXPLICIT, DEM_HIER_LEVEL, PRESEL_ID, QLF_MATCH_DISP, DEM_RES_SEL, TEAM_RESP, RANK_UTIL, BASIC_AVAIL, DRAG_DROP, ACTIVE_DETAIL, RESOURCE_STAT, GEO_PROFILE, OPT_PROFILE, MAP_PROFILE, OPT_SCENARIO, DELAY_ASSGN, ACTIVE_OPT, ACTIVE_TRV_TIME, ACTIVE_MAP, RES_LOCK_NO_DATE, ASK_FOR_SAVE, INIT_ALL_ITEMS, DYNAMIC_BREAK, DEL_REF_ACT, DAYB_SCHED_ACT, DISTANCE_UNIT, TRAVEL_TIME_UNIT, NO_COMPL_ITEMS, IGNORE_HORIZON, SI_UNITS, FPS_UNITS, DEM_SPLIT_MAINT, WEBUI_PROFILE, MANUAL_SPLIT, AUTO_SCHED_MULTD, ORDERS_HORIZON, PART_COMM_EXEC, PARTS_CHECK_PROF, ALIGN_ASSIGNMENT, ALIGN_DROP_GAP, ALIGN_TRV_NONAV, RAL_PROFILE, MOB_BASE, IGNORE_DEM_DATES, RES_CONFIDENTIAL, ASGN_CHNG_ALLOW FROM /MRSS/C_SGE_PR
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PROFILEPlanning Board Profilenvarchar100CHAR(N' ')No/MRSS/T_SGE_PROFILE Allow NULL? 
3RES_LOCKLock Active at Resource Levelchar10CHAR(N' ')Yes/MRSS/T_RES_LOCK Allow NULL? 
4MANUAL_LOCKINGManual lockchar10CHAR(N' ')Yes/MRSS/T_SGE_MANUAL_LOCKING Allow NULL? 
5ORD_LOCKLock Active at Order Levelchar10CHAR(N' ')Yes/MRSS/T_ORD_LOCK Allow NULL? 
6TMZTime Zone for Planning Boardnvarchar60CHAR(N' ')YesTTZZ/MRSS/T_SGE_TIMEZONE Allow NULL? 
7SPLT_MIN_DURMinimum Duration of an Assignment for Splitdecimal51DEC((0))Yes/MRSS/T_SPLT_MIN_DUR
8SPLT_MIN_DUR_UNUnit for Minimum Duration of an Assignment for Splitnvarchar30CHAR(N' ')Yes/MRSS/T_SPLT_MIN_DUR_UNIT Allow NULL? 
9OVRTM_MAXSplit: Maximum Overtime Hoursdecimal51DEC((0))Yes/MRSS/T_OVRTM_MAX
10OVRTM_MAX_UNITTime Unit for Maximum Overtime Hoursnvarchar30CHAR(N' ')Yes/MRSS/T_OVRTM_MAX_UNIT Allow NULL? 
11OVRTM_MAX_RATIOSplit: Maximum Ratio of Overtime Hours to Total Timetinyint30INT1((0))Yes/MRSS/T_OVRTM_MAX_RATIO
12SPLT_MAX_GAPMaximum Difference Between Two Assignments When Splitdecimal51DEC((0))Yes/MRSS/T_SPLT_MAX_GAP
13SPLT_MAX_GAP_UNUnit for Maximum Difference Between Assignments When Splitnvarchar30CHAR(N' ')Yes/MRSS/T_SPLT_MAX_GAP_UNIT Allow NULL? 
14CHECK_PROFILEProfile for Checks in the Planning Boardnvarchar100CHAR(N' ')Yes/MRSS/C_CHECK_P/MRSS/T_CHECK_PROFILE Allow NULL? 
15ALERT_PROFILEScheduling alert profilesnvarchar100CHAR(N' ')Yes/MRSS/C_AL_PROF/MRSS/T_ALERT_PROFILE Allow NULL? 
16WL_PROFILEWorklist Profilenvarchar100CHAR(N' ')Yes/MRSS/C_WL_PR/MRSS/T_WL_PROFILE Allow NULL? 
17UI_PROFILEUser Interface Profilenvarchar100CHAR(N' ')Yes/MRSS/C_SGU_PRO/MRSS/T_UI_PROFILE Allow NULL? 
18MIN_ASS_DURMinimum Duration of an Assignment (in Minutes)nvarchar30NUMC(N'000')Yes/MRSS/T_MIN_ASS_DUR Allow NULL? 
19TIME_GRANTime Granularity in Resource Planningnvarchar20NUMC(N'00')Yes/MRSS/T_TIME_GRAN Allow NULL? 
20REFRESH_PERIODPeriod for Refreshing Time Recording Informationdecimal30DEC((0))Yes/MRSS/T_CLOCK_REFRESH
21REFRESH_WLUpdate worklist automaticallychar10CHAR(N' ')Yes/MRSS/T_REFRESH_WL Allow NULL? 
22ACTIVE_CLOCKTime Recording Is Activechar10CHAR(N' ')Yes/MRSS/T_ACTIVE_CLOCK Allow NULL? 
23ACTIVE_TEAMPlanning Board Teams Are Supportedchar10CHAR(N' ')Yes/MRSS/T_ACTIVE_TEAM Allow NULL? 
24ACTIVE_LINKLinks Are Activechar10CHAR(N' ')Yes/MRSS/T_ACTIVE_LINK Allow NULL? 
25CLOCK_EXTRAPOLExtrapolate Time Recording Datachar10CHAR(N' ')Yes/MRSS/T_CLOCK_EXTRAPOL Allow NULL? 
26CHECK_QUALAvailability Check for Qualification Rankingchar10CHAR(N' ')Yes/MRSS/T_CHECK_QUAL Allow NULL? 
27INTL_SHIFT_ACTVTo check if intelligent Shifting is active or notchar10CHAR(N' ')Yes/MRSS/T_INTL_SHIFT Allow NULL? 
28MAX_SCALE_FACTORMaximum Scaling Factor for intelligent Shiftingtinyint30INT1((0))Yes/MRSS/T_SCALE_FACTOR
29AUTO_SAVEEnable Automatic Savingchar10CHAR(N' ')Yes/MRSS/T_AUTO_SAVE Allow NULL? 
30TIMER_BASEDTimer-based Savingchar10CHAR(N' ')Yes/MRSS/T_TIMER_BASED Allow NULL? 
31NO_AUTO_SAVENo Automatic Savingchar10CHAR(N' ')Yes/MRSS/T_NO_AUTO_SAVE Allow NULL? 
32TIMER_TOGGLEUntoggled-Timer Basedchar10CHAR(N' ')Yes/MRSS/T_UNTOGGLE_MODE Allow NULL? 
33SHOW_ORGUNITShow resource plannig node in front of resourcechar10CHAR(N' ')Yes/MRSS/T_SHOWORG Allow NULL? 
34TIMER_PERIODCustomizable Time interval for Automatic Savedecimal30DEC((0))Yes/MRSS/T_CLOCK_TIMER_SAVE
35RESEL_DEM_NODEDemand Planning Nodechar10CHAR(N' ')Yes/MRSS/T_SGE_RESEL_DEM_NODE Allow NULL? 
36RESEL_DEM_HIERDemand Hierarchychar10CHAR(N' ')Yes/MRSS/T_SGE_RESEL_DEM_HIER Allow NULL? 
37RESEL_EXPLICITExplicit Planning Nodeschar10CHAR(N' ')Yes/MRSS/T_SGE_RESEL_EXPLICIT Allow NULL? 
38DEM_HIER_LEVELResource Planning Node Hierarchy Levelnvarchar20NUMC(N'00')Yes/MRSS/T_SGE_HIERARCHY_LEVEL Allow NULL? 
39PRESEL_IDPreselection criteria identifiernvarchar30CHAR(N' ')Yes/MRSS/C_SQE_PSEL/MRSS/T_SQE_PRESEL_ID Allow NULL? 
40QLF_MATCH_DISPDisplay Qualification Match Resultchar10CHAR(N' ')Yes/MRSS/T_SGE_QLF_MATCH_DISP Allow NULL? 
41DEM_RES_SELDemand-Based Resource Selectionchar10CHAR(N' ')Yes/MRSS/T_DEM_BASED_RES_SEL Allow NULL? 
42TEAM_RESPPerson Responsible in the Team Requiredchar10CHAR(N' ')Yes/MRSS/T_TEAM_RESP Allow NULL? 
43RANK_UTILRanking with Utilizationchar10CHAR(N' ')Yes/MRSS/T_RANK_UTIL Allow NULL? 
44BASIC_AVAILBasic Availability of the resourcechar10CHAR(N' ')Yes/MRSS/T_BASIC_AVAIL Allow NULL? 
45DRAG_DROPAssignments Split When Drag and Dropchar10CHAR(N' ')Yes/MRSS/T_DRAGDROP Allow NULL? 
46ACTIVE_DETAILAssignment split in detail screenchar10CHAR(N' ')Yes/MRSS/T_ACTIVE_DETAIL Allow NULL? 
47RESOURCE_STATActivates Status for Resources in Planning boardchar10CHAR(N' ')Yes/MRSS/T_RES_STAT Allow NULL? 
48GEO_PROFILEGeo Profile Keynvarchar100CHAR(N' ')Yes/MRSS/C_GEO_SYS/MRSS/T_GEO_PROFILE Allow NULL? 
49OPT_PROFILEProfile key of the optimizernvarchar100CHAR(N' ')Yes/MRSS/C_OPT_SYS/MRSS/T_OPT_PROFILE Allow NULL? 
50MAP_PROFILEMap Profilenvarchar100CHAR(N' ')Yes/MRSS/C_GEO_MAP/MRSS/T_MAP_PROFILE Allow NULL? 
51OPT_SCENARIOOptimization Scenario Keynvarchar100CHAR(N' ')Yes/MRSS/C_OPT_SCE/MRSS/T_OPT_SCENARIO_KEY Allow NULL? 
52DELAY_ASSGNDelay in Assignment Creationchar10CHAR(N' ')Yes/MRSS/T_DELAY_ASSGN Allow NULL? 
53ACTIVE_OPTOptimization Activechar10CHAR(N' ')Yes/MRSS/T_ACTIVE_OPT Allow NULL? 
54ACTIVE_TRV_TIMETravel Time Profile Activechar10CHAR(N' ')Yes/MRSS/T_ACTIVE_TRV_TIME Allow NULL? 
55ACTIVE_MAPMap is activechar10CHAR(N' ')Yes/MRSS/T_ACTIVE_MAP Allow NULL? 
56RES_LOCK_NO_DATEResource Lock Ignoring Dateschar10CHAR(N' ')Yes/MRSS/T_SGE_RES_LOCK_NO_DATE Allow NULL? 
57ASK_FOR_SAVEConfirm before savechar10CHAR(N' ')Yes/MRSS/T_SGU_ASK_FOR_SAVE Allow NULL? 
58INIT_ALL_ITEMSInitialize All Work Itemschar10CHAR(N' ')Yes/MRSS/T_INIT_ALL_ITEMS Allow NULL? 
59DYNAMIC_BREAKEnable Dynamic Breakschar10CHAR(N' ')Yes/MRSS/T_SGE_DYNAMIC_BREAK Allow NULL? 
60DEL_REF_ACTDelta Refresh Active?char10CHAR(N' ')Yes/MRSS/T_SGE_DELTA_REF_ACTIVE Allow NULL? 
61DAYB_SCHED_ACTActivate Day-Based Schedulingchar10CHAR(N' ')Yes/MRSS/T_SGE_DAYBASED_SCHED_ACT Allow NULL? 
62DISTANCE_UNITUnit of Measurement for the Distancenvarchar20CHAR(N' ')Yes/MRSS/T_SGE_DISTANCE_UNIT Allow NULL? 
63TRAVEL_TIME_UNITTravel Time Unitnvarchar30CHAR(N' ')Yes/MRSS/T_TRAVEL_TIME_UNIT Allow NULL? 
64NO_COMPL_ITEMSNo Completed Itemschar10CHAR(N' ')Yes/MRSS/T_NO_COMPLETED_ITEMS Allow NULL? 
65IGNORE_HORIZONDeactivate Planning Horizon Checkschar10CHAR(N' ')Yes/MRSS/T_SGE_IGNORE_HORIZON Allow NULL? 
66SI_UNITSUnit of Measurement for Travel Distancechar10CHAR(N' ')Yes/MRSS/T_SI_UNITS Allow NULL? 
67FPS_UNITSUnit of measurement for Travel Distance in FPS Unitschar10CHAR(N' ')Yes/MRSS/T_FPS_UNITS Allow NULL? 
68DEM_SPLIT_MAINTDemand Split Maintenencechar10CHAR(N' ')Yes/MRSS/T_DEM_SPLIT_MAINT Allow NULL? 
69WEBUI_PROFILEID of the Web User Interface Profilenvarchar100CHAR(N' ')Yes/MRSS/C_SGX_WPRO/MRSS/T_SGX_WEBUI_ID Allow NULL? 
70MANUAL_SPLITManual Split of Assignmentschar10CHAR(N' ')Yes/MRSS/T_MANUAL_SPLIT_ASGN Allow NULL? 
71AUTO_SCHED_MULTDAutomatic Scheduling of Multiday Assignments Is Activechar10CHAR(N' ')Yes/MRSS/T_SGE_MULTIDAY_SCHED_ACT Allow NULL? 
72ORDERS_HORIZONOrders outside the horizon having assign within the horizonchar10CHAR(N' ')Yes/MRSS/T_DEM_HORIZON Allow NULL? 
73PART_COMM_EXECAllow Partial Changeschar10CHAR(N' ')Yes/MRSS/T_PARTIAL_COMMAND_EXEC Allow NULL? 
74PARTS_CHECK_PROFParts Check Profilenvarchar100CHAR(N' ')Yes/MRSS/C_MAT_CHK/MRSS/T_MAT_CHECK_PROFILE Allow NULL? 
75ALIGN_ASSIGNMENTAlign Assignmentschar10CHAR(N' ')Yes/MRSS/T_SGE_ALIGN_ASSIGNMENTS Allow NULL? 
76ALIGN_DROP_GAPMaximum Time Interval in Hourstinyint30INT1((0))Yes/MRSS/T_SGE_ALIGN_DROP_GAP
77ALIGN_TRV_NONAVTravel Time in Non-Availabilitychar10CHAR(N' ')Yes/MRSS/T_SGE_NONAVAIL_TRV_TIME Allow NULL? 
78RAL_PROFILEResource Assignment List Profile IDnvarchar100CHAR(N' ')Yes/MRSS/C_RAL_DSEL/MRSS/T_RAL_PROFILE_ID Allow NULL? 
79MOB_BASEDisplay Processing Timeschar10CHAR(N' ')Yes/MRSS/T_ACTIVE_MOBILIZATION Allow NULL? 
80IGNORE_DEM_DATESIgnore Demand Dates in Alignment of Assignmentschar10CHAR(N' ')Yes/MRSS/T_SGE_IGNORE_DEM_DATES Allow NULL? 
81RES_CONFIDENTIALResource Is Confidential Outside Validity Periodchar10CHAR(N' ')Yes/MRSS/T_RES_CONFIDENTIALITY Allow NULL? 
82ASGN_CHNG_ALLOWAllow Resource Planning Outside Resource Validity Periodchar10CHAR(N' ')Yes/MRSS/T_ASGN_CHNG_ALLOW Allow NULL? 
NamePrimaryUniqueTypeColumns
/MRSS/C_SGE_PR~0YesYesCLUSTEREDPROFILE, CLIENT

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