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

33 columns | Print definition?ERP 6.0  | PERIODICITY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SOMO/JOBMON01Job schedule template38PERIODICITYint100
TOPBalanced Scorecard
2UMB_MC100Scorecard: Measure Value Fields14PERIODICITYValue Fields - Periodizationnvarchar40
3UMB_MC106Scorecard: BW Variables for the Value Fields of a Measure6PERIODICITYTechnical Name of Periodizationnvarchar40
4UMB_SC100Scorecard: Header Table19PERIODICITYPeriodization of an Applicationnvarchar40
5UMB_SC103Scorecard: Measure Assignment12PERIODICITYPeriodization of Elementnvarchar40
6UMB_SC104Scorecard: Strategy Assignment11PERIODICITYPeriodization of Elementnvarchar40
7UMB_SC105Scorecard: Objective Assignment11PERIODICITYPeriodization of Elementnvarchar40
8UMB_SC112Scorecard: Perspective Assignment11PERIODICITYPeriodization of Elementnvarchar40
9UMB_SC180Scorecard: Initiatives30PERIODICITYPeriodization of Elementnvarchar40
10UMB_SC193Scorecard: BW Key Figure Values of an Initiative9PERIODICITYValue Fields - Periodizationnvarchar40
11UMB_SC195Scorecard: BW Variables for Value Fields of an Initiative6PERIODICITYTechnical Name of Periodizationnvarchar40
TOPClaims Management
12ICLITEMClaim Item72PERIODICITYTime Periodsnvarchar20
13ICSITEMClaim Item72PERIODICITYTime Periodsnvarchar20
TOPCorporate Performance Monitor
14UMC_RU100Periodization2PERIODICITYTechnical Name of Periodizationnvarchar40
15UMC_RU100TPeriodization: Texts2PERIODICITYTechnical Name of Periodizationnvarchar40
16UMC_RU101Periodization: Subintervals2PERIODICITYTechnical Name of Periodizationnvarchar40
17UMC_RU101TPeriodization: Subintervals - Texts2PERIODICITYTechnical Name of Periodizationnvarchar40
18UMR_RF100RMS: Measure-Risk Value Fields16PERIODICITYValue Fields - Periodizationnvarchar40
19UMR_RF102RMS: Measure-Risk Value Fields BW Variable9PERIODICITYTechnical Name of Periodizationnvarchar40
20UMR_RI110RMS: Assignment of Target Systems8PERIODICITYPeriodization of Elementnvarchar40
21UMR_RI116RMS: Measure Weight Data Selection - NOT USED12PERIODICITYValue Fields - Periodizationnvarchar40
22UMV_TR100Value Driver Tree: Header Table9PERIODICITYPeriodization of an Applicationnvarchar40
23UMV_TR112Obsolete: Value Driver Tree: Value Fields of a Value Driver12PERIODICITYValue Fields - Periodizationnvarchar40
24UMV_TR116Obsolete: Value Driver Tree: BW Variables for Value Fields6PERIODICITYTechnical Name of Periodizationnvarchar40
25UMV_TR212Value Driver Tree: Value Fields or Measure12PERIODICITYValue Fields - Periodizationnvarchar40
26UMV_TR216Value Driver Tree: BW Variables for Value Fields6PERIODICITYTechnical Name of Periodizationnvarchar40
TOPManagement Cockpit
27UMM_CO100Cockpits: Header Table13PERIODICITYPeriodization of an Applicationnvarchar40
28UMM_FR110Frames:Graphics Assignment13PERIODICITYPeriodizationnvarchar40
29UMM_FR114Frame: BW Variables4PERIODICITYTechnical Name of Periodizationnvarchar40
TOPOffice Suite Program
30/OSP/T_RAUI_MTOSP Mendocino Timepoints Table7PERIODICITYFrequencysmallint50
31/OSP/T_RAUI_SCHOSP Report Scheduling Table9PERIODICITYFrequencysmallint50
TOPPublic Sector Contract Accounts Receivable and Payable
32DFMCA_BRF510BRF: Parameters for Creating Tax Obligation15PERIODICITYBRF: Expressionnvarchar200
TOPService Data Download
33/SOMO/JOSCHEDLTJob Schedule Local Template52PERIODICITYint100