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_PROC
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_PROC341Business process CustomizingMaintenance Orders
SQL:  selectupdate insert create

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

SELECT CLIENT, TEAM_ASSIGNMENT, CAPACITIVE_ASSGN, ACTIVATE_DBM, ACT_MRS_BASIS, RESOURCE_CLASS, MRS_QUALIFICAT, MRS_SPLITS, TRAVEL_TIMES, ACTV_AUTH_RPS, FCHG_ALERT, BACK_MRS_SPLITS, BACK_WORK_CENTER, BACK_DATES_DURAT, BACK_DEM_FOL_ASG, BACK_TRAVEL_TIME, DATE_LOGIC, DURATION_LOGIC, GET_RES_MAN, CONS_PLANT, CONS_PERS_AREA, ALLOW_NEG_CAPA, TEAM_AVAIL, TEAM_MEM_PERIOD, TEAM_MEM_ASSIGN, DAY_WISE_CG, GLOBAL_TIMEZONE, UTIL_UNIT, ACTIVATE_PPM, READ_LOG_ACTIVE, AVAIL_BASED_UTIL, TECH_OBJ_MRS_RES, TEAM_QUAL_MATCH, QUAL_AGR_SUB_ITM FROM /MRSS/C_SGE_PROC
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2TEAM_ASSIGNMENTDistribute Team Assignments to Teamchar10CHAR(N' ')Yes/MRSS/T_SGE_TEAM_ASSIGNMENT Allow NULL? 
3CAPACITIVE_ASSGNCapacitive Assignmentschar10CHAR(N' ')Yes/MRSS/T_SGE_CAPACITIVE_ASSGN Allow NULL? 
4ACTIVATE_DBMActivate DBM scenariochar10CHAR(N' ')Yes/MRSS/T_SGE_ACTIVATE_DBM Allow NULL? 
5ACT_MRS_BASISActivate MRS Basischar10CHAR(N' ')Yes/MRSS/T_ACT_MRS_BASIS Allow NULL? 
6RESOURCE_CLASSResource Classchar10CHAR(N' ')Yes/MRSS/T_RESOURCE_CLASS Allow NULL? 
7MRS_QUALIFICATMRS Qualificationschar10CHAR(N' ')Yes/MRSS/T_SGE_MRS_QUALIFICATION Allow NULL? 
8MRS_SPLITSMRS Capacity Splitschar10CHAR(N' ')Yes/MRSS/T_SGE_SPLITS Allow NULL? 
9TRAVEL_TIMESForward Integration: Travel Timeschar10CHAR(N' ')Yes/MRSS/T_SGE_TRAVEL_TIME Allow NULL? 
10ACTV_AUTH_RPSActivate Authority Check via Evaluation Pathschar10CHAR(N' ')Yes/MRSS/T_SGE_AUTH_PLAN_STR Allow NULL? 
11FCHG_ALERTMRS Integration: Alert for Field Changeschar10CHAR(N' ')Yes/MRSS/T_SGE_FCHG_ALERT Allow NULL? 
12BACK_MRS_SPLITSBackward Integration: Capacity Splitschar10CHAR(N' ')Yes/MRSS/T_SGE_BACK_SPLITS Allow NULL? 
13BACK_WORK_CENTERBackward Integration: Work Centerchar10NUMC(N'0')Yes/MRSS/T_SGE_BACK_WORK_CENTER Allow NULL? 
14BACK_DATES_DURATBackward Integration: Dates and Durationchar10CHAR(N' ')Yes/MRSS/T_SGE_BACK_DATE_DURATION Allow NULL? 
15BACK_DEM_FOL_ASGBackward Integration: Demand Follows Assignmentchar10CHAR(N' ')Yes/MRSS/T_SGE_BACK_DEM_FOLLOW_AS Allow NULL? 
16BACK_TRAVEL_TIMEBackward Integration: Travel Timeschar10CHAR(N' ')Yes/MRSS/T_SGE_BACK_TRAVEL_TIME Allow NULL? 
17DATE_LOGICIntegration: Date Logicchar10NUMC(N'0')Yes/MRSS/T_SGE_DATE_LOGIC Allow NULL? 
18DURATION_LOGICIntegration: Duration Logicchar10NUMC(N'0')Yes/MRSS/T_SGE_DURAT_LOGIC Allow NULL? 
19GET_RES_MANGet resource manager from parent org unitchar10CHAR(N' ')Yes/MRSS/T_SGE_RESMAN Allow NULL? 
20CONS_PLANTConsider Plant in MRS Qualificationschar10CHAR(N' ')Yes/MRSS/T_SGE_CONS_PLANT_QUAL Allow NULL? 
21CONS_PERS_AREAConsider personnel area in MRS qualificationschar10CHAR(N' ')Yes/MRSS/T_SGE_CONS_PERS_AREA Allow NULL? 
22ALLOW_NEG_CAPAAllow Negative Capacitychar10CHAR(N' ')Yes/MRSS/T_SGE_ALLOW_NEG_CAPACITY Allow NULL? 
23TEAM_AVAILTeam Availability Definitionnvarchar70CHAR(N' ')Yes/MRSS/T_TEAM_AVAIL_DEFINITION Allow NULL? 
24TEAM_MEM_PERIODTeam Member Validitynvarchar100CHAR(N' ')Yes/MRSS/T_SGE_TEAM_MEM_PERIOD Allow NULL? 
25TEAM_MEM_ASSIGNTeam Member Assignment Behaviornvarchar100CHAR(N' ')Yes/MRSS/T_TEAM_ASSIGN_BEHAVIOUR Allow NULL? 
26DAY_WISE_CGUpdate Day-Based Capacity Graphschar10CHAR(N' ')Yes/MRSS/T_SGE_DAY_WISE_CG Allow NULL? 
27GLOBAL_TIMEZONEStandard Time Zone for SAP Multiresource Schedulingnvarchar60CHAR(N' ')YesTTZZ/MRSS/T_SGE_GLOBAL_TIMEZONE Allow NULL? 
28UTIL_UNITUtilization Report Unitnvarchar100CHAR(N' ')Yes/MRSS/T_SGE_UTIL_UNIT Allow NULL? 
29ACTIVATE_PPMActivate Permanent Performance Monitoringchar10CHAR(N' ')Yes/MRSS/T_PPM_ACTIVATE_MONITOR Allow NULL? 
30READ_LOG_ACTIVEActivate Read Access Loggingchar10CHAR(N' ')Yes/MRSS/T_SGE_READ_LOG_ACTIVE Allow NULL? 
31AVAIL_BASED_UTILAvailability-Based Utilizationchar10CHAR(N' ')Yes/MRSS/T_SGE_AVAIL_BASED_UTIL Allow NULL? 
32TECH_OBJ_MRS_RESAllow Creation of Technical Object Resourceschar10CHAR(N' ')Yes/MRSS/T_TOBJ_ALLOW_RES_CREATE Allow NULL? 
33TEAM_QUAL_MATCHQualification Matching at Team Levelchar10CHAR(N' ')Yes/MRSS/T_SGE_TEAM_QUAL_MATCH Allow NULL? 
34QUAL_AGR_SUB_ITMQualification Requirements from Subitemschar10CHAR(N' ')Yes/MRSS/T_QUALIF_AGR_FROM_SUB_IT Allow NULL? 
NamePrimaryUniqueTypeColumns
/MRSS/C_SGE_PROC~0YesYesCLUSTEREDCLIENT

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