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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

270 columns | Print definition?ERP 6.0  | PRED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/B364/IFPIDSID Structure of Hierarchies: InfoObject Structure Element3PREDMaster data IDint100
2/B364/IMPITEMSSID Structure of Hierarchies: InfoObject Structure Element3PREDMaster data IDint100
3/B631/IACTTYPESID Structure of Hierarchies: InfoObject Activity Type3PREDMaster data IDint100
4/B631/ICOORDERSID Structure of Hierarchies: InfoObject Order3PREDMaster data IDint100
5/B631/ICOSTCNTRSID Structure of Hierarchies: InfoObject Cost Center3PREDMaster data IDint100
6/B631/ICOSTELMTSID Structure of Hierarchies: InfoObject Cost Element3PREDMaster data IDint100
7/B631/IPLANTSID Structure of Hierarchies: InfoObject Plant3PREDMaster data IDint100
8/B631/IPROFTCTRSID Structure of Hierarchies: InfoObject Profit Center3PREDMaster data IDint100
9/B631/IWBSELMTSID Structure of Hierarchies: InfoObject WBS Element3PREDMaster data IDint100
10/BI0/0200000001Temporary SID table2PREDint100
11/BI0/0200000002Temporary SID table2PREDint100
12/BI0/0200000003Temporary SID table2PREDint100
13/BI0/0200000004Temporary SID table2PREDint100
14/BI0/0200000005Temporary SID table2PREDint100
15/BI0/0200000006Temporary SID table2PREDint100
16/BI0/0200000007Temporary SID table2PREDint100
17/BI0/0200000008Temporary SID table2PREDint100
18/BI0/0200000009Temporary SID table2PREDint100
19/BI0/0200000010Temporary SID table2PREDint100
20/BI0/0200000011Temporary SID table2PREDint100
21/BI0/0200000012Temporary SID table2PREDint100
22/BI0/0200000013Temporary SID table2PREDint100
23/BI0/0200000014Temporary SID table2PREDint100
24/BI0/0200000015Temporary SID table2PREDint100
25/BI0/0200000016Temporary SID table2PREDint100
26/BI0/0200000017Temporary SID table2PREDint100
27/BI0/0200000018Temporary SID table2PREDint100
28/BI0/0200000019Temporary SID table2PREDint100
29/BI0/0200000020Temporary SID table2PREDint100
30/BI0/0200000021Temporary SID table2PREDint100
31/BI0/0200000022Temporary SID table2PREDint100
32/BI0/0200000023Temporary SID table2PREDint100
33/BI0/0200000024Temporary SID table2PREDint100
34/BI0/0200000025Temporary SID table2PREDint100
35/BI0/0200000026Temporary SID table2PREDint100
36/BI0/0200000027Temporary SID table2PREDint100
37/BI0/0200000028Temporary SID table2PREDint100
38/BI0/0200000029Temporary SID table2PREDint100
39/BI0/0200000030Temporary SID table2PREDint100
40/BI0/0200000031Temporary SID table2PREDint100
41/BI0/0200000032Temporary SID table2PREDint100
42/BI0/0200000033Temporary SID table2PREDint100
43/BI0/0200000034Temporary SID table2PREDint100
44/BI0/0200000035Temporary SID table2PREDint100
45/BI0/0200000036Temporary SID table2PREDint100
46/BI0/0200000037Temporary SID table2PREDint100
47/BI0/0200000038Temporary SID table2PREDint100
48/BI0/0200000039Temporary SID table2PREDint100
49/BI0/0200000040Temporary SID table2PREDint100
50/BI0/0200000041Temporary SID table2PREDint100
51/BI0/0200000042Temporary SID table2PREDint100
52/BI0/0200000043Temporary SID table2PREDint100
53/BI0/0200000044Temporary SID table2PREDint100
54/BI0/0200000045Temporary SID table2PREDint100
55/BI0/0200000046Temporary SID table2PREDint100
56/BI0/0200000047Temporary SID table2PREDint100
57/BI0/0200000048Temporary SID table2PREDint100
58/BI0/0200000049Temporary SID table2PREDint100
59/BI0/0200000050Temporary SID table2PREDint100
60/BI0/0200000051Temporary SID table2PREDint100
61/BI0/0200000052Temporary SID table2PREDint100
62/BI0/0200000053Temporary SID table2PREDint100
63/BI0/0200000054Temporary SID table2PREDint100
64/BI0/0200000055Temporary SID table2PREDint100
65/BI0/0200000056Temporary SID table2PREDint100
66/BI0/0200000057Temporary SID table2PREDint100
67/BI0/0200000058Temporary SID table2PREDint100
68/BI0/0200000059Temporary SID table2PREDint100
69/BI0/0200000060Temporary SID table2PREDint100
70/BI0/0200000061Temporary SID table2PREDint100
71/BI0/0200000062Temporary SID table2PREDint100
72/BI0/0200000063Temporary SID table2PREDint100
73/BI0/0200000064Temporary SID table2PREDint100
74/BI0/0200000065Temporary SID table2PREDint100
75/BI0/0200000066Temporary SID table2PREDint100
76/BI0/0200000067Temporary SID table2PREDint100
77/BI0/0200000068Temporary SID table2PREDint100
78/BI0/0200000069Temporary SID table2PREDint100
79/BI0/0200000070Temporary SID table2PREDint100
80/BI0/0200000071Temporary SID table2PREDint100
81/BI0/0200000072Temporary SID table2PREDint100
82/BI0/0200000073Temporary SID table2PREDint100
83/BI0/0200000074Temporary SID table2PREDint100
84/BI0/0200000075Temporary SID table2PREDint100
85/BI0/0200000076Temporary SID table2PREDint100
86/BI0/0200000077Temporary SID table2PREDint100
87/BI0/0200000078Temporary SID table2PREDint100
88/BI0/0200000079Temporary SID table2PREDint100
89/BI0/0200000080Temporary SID table2PREDint100
90/BI0/0200000081Temporary SID table2PREDint100
91/BI0/0200000082Temporary SID table2PREDint100
92/BI0/0200000083Temporary SID table2PREDint100
93/BI0/0200000084Temporary SID table2PREDint100
94/BI0/0200000085Temporary SID table2PREDint100
95/BI0/0200000086Temporary SID table2PREDint100
96/BI0/0200000087Temporary SID table2PREDint100
97/BI0/0200000088Temporary SID table2PREDint100
98/BI0/0200000089Temporary SID table2PREDint100
99/BI0/0200000090Temporary SID table2PREDint100
100/BI0/0200000091Temporary SID table2PREDint100
101/BI0/0200000092Temporary SID table2PREDint100
102/BI0/0200000093Temporary SID table2PREDint100
103/BI0/0200000094Temporary SID table2PREDint100
104/BI0/0200000095Temporary SID table2PREDint100
105/BI0/0200000096Temporary SID table2PREDint100
106/BI0/0200000097Temporary SID table2PREDint100
107/BI0/0200000098Temporäre SID-Tabelle2PREDint100
108/BI0/0200000099Temporäre SID-Tabelle2PREDint100
109/BI0/0200000100Temporary SID table2PREDint100
110/BI0/0200000101Temporary SID table2PREDint100
111/BI0/0200000102Temporary SID table2PREDint100
112/BI0/0200000103Temporary SID table2PREDint100
113/BI0/0200000104Temporary SID table2PREDint100
114/BI0/0200000105Temporary SID table2PREDint100
115/BI0/0200000106Temporary SID table2PREDint100
116/BI0/0200000107Temporary SID table2PREDint100
117/BI0/0200000108Temporary SID table2PREDint100
118/BI0/0200000109Temporary SID table2PREDint100
119/BI0/0200000110Temporary SID table2PREDint100
120/BI0/0200000111Temporary SID table2PREDint100
121/BI0/0200000112Temporary SID table2PREDint100
122/BI0/0200000113Temporary SID table2PREDint100
123/BI0/0200000114Temporary SID table2PREDint100
124/BI0/0200000115Temporary SID table2PREDint100
125/BI0/0200000116Temporary SID table2PREDint100
126/BI0/0200000117Temporary SID table2PREDint100
127/BI0/0200000118Temporary SID table2PREDint100
128/BI0/0200000119Temporary SID table2PREDint100
129/BI0/0200000120Temporary SID table2PREDint100
130/BI0/0200000121Temporary SID table2PREDint100
131/BI0/0200000122Temporary SID table2PREDint100
132/BI0/0200000123Temporary SID table2PREDint100
133/BI0/0200000124Temporary SID table2PREDint100
134/BI0/0200000125Temporary SID table2PREDint100
135/BI0/0200000126Temporary SID table2PREDint100
136/BI0/0200000127Temporary SID table2PREDint100
137/BI0/0200000128Temporary SID table2PREDint100
138/BI0/0200000129Temporary SID table2PREDint100
139/BI0/0200000130Temporary SID table2PREDint100
140/BI0/0200000131Temporary SID table2PREDint100
141/BI0/0200000132Temporary SID table2PREDint100
142/BI0/0200000133Temporary SID table2PREDint100
143/BI0/0200000134Temporary SID table2PREDint100
144/BI0/0200000135Temporary SID table2PREDint100
145/BI0/0200000136Temporary SID table2PREDint100
146/BI0/0200000137Temporary SID table2PREDint100
147/BI0/0200000138Temporary SID table2PREDint100
148/BI0/0200000139Temporary SID table2PREDint100
149/BI0/0200000140Temporary SID table2PREDint100
150/BI0/0200000141Temporary SID table2PREDint100
151/BI0/0200000142Temporary SID table2PREDint100
152/BI0/0200000143Temporary SID table2PREDint100
153/BI0/0200000144Temporary SID table2PREDint100
154/BI0/0200000145Temporary SID table2PREDint100
155/BI0/0200000146Temporary SID table2PREDint100
156/BI0/0200000147Temporary SID table2PREDint100
157/BI0/0200000148Temporary SID table2PREDint100
158/BI0/0200000149Temporary SID table2PREDint100
159/BI0/0200000150Temporary SID table2PREDint100
160/BI0/0200000151Temporary SID table2PREDint100
161/BI0/0200000152Temporary SID table2PREDint100
162/BI0/0200000153Temporary SID table2PREDint100
163/BI0/0200000154Temporary SID table2PREDint100
164/BI0/0200000155Temporary SID table2PREDint100
165/BI0/0200000156Temporary SID table2PREDint100
166/BI0/0200000157Temporary SID table2PREDint100
167/BI0/0200000158Temporary SID table2PREDint100
168/BI0/0200000159Temporary SID table2PREDint100
169/BI0/0200000160Temporary SID table2PREDint100
170/BI0/0200000161Temporary SID table2PREDint100
171/BI0/0200000162Temporary SID table2PREDint100
172/BI0/0200000163Temporary SID table2PREDint100
173/BI0/0200000164Temporary SID table2PREDint100
174/BI0/0200000165Temporary SID table2PREDint100
175/BI0/0200000166Temporary SID table2PREDint100
176/BI0/0200000167Temporary SID table2PREDint100
177/BI0/0200000168Temporary SID table2PREDint100
178/BI0/0200000169Temporary SID table2PREDint100
179/BI0/0200000170Temporary SID table2PREDint100
180/BI0/0200000171Temporary SID table2PREDint100
181/BI0/0200000172Temporary SID table2PREDint100
182/BI0/0200000173Temporary SID table2PREDint100
183/BI0/0200000174Temporary SID table2PREDint100
184/BI0/0200000175Temporary SID table2PREDint100
185/BI0/0200000176Temporary SID table2PREDint100
186/BI0/0200000177Temporary SID table2PREDint100
187/BI0/0200000178Temporary SID table2PREDint100
188/BI0/0200000179Temporary SID table2PREDint100
189/BI0/0200000180Temporary SID table2PREDint100
190/BI0/0200000181Temporary SID table2PREDint100
191/BI0/0200000182Temporary SID table2PREDint100
192/BI0/0200000183Temporary SID table2PREDint100
193/BI0/0200000184Temporary SID table2PREDint100
194/BI0/0200000185Temporary SID table2PREDint100
195/BI0/0200000186Temporary SID table2PREDint100
196/BI0/0200000187Temporary SID table2PREDint100
197/BI0/0200000188Temporary SID table2PREDint100
198/BI0/0200000189Temporary SID table2PREDint100
199/BI0/0200000190Temporary SID table2PREDint100
200/BI0/0200000191Temporary SID table2PREDint100
201/BI0/0200000192Temporary SID table2PREDint100
202/BI0/0200000193Temporary SID table2PREDint100
203/BI0/0200000194Temporary SID table2PREDint100
204/BI0/0200000195Temporary SID table2PREDint100
205/BI0/0200000196Temporary SID table2PREDint100
206/BI0/0200000197Temporary SID table2PREDint100
207/BI0/0200000198Temporary SID table2PREDint100
208/BI0/0200000199Temporary SID table2PREDint100
209/BI0/0200000200Temporary SID table2PREDint100
210/BI0/0200000201Temporary SID table2PREDint100
211/BI0/IBUCKETSID Structure of Hierarchies: InfoObject Directory of Precal3PREDMaster data IDint100
212/BI0/ICALMONTHSID Structure of Hierarchies: InfoObject Calendar Year/Month3PREDMaster data IDint100
213/BI0/ICALMONTH2SID Structure of Hierarchies: InfoObject Calendar month3PREDMaster data IDint100
214/BI0/IDATESID Structure of Hierarchies: InfoObject Date3PREDMaster data IDint100
215/BI0/IFISCPERSID Structure of Hierarchies: InfoObject Fiscal year/period3PREDMaster data IDint100
216/BI0/IHALFYEAR1SID Structure of Hierarchies: InfoObject Halfyear3PREDMaster data IDint100
217/BI0/IINFOPROVSID Structure of Hierarchies: InfoObject InfoProvider3PREDMaster data IDint100
218/BI0/IIOBJNMSID Structure of Hierarchies: InfoObject InfoObject3PREDMaster data IDint100
219/BI0/IRSPL_ORGSID Structure of Hierarchies: InfoObject Area of Responsibil3PREDMaster data IDint100
220/BI0/IRSTT_EIDSID Structure of Hierarchies: InfoObject Error ID3PREDMaster data IDint100
221/BI0/IRSTT_FTPCSID Structure of Hierarchies: InfoObject Function Subject3PREDMaster data IDint100
222/BI0/IRSTT_FUNCSID Structure of Hierarchies: InfoObject Functions3PREDMaster data IDint100
223/BI0/IRSTT_IONMSID Structure of Hierarchies: InfoObject InfoObject3PREDMaster data IDint100
224/BI0/IRSTT_IPBZMSID Structure of Hierarchies: InfoObject RTM for Non-Cum.3PREDMaster data IDint100
225/BI0/IRSTT_IPNMSID Structure of Hierarchies: InfoObject InfoProvider Name3PREDMaster data IDint100
226/BI0/IRSTT_JIDSID Structure of Hierarchies: InfoObject Job ID3PREDMaster data IDint100
227/BI0/IRSTT_OBJNMSID Structure of Hierarchies: InfoObject Object Name3PREDMaster data IDint100
228/BI0/IRSTT_PIDSID Structure of Hierarchies: InfoObject Trace Package ID3PREDMaster data IDint100
229/BI0/IRSTT_PVARSID Structure of Hierarchies: InfoObject Play Variant3PREDMaster data IDint100
230/BI0/IRSTT_QYNMSID Structure of Hierarchies: InfoObject Query Name3PREDMaster data IDint100
231/BI0/IRSTT_RQIDSID Structure of Hierarchies: InfoObject Test Request3PREDMaster data IDint100
232/BI0/IRSTT_RVARSID Structure of Hierarchies: InfoObject Ref. Data Variant3PREDMaster data IDint100
233/BI0/IRSTT_SAPCPSID Structure of Hierarchies: InfoObject SAP Component3PREDMaster data IDint100
234/BI0/IRSTT_SVARISID Structure of Hierarchies: InfoObject Selection Variant3PREDMaster data IDint100
235/BI0/IRSTT_TIDSID Structure of Hierarchies: InfoObject Trace ID3PREDMaster data IDint100
236/BI0/IRSTT_TLAYSID Structure of Hierarchies: InfoObject Trace Layer3PREDMaster data IDint100
237/BI0/IRSTT_TOTYPSID Structure of Hierarchies: InfoObject Object Type (Transp3PREDMaster data IDint100
238/BI0/IRSTT_TRANRSID Structure of Hierarchies: InfoObject Transport Request3PREDMaster data IDint100
239/BI0/IRSTT_TRTGTSID Structure of Hierarchies: InfoObject Transport Target3PREDMaster data IDint100
240/BI0/IRSTT_USERSID Structure of Hierarchies: InfoObject Trace User3PREDMaster data IDint100
241/BI0/ITCAIFAREASID Structure of Hierarchies: InfoObject InfoArea Analys. Au3PREDMaster data IDint100
242/BI0/ITCTAPPLSID Structure of Hierarchies: InfoObject Appl. Component3PREDMaster data IDint100
243/BI0/ITCTBWOBJCTSID Structure of Hierarchies: InfoObject BI Object3PREDMaster data IDint100
244/BI0/ITCTIFAREASID Structure of Hierarchies: InfoObject InfoArea3PREDMaster data IDint100
245/BI0/ITCTMDXFCSID Structure of Hierarchies: InfoObject MDX Functions3PREDMaster data IDint100
246/BI0/ITCTPRCSCHNSID Structure of Hierarchies: InfoObject Process Chain ID3PREDMaster data IDint100
247/BI0/ITCTQUERIDSID Structure of Hierarchies: InfoObject Query (UID)3PREDMaster data IDint100
248/BI0/ITCTSOURSYSSID Structure of Hierarchies: InfoObject Source System3PREDMaster data IDint100
249/BI0/ITCTSTATEVTSID Structure of Hierarchies: InfoObject Statistics Event3PREDMaster data IDint100
250/BI0/ITCTSYSIDSID Structure of Hierarchies: InfoObject BW System3PREDMaster data IDint100
251/BI0/ITCTUSERNMSID Structure of Hierarchies: InfoObject User3PREDMaster data IDint100
252/BI0/ITCTUSRNMSID Structure of Hierarchies: InfoObject User ID3PREDMaster data IDint100
253RSRHINTAB_OLAP_SHierarchy interval for the OLAP processor3PREDMaster data IDint100
TOPAdvertising Management
254JJTDOBJINIS-M/AM: Booking Unit Object (Date-Specific Perspective)13PREDIS-M: Predecessor Content Component in Hierarchy Structurenvarchar80
255JJTOBJINIS-M/AM: Planned Production Unit - Content16PREDIS-M: Predecessor Content Component in Hierarchy Structurenvarchar80
256JJTZKIIS-M/AM: Content of Date Combination BU13PREDIS-M: Predecessor Content Component in Hierarchy Structurenvarchar80
TOPAgency Business Global Trade
257TWUF_TRCall-Up of a Transformation8PREDPredecessor Transformationnvarchar50
258TWUF_TR_CClient-Dependent: Call-Up of a Transformation10PREDPredecessor Transformationnvarchar50
TOPIntegrated Product and Process Engineering
259CPSRELAssignment: Status Type to Status Type (Predecessor)2PREDStatus: Predecessornvarchar80
TOPMetadata Repository
260RSDMINCTABModel table: SID structure of the hierarchies of a charact.3PREDMaster data IDint100
TOPOLAP Technology
261RSDDINCTEMPLTemporary table for the results of a hierarchy query2PREDMaster data IDint100
262RSRHINTAB_OLAP(obsolete) Hierarchy interval for the OLAP /XPRA -> 7.40 rel5PREDMaster data IDint100
TOPSets
263SETHANAHIER0101Hierarchy table for Cost Center Groups6PREDNode number in hierarchy tableint100
264SETHANAHIER0102Hierarchy table for Cost Element Groups6PREDNode number in hierarchy tableint100
265SETHANAHIER0103Hierarchy table for Order Groups6PREDNode number in hierarchy tableint100
266SETHANAHIER0106Hierarchy table for Profit Center Groups6PREDNode number in hierarchy tableint100
267SETHANAHIER0109Hierarchy table for Account Groups6PREDNode number in hierarchy tableint100
TOPWork Clearance Management
268WCAITWCM: Work Clearance Document (Item)7PREDPredecessornvarchar60
269WCAMEWCM: (Temporary) Log of Operational Lists (Items)8PREDPredecessornvarchar60
270WCAMIWCM: Log of Operational Lists (Items)8PREDPredecessornvarchar60