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
Industry Specific :: SAP Utilities :: Energy Data Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EPROFVAL05_1_TMP1471Temporary Profile Values in 5-Minute Intervals: Part 1Energy Data Management
SQL:  selectupdate insert create

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

SELECT MANDT, PROFILE, VALUEDAY, VAL0000, VAL0005, VAL0010, VAL0015, VAL0020, VAL0025, VAL0030, VAL0035, VAL0040, VAL0045, VAL0050, VAL0055, VAL0100, VAL0105, VAL0110, VAL0115, VAL0120, VAL0125, VAL0130, VAL0135, VAL0140, VAL0145, VAL0150, VAL0155, VAL0200, VAL0205, VAL0210, VAL0215, VAL0220, VAL0225, VAL0230, VAL0235, VAL0240, VAL0245, VAL0250, VAL0255, VAL0300, VAL0305, VAL0310, VAL0315, VAL0320, VAL0325, VAL0330, VAL0335, VAL0340, VAL0345, VAL0350, VAL0355, VAL0400, VAL0405, VAL0410, VAL0415, VAL0420, VAL0425, VAL0430, VAL0435, VAL0440, VAL0445, VAL0450, VAL0455, VAL0500, VAL0505, VAL0510, VAL0515, VAL0520, VAL0525, VAL0530, VAL0535, VAL0540, VAL0545, VAL0550, VAL0555, VAL0600, VAL0605, VAL0610, VAL0615, VAL0620, VAL0625, VAL0630, VAL0635, VAL0640, VAL0645, VAL0650, VAL0655, VAL0700, VAL0705, VAL0710, VAL0715, VAL0720, VAL0725, VAL0730, VAL0735, VAL0740, VAL0745, VAL0750, VAL0755, VAL0800, VAL0805, VAL0810, VAL0815, VAL0820, VAL0825, VAL0830, VAL0835, VAL0840, VAL0845, VAL0850, VAL0855, VAL0900, VAL0905, VAL0910, VAL0915, VAL0920, VAL0925, VAL0930, VAL0935, VAL0940, VAL0945, VAL0950, VAL0955, VAL1000, VAL1005, VAL1010, VAL1015, VAL1020, VAL1025, VAL1030, VAL1035, VAL1040, VAL1045, VAL1050, VAL1055, VAL1100, VAL1105, VAL1110, VAL1115, VAL1120, VAL1125, VAL1130, VAL1135, VAL1140, VAL1145, VAL1150, VAL1155 FROM EPROFVAL05_1_TMP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PROFILENumber of EDM Profilenvarchar180NUMC(N'000000000000000000')NoEPROFHEADE_PROFILE Allow NULL? 
3VALUEDAYDay of profile valuesnvarchar80DATS(N'00000000')NoPROFVALDAY Allow NULL? 
4VAL0000Profile valuedecimal160DEC((0))YesPROFVALUE
5VAL0005Profile valuedecimal160DEC((0))YesPROFVALUE
6VAL0010Profile valuedecimal160DEC((0))YesPROFVALUE
7VAL0015Profile valuedecimal160DEC((0))YesPROFVALUE
8VAL0020Profile valuedecimal160DEC((0))YesPROFVALUE
9VAL0025Profile valuedecimal160DEC((0))YesPROFVALUE
10VAL0030Profile valuedecimal160DEC((0))YesPROFVALUE
11VAL0035Profile valuedecimal160DEC((0))YesPROFVALUE
12VAL0040Profile valuedecimal160DEC((0))YesPROFVALUE
13VAL0045Profile valuedecimal160DEC((0))YesPROFVALUE
14VAL0050Profile valuedecimal160DEC((0))YesPROFVALUE
15VAL0055Profile valuedecimal160DEC((0))YesPROFVALUE
16VAL0100Profile valuedecimal160DEC((0))YesPROFVALUE
17VAL0105Profile valuedecimal160DEC((0))YesPROFVALUE
18VAL0110Profile valuedecimal160DEC((0))YesPROFVALUE
19VAL0115Profile valuedecimal160DEC((0))YesPROFVALUE
20VAL0120Profile valuedecimal160DEC((0))YesPROFVALUE
21VAL0125Profile valuedecimal160DEC((0))YesPROFVALUE
22VAL0130Profile valuedecimal160DEC((0))YesPROFVALUE
23VAL0135Profile valuedecimal160DEC((0))YesPROFVALUE
24VAL0140Profile valuedecimal160DEC((0))YesPROFVALUE
25VAL0145Profile valuedecimal160DEC((0))YesPROFVALUE
26VAL0150Profile valuedecimal160DEC((0))YesPROFVALUE
27VAL0155Profile valuedecimal160DEC((0))YesPROFVALUE
28VAL0200Profile valuedecimal160DEC((0))YesPROFVALUE
29VAL0205Profile valuedecimal160DEC((0))YesPROFVALUE
30VAL0210Profile valuedecimal160DEC((0))YesPROFVALUE
31VAL0215Profile valuedecimal160DEC((0))YesPROFVALUE
32VAL0220Profile valuedecimal160DEC((0))YesPROFVALUE
33VAL0225Profile valuedecimal160DEC((0))YesPROFVALUE
34VAL0230Profile valuedecimal160DEC((0))YesPROFVALUE
35VAL0235Profile valuedecimal160DEC((0))YesPROFVALUE
36VAL0240Profile valuedecimal160DEC((0))YesPROFVALUE
37VAL0245Profile valuedecimal160DEC((0))YesPROFVALUE
38VAL0250Profile valuedecimal160DEC((0))YesPROFVALUE
39VAL0255Profile valuedecimal160DEC((0))YesPROFVALUE
40VAL0300Profile valuedecimal160DEC((0))YesPROFVALUE
41VAL0305Profile valuedecimal160DEC((0))YesPROFVALUE
42VAL0310Profile valuedecimal160DEC((0))YesPROFVALUE
43VAL0315Profile valuedecimal160DEC((0))YesPROFVALUE
44VAL0320Profile valuedecimal160DEC((0))YesPROFVALUE
45VAL0325Profile valuedecimal160DEC((0))YesPROFVALUE
46VAL0330Profile valuedecimal160DEC((0))YesPROFVALUE
47VAL0335Profile valuedecimal160DEC((0))YesPROFVALUE
48VAL0340Profile valuedecimal160DEC((0))YesPROFVALUE
49VAL0345Profile valuedecimal160DEC((0))YesPROFVALUE
50VAL0350Profile valuedecimal160DEC((0))YesPROFVALUE
51VAL0355Profile valuedecimal160DEC((0))YesPROFVALUE
52VAL0400Profile valuedecimal160DEC((0))YesPROFVALUE
53VAL0405Profile valuedecimal160DEC((0))YesPROFVALUE
54VAL0410Profile valuedecimal160DEC((0))YesPROFVALUE
55VAL0415Profile valuedecimal160DEC((0))YesPROFVALUE
56VAL0420Profile valuedecimal160DEC((0))YesPROFVALUE
57VAL0425Profile valuedecimal160DEC((0))YesPROFVALUE
58VAL0430Profile valuedecimal160DEC((0))YesPROFVALUE
59VAL0435Profile valuedecimal160DEC((0))YesPROFVALUE
60VAL0440Profile valuedecimal160DEC((0))YesPROFVALUE
61VAL0445Profile valuedecimal160DEC((0))YesPROFVALUE
62VAL0450Profile valuedecimal160DEC((0))YesPROFVALUE
63VAL0455Profile valuedecimal160DEC((0))YesPROFVALUE
64VAL0500Profile valuedecimal160DEC((0))YesPROFVALUE
65VAL0505Profile valuedecimal160DEC((0))YesPROFVALUE
66VAL0510Profile valuedecimal160DEC((0))YesPROFVALUE
67VAL0515Profile valuedecimal160DEC((0))YesPROFVALUE
68VAL0520Profile valuedecimal160DEC((0))YesPROFVALUE
69VAL0525Profile valuedecimal160DEC((0))YesPROFVALUE
70VAL0530Profile valuedecimal160DEC((0))YesPROFVALUE
71VAL0535Profile valuedecimal160DEC((0))YesPROFVALUE
72VAL0540Profile valuedecimal160DEC((0))YesPROFVALUE
73VAL0545Profile valuedecimal160DEC((0))YesPROFVALUE
74VAL0550Profile valuedecimal160DEC((0))YesPROFVALUE
75VAL0555Profile valuedecimal160DEC((0))YesPROFVALUE
76VAL0600Profile valuedecimal160DEC((0))YesPROFVALUE
77VAL0605Profile valuedecimal160DEC((0))YesPROFVALUE
78VAL0610Profile valuedecimal160DEC((0))YesPROFVALUE
79VAL0615Profile valuedecimal160DEC((0))YesPROFVALUE
80VAL0620Profile valuedecimal160DEC((0))YesPROFVALUE
81VAL0625Profile valuedecimal160DEC((0))YesPROFVALUE
82VAL0630Profile valuedecimal160DEC((0))YesPROFVALUE
83VAL0635Profile valuedecimal160DEC((0))YesPROFVALUE
84VAL0640Profile valuedecimal160DEC((0))YesPROFVALUE
85VAL0645Profile valuedecimal160DEC((0))YesPROFVALUE
86VAL0650Profile valuedecimal160DEC((0))YesPROFVALUE
87VAL0655Profile valuedecimal160DEC((0))YesPROFVALUE
88VAL0700Profile valuedecimal160DEC((0))YesPROFVALUE
89VAL0705Profile valuedecimal160DEC((0))YesPROFVALUE
90VAL0710Profile valuedecimal160DEC((0))YesPROFVALUE
91VAL0715Profile valuedecimal160DEC((0))YesPROFVALUE
92VAL0720Profile valuedecimal160DEC((0))YesPROFVALUE
93VAL0725Profile valuedecimal160DEC((0))YesPROFVALUE
94VAL0730Profile valuedecimal160DEC((0))YesPROFVALUE
95VAL0735Profile valuedecimal160DEC((0))YesPROFVALUE
96VAL0740Profile valuedecimal160DEC((0))YesPROFVALUE
97VAL0745Profile valuedecimal160DEC((0))YesPROFVALUE
98VAL0750Profile valuedecimal160DEC((0))YesPROFVALUE
99VAL0755Profile valuedecimal160DEC((0))YesPROFVALUE
100VAL0800Profile valuedecimal160DEC((0))YesPROFVALUE
101VAL0805Profile valuedecimal160DEC((0))YesPROFVALUE
102VAL0810Profile valuedecimal160DEC((0))YesPROFVALUE
103VAL0815Profile valuedecimal160DEC((0))YesPROFVALUE
104VAL0820Profile valuedecimal160DEC((0))YesPROFVALUE
105VAL0825Profile valuedecimal160DEC((0))YesPROFVALUE
106VAL0830Profile valuedecimal160DEC((0))YesPROFVALUE
107VAL0835Profile valuedecimal160DEC((0))YesPROFVALUE
108VAL0840Profile valuedecimal160DEC((0))YesPROFVALUE
109VAL0845Profile valuedecimal160DEC((0))YesPROFVALUE
110VAL0850Profile valuedecimal160DEC((0))YesPROFVALUE
111VAL0855Profile valuedecimal160DEC((0))YesPROFVALUE
112VAL0900Profile valuedecimal160DEC((0))YesPROFVALUE
113VAL0905Profile valuedecimal160DEC((0))YesPROFVALUE
114VAL0910Profile valuedecimal160DEC((0))YesPROFVALUE
115VAL0915Profile valuedecimal160DEC((0))YesPROFVALUE
116VAL0920Profile valuedecimal160DEC((0))YesPROFVALUE
117VAL0925Profile valuedecimal160DEC((0))YesPROFVALUE
118VAL0930Profile valuedecimal160DEC((0))YesPROFVALUE
119VAL0935Profile valuedecimal160DEC((0))YesPROFVALUE
120VAL0940Profile valuedecimal160DEC((0))YesPROFVALUE
121VAL0945Profile valuedecimal160DEC((0))YesPROFVALUE
122VAL0950Profile valuedecimal160DEC((0))YesPROFVALUE
123VAL0955Profile valuedecimal160DEC((0))YesPROFVALUE
124VAL1000Profile valuedecimal160DEC((0))YesPROFVALUE
125VAL1005Profile valuedecimal160DEC((0))YesPROFVALUE
126VAL1010Profile valuedecimal160DEC((0))YesPROFVALUE
127VAL1015Profile valuedecimal160DEC((0))YesPROFVALUE
128VAL1020Profile valuedecimal160DEC((0))YesPROFVALUE
129VAL1025Profile valuedecimal160DEC((0))YesPROFVALUE
130VAL1030Profile valuedecimal160DEC((0))YesPROFVALUE
131VAL1035Profile valuedecimal160DEC((0))YesPROFVALUE
132VAL1040Profile valuedecimal160DEC((0))YesPROFVALUE
133VAL1045Profile valuedecimal160DEC((0))YesPROFVALUE
134VAL1050Profile valuedecimal160DEC((0))YesPROFVALUE
135VAL1055Profile valuedecimal160DEC((0))YesPROFVALUE
136VAL1100Profile valuedecimal160DEC((0))YesPROFVALUE
137VAL1105Profile valuedecimal160DEC((0))YesPROFVALUE
138VAL1110Profile valuedecimal160DEC((0))YesPROFVALUE
139VAL1115Profile valuedecimal160DEC((0))YesPROFVALUE
140VAL1120Profile valuedecimal160DEC((0))YesPROFVALUE
141VAL1125Profile valuedecimal160DEC((0))YesPROFVALUE
142VAL1130Profile valuedecimal160DEC((0))YesPROFVALUE
143VAL1135Profile valuedecimal160DEC((0))YesPROFVALUE
144VAL1140Profile valuedecimal160DEC((0))YesPROFVALUE
145VAL1145Profile valuedecimal160DEC((0))YesPROFVALUE
146VAL1150Profile valuedecimal160DEC((0))YesPROFVALUE
147VAL1155Profile valuedecimal160DEC((0))YesPROFVALUE
NamePrimaryUniqueTypeColumns
EPROFVAL05_1_TMP~0YesYesCLUSTEREDVALUEDAY, PROFILE, MANDT