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
Training and Event Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0HRP10201522Infotype 1020 DB tableTraining and Event Management
SQL:  selectupdate insert create

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

SELECT MANDT, PLVAR, OTYPE, OBJID, SUBTY, ISTAT, BEGDA, ENDDA, VARYF, SEQNR, INFTY, OTJID, AEDTM, UNAME, REASN, HISTO, ITXNR, LANGU, BED01, BED02, BED03, BED04, LANGU001, BED01001, BED02001, BED03001, BED04001, LANGU002, BED01002, BED02002, BED03002, BED04002, LANGU003, BED01003, BED02003, BED03003, BED04003, LANGU004, BED01004, BED02004, BED03004, BED04004, LANGU005, BED01005, BED02005, BED03005, BED04005, LANGU006, BED01006, BED02006, BED03006, BED04006, LANGU007, BED01007, BED02007, BED03007, BED04007, LANGU008, BED01008, BED02008, BED03008, BED04008, LANGU009, BED01009, BED02009, BED03009, BED04009, LANGU010, BED01010, BED02010, BED03010, BED04010, LANGU011, BED01011, BED02011, BED03011, BED04011, LANGU012, BED01012, BED02012, BED03012, BED04012, LANGU013, BED01013, BED02013, BED03013, BED04013, LANGU014, BED01014, BED02014, BED03014, BED04014, LANGU015, BED01015, BED02015, BED03015, BED04015, LANGU016, BED01016, BED02016, BED03016, BED04016, LANGU017, BED01017, BED02017, BED03017, BED04017, LANGU018, BED01018, BED02018, BED03018, BED04018, LANGU019, BED01019, BED02019, BED03019, BED04019, LANGU020, BED01020, BED02020, BED03020, BED04020, LANGU021, BED01021, BED02021, BED03021, BED04021, LANGU022, BED01022, BED02022, BED03022, BED04022, LANGU023, BED01023, BED02023, BED03023, BED04023, LANGU024, BED01024, BED02024, BED03024, BED04024, LANGU025, BED01025, BED02025, BED03025, BED04025, LANGU026, BED01026, BED02026, BED03026, BED04026 FROM HRP1020
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2PLVARPlan Versionnvarchar20 Allow NULL? 
3OTYPEObject Typenvarchar20 Allow NULL? 
4OBJIDObject IDnvarchar80 Allow NULL? 
5SUBTYSubtypenvarchar40 Allow NULL? 
6ISTATPlanning Statuschar10 Allow NULL? 
7BEGDAStart Datenvarchar80 Allow NULL? 
8ENDDAEnd Datenvarchar80 Allow NULL? 
9VARYFVariation Field for File PLOGnvarchar100 Allow NULL? 
10SEQNRNumber of Infotype Record with Same Keynvarchar30 Allow NULL? 
11INFTYInfotypenvarchar40 Allow NULL? 
12OTJIDConcatenation of Object Type and Object IDnvarchar100 Allow NULL? 
13AEDTMChanged onnvarchar80 Allow NULL? 
14UNAMEUser Namenvarchar120 Allow NULL? 
15REASNReasonnvarchar20 Allow NULL? 
16HISTOHistorical Record Flagchar10 Allow NULL? 
17ITXNRText Module for Infotypenvarchar80 Allow NULL? 
18LANGULanguage Keychar10 Allow NULL? 
19BED01Demand in first quarterdecimal30
20BED02Demand in second quarterdecimal30
21BED03Demand in third quarterdecimal30
22BED04Demand in fourth quarterdecimal30
23LANGU001Language Keychar10 Allow NULL? 
24BED01001Demand in first quarterdecimal30
25BED02001Demand in second quarterdecimal30
26BED03001Demand in third quarterdecimal30
27BED04001Demand in fourth quarterdecimal30
28LANGU002Language Keychar10 Allow NULL? 
29BED01002Demand in first quarterdecimal30
30BED02002Demand in second quarterdecimal30
31BED03002Demand in third quarterdecimal30
32BED04002Demand in fourth quarterdecimal30
33LANGU003Language Keychar10 Allow NULL? 
34BED01003Demand in first quarterdecimal30
35BED02003Demand in second quarterdecimal30
36BED03003Demand in third quarterdecimal30
37BED04003Demand in fourth quarterdecimal30
38LANGU004Language Keychar10 Allow NULL? 
39BED01004Demand in first quarterdecimal30
40BED02004Demand in second quarterdecimal30
41BED03004Demand in third quarterdecimal30
42BED04004Demand in fourth quarterdecimal30
43LANGU005Language Keychar10 Allow NULL? 
44BED01005Demand in first quarterdecimal30
45BED02005Demand in second quarterdecimal30
46BED03005Demand in third quarterdecimal30
47BED04005Demand in fourth quarterdecimal30
48LANGU006Language Keychar10 Allow NULL? 
49BED01006Demand in first quarterdecimal30
50BED02006Demand in second quarterdecimal30
51BED03006Demand in third quarterdecimal30
52BED04006Demand in fourth quarterdecimal30
53LANGU007Language Keychar10 Allow NULL? 
54BED01007Demand in first quarterdecimal30
55BED02007Demand in second quarterdecimal30
56BED03007Demand in third quarterdecimal30
57BED04007Demand in fourth quarterdecimal30
58LANGU008Language Keychar10 Allow NULL? 
59BED01008Demand in first quarterdecimal30
60BED02008Demand in second quarterdecimal30
61BED03008Demand in third quarterdecimal30
62BED04008Demand in fourth quarterdecimal30
63LANGU009Language Keychar10 Allow NULL? 
64BED01009Demand in first quarterdecimal30
65BED02009Demand in second quarterdecimal30
66BED03009Demand in third quarterdecimal30
67BED04009Demand in fourth quarterdecimal30
68LANGU010Language Keychar10 Allow NULL? 
69BED01010Demand in first quarterdecimal30
70BED02010Demand in second quarterdecimal30
71BED03010Demand in third quarterdecimal30
72BED04010Demand in fourth quarterdecimal30
73LANGU011Language Keychar10 Allow NULL? 
74BED01011Demand in first quarterdecimal30
75BED02011Demand in second quarterdecimal30
76BED03011Demand in third quarterdecimal30
77BED04011Demand in fourth quarterdecimal30
78LANGU012Language Keychar10 Allow NULL? 
79BED01012Demand in first quarterdecimal30
80BED02012Demand in second quarterdecimal30
81BED03012Demand in third quarterdecimal30
82BED04012Demand in fourth quarterdecimal30
83LANGU013Language Keychar10 Allow NULL? 
84BED01013Demand in first quarterdecimal30
85BED02013Demand in second quarterdecimal30
86BED03013Demand in third quarterdecimal30
87BED04013Demand in fourth quarterdecimal30
88LANGU014Language Keychar10 Allow NULL? 
89BED01014Demand in first quarterdecimal30
90BED02014Demand in second quarterdecimal30
91BED03014Demand in third quarterdecimal30
92BED04014Demand in fourth quarterdecimal30
93LANGU015Language Keychar10 Allow NULL? 
94BED01015Demand in first quarterdecimal30
95BED02015Demand in second quarterdecimal30
96BED03015Demand in third quarterdecimal30
97BED04015Demand in fourth quarterdecimal30
98LANGU016Language Keychar10 Allow NULL? 
99BED01016Demand in first quarterdecimal30
100BED02016Demand in second quarterdecimal30
101BED03016Demand in third quarterdecimal30
102BED04016Demand in fourth quarterdecimal30
103LANGU017Language Keychar10 Allow NULL? 
104BED01017Demand in first quarterdecimal30
105BED02017Demand in second quarterdecimal30
106BED03017Demand in third quarterdecimal30
107BED04017Demand in fourth quarterdecimal30
108LANGU018Language Keychar10 Allow NULL? 
109BED01018Demand in first quarterdecimal30
110BED02018Demand in second quarterdecimal30
111BED03018Demand in third quarterdecimal30
112BED04018Demand in fourth quarterdecimal30
113LANGU019Language Keychar10 Allow NULL? 
114BED01019Demand in first quarterdecimal30
115BED02019Demand in second quarterdecimal30
116BED03019Demand in third quarterdecimal30
117BED04019Demand in fourth quarterdecimal30
118LANGU020Language Keychar10 Allow NULL? 
119BED01020Demand in first quarterdecimal30
120BED02020Demand in second quarterdecimal30
121BED03020Demand in third quarterdecimal30
122BED04020Demand in fourth quarterdecimal30
123LANGU021Language Keychar10 Allow NULL? 
124BED01021Demand in first quarterdecimal30
125BED02021Demand in second quarterdecimal30
126BED03021Demand in third quarterdecimal30
127BED04021Demand in fourth quarterdecimal30
128LANGU022Language Keychar10 Allow NULL? 
129BED01022Demand in first quarterdecimal30
130BED02022Demand in second quarterdecimal30
131BED03022Demand in third quarterdecimal30
132BED04022Demand in fourth quarterdecimal30
133LANGU023Language Keychar10 Allow NULL? 
134BED01023Demand in first quarterdecimal30
135BED02023Demand in second quarterdecimal30
136BED03023Demand in third quarterdecimal30
137BED04023Demand in fourth quarterdecimal30
138LANGU024Language Keychar10 Allow NULL? 
139BED01024Demand in first quarterdecimal30
140BED02024Demand in second quarterdecimal30
141BED03024Demand in third quarterdecimal30
142BED04024Demand in fourth quarterdecimal30
143LANGU025Language Keychar10 Allow NULL? 
144BED01025Demand in first quarterdecimal30
145BED02025Demand in second quarterdecimal30
146BED03025Demand in third quarterdecimal30
147BED04025Demand in fourth quarterdecimal30
148LANGU026Language Keychar10 Allow NULL? 
149BED01026Demand in first quarterdecimal30
150BED02026Demand in second quarterdecimal30
151BED03026Demand in third quarterdecimal30
152BED04026Demand in fourth quarterdecimal30
NamePrimaryUniqueTypeColumns
HRP1020~0YesYesCLUSTEREDSEQNR, VARYF, ENDDA, BEGDA, ISTAT, SUBTY, OBJID, OTYPE, PLVAR, MANDT
HRP1020~1NoNoNONCLUSTEREDMANDT, PLVAR, OTJID