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

39 columns | Print definition?ERP 6.0  | SCORE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_MTCRSLTMatch Results table to store results from RSADRINI program7SCOREScorenvarchar30
2CNV_00001_CNDStatus of partitioning analysis9SCOREField of type FLTPfloat1516
3GRFNQLIBCHOICEQuestion Library Choices4SCOREScoredecimal135
4GRFNQRATINGQustion Ratings4SCOREScoredecimal135
5GRFNREAAEAudit Risk Rating and Audit Entity4SCOREScoredecimal135
6GRPCSSCORESSurvey Question Scores (override)5SCOREScoredecimal135
7GRRMOBAGBUFVALUEAggregation Buffer - Values7SCOREAggregation Buffer - Scoredecimal135
8GRRMOBAGCOLORAggregation Colors5SCOREAggregation Color - Score Interval Fromdecimal135
9LSOTACLRNATTMSCRTrack Multiple Attempts for Web-Based Assessments6SCOREResult Achieved in Pointsnvarchar40
TOPAudit Management
10PLMC_ASSESSMENTQuestion List - Valuation5SCOREPoints, Valuationdecimal51
TOPBusiness Information Collection
11UISCOREValuation (SEM-BIC)1SCOREID Valuation (SEM-BIC)nvarchar20
12UISCORE_TText on valuation (SEM-BIC)1SCOREID Valuation (SEM-BIC)nvarchar20
13UISRC_R_KWRelation Content Provider <-> Keyword (SEM-BIC)5SCOREID Valuation (SEM-BIC)nvarchar20
TOPContract Accounts Receivable and Payable
14DFKKWLIWork Items32SCORERankingnvarchar40
15DFKKWLIAWork Items (Work Item Type)32SCORERankingnvarchar40
16DFKKWLIAHWork Items (History, Work Item Type)7SCORERankingnvarchar40
17DFKKWLIHWork Items (History)7SCORERankingnvarchar40
18DFKK_BRF090BRF: Parameters for Collection Step and Valuation Figure8SCOREBRF: Expressionnvarchar200
TOPCorporate Performance Monitor
19UMC_GS121Assignment of Formula Result5SCOREScoredecimal40
20UMR_EX120RMS: Measure Status & Risk Status7SCOREScoredecimal40
TOPIncident Recording
21EHHSSC_INC_DUCIncident Duration Classification Code3SCOREScore for Risk Matrixint100
22EHHSSC_INC_FREIncident Frequency Code3SCOREScore for Risk Matrixint100
23EHHSSC_INC_LIKIncident Likelihood Code3SCOREScore for Risk Matrixint100
24EHHSSC_INC_SEVIncident Severity Code4SCOREScore for Risk Matrixint100
TOPLaunchpad
25APB_LPD_HITLISTMost frequently used Applications6SCORENatural Numberint100
TOPPortfolio Management
26/RPM/SMODEL_CURRRange Table - Currency9SCOREScorenvarchar30
27/RPM/SMODEL_NUMCRange Table - Numeric9SCOREScorenvarchar30
28/RPM/SMODEL_TEXTRange Table - Text9SCOREScorenvarchar30
TOPRisk Assessment
29EHHSSC_RISKEXPExposure Frequency3SCOREScore of Risk Matrix Dimensionint100
30EHHSSC_RISKLIKLikelihood3SCOREScore of Risk Matrix Dimensionint100
31EHHSSC_RISKSEVSeverity4SCOREScore of Risk Matrix Dimensionint100
32EHHSSD_RSK_ANLYSRisk Analysis10SCORECalculated Value for Risk Levelint100
TOPService Implementation Workbench
33TSIW_MM_MATCHESCached matches4SCORENatural Numberint100
TOPTraining Management
34LSOLEARNMEDIAT_CCourse Completion - Reentry Information9SCOREScore Achieved for Course Nodenvarchar100
35LSOTACLRNASSRESobsolete in LSO200: Test Completion -Test Results9SCOREResult Achieved in Pointsnvarchar40
36LSOTACLRNITRESPerformance of Assessment - Item Results8SCOREResult Achieved in Pointsnvarchar40
37LSOTACLRNRESULTPerformance of Assessment - Assessment Results8SCOREResult Achieved in Pointsnvarchar40
TOPWithout Description
38RSDMESC_NET_SCORScore Grid: Scores for Node Indexes3SCOREScorefloat1516
39RSDMESC_WST_SCORWeighted Score Tables: Scores in the Individual Dimensions4SCOREScorefloat1516