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
1ERP EHP76.0P2RN_FB2911Payroll Results: Flexible benefits
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, DCT_PERNR, DCT_SEQNR, DCT_ROWID, FBNSP, BEGDA, ENDDA, BAREA, KZMDL, STAT1, KZVAR, BRN01, TBB01, TAB01, BBB01, BAB01, BRN02, TBB02, TAB02, BBB02, BAB02, BRN03, TBB03, TAB03, BBB03, BAB03, BRN04, TBB04, TAB04, BBB04, BAB04, BRN05, TBB05, TAB05, BBB05, BAB05, BRN06, TBB06, TAB06, BBB06, BAB06, BRN07, TBB07, TAB07, BBB07, BAB07, BRN08, TBB08, TAB08, BBB08, BAB08, DL_01, KZD01, TBD01, TAD01, DL_02, KZD02, TBD02, TAD02, DL_03, KZD03, TBD03, TAD03, DL_04, KZD04, TBD04, TAD04, DL_05, KZD05, TBD05, TAD05, DL_06, KZD06, TBD06, TAD06, DL_07, KZD07, TBD07, TAD07, DL_08, KZD08, TBD08, TAD08, DL_09, KZD09, TBD09, TAD09, DL_10, KZD10, TBD10, TAD10, DL_11, KZD11, TBD11, TAD11, DL_12, KZD12, TBD12, TAD12, B1D01, A1D01, B1D02, A1D02, B1D03, A1D03, B1D04, A1D04, B1D05, A1D05, B1D06, A1D06, B1D07, A1D07, B1D08, A1D08, B1D09, A1D09, B1D10, A1D10, B1D11, A1D11, B1D12, A1D12, B2D01, A2D01, B2D02, A2D02, B2D03, A2D03, B2D04, A2D04, B2D05, A2D05, B2D06, A2D06, B2D07, A2D07, B2D08, A2D08, B2D09, A2D09, B2D10, A2D10, B2D11, A2D11, B2D12, A2D12, B3D01, A3D01, B3D02, A3D02, B3D03, A3D03, B3D04, A3D04, B3D05, A3D05, B3D06, A3D06, B3D07, A3D07, B3D08, A3D08, B3D09, A3D09, B3D10, A3D10, B3D11, A3D11, B3D12, A3D12, B4D01, A4D01, B4D02, A4D02, B4D03, A4D03, B4D04, A4D04, B4D05, A4D05, B4D06, A4D06, B4D07, A4D07, B4D08, A4D08, B4D09, A4D09, B4D10, A4D10, B4D11, A4D11, B4D12, A4D12, B5D01, A5D01, B5D02, A5D02, B5D03, A5D03, B5D04, A5D04, B5D05, A5D05, B5D06, A5D06, B5D07, A5D07, B5D08, A5D08, B5D09, A5D09, B5D10, A5D10, B5D11, A5D11, B5D12, A5D12, B6D01, A6D01, B6D02, A6D02, B6D03, A6D03, B6D04, A6D04, B6D05, A6D05, B6D06, A6D06, B6D07, A6D07, B6D08, A6D08, B6D09, A6D09, B6D10, A6D10, B6D11, A6D11, B6D12, A6D12, B7D01, A7D01, B7D02, A7D02, B7D03, A7D03, B7D04, A7D04, B7D05, A7D05, B7D06, A7D06, B7D07, A7D07, B7D08, A7D08, B7D09, A7D09, B7D10, A7D10, B7D11, A7D11, B7D12, A7D12, B8D01, A8D01, B8D02, A8D02, B8D03, A8D03, B8D04, A8D04, B8D05, A8D05, B8D06, A8D06, B8D07, A8D07, B8D08, A8D08, B8D09, A8D09, B8D10, A8D10, B8D11, A8D11, B8D12, A8D12 FROM P2RN_FB
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2DCT_PERNRPersonnel Numbernvarchar80 Allow NULL? 
3DCT_SEQNRSequence Numbernvarchar50 Allow NULL? 
4DCT_ROWIDUnique Row Numbernvarchar50 Allow NULL? 
5FBNSPTax splitvarbinary10
6BEGDAStart Datenvarchar80 Allow NULL? 
7ENDDAEnd Datenvarchar80 Allow NULL? 
8BAREABenefit areanvarchar20 Allow NULL? 
9KZMDLProgramnvarchar40 Allow NULL? 
10STAT1Status of Flexible Benefits Recordnvarchar20 Allow NULL? 
11KZVARProgram Variantnvarchar20 Allow NULL? 
12BRN01Sourcenvarchar40 Allow NULL? 
13TBB01Total Amount Sourcedecimal92
14TAB01Total Number Sourcedecimal52
15BBB01Source amount availabledecimal92
16BAB01Source number availabledecimal52
17BRN02Sourcenvarchar40 Allow NULL? 
18TBB02Total Amount Sourcedecimal92
19TAB02Total Number Sourcedecimal52
20BBB02Source amount availabledecimal92
21BAB02Source number availabledecimal52
22BRN03Sourcenvarchar40 Allow NULL? 
23TBB03Total Amount Sourcedecimal92
24TAB03Total Number Sourcedecimal52
25BBB03Source amount availabledecimal92
26BAB03Source number availabledecimal52
27BRN04Sourcenvarchar40 Allow NULL? 
28TBB04Total Amount Sourcedecimal92
29TAB04Total Number Sourcedecimal52
30BBB04Source amount availabledecimal92
31BAB04Source number availabledecimal52
32BRN05Sourcenvarchar40 Allow NULL? 
33TBB05Total Amount Sourcedecimal92
34TAB05Total Number Sourcedecimal52
35BBB05Source amount availabledecimal92
36BAB05Source number availabledecimal52
37BRN06Sourcenvarchar40 Allow NULL? 
38TBB06Total Amount Sourcedecimal92
39TAB06Total Number Sourcedecimal52
40BBB06Source amount availabledecimal92
41BAB06Source number availabledecimal52
42BRN07Sourcenvarchar40 Allow NULL? 
43TBB07Total Amount Sourcedecimal92
44TAB07Total Number Sourcedecimal52
45BBB07Source amount availabledecimal92
46BAB07Source number availabledecimal52
47BRN08Sourcenvarchar40 Allow NULL? 
48TBB08Total Amount Sourcedecimal92
49TAB08Total Number Sourcedecimal52
50BBB08Source amount availabledecimal92
51BAB08Source number availabledecimal52
52DL_01Notenvarchar40 Allow NULL? 
53KZD01Optionsnvarchar40 Allow NULL? 
54TBD01Total Amount Targetdecimal92
55TAD01Total Number Targetdecimal52
56DL_02Notenvarchar40 Allow NULL? 
57KZD02Optionsnvarchar40 Allow NULL? 
58TBD02Total Amount Targetdecimal92
59TAD02Total Number Targetdecimal52
60DL_03Notenvarchar40 Allow NULL? 
61KZD03Optionsnvarchar40 Allow NULL? 
62TBD03Total Amount Targetdecimal92
63TAD03Total Number Targetdecimal52
64DL_04Notenvarchar40 Allow NULL? 
65KZD04Optionsnvarchar40 Allow NULL? 
66TBD04Total Amount Targetdecimal92
67TAD04Total Number Targetdecimal52
68DL_05Notenvarchar40 Allow NULL? 
69KZD05Optionsnvarchar40 Allow NULL? 
70TBD05Total Amount Targetdecimal92
71TAD05Total Number Targetdecimal52
72DL_06Notenvarchar40 Allow NULL? 
73KZD06Optionsnvarchar40 Allow NULL? 
74TBD06Total Amount Targetdecimal92
75TAD06Total Number Targetdecimal52
76DL_07Notenvarchar40 Allow NULL? 
77KZD07Optionsnvarchar40 Allow NULL? 
78TBD07Total Amount Targetdecimal92
79TAD07Total Number Targetdecimal52
80DL_08Notenvarchar40 Allow NULL? 
81KZD08Optionsnvarchar40 Allow NULL? 
82TBD08Total Amount Targetdecimal92
83TAD08Total Number Targetdecimal52
84DL_09Notenvarchar40 Allow NULL? 
85KZD09Optionsnvarchar40 Allow NULL? 
86TBD09Total Amount Targetdecimal92
87TAD09Total Number Targetdecimal52
88DL_10Notenvarchar40 Allow NULL? 
89KZD10Optionsnvarchar40 Allow NULL? 
90TBD10Total Amount Targetdecimal92
91TAD10Total Number Targetdecimal52
92DL_11Notenvarchar40 Allow NULL? 
93KZD11Optionsnvarchar40 Allow NULL? 
94TBD11Total Amount Targetdecimal92
95TAD11Total Number Targetdecimal52
96DL_12Notenvarchar40 Allow NULL? 
97KZD12Optionsnvarchar40 Allow NULL? 
98TBD12Total Amount Targetdecimal92
99TAD12Total Number Targetdecimal52
100B1D01Source-Target Combination Program Amountdecimal92
101A1D01Source-Target Combination Program Numberdecimal52
102B1D02Source-Target Combination Program Amountdecimal92
103A1D02Source-Target Combination Program Numberdecimal52
104B1D03Source-Target Combination Program Amountdecimal92
105A1D03Source-Target Combination Program Numberdecimal52
106B1D04Source-Target Combination Program Amountdecimal92
107A1D04Source-Target Combination Program Numberdecimal52
108B1D05Source-Target Combination Program Amountdecimal92
109A1D05Source-Target Combination Program Numberdecimal52
110B1D06Source-Target Combination Program Amountdecimal92
111A1D06Source-Target Combination Program Numberdecimal52
112B1D07Source-Target Combination Program Amountdecimal92
113A1D07Source-Target Combination Program Numberdecimal52
114B1D08Source-Target Combination Program Amountdecimal92
115A1D08Source-Target Combination Program Numberdecimal52
116B1D09Source-Target Combination Program Amountdecimal92
117A1D09Source-Target Combination Program Numberdecimal52
118B1D10Source-Target Combination Program Amountdecimal92
119A1D10Source-Target Combination Program Numberdecimal52
120B1D11Source-Target Combination Program Amountdecimal92
121A1D11Source-Target Combination Program Numberdecimal52
122B1D12Source-Target Combination Program Amountdecimal92
123A1D12Source-Target Combination Program Numberdecimal52
124B2D01Source-Target Combination Program Amountdecimal92
125A2D01Source-Target Combination Program Numberdecimal52
126B2D02Source-Target Combination Program Amountdecimal92
127A2D02Source-Target Combination Program Numberdecimal52
128B2D03Source-Target Combination Program Amountdecimal92
129A2D03Source-Target Combination Program Numberdecimal52
130B2D04Source-Target Combination Program Amountdecimal92
131A2D04Source-Target Combination Program Numberdecimal52
132B2D05Source-Target Combination Program Amountdecimal92
133A2D05Source-Target Combination Program Numberdecimal52
134B2D06Source-Target Combination Program Amountdecimal92
135A2D06Source-Target Combination Program Numberdecimal52
136B2D07Source-Target Combination Program Amountdecimal92
137A2D07Source-Target Combination Program Numberdecimal52
138B2D08Source-Target Combination Program Amountdecimal92
139A2D08Source-Target Combination Program Numberdecimal52
140B2D09Source-Target Combination Program Amountdecimal92
141A2D09Source-Target Combination Program Numberdecimal52
142B2D10Source-Target Combination Program Amountdecimal92
143A2D10Source-Target Combination Program Numberdecimal52
144B2D11Source-Target Combination Program Amountdecimal92
145A2D11Source-Target Combination Program Numberdecimal52
146B2D12Source-Target Combination Program Amountdecimal92
147A2D12Source-Target Combination Program Numberdecimal52
148B3D01Source-Target Combination Program Amountdecimal92
149A3D01Source-Target Combination Program Numberdecimal52
150B3D02Source-Target Combination Program Amountdecimal92
151A3D02Source-Target Combination Program Numberdecimal52
152B3D03Source-Target Combination Program Amountdecimal92
153A3D03Source-Target Combination Program Numberdecimal52
154B3D04Source-Target Combination Program Amountdecimal92
155A3D04Source-Target Combination Program Numberdecimal52
156B3D05Source-Target Combination Program Amountdecimal92
157A3D05Source-Target Combination Program Numberdecimal52
158B3D06Source-Target Combination Program Amountdecimal92
159A3D06Source-Target Combination Program Numberdecimal52
160B3D07Source-Target Combination Program Amountdecimal92
161A3D07Source-Target Combination Program Numberdecimal52
162B3D08Source-Target Combination Program Amountdecimal92
163A3D08Source-Target Combination Program Numberdecimal52
164B3D09Source-Target Combination Program Amountdecimal92
165A3D09Source-Target Combination Program Numberdecimal52
166B3D10Source-Target Combination Program Amountdecimal92
167A3D10Source-Target Combination Program Numberdecimal52
168B3D11Source-Target Combination Program Amountdecimal92
169A3D11Source-Target Combination Program Numberdecimal52
170B3D12Source-Target Combination Program Amountdecimal92
171A3D12Source-Target Combination Program Numberdecimal52
172B4D01Source-Target Combination Program Amountdecimal92
173A4D01Source-Target Combination Program Numberdecimal52
174B4D02Source-Target Combination Program Amountdecimal92
175A4D02Source-Target Combination Program Numberdecimal52
176B4D03Source-Target Combination Program Amountdecimal92
177A4D03Source-Target Combination Program Numberdecimal52
178B4D04Source-Target Combination Program Amountdecimal92
179A4D04Source-Target Combination Program Numberdecimal52
180B4D05Source-Target Combination Program Amountdecimal92
181A4D05Source-Target Combination Program Numberdecimal52
182B4D06Source-Target Combination Program Amountdecimal92
183A4D06Source-Target Combination Program Numberdecimal52
184B4D07Source-Target Combination Program Amountdecimal92
185A4D07Source-Target Combination Program Numberdecimal52
186B4D08Source-Target Combination Program Amountdecimal92
187A4D08Source-Target Combination Program Numberdecimal52
188B4D09Source-Target Combination Program Amountdecimal92
189A4D09Source-Target Combination Program Numberdecimal52
190B4D10Source-Target Combination Program Amountdecimal92
191A4D10Source-Target Combination Program Numberdecimal52
192B4D11Source-Target Combination Program Amountdecimal92
193A4D11Source-Target Combination Program Numberdecimal52
194B4D12Source-Target Combination Program Amountdecimal92
195A4D12Source-Target Combination Program Numberdecimal52
196B5D01Source-Target Combination Program Amountdecimal92
197A5D01Source-Target Combination Program Numberdecimal52
198B5D02Source-Target Combination Program Amountdecimal92
199A5D02Source-Target Combination Program Numberdecimal52
200B5D03Source-Target Combination Program Amountdecimal92
201A5D03Source-Target Combination Program Numberdecimal52
202B5D04Source-Target Combination Program Amountdecimal92
203A5D04Source-Target Combination Program Numberdecimal52
204B5D05Source-Target Combination Program Amountdecimal92
205A5D05Source-Target Combination Program Numberdecimal52
206B5D06Source-Target Combination Program Amountdecimal92
207A5D06Source-Target Combination Program Numberdecimal52
208B5D07Source-Target Combination Program Amountdecimal92
209A5D07Source-Target Combination Program Numberdecimal52
210B5D08Source-Target Combination Program Amountdecimal92
211A5D08Source-Target Combination Program Numberdecimal52
212B5D09Source-Target Combination Program Amountdecimal92
213A5D09Source-Target Combination Program Numberdecimal52
214B5D10Source-Target Combination Program Amountdecimal92
215A5D10Source-Target Combination Program Numberdecimal52
216B5D11Source-Target Combination Program Amountdecimal92
217A5D11Source-Target Combination Program Numberdecimal52
218B5D12Source-Target Combination Program Amountdecimal92
219A5D12Source-Target Combination Program Numberdecimal52
220B6D01Source-Target Combination Program Amountdecimal92
221A6D01Source-Target Combination Program Numberdecimal52
222B6D02Source-Target Combination Program Amountdecimal92
223A6D02Source-Target Combination Program Numberdecimal52
224B6D03Source-Target Combination Program Amountdecimal92
225A6D03Source-Target Combination Program Numberdecimal52
226B6D04Source-Target Combination Program Amountdecimal92
227A6D04Source-Target Combination Program Numberdecimal52
228B6D05Source-Target Combination Program Amountdecimal92
229A6D05Source-Target Combination Program Numberdecimal52
230B6D06Source-Target Combination Program Amountdecimal92
231A6D06Source-Target Combination Program Numberdecimal52
232B6D07Source-Target Combination Program Amountdecimal92
233A6D07Source-Target Combination Program Numberdecimal52
234B6D08Source-Target Combination Program Amountdecimal92
235A6D08Source-Target Combination Program Numberdecimal52
236B6D09Source-Target Combination Program Amountdecimal92
237A6D09Source-Target Combination Program Numberdecimal52
238B6D10Source-Target Combination Program Amountdecimal92
239A6D10Source-Target Combination Program Numberdecimal52
240B6D11Source-Target Combination Program Amountdecimal92
241A6D11Source-Target Combination Program Numberdecimal52
242B6D12Source-Target Combination Program Amountdecimal92
243A6D12Source-Target Combination Program Numberdecimal52
244B7D01Source-Target Combination Program Amountdecimal92
245A7D01Source-Target Combination Program Numberdecimal52
246B7D02Source-Target Combination Program Amountdecimal92
247A7D02Source-Target Combination Program Numberdecimal52
248B7D03Source-Target Combination Program Amountdecimal92
249A7D03Source-Target Combination Program Numberdecimal52
250B7D04Source-Target Combination Program Amountdecimal92
251A7D04Source-Target Combination Program Numberdecimal52
252B7D05Source-Target Combination Program Amountdecimal92
253A7D05Source-Target Combination Program Numberdecimal52
254B7D06Source-Target Combination Program Amountdecimal92
255A7D06Source-Target Combination Program Numberdecimal52
256B7D07Source-Target Combination Program Amountdecimal92
257A7D07Source-Target Combination Program Numberdecimal52
258B7D08Source-Target Combination Program Amountdecimal92
259A7D08Source-Target Combination Program Numberdecimal52
260B7D09Source-Target Combination Program Amountdecimal92
261A7D09Source-Target Combination Program Numberdecimal52
262B7D10Source-Target Combination Program Amountdecimal92
263A7D10Source-Target Combination Program Numberdecimal52
264B7D11Source-Target Combination Program Amountdecimal92
265A7D11Source-Target Combination Program Numberdecimal52
266B7D12Source-Target Combination Program Amountdecimal92
267A7D12Source-Target Combination Program Numberdecimal52
268B8D01Source-Target Combination Program Amountdecimal92
269A8D01Source-Target Combination Program Numberdecimal52
270B8D02Source-Target Combination Program Amountdecimal92
271A8D02Source-Target Combination Program Numberdecimal52
272B8D03Source-Target Combination Program Amountdecimal92
273A8D03Source-Target Combination Program Numberdecimal52
274B8D04Source-Target Combination Program Amountdecimal92
275A8D04Source-Target Combination Program Numberdecimal52
276B8D05Source-Target Combination Program Amountdecimal92
277A8D05Source-Target Combination Program Numberdecimal52
278B8D06Source-Target Combination Program Amountdecimal92
279A8D06Source-Target Combination Program Numberdecimal52
280B8D07Source-Target Combination Program Amountdecimal92
281A8D07Source-Target Combination Program Numberdecimal52
282B8D08Source-Target Combination Program Amountdecimal92
283A8D08Source-Target Combination Program Numberdecimal52
284B8D09Source-Target Combination Program Amountdecimal92
285A8D09Source-Target Combination Program Numberdecimal52
286B8D10Source-Target Combination Program Amountdecimal92
287A8D10Source-Target Combination Program Numberdecimal52
288B8D11Source-Target Combination Program Amountdecimal92
289A8D11Source-Target Combination Program Numberdecimal52
290B8D12Source-Target Combination Program Amountdecimal92
291A8D12Source-Target Combination Program Numberdecimal52
NamePrimaryUniqueTypeColumns
P2RN_FB~0YesYesCLUSTEREDDCT_ROWID, DCT_SEQNR, DCT_PERNR, MANDT