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

248 columns | Print definition?ERP 6.0  | SEQ_NR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BI0/0200000001Temporary SID table3SEQ_NRint100
2/BI0/0200000002Temporary SID table3SEQ_NRint100
3/BI0/0200000003Temporary SID table3SEQ_NRint100
4/BI0/0200000004Temporary SID table3SEQ_NRint100
5/BI0/0200000005Temporary SID table3SEQ_NRint100
6/BI0/0200000006Temporary SID table3SEQ_NRint100
7/BI0/0200000007Temporary SID table3SEQ_NRint100
8/BI0/0200000008Temporary SID table3SEQ_NRint100
9/BI0/0200000009Temporary SID table3SEQ_NRint100
10/BI0/0200000010Temporary SID table3SEQ_NRint100
11/BI0/0200000011Temporary SID table3SEQ_NRint100
12/BI0/0200000012Temporary SID table3SEQ_NRint100
13/BI0/0200000013Temporary SID table3SEQ_NRint100
14/BI0/0200000014Temporary SID table3SEQ_NRint100
15/BI0/0200000015Temporary SID table3SEQ_NRint100
16/BI0/0200000016Temporary SID table3SEQ_NRint100
17/BI0/0200000017Temporary SID table3SEQ_NRint100
18/BI0/0200000018Temporary SID table3SEQ_NRint100
19/BI0/0200000019Temporary SID table3SEQ_NRint100
20/BI0/0200000020Temporary SID table3SEQ_NRint100
21/BI0/0200000021Temporary SID table3SEQ_NRint100
22/BI0/0200000022Temporary SID table3SEQ_NRint100
23/BI0/0200000023Temporary SID table3SEQ_NRint100
24/BI0/0200000024Temporary SID table3SEQ_NRint100
25/BI0/0200000025Temporary SID table3SEQ_NRint100
26/BI0/0200000026Temporary SID table3SEQ_NRint100
27/BI0/0200000027Temporary SID table3SEQ_NRint100
28/BI0/0200000028Temporary SID table3SEQ_NRint100
29/BI0/0200000029Temporary SID table3SEQ_NRint100
30/BI0/0200000030Temporary SID table3SEQ_NRint100
31/BI0/0200000031Temporary SID table3SEQ_NRint100
32/BI0/0200000032Temporary SID table3SEQ_NRint100
33/BI0/0200000033Temporary SID table3SEQ_NRint100
34/BI0/0200000034Temporary SID table3SEQ_NRint100
35/BI0/0200000035Temporary SID table3SEQ_NRint100
36/BI0/0200000036Temporary SID table3SEQ_NRint100
37/BI0/0200000037Temporary SID table3SEQ_NRint100
38/BI0/0200000038Temporary SID table3SEQ_NRint100
39/BI0/0200000039Temporary SID table3SEQ_NRint100
40/BI0/0200000040Temporary SID table3SEQ_NRint100
41/BI0/0200000041Temporary SID table3SEQ_NRint100
42/BI0/0200000042Temporary SID table3SEQ_NRint100
43/BI0/0200000043Temporary SID table3SEQ_NRint100
44/BI0/0200000044Temporary SID table3SEQ_NRint100
45/BI0/0200000045Temporary SID table3SEQ_NRint100
46/BI0/0200000046Temporary SID table3SEQ_NRint100
47/BI0/0200000047Temporary SID table3SEQ_NRint100
48/BI0/0200000048Temporary SID table3SEQ_NRint100
49/BI0/0200000049Temporary SID table3SEQ_NRint100
50/BI0/0200000050Temporary SID table3SEQ_NRint100
51/BI0/0200000051Temporary SID table3SEQ_NRint100
52/BI0/0200000052Temporary SID table3SEQ_NRint100
53/BI0/0200000053Temporary SID table3SEQ_NRint100
54/BI0/0200000054Temporary SID table3SEQ_NRint100
55/BI0/0200000055Temporary SID table3SEQ_NRint100
56/BI0/0200000056Temporary SID table3SEQ_NRint100
57/BI0/0200000057Temporary SID table3SEQ_NRint100
58/BI0/0200000058Temporary SID table3SEQ_NRint100
59/BI0/0200000059Temporary SID table3SEQ_NRint100
60/BI0/0200000060Temporary SID table3SEQ_NRint100
61/BI0/0200000061Temporary SID table3SEQ_NRint100
62/BI0/0200000062Temporary SID table3SEQ_NRint100
63/BI0/0200000063Temporary SID table3SEQ_NRint100
64/BI0/0200000064Temporary SID table3SEQ_NRint100
65/BI0/0200000065Temporary SID table3SEQ_NRint100
66/BI0/0200000066Temporary SID table3SEQ_NRint100
67/BI0/0200000067Temporary SID table3SEQ_NRint100
68/BI0/0200000068Temporary SID table3SEQ_NRint100
69/BI0/0200000069Temporary SID table3SEQ_NRint100
70/BI0/0200000070Temporary SID table3SEQ_NRint100
71/BI0/0200000071Temporary SID table3SEQ_NRint100
72/BI0/0200000072Temporary SID table3SEQ_NRint100
73/BI0/0200000073Temporary SID table3SEQ_NRint100
74/BI0/0200000074Temporary SID table3SEQ_NRint100
75/BI0/0200000075Temporary SID table3SEQ_NRint100
76/BI0/0200000076Temporary SID table3SEQ_NRint100
77/BI0/0200000077Temporary SID table3SEQ_NRint100
78/BI0/0200000078Temporary SID table3SEQ_NRint100
79/BI0/0200000079Temporary SID table3SEQ_NRint100
80/BI0/0200000080Temporary SID table3SEQ_NRint100
81/BI0/0200000081Temporary SID table3SEQ_NRint100
82/BI0/0200000082Temporary SID table3SEQ_NRint100
83/BI0/0200000083Temporary SID table3SEQ_NRint100
84/BI0/0200000084Temporary SID table3SEQ_NRint100
85/BI0/0200000085Temporary SID table3SEQ_NRint100
86/BI0/0200000086Temporary SID table3SEQ_NRint100
87/BI0/0200000087Temporary SID table3SEQ_NRint100
88/BI0/0200000088Temporary SID table3SEQ_NRint100
89/BI0/0200000089Temporary SID table3SEQ_NRint100
90/BI0/0200000090Temporary SID table3SEQ_NRint100
91/BI0/0200000091Temporary SID table3SEQ_NRint100
92/BI0/0200000092Temporary SID table3SEQ_NRint100
93/BI0/0200000093Temporary SID table3SEQ_NRint100
94/BI0/0200000094Temporary SID table3SEQ_NRint100
95/BI0/0200000095Temporary SID table3SEQ_NRint100
96/BI0/0200000096Temporary SID table3SEQ_NRint100
97/BI0/0200000097Temporary SID table3SEQ_NRint100
98/BI0/0200000098Temporäre SID-Tabelle3SEQ_NRint100
99/BI0/0200000099Temporäre SID-Tabelle3SEQ_NRint100
100/BI0/0200000100Temporary SID table3SEQ_NRint100
101/BI0/0200000101Temporary SID table3SEQ_NRint100
102/BI0/0200000102Temporary SID table3SEQ_NRint100
103/BI0/0200000103Temporary SID table3SEQ_NRint100
104/BI0/0200000104Temporary SID table3SEQ_NRint100
105/BI0/0200000105Temporary SID table3SEQ_NRint100
106/BI0/0200000106Temporary SID table3SEQ_NRint100
107/BI0/0200000107Temporary SID table3SEQ_NRint100
108/BI0/0200000108Temporary SID table3SEQ_NRint100
109/BI0/0200000109Temporary SID table3SEQ_NRint100
110/BI0/0200000110Temporary SID table3SEQ_NRint100
111/BI0/0200000111Temporary SID table3SEQ_NRint100
112/BI0/0200000112Temporary SID table3SEQ_NRint100
113/BI0/0200000113Temporary SID table3SEQ_NRint100
114/BI0/0200000114Temporary SID table3SEQ_NRint100
115/BI0/0200000115Temporary SID table3SEQ_NRint100
116/BI0/0200000116Temporary SID table3SEQ_NRint100
117/BI0/0200000117Temporary SID table3SEQ_NRint100
118/BI0/0200000118Temporary SID table3SEQ_NRint100
119/BI0/0200000119Temporary SID table3SEQ_NRint100
120/BI0/0200000120Temporary SID table3SEQ_NRint100
121/BI0/0200000121Temporary SID table3SEQ_NRint100
122/BI0/0200000122Temporary SID table3SEQ_NRint100
123/BI0/0200000123Temporary SID table3SEQ_NRint100
124/BI0/0200000124Temporary SID table3SEQ_NRint100
125/BI0/0200000125Temporary SID table3SEQ_NRint100
126/BI0/0200000126Temporary SID table3SEQ_NRint100
127/BI0/0200000127Temporary SID table3SEQ_NRint100
128/BI0/0200000128Temporary SID table3SEQ_NRint100
129/BI0/0200000129Temporary SID table3SEQ_NRint100
130/BI0/0200000130Temporary SID table3SEQ_NRint100
131/BI0/0200000131Temporary SID table3SEQ_NRint100
132/BI0/0200000132Temporary SID table3SEQ_NRint100
133/BI0/0200000133Temporary SID table3SEQ_NRint100
134/BI0/0200000134Temporary SID table3SEQ_NRint100
135/BI0/0200000135Temporary SID table3SEQ_NRint100
136/BI0/0200000136Temporary SID table3SEQ_NRint100
137/BI0/0200000137Temporary SID table3SEQ_NRint100
138/BI0/0200000138Temporary SID table3SEQ_NRint100
139/BI0/0200000139Temporary SID table3SEQ_NRint100
140/BI0/0200000140Temporary SID table3SEQ_NRint100
141/BI0/0200000141Temporary SID table3SEQ_NRint100
142/BI0/0200000142Temporary SID table3SEQ_NRint100
143/BI0/0200000143Temporary SID table3SEQ_NRint100
144/BI0/0200000144Temporary SID table3SEQ_NRint100
145/BI0/0200000145Temporary SID table3SEQ_NRint100
146/BI0/0200000146Temporary SID table3SEQ_NRint100
147/BI0/0200000147Temporary SID table3SEQ_NRint100
148/BI0/0200000148Temporary SID table3SEQ_NRint100
149/BI0/0200000149Temporary SID table3SEQ_NRint100
150/BI0/0200000150Temporary SID table3SEQ_NRint100
151/BI0/0200000151Temporary SID table3SEQ_NRint100
152/BI0/0200000152Temporary SID table3SEQ_NRint100
153/BI0/0200000153Temporary SID table3SEQ_NRint100
154/BI0/0200000154Temporary SID table3SEQ_NRint100
155/BI0/0200000155Temporary SID table3SEQ_NRint100
156/BI0/0200000156Temporary SID table3SEQ_NRint100
157/BI0/0200000157Temporary SID table3SEQ_NRint100
158/BI0/0200000158Temporary SID table3SEQ_NRint100
159/BI0/0200000159Temporary SID table3SEQ_NRint100
160/BI0/0200000160Temporary SID table3SEQ_NRint100
161/BI0/0200000161Temporary SID table3SEQ_NRint100
162/BI0/0200000162Temporary SID table3SEQ_NRint100
163/BI0/0200000163Temporary SID table3SEQ_NRint100
164/BI0/0200000164Temporary SID table3SEQ_NRint100
165/BI0/0200000165Temporary SID table3SEQ_NRint100
166/BI0/0200000166Temporary SID table3SEQ_NRint100
167/BI0/0200000167Temporary SID table3SEQ_NRint100
168/BI0/0200000168Temporary SID table3SEQ_NRint100
169/BI0/0200000169Temporary SID table3SEQ_NRint100
170/BI0/0200000170Temporary SID table3SEQ_NRint100
171/BI0/0200000171Temporary SID table3SEQ_NRint100
172/BI0/0200000172Temporary SID table3SEQ_NRint100
173/BI0/0200000173Temporary SID table3SEQ_NRint100
174/BI0/0200000174Temporary SID table3SEQ_NRint100
175/BI0/0200000175Temporary SID table3SEQ_NRint100
176/BI0/0200000176Temporary SID table3SEQ_NRint100
177/BI0/0200000177Temporary SID table3SEQ_NRint100
178/BI0/0200000178Temporary SID table3SEQ_NRint100
179/BI0/0200000179Temporary SID table3SEQ_NRint100
180/BI0/0200000180Temporary SID table3SEQ_NRint100
181/BI0/0200000181Temporary SID table3SEQ_NRint100
182/BI0/0200000182Temporary SID table3SEQ_NRint100
183/BI0/0200000183Temporary SID table3SEQ_NRint100
184/BI0/0200000184Temporary SID table3SEQ_NRint100
185/BI0/0200000185Temporary SID table3SEQ_NRint100
186/BI0/0200000186Temporary SID table3SEQ_NRint100
187/BI0/0200000187Temporary SID table3SEQ_NRint100
188/BI0/0200000188Temporary SID table3SEQ_NRint100
189/BI0/0200000189Temporary SID table3SEQ_NRint100
190/BI0/0200000190Temporary SID table3SEQ_NRint100
191/BI0/0200000191Temporary SID table3SEQ_NRint100
192/BI0/0200000192Temporary SID table3SEQ_NRint100
193/BI0/0200000193Temporary SID table3SEQ_NRint100
194/BI0/0200000194Temporary SID table3SEQ_NRint100
195/BI0/0200000195Temporary SID table3SEQ_NRint100
196/BI0/0200000196Temporary SID table3SEQ_NRint100
197/BI0/0200000197Temporary SID table3SEQ_NRint100
198/BI0/0200000198Temporary SID table3SEQ_NRint100
199/BI0/0200000199Temporary SID table3SEQ_NRint100
200/BI0/0200000200Temporary SID table3SEQ_NRint100
201/BI0/0200000201Temporary SID table3SEQ_NRint100
202/GSINS/NLG_INBGBA Interface: Incoming Message Lines4SEQ_NRGBA Interface: Message Sequence Numbernvarchar30
203/GSINS/NLG_OUTBGBA Interface: Outgoing Message Lines4SEQ_NRGBA Interface: Message Sequence Numbernvarchar30
204/OEE/C_HTNTRELHierrachy Template Parent Child Node Type Relationship3SEQ_NRSequence Nunmbernvarchar50
205DBA_LOG_DETAILDBA: Details for Audit/Trace Log for DBA Cockpit2SEQ_NRint100
206RSDB2A_STA_HIEDB2 Accelerator: hierarchy status table3SEQ_NRint100
207T7INLOAN_TRNSDTLoans Specific Data6SEQ_NRObject Identificationnvarchar20
TOPBRFplus - ABAP-Based Business Rules
208FDT_ACTN_1000FDT: Action - Message15SEQ_NRFDT: Sequence numbernvarchar100
209FDT_ACTN_1000AFDT: Action - Message15SEQ_NRFDT: Sequence numbernvarchar100
210FDT_ACTN_1000SFDT: Action - Message14SEQ_NRFDT: Sequence numbernvarchar100
211FDT_ACTN_1000TFDT: Action - Message14SEQ_NRFDT: Sequence numbernvarchar100
212FDT_ACTN_1001FDT: Action - Message4SEQ_NRFDT: Sequence numbernvarchar100
213FDT_ACTN_1001AFDT: Action - Message4SEQ_NRFDT: Sequence numbernvarchar100
214FDT_ACTN_1001SFDT: Action - Message3SEQ_NRFDT: Sequence numbernvarchar100
215FDT_ACTN_1001TFDT: Action - Message3SEQ_NRFDT: Sequence numbernvarchar100
216FDT_EXPR_1100FDT: Expression - Range OLD8SEQ_NRFDT: Sequence numbernvarchar100
217FDT_EXPR_1100AFDT: Expression - Range OLD8SEQ_NRFDT: Sequence numbernvarchar100
218FDT_EXPR_1100SFDT: Expression - Range OLD7SEQ_NRFDT: Sequence numbernvarchar100
219FDT_EXPR_1100TFDT: Expression - Range OLD7SEQ_NRFDT: Sequence numbernvarchar100
TOPClaims Management
220ICL_ACTN_4000BRFplus : Document Proposal (Customizing)15SEQ_NRFDT: Sequence numbernvarchar100
221ICL_ACTN_4000ABRFplus : Document Proposal (Application)15SEQ_NRFDT: Sequence numbernvarchar100
222ICL_ACTN_4000SBRFplus: Document Proposal (System)14SEQ_NRFDT: Sequence numbernvarchar100
223ICL_ACTN_4001BRFplus : Document Proposal (Customizing)4SEQ_NRFDT: Sequence numbernvarchar100
224ICL_ACTN_4001ABRFplus : Document Proposal (Application)4SEQ_NRFDT: Sequence numbernvarchar100
225ICL_ACTN_4001SBRFplus: Document Proposal (System)3SEQ_NRFDT: Sequence numbernvarchar100
TOPDatabase Interface, Database Platforms
226DB6AUDITDTDB6: Audit log for maintenance actions5SEQ_NRint100
TOPE-Recruiting
227T77RCF_ACTPROCProcesses3SEQ_NRSequence Number of a Processnvarchar30
228T77RCF_ACTTY2RPAssignment of Activities to Process Templates5SEQ_NRSequence Number of Activity in Process Templatenvarchar30
229T77RCF_ACT_PROCOBSOLETE!!3SEQ_NRSequence Number of a Processnvarchar30
230T77RCF_CS_SEQAssignment of Elements to a Container Sequence (Standard)2SEQ_NRSequence Number in Container Sequencenvarchar40
231T77RCF_CS_SEQCAssignments of Elements to Container Sequence3SEQ_NRSequence Number in Container Sequencenvarchar40
232T77RCF_PROC2SUBAssignment of Processes to Subarea of E-Recruiting5SEQ_NRSequence Number of a Processnvarchar30
233T77RCF_RM_SEQAssignment of Roadmap Step to Roadmap Scenario2SEQ_NRSequence Number in Roadmap Scenarionvarchar40
234T77RCF_RM_SEQCAssignment of Roadmap Step to Roadmap Scenario3SEQ_NRSequence Number in Roadmap Scenarionvarchar40
235T77RCF_SP_ASGRPAssignment of Links to Groups on Start Pages2SEQ_NRSequence Numbernvarchar40
236T77RCF_SP_ASGRPCAssignment of Links to Start Page Groups3SEQ_NRSequence Numbernvarchar40
237T77RCF_SP_ASIDAssignment of Groups to Start Pages2SEQ_NRSequence Numbernvarchar40
238T77RCF_SP_ASIDCAssignment of Groups to Start Pages3SEQ_NRSequence Numbernvarchar40
239T77RCF_UI_LINKSLinks on Home Page3SEQ_NRSequence Number of Interface Linksnvarchar30
240T77RCF_UI_LINK_TText Table Links to Home Page3SEQ_NRSequence Number of Interface Linksnvarchar30
241T77RCF_WD1ST_SPAssignment of Elements of First Level to Start Page2SEQ_NRRelative Position of Object in Level on Start Pagenvarchar40
242T77RCF_WD1ST_SPCAssignment of Elements of First Level to Start Page4SEQ_NRRelative Position of Object in Level on Start Pagenvarchar40
243T77RCF_WD2ND1STAssignment of Element of 2nd Level to Element of First Level2SEQ_NRRelative Position of Object in Level on Start Pagenvarchar40
244T77RCF_WD2ND1STCAssignment of Element of 2nd Level to Element of First Level4SEQ_NRRelative Position of Object in Level on Start Pagenvarchar40
TOPOLAP Technology
245RSDRHSEQNRTable for Calculating Unique Sequence Numbers2SEQ_NRint100
TOPPeriodical Sales and Distribution
246JVTMCP_PROTIS-M: TMCP Logs5SEQ_NRSequence Number for Market Coverage Executionnvarchar30
TOPRemote Logistics Management
247OIO_SH_VOYAGE_DTVoyage date and time3SEQ_NRSequence Numbernvarchar30
TOPTransportation and Distribution
248OIGSHTD Shipment History4SEQ_NRDummy for B20 int1 (Local Everywhere)tinyint30