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

203 columns | Print definition?ERP 6.0  | DIMID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/B364/DCPFP_R011Plan1DIMIDDimension Table Keyint100
2/B364/DCPFP_R012Resource1DIMIDDimension Table Keyint100
3/B364/DCPFP_R013Change Request1DIMIDDimension Table Keyint100
4/B364/DCPFP_R014Cost Element1DIMIDDimension Table Keyint100
5/B364/DCPFP_R015MRS1DIMIDDimension Table Keyint100
6/B364/DCPFP_R016Person Detail1DIMIDDimension Table Keyint100
7/B364/DCPFP_R01PData Package1DIMIDDimension Table Keyint100
8/B364/DCPFP_R01TTime1DIMIDDimension Table Keyint100
9/B364/DCPFP_R01UUnit1DIMIDDimension Table Keyint100
10/B364/DPFP_C011Plan1DIMIDDimension Table Keyint100
11/B364/DPFP_C012Resource1DIMIDDimension Table Keyint100
12/B364/DPFP_C013Change Request1DIMIDDimension Table Keyint100
13/B364/DPFP_C014Cost Element1DIMIDDimension Table Keyint100
14/B364/DPFP_C015MRS1DIMIDDimension Table Keyint100
15/B364/DPFP_C016Date1DIMIDDimension Table Keyint100
16/B364/DPFP_C017Person Detail1DIMIDDimension Table Keyint100
17/B364/DPFP_C01PData Package1DIMIDDimension Table Keyint100
18/B364/DPFP_C01TTime1DIMIDDimension Table Keyint100
19/B364/DPFP_C01UUnit1DIMIDDimension Table Keyint100
20/B364/DPFP_R011Plan1DIMIDDimension Table Keyint100
21/B364/DPFP_R012Resource1DIMIDDimension Table Keyint100
22/B364/DPFP_R013Change Request1DIMIDDimension Table Keyint100
23/B364/DPFP_R014Cost Element1DIMIDDimension Table Keyint100
24/B364/DPFP_R015MRS1DIMIDDimension Table Keyint100
25/B364/DPFP_R016Person Detail1DIMIDDimension Table Keyint100
26/B364/DPFP_R01PData Package1DIMIDDimension Table Keyint100
27/B364/DPFP_R01TTime1DIMIDDimension Table Keyint100
28/B364/DPFP_R01UUnit1DIMIDDimension Table Keyint100
29/BI0/D0PPM_VC11Dimension 11DIMIDDimension Table Keyint100
30/BI0/D0PPM_VC1PData Package1DIMIDDimension Table Keyint100
31/BI0/D0PPM_VC1TTime1DIMIDDimension Table Keyint100
32/BI0/D0PPM_VC1UUnit of Measure1DIMIDDimension Table Keyint100
33/BI0/D0RSTT_C012Test Job1DIMIDDimension Table Keyint100
34/BI0/D0RSTT_C013Trace1DIMIDDimension Table Keyint100
35/BI0/D0RSTT_C014Notification Status1DIMIDDimension Table Keyint100
36/BI0/D0RSTT_C016Error status1DIMIDDimension Table Keyint100
37/BI0/D0RSTT_C017Program Object Parameter1DIMIDDimension Table Keyint100
38/BI0/D0RSTT_C018Data Object Parameter1DIMIDDimension Table Keyint100
39/BI0/D0RSTT_C019Test Obj. Parameter1DIMIDDimension Table Keyint100
40/BI0/D0RSTT_C01PData Package1DIMIDDimension Table Keyint100
41/BI0/D0RSTT_C01TTime1DIMIDDimension Table Keyint100
42/BI0/D0RSTT_C021Trace1DIMIDDimension Table Keyint100
43/BI0/D0RSTT_C022Play Variant1DIMIDDimension Table Keyint100
44/BI0/D0RSTT_C023Notification Status1DIMIDDimension Table Keyint100
45/BI0/D0RSTT_C024Error status1DIMIDDimension Table Keyint100
46/BI0/D0RSTT_C025Program Object Parameter1DIMIDDimension Table Keyint100
47/BI0/D0RSTT_C026Data Object Parameter1DIMIDDimension Table Keyint100
48/BI0/D0RSTT_C027Test Obj. Parameter1DIMIDDimension Table Keyint100
49/BI0/D0RSTT_C02PData Package1DIMIDDimension Table Keyint100
50/BI0/D0RSTT_C02TTime1DIMIDDimension Table Keyint100
51/BI0/D0RSTT_C032Test Job1DIMIDDimension Table Keyint100
52/BI0/D0RSTT_C033Trace1DIMIDDimension Table Keyint100
53/BI0/D0RSTT_C034Notification Status1DIMIDDimension Table Keyint100
54/BI0/D0RSTT_C036Error Assignment1DIMIDDimension Table Keyint100
55/BI0/D0RSTT_C037Program Object Parameter1DIMIDDimension Table Keyint100
56/BI0/D0RSTT_C038Data Object Parameter1DIMIDDimension Table Keyint100
57/BI0/D0RSTT_C039Test Object Parameter1DIMIDDimension Table Keyint100
58/BI0/D0RSTT_C03BSupport Package1DIMIDDimension Table Keyint100
59/BI0/D0RSTT_C03PData Package1DIMIDDimension Table Keyint100
60/BI0/D0RSTT_C03TTime1DIMIDDimension Table Keyint100
61/BI0/D0RSTT_C042CATT Trace1DIMIDDimension Table Keyint100
62/BI0/D0RSTT_C043Processing Block1DIMIDDimension Table Keyint100
63/BI0/D0RSTT_C044Support Package1DIMIDDimension Table Keyint100
64/BI0/D0RSTT_C045System1DIMIDDimension Table Keyint100
65/BI0/D0RSTT_C046Selection Variant1DIMIDDimension Table Keyint100
66/BI0/D0RSTT_C04PData Package1DIMIDDimension Table Keyint100
67/BI0/D0RSTT_C04TTime1DIMIDDimension Table Keyint100
68/BI0/D0RSTT_C052Test Requirement1DIMIDDimension Table Keyint100
69/BI0/D0RSTT_C053Modification1DIMIDDimension Table Keyint100
70/BI0/D0RSTT_C054Status1DIMIDDimension Table Keyint100
71/BI0/D0RSTT_C055Support Package1DIMIDDimension Table Keyint100
72/BI0/D0RSTT_C05PData Package1DIMIDDimension Table Keyint100
73/BI0/D0RSTT_C05TTime1DIMIDDimension Table Keyint100
74/BI0/D0RSTT_C061Technology1DIMIDDimension Table Keyint100
75/BI0/D0RSTT_C062System1DIMIDDimension Table Keyint100
76/BI0/D0RSTT_C063Support Package1DIMIDDimension Table Keyint100
77/BI0/D0RSTT_C064Transport Object1DIMIDDimension Table Keyint100
78/BI0/D0RSTT_C065Program Object1DIMIDDimension Table Keyint100
79/BI0/D0RSTT_C066Type of Evaluation1DIMIDDimension Table Keyint100
80/BI0/D0RSTT_C068Object Context1DIMIDDimension Table Keyint100
81/BI0/D0RSTT_C06PData Package1DIMIDDimension Table Keyint100
82/BI0/D0RSTT_C06TTime1DIMIDDimension Table Keyint100
83/BI0/D0TCTHP24I1Daemon Details1DIMIDDimension Table Keyint100
84/BI0/D0TCTHP24I2General1DIMIDDimension Table Keyint100
85/BI0/D0TCTHP24IPData Package1DIMIDDimension Table Keyint100
86/BI0/D0TCTHP24ITTime1DIMIDDimension Table Keyint100
87/BI0/D0TCT_C013Step (details)1DIMIDDimension Table Keyint100
88/BI0/D0TCT_C018Objecttype1DIMIDDimension Table Keyint100
89/BI0/D0TCT_C019General1DIMIDDimension Table Keyint100
90/BI0/D0TCT_C01PData Package1DIMIDDimension Table Keyint100
91/BI0/D0TCT_C01TTime1DIMIDDimension Table Keyint100
92/BI0/D0TCT_C023Step (details)1DIMIDDimension Table Keyint100
93/BI0/D0TCT_C024InfoProvider1DIMIDDimension Table Keyint100
94/BI0/D0TCT_C025InfoProvider type1DIMIDDimension Table Keyint100
95/BI0/D0TCT_C026Type, Event1DIMIDDimension Table Keyint100
96/BI0/D0TCT_C028General1DIMIDDimension Table Keyint100
97/BI0/D0TCT_C02PData Package1DIMIDDimension Table Keyint100
98/BI0/D0TCT_C02TTime1DIMIDDimension Table Keyint100
99/BI0/D0TCT_C033InfoProvider1DIMIDDimension Table Keyint100
100/BI0/D0TCT_C034Provider1DIMIDDimension Table Keyint100
101/BI0/D0TCT_C036Handle, System1DIMIDDimension Table Keyint100
102/BI0/D0TCT_C039Type1DIMIDDimension Table Keyint100
103/BI0/D0TCT_C03AAccess1DIMIDDimension Table Keyint100
104/BI0/D0TCT_C03BHourslot1DIMIDDimension Table Keyint100
105/BI0/D0TCT_C03PData Package1DIMIDDimension Table Keyint100
106/BI0/D0TCT_C03TTime1DIMIDDimension Table Keyint100
107/BI0/D0TCT_C051General1DIMIDDimension Table Keyint100
108/BI0/D0TCT_C052Start time1DIMIDDimension Table Keyint100
109/BI0/D0TCT_C05PData Package1DIMIDDimension Table Keyint100
110/BI0/D0TCT_C05TTime1DIMIDDimension Table Keyint100
111/BI0/D0TCT_C141BW Object and Properties1DIMIDDimension Table Keyint100
112/BI0/D0TCT_C142Dataload Errors and Related Objects1DIMIDDimension Table Keyint100
113/BI0/D0TCT_C143Target Object Details1DIMIDDimension Table Keyint100
114/BI0/D0TCT_C144Time stamp details1DIMIDDimension Table Keyint100
115/BI0/D0TCT_C145General1DIMIDDimension Table Keyint100
116/BI0/D0TCT_C146Miscellaneous1DIMIDDimension Table Keyint100
117/BI0/D0TCT_C147Flag for Data Availability1DIMIDDimension Table Keyint100
118/BI0/D0TCT_C14PData Package1DIMIDDimension Table Keyint100
119/BI0/D0TCT_C14TTime1DIMIDDimension Table Keyint100
120/BI0/D0TCT_C151BW data storage object1DIMIDDimension Table Keyint100
121/BI0/D0TCT_C152Responsible BW Process1DIMIDDimension Table Keyint100
122/BI0/D0TCT_C155RRI URLs1DIMIDDimension Table Keyint100
123/BI0/D0TCT_C156General1DIMIDDimension Table Keyint100
124/BI0/D0TCT_C158Other Error Details1DIMIDDimension Table Keyint100
125/BI0/D0TCT_C159InfoArea/Application Component1DIMIDDimension Table Keyint100
126/BI0/D0TCT_C15PData Package1DIMIDDimension Table Keyint100
127/BI0/D0TCT_C15TTime1DIMIDDimension Table Keyint100
128/BI0/D0TCT_C212General Data and Process Chain1DIMIDDimension Table Keyint100
129/BI0/D0TCT_C21PData Package1DIMIDDimension Table Keyint100
130/BI0/D0TCT_C21TTime Dimension1DIMIDDimension Table Keyint100
131/BI0/D0TCT_C221General Data1DIMIDDimension Table Keyint100
132/BI0/D0TCT_C222Process Chain Details1DIMIDDimension Table Keyint100
133/BI0/D0TCT_C223DTP Details1DIMIDDimension Table Keyint100
134/BI0/D0TCT_C224DTP Source1DIMIDDimension Table Keyint100
135/BI0/D0TCT_C225DTP Target1DIMIDDimension Table Keyint100
136/BI0/D0TCT_C226WHM1DIMIDDimension Table Keyint100
137/BI0/D0TCT_C227Events1DIMIDDimension Table Keyint100
138/BI0/D0TCT_C22PData Package1DIMIDDimension Table Keyint100
139/BI0/D0TCT_C22TTime Dimension1DIMIDDimension Table Keyint100
140/BI0/D0TCT_C231General Data1DIMIDDimension Table Keyint100
141/BI0/D0TCT_C232Warehouse1DIMIDDimension Table Keyint100
142/BI0/D0TCT_C233Process Chain1DIMIDDimension Table Keyint100
143/BI0/D0TCT_C234Action type1DIMIDDimension Table Keyint100
144/BI0/D0TCT_C235Source1DIMIDDimension Table Keyint100
145/BI0/D0TCT_C236Target1DIMIDDimension Table Keyint100
146/BI0/D0TCT_C23PData Package1DIMIDDimension Table Keyint100
147/BI0/D0TCT_C23TTime1DIMIDDimension Table Keyint100
148/BI0/D0TCT_C252BI Object1DIMIDDimension Table Keyint100
149/BI0/D0TCT_C253Properties1DIMIDDimension Table Keyint100
150/BI0/D0TCT_C255Assignment1DIMIDDimension Table Keyint100
151/BI0/D0TCT_C25PData Package1DIMIDDimension Table Keyint100
152/BI0/D0TCT_C25TTime1DIMIDDimension Table Keyint100
153/BI0/D0TCT_C311General1DIMIDDimension Table Keyint100
154/BI0/D0TCT_C312Start time1DIMIDDimension Table Keyint100
155/BI0/D0TCT_C31PData Package1DIMIDDimension Table Keyint100
156/BI0/D0TCT_C31TTime1DIMIDDimension Table Keyint100
157/BI0/D0TCT_C321General1DIMIDDimension Table Keyint100
158/BI0/D0TCT_C322Start time1DIMIDDimension Table Keyint100
159/BI0/D0TCT_C32PData Package1DIMIDDimension Table Keyint100
160/BI0/D0TCT_C32TTime1DIMIDDimension Table Keyint100
161/BI0/D0TCT_CA18Object Type1DIMIDDimension Table Keyint100
162/BI0/D0TCT_CA19General1DIMIDDimension Table Keyint100
163/BI0/D0TCT_CA1PData Package1DIMIDDimension Table Keyint100
164/BI0/D0TCT_CA1TTime1DIMIDDimension Table Keyint100
165/BIC/DIC_MMPData Package1DIMIDDimension Table Keyint100
166/BIC/DIC_SD1PData Package1DIMIDDimension Table Keyint100
167/BIC/DIC_SD2PData Package1DIMIDDimension Table Keyint100
168/BIC/DZPFP_R02PData Package1DIMIDDimension Table Keyint100
169/BIC/DZ_PFP_R01PData Package1DIMIDDimension Table Keyint100
170GRRMCONTEXTGRRM Context data base table for non HR Entities3DIMIDDimension IDnvarchar250
171GRRMCTXIDContext IDs and description of IDs stored locally3DIMIDDimension IDnvarchar250
172GRRMDIMContext Dimensions2DIMIDDimension IDnvarchar250
173GRRMDIMENTITYAssignment Dimensions to Enities3DIMIDDimension IDnvarchar250
174GRRMDIMTDescriptions of Context Dimensions3DIMIDDimension IDnvarchar250
175HRP1897DB Table for Infotype 189718DIMIDDimension IDnvarchar250
TOPAdvertising Management
176TJJV13IS-M: Dimension Key for Contract Target Quantity2DIMIDDimension keynvarchar60
TOPBatches
177TCHW2Units of Measurement for Batch-Specific Units of Measure8DIMIDAllowed dimension for ratiosnvarchar60
TOPContractual Allocation
178OIUCA_SSDIMPossible dimensions for sliding scale methods3DIMIDDimension keynvarchar60
TOPData Basis
179RSDMDIMTABModel table: Dimensions table1DIMIDDimension Table Keyint100
TOPDevice Management
180TE270EZWG_DIMUnits of Measurement for Register Categories of Reg. Group4DIMIDDimension keynvarchar60
TOPEnergy Data Management
181EDIVDIMPermitted Dimensions for Division Cat. and Profile Val. Cat.4DIMIDDimension keynvarchar60
182EEDMFORMPARFormula Parameters9DIMIDDimension keynvarchar60
TOPEnvironment, Health and Safety Master Data
183HSMC_019EHS: Definition of Numeric Types in Hazardous Subs. Master3DIMIDDimension keynvarchar60
TOPFreight Processing
184TVFSCBScale Bases21DIMIDDimension keynvarchar60
TOPIndustry Solution Oil
185OIB07_HELPParameter of the Quantity Conversion Interface4DIMIDDimension keynvarchar60
TOPInformation System
186TCNUProject Information System: Unit Conversion3DIMIDDimension keynvarchar60
TOPIntegration Customer Relationship Management
187EDIVDIM_PRPPermitted Dimensions for Division Category3DIMIDDimension keynvarchar60
TOPLogistics Execution
188/DSD/PE_PHYSICALHeader structure of SyncBO 'PhysicalUnit' for pricing engi4DIMIDDimension keynvarchar60
TOPMeasurement System
189GHO_MEASDTMeasurement Details4DIMIDDimension keynvarchar60
190GHO_MEAS_GRPDTMeasurement Group Details4DIMIDDimension keynvarchar60
TOPOLAP Technology
191RSCDSREQDELTABAdministration of Requests to be Deleted When Compressing3DIMIDDimension Table Keyint100
192RSDDTREXNEWDID_RDIMIDs Required for BIA Recovery2DIMIDDimension Table Keyint100
193RSDDTREXNEWDIMIDNew DIMIDs for Dimensions in HPA Aggregates2DIMIDDimension Table Keyint100
194RSDRDREQDELTABManagement of Requests to be Deleted with Request Deletion3DIMIDDimension Table Keyint100
TOPProduct Safety
195TCGUPDEFUNITEHS: Asgt - Unit of Meas. Profile to Dimension/Standard UoM3DIMIDDimension keynvarchar60
TOPProduction and Revenue Accounting
196OIU_ME_RTYPEReading Type4DIMIDDimension keynvarchar60
TOPReal Estate Management
197VIAK08DME Settlement Units Master Data12DIMIDDimension keynvarchar60
TOPRoyalty Reporting
198OIUREP_UOMRegulatory Report Unit of Measures5DIMIDDimension keynvarchar60
TOPUnits of Measurement
199T006Units of Measurement10DIMIDDimension keynvarchar60
200T006DDimensions2DIMIDDimension keynvarchar60
201T006D_OIBAdd-On Extension for Dimensions2DIMIDDimension keynvarchar60
202T006TDimension Texts3DIMIDDimension keynvarchar60
TOPWork Center
203KAPECapacity unit of measure allocation7DIMIDDimension keynvarchar60