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
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
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

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

67 columns | Print definition?ERP 6.0  | APP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GRFNAPPFLDField Status Configuration by Application Component4APPApplication Componentnvarchar20
2GRFNAPPFLDCField Status Configuration by Application Component4APPApplication Componentnvarchar20
3GRFNENTUIBBAPPEntity UIBB Configuration by Application Component5APPApplication Componentnvarchar20
4GRFNORGVIEWOrganization Views Configuration3APPApplication Componentnvarchar20
5GRFNORGVIEWTOrganization Views Configuration Text Table4APPApplication Componentnvarchar20
TOPBalanced Scorecard
6UMB_BU100BW Buffer (Cross-Application)2APPApplication Keynvarchar10
7UMB_BU101Local Measure Buffer2APPApplication Keynvarchar10
TOPBasic Data
8QMATInspection type - material parameters9APPAutomatic Specification Assignmentnvarchar10
TOPBusiness Object Builder
9SWOTOLEWorkflow Object Types: OLE Applications1APPOLE applicationnvarchar320
10SWOTTOLEWorkflow Object Types: Texts OLE Applications1APPOLE applicationnvarchar320
TOPBusiness Planning and Simulation
11UPX_CUST_APPCustomizing Framework: Applications1APPApplication for the Customizing Frameworknvarchar50
12UPX_CUST_APP_TCustomizing Framework: Applications - Text Table1APPApplication for the Customizing Frameworknvarchar50
13UPX_CUST_CONSTRCustomizing Components Constraints2APPApplicationnvarchar300
14UPX_CUST_FCTRYCustomizing Framework: Factories1APPApplication for the Customizing Frameworknvarchar50
15UPX_CUST_FCTRY_TCustomizing Framework: Factories - Text Tables1APPApplication for the Customizing Frameworknvarchar50
16UPX_CUST_STEPCustomizing Framework: Steps1APPApplication for the Customizing Frameworknvarchar50
17UPX_CUST_STEP_TCustomizing Framework: Steps - Text Table1APPApplication for the Customizing Frameworknvarchar50
18UPX_KPI_APPUPX_KPI_APP1APPPlanning Application in CRMnvarchar30
TOPCorporate Performance Monitor
19UMC_CUSTGeneral Settings2APPApplication Keynvarchar10
20UMC_FILE_CACHECache for Generated Files2APPApplication Keynvarchar10
21UMC_LG100Log3APPApplication Keynvarchar10
22UMC_PC100Closing of Periods3APPApplication Keynvarchar10
23UMC_TD100Task List3APPApplication Keynvarchar10
24UMC_UN100Notification2APPApplication Keynvarchar10
25UMC_UN101Notification E-Mail Template3APPApplication Keynvarchar10
26UMR_RF100RMS: Measure-Risk Value Fields2APPApplication Keynvarchar10
27UMR_RF101RMS: Measure-Risk Value Fields Selection Criteria2APPApplication Keynvarchar10
28UMR_RF102RMS: Measure-Risk Value Fields BW Variable2APPApplication Keynvarchar10
29UMR_RF103RMS: Measure-Risk Value Fields BW Variables2APPApplication Keynvarchar10
30UMR_RI110RMS: Assignment of Target Systems2APPApplication Keynvarchar10
31UMR_RI111RMS: Assignment of TS-Specific Deviation Value Fields2APPApplication Keynvarchar10
32UMR_RI112OBSOLETE RMS: Deviations per Thread Level for Measure2APPApplication Keynvarchar10
33UMR_RI114RMS: Measure Selection and Attributes2APPApplication Keynvarchar10
34UMR_RI115RMS: Measure Formula Argument Assignment2APPApplication Keynvarchar10
35UMR_RI116RMS: Measure Weight Data Selection - NOT USED2APPApplication Keynvarchar10
36UMR_RI117RMS: Measure Weight Data Selection - Selections - NOT USED2APPApplication Keynvarchar10
37UMR_RI118RMS: Measure-Risk Value Fields Read Only Flag2APPApplication Keynvarchar10
38UMR_RI120RMS: Assignment of Risks2APPApplication Keynvarchar10
39UMR_RI121RMS: Owner of Risk2APPApplication Keynvarchar10
40UMR_RI124OBSOLETE RMS: Probability and Risk Intensity - Header2APPApplication Keynvarchar10
41UMR_RI125OBSOLETE RMS: Probability and Risk Intensity Versions2APPApplication Keynvarchar10
42UMR_RI125TOBSOLETE RMS: Probability and Risk Intensity Versions Text T2APPApplication Keynvarchar10
43UMR_RI126OBSOLETE RMS: Probability and Risk Intensity2APPApplication Keynvarchar10
44UMR_RI128RMS: Measure Deviations for Risks2APPApplication Keynvarchar10
45UMR_RI129RMS: Risk Status for Measure2APPApplication Keynvarchar10
46UMR_RI131Obsolete: RMS Graphic Settings2APPApplication Keynvarchar10
47UMR_RI140RMS: Risk-Reducing Activities (Master)2APPApplication Keynvarchar10
48UMR_RI140TRMS: Risk-Reducing Activities (Text Table)2APPApplication Keynvarchar10
49UMR_RI141RMS: Risk-Reducing Activities - Milestones2APPApplication Keynvarchar10
50UMR_RI141TRMS: Risk-Reducing Activities - Milestones - Text Table2APPApplication Keynvarchar10
51UMR_RI142RMS: Risk-Reducing Activities - Team Members2APPApplication Keynvarchar10
52UMR_RI150RMS: Assignment of Risk-Reducing Activities to Risk2APPApplication Keynvarchar10
53UMR_RI160OBSOLETE RMS: Risk Score2APPApplication Keynvarchar10
54UMR_RI200RMS: Assigned BW Queries3APPApplication Keynvarchar10
55UMR_RI201RMS: BW Web Report3APPApplication Keynvarchar10
56UMR_RI202RMS: URL3APPApplication Keynvarchar10
TOPGovernance, Risk and Compliance
57GRFNACTIVEAPPActive GRC Applications2APPGRC Applicationnvarchar20
TOPGRC Risk Management
58GRFNMWREGMigration Registry5APPSource Application for Migrationnvarchar20
TOPMaintenance Orders
59/MRSS/C_CUSTPARMRCCF: Experteneinstellungen2APPApplication ID in RCCFnvarchar40
60/MRSS/D_ENG_LOGProtokolltabelle für Engineläufe5APPApplication ID in RCCFnvarchar40
TOPManagement Cockpit
61UMM_SH101Standard Style2APPApplication Keynvarchar10
TOPProcess Management
62CMX_XS_DB_PSLXSteps: Parameter, LIVE Data in DB Format SMALL13APPXSteps: Applicationnvarchar30
TOPQuality Inspection
63TQ34Default values for inspection type7APPAutomatic Specification Assignmentnvarchar10
TOPRemote Control and Communication Framework
64RCCC_CUSTPARMRCCF: Settings for Experts2APPRCCF Application IDnvarchar40
65RCCD_ENG_LOGLog Table for Engine Runs5APPRCCF Application IDnvarchar40
TOPUse BC-FES-CTL see SAP Note 842824
66TOLEOLE Applications1APPOLE applicationnvarchar320
67TOLETWorkflow Object Types: Texts OLE Applications1APPOLE applicationnvarchar320