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

113 columns | Print definition?ERP 6.0  | MEAS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TIVXCESCDMSRDefine the measurements that affect the rent2MEASMeasurement Typenvarchar40
2TIVXCITCADMSRDefine the editable measurements3MEASMeasurement Typenvarchar40
3TIVYCMETER2COSTMeter and Cost Element Mapping table4MEASMeasurement Typenvarchar40
4VIXCITCADMSRTemporary measurement data6MEASMeasurement Typenvarchar40
5VIYCMETERCOSTSMeter Based Costs15MEASMeasurement Typenvarchar40
TOPBalanced Scorecard
6UMB_BC_SM103Strategy Map: Measure Assignment3MEASMeasurenvarchar180
7UMB_MC100Scorecard: Measure Value Fields3MEASMeasurenvarchar180
8UMB_MC101Scorecard: Characteristics for the Value Fields of a Measure3MEASMeasurenvarchar180
9UMB_MC102Scorecard: Graphics3MEASMeasurenvarchar180
10UMB_MC103Scorecard: Assignment of Columns to Graphics3MEASMeasurenvarchar180
11UMB_MC105Scorecard: Graphics: Texts4MEASMeasurenvarchar180
12UMB_MC106Scorecard: BW Variables for the Value Fields of a Measure3MEASMeasurenvarchar180
13UMB_MC107Scorecard: BW Variables for the Value Fields of a Measure3MEASMeasurenvarchar180
14UMB_MC108Scorecard: Graphic - Setting in XML Format3MEASMeasurenvarchar180
15UMB_MC109Scorecard: Graphic - Setting in XML Format3MEASMeasurenvarchar180
16UMB_SC103Scorecard: Measure Assignment3MEASMeasurenvarchar180
17UMB_SC160Scorecard: Measure Assignment (Time-Dependent)3MEASMeasurenvarchar180
18UMB_SC161Scorecard: Measure Score, A&C, DBS, Doc Id3MEASMeasurenvarchar180
19UMB_SC162Objective: Measure Assignment (Time-Dependent)4MEASMeasurenvarchar180
20UMB_SC163Scorecard: Assignment of Formula Argument to Value Fields3MEASMeasurenvarchar180
21UMB_SC164Scorecard: Formula to Calculate the Status of a Measure3MEASMeasurenvarchar180
22UMB_SC165Scorecard: Assignment of Formula Value to Measure Status3MEASMeasurenvarchar180
23UMB_SC166Scorecard: Measures: BIC Selections3MEASMeasurenvarchar180
24UMB_SC167Scorecard: Measures: BPS Link3MEASMeasurenvarchar180
25UMB_SC168Scorecard: Measures: Assigned BW Queries3MEASMeasurenvarchar180
TOPBasic Data
26TIVBDMEASMeasurement Type2MEASMeasurement Typenvarchar40
27TIVBDMEASAOMeasurement Type: Settings per Arch. Object Type2MEASMeasurement Typenvarchar40
28TIVBDMEASAOFUMeasurement Types: Settings per Arch. Object Type and Funct.2MEASMeasurement Typenvarchar40
29TIVBDMEASMETERCharacteristic per Measurement Type2MEASMeasurement Typenvarchar40
30TIVBDMEASRELSTRCMeasurement Structure for Measurement Type3MEASMeasurement Typenvarchar40
31TIVBDMEASROMeasurement Type: Settings per Usage Type2MEASMeasurement Typenvarchar40
32TIVBDMEASROTYPEMeasurement Type: Settings per Rental Object Type2MEASMeasurement Typenvarchar40
33TIVBDMEASTMeasurement Type - Texts3MEASMeasurement Typenvarchar40
34VIBDMEASMeasurement3MEASMeasurement Typenvarchar40
35VIBDOBJRELPARTObject Relationship A/U Object <-> A/U Object: Percent5MEASMeasurement Typenvarchar40
36VIBDPLANOBJPlan Pooled Space7MEASMeasurement Typenvarchar40
37VIBDPLANOCCPlanned Occupancy of Usage Objects7MEASMeasurement Typenvarchar40
TOPCorporate Performance Monitor
38UMK_BU100Total Float1MEASMeasurenvarchar180
39UMK_MB100Key Figures: Header Table1MEASMeasurenvarchar180
40UMK_MB100TMeasures: Texts2MEASMeasurenvarchar180
41UMK_MB110Industry Assignment1MEASMeasurenvarchar180
42UMK_MB120Benchmark Data Source <-> Measure1MEASMeasurenvarchar180
43UMK_MB130Measure Mapping & Sourcing: InfoProvider Key Figure1MEASMeasurenvarchar180
44UMK_MB140URL Assignment1MEASMeasurenvarchar180
45UMK_MB140TText Table for URL Assignment2MEASMeasurenvarchar180
46UMK_MB150Company <-> Provider Measure1MEASCustomer Measurenvarchar180
47UMK_MB160Source for Measure1MEASMeasurenvarchar180
48UMK_MB200Measure Formula1MEASMeasurenvarchar180
49UMR_EX100RMS: Measure Deviations for Risks3MEASMeasurenvarchar180
50UMR_EX110RMS: Measure Targets3MEASMeasurenvarchar180
51UMR_EX120RMS: Measure Status & Risk Status3MEASMeasurenvarchar180
52UMR_RF100RMS: Measure-Risk Value Fields4MEASMeasurenvarchar180
53UMR_RF101RMS: Measure-Risk Value Fields Selection Criteria4MEASMeasurenvarchar180
54UMR_RF102RMS: Measure-Risk Value Fields BW Variable4MEASMeasurenvarchar180
55UMR_RF103RMS: Measure-Risk Value Fields BW Variables4MEASMeasurenvarchar180
56UMR_RI030Risk: Measure Assignment3MEASMeasurenvarchar180
57UMR_RI114RMS: Measure Selection and Attributes4MEASMeasurenvarchar180
58UMR_RI115RMS: Measure Formula Argument Assignment4MEASMeasurenvarchar180
59UMR_RI116RMS: Measure Weight Data Selection - NOT USED4MEASMeasurenvarchar180
60UMR_RI117RMS: Measure Weight Data Selection - Selections - NOT USED4MEASMeasurenvarchar180
61UMR_RI118RMS: Measure-Risk Value Fields Read Only Flag4MEASMeasurenvarchar180
62UMR_RI128RMS: Measure Deviations for Risks4MEASMeasurenvarchar180
63UMR_RI129RMS: Risk Status for Measure4MEASMeasurenvarchar180
64UMV_TR120Value Driver Tree: Graphics3MEASMeasurenvarchar180
65UMV_TR121Value Driver Tree: Assignment of Value Fields to Graphics3MEASMeasurenvarchar180
66UMV_TR123Value Driver Tree: Graphics : Texts4MEASMeasurenvarchar180
67UMV_TR124Value Driver Tree: Graphic - Settings in XML Format3MEASMeasurenvarchar180
68UMV_TR127Value Driver Tree: Graphic - Settings in XML Format3MEASMeasurenvarchar180
69UMV_TR210Value Driver Tree: Used Measures3MEASMeasurenvarchar180
70UMV_TR212Value Driver Tree: Value Fields or Measure3MEASMeasurenvarchar180
71UMV_TR213Value Driver Tree: Selections for the Value Fields3MEASMeasurenvarchar180
72UMV_TR214Value Driver Tree: BIC Selections for Measures3MEASMeasurenvarchar180
73UMV_TR215Value Driver Tree: BW Queries and Workbooks for Measures3MEASMeasurenvarchar180
74UMV_TR216Value Driver Tree: BW Variables for Value Fields3MEASMeasurenvarchar180
75UMV_TR217Value Driver Tree: BW Variables for Value Fields3MEASMeasurenvarchar180
76UMV_TR218Value Driver Tree: Assignment of BPS Functions to Measures3MEASMeasurenvarchar180
77UMV_TR219Value Driver Tree - Measures: BPS Measure3MEASMeasurenvarchar180
78UMV_TR225Value Driver Tree: Assignment of web Reports to Measures4MEASMeasurenvarchar180
79UMV_TR226Value Driver Tree: Assignment of URLs to Measures4MEASMeasurenvarchar180
80UMV_TR227Value Driver Tree: Responsible Persons for Measures4MEASMeasurenvarchar180
81UMV_TR230Value Driver Tree: Assign Value Fields to Formula Arguments3MEASMeasurenvarchar180
82UMV_TR231Value Driver Tree: Status, Assessments and Comments4MEASMeasurenvarchar180
TOPDFPS Authorized Infrastructure
83/ISDFPS/CREIPLYAssignment of Architectural Object Type to Planning Level4MEASMeasurement Typenvarchar40
TOPFlexible Real Estate Management
84TIVSCSCKATTROBSOLETE: Service Charge Key Attributes6MEASMeasurement Typenvarchar40
85VISCS_MEASOBSOLETE: Measurement Amount (Replaced by VISCSMEAS)5MEASMeasurement Typenvarchar40
86VIXCSCCHTPSHARDistribution for External Heating Expenses Settlement7MEASMeasurement Typenvarchar40
TOPInformation System
87TIVISPFCONDRELReport Profile for Conditions: Properties10MEASMeasurement Typenvarchar40
88TIVISPFMEASRELReport Profile for Measurements: Properties4MEASMeasurement Typenvarchar40
TOPInput Tax Treatment
89TIVITOPTMETHMethod for Option Rate Determination4MEASMeasurement Typenvarchar40
90VIITORCOBJOption Rate Determination: Result of Calculation Object5MEASMeasurement Typenvarchar40
TOPLocalization
91VIXCJPSCCOSTSEXTCosts per Object - Legacy Data Transfer25MEASMeasurement Typenvarchar40
TOPManagement Cockpit
92UMM_FR102Frames: Key Figures11MEASMeasurenvarchar180
TOPMigration
93TIVMISETMEASConversion of Area Type and Apportionment Unit to Meas.Type4MEASMeasurement Typenvarchar40
TOPOffer and Rental Request
94TIVORRRTYPEMTCUsage Types for RE Search Request Type5MEASMeasurement Typenvarchar40
95VIOROOOffered Object19MEASMeasurement Typenvarchar40
TOPReal Estate Contract
96TIVCNMEASCNMeasurement: Settings per Contract Type2MEASMeasurement Typenvarchar40
97VICNMEASCNContract Measurement4MEASMeasurement Typenvarchar40
TOPReal Estate Controlling
98TIVEXCOMEASKYFAssignment of Measurement to Statistical Key Figure6MEASMeasurement Typenvarchar40
TOPReal Estate Management
99VIAK26Master Settlement Unit: Participating Settlement Units35MEASMeasurement Typenvarchar40
TOPRent Adjustment
100TIVAJMEASATMeasurement: Settings per Adjustment Rule2MEASMeasurement Typenvarchar40
TOPSales-Based Rent and Settlement
101VISRTMRPReporting Rule11MEASMeasurement Typenvarchar40
TOPService Charge Settlement
102TIVSCAJSCKATTRAttributes of Adjustment of SCS Advance Pmnt per SC Key3MEASMeasurement Type for Consideration of Average Costsnvarchar40
103TIVSCMEAS2CONDAssignment of Measurement Type to Condition Type2MEASMeasurement Typenvarchar40
104TIVSCSCKEYService Charge Keys9MEASMeasurement Typenvarchar40
105TIVSCSUDEFAULTDefaults for Creating SU per SC Key4MEASMeasurement Typenvarchar40
106VISCEXBASERATEBasic Components for External Settlement per SU5MEASMeasurement Typenvarchar40
107VISCSHAREOUTSplit settlement factors for settlement variant5MEASMeasurement Typenvarchar40
108VISCSURELMaster Settlement Unit: Participating Settlement Units16MEASMeasurement Typenvarchar40
109VISCS_MSU_RESTDistribution of Master SU to Remaining Objects10MEASMeasurement Typenvarchar40
110VISCS_MSU_SUDistribution of Master SU to Participating SUs11MEASMeasurement Typenvarchar40
111VISCS_RO_CNCosts and Measurement Amounts for REC + RO (Lease-Out View)10MEASMeasurement Typenvarchar40
112VISCS_SU_ROSum of All Costs and Measurement Amounts for a Rental Object10MEASMeasurement Typenvarchar40
113VISCS_SU_SUMSum of All Costs and Measurement Amounts for Settlment Unit9MEASMeasurement Typenvarchar40