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

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
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