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

263 columns | Print definition?ERP 6.0  | SUCC

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