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

Home | ERP 6.0  | HRP1020
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PLVARPlan Versionnvarchar20CHAR(N' ')NoT778PPLVAR Allow NULL? 
3OTYPEObject Typenvarchar20CHAR(N' ')NoT778OOTYPE Allow NULL? 
4OBJIDObject IDnvarchar80NUMC(N'00000000')NoPLOGIHROBJID Allow NULL? 
5SUBTYSubtypenvarchar40CHAR(N' ')No*SUBTYP Allow NULL? 
6ISTATPlanning Statuschar10CHAR(N' ')NoT778SISTAT_D Allow NULL? 
7BEGDAStart Datenvarchar80DATS(N'00000000')NoBEGDATUM Allow NULL? 
8ENDDAEnd Datenvarchar80DATS(N'00000000')NoENDDATUM Allow NULL? 
9VARYFVariation Field for File PLOGnvarchar100CHAR(N' ')NoVARYF Allow NULL? 
10SEQNRNumber of Infotype Record with Same Keynvarchar30NUMC(N'000')NoSEQNR Allow NULL? 
11INFTYInfotypenvarchar40CHAR(N' ')NoT778TINFOTYP Allow NULL? 
12OTJIDConcatenation of Object Type and Object IDnvarchar100CHAR(N' ')NoOTJID Allow NULL? 
13AEDTMChanged onnvarchar80DATS(N'00000000')NoAEDTM Allow NULL? 
14UNAMEUser Namenvarchar120CHAR(N' ')NoUSRNAME Allow NULL? 
15REASNReasonnvarchar20CHAR(N' ')NoREASN Allow NULL? 
16HISTOHistorical Record Flagchar10CHAR(N' ')NoHISTO Allow NULL? 
17ITXNRText Module for Infotypenvarchar80NUMC(N'00000000')NoITXNR Allow NULL? 
18LANGULanguage Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
19BED01Demand in first quarterdecimal30DEC((0))NoBED01
20BED02Demand in second quarterdecimal30DEC((0))NoBED02
21BED03Demand in third quarterdecimal30DEC((0))NoBED03
22BED04Demand in fourth quarterdecimal30DEC((0))NoBED04
23LANGU001Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
24BED01001Demand in first quarterdecimal30DEC((0))NoBED01
25BED02001Demand in second quarterdecimal30DEC((0))NoBED02
26BED03001Demand in third quarterdecimal30DEC((0))NoBED03
27BED04001Demand in fourth quarterdecimal30DEC((0))NoBED04
28LANGU002Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
29BED01002Demand in first quarterdecimal30DEC((0))NoBED01
30BED02002Demand in second quarterdecimal30DEC((0))NoBED02
31BED03002Demand in third quarterdecimal30DEC((0))NoBED03
32BED04002Demand in fourth quarterdecimal30DEC((0))NoBED04
33LANGU003Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
34BED01003Demand in first quarterdecimal30DEC((0))NoBED01
35BED02003Demand in second quarterdecimal30DEC((0))NoBED02
36BED03003Demand in third quarterdecimal30DEC((0))NoBED03
37BED04003Demand in fourth quarterdecimal30DEC((0))NoBED04
38LANGU004Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
39BED01004Demand in first quarterdecimal30DEC((0))NoBED01
40BED02004Demand in second quarterdecimal30DEC((0))NoBED02
41BED03004Demand in third quarterdecimal30DEC((0))NoBED03
42BED04004Demand in fourth quarterdecimal30DEC((0))NoBED04
43LANGU005Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
44BED01005Demand in first quarterdecimal30DEC((0))NoBED01
45BED02005Demand in second quarterdecimal30DEC((0))NoBED02
46BED03005Demand in third quarterdecimal30DEC((0))NoBED03
47BED04005Demand in fourth quarterdecimal30DEC((0))NoBED04
48LANGU006Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
49BED01006Demand in first quarterdecimal30DEC((0))NoBED01
50BED02006Demand in second quarterdecimal30DEC((0))NoBED02
51BED03006Demand in third quarterdecimal30DEC((0))NoBED03
52BED04006Demand in fourth quarterdecimal30DEC((0))NoBED04
53LANGU007Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
54BED01007Demand in first quarterdecimal30DEC((0))NoBED01
55BED02007Demand in second quarterdecimal30DEC((0))NoBED02
56BED03007Demand in third quarterdecimal30DEC((0))NoBED03
57BED04007Demand in fourth quarterdecimal30DEC((0))NoBED04
58LANGU008Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
59BED01008Demand in first quarterdecimal30DEC((0))NoBED01
60BED02008Demand in second quarterdecimal30DEC((0))NoBED02
61BED03008Demand in third quarterdecimal30DEC((0))NoBED03
62BED04008Demand in fourth quarterdecimal30DEC((0))NoBED04
63LANGU009Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
64BED01009Demand in first quarterdecimal30DEC((0))NoBED01
65BED02009Demand in second quarterdecimal30DEC((0))NoBED02
66BED03009Demand in third quarterdecimal30DEC((0))NoBED03
67BED04009Demand in fourth quarterdecimal30DEC((0))NoBED04
68LANGU010Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
69BED01010Demand in first quarterdecimal30DEC((0))NoBED01
70BED02010Demand in second quarterdecimal30DEC((0))NoBED02
71BED03010Demand in third quarterdecimal30DEC((0))NoBED03
72BED04010Demand in fourth quarterdecimal30DEC((0))NoBED04
73LANGU011Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
74BED01011Demand in first quarterdecimal30DEC((0))NoBED01
75BED02011Demand in second quarterdecimal30DEC((0))NoBED02
76BED03011Demand in third quarterdecimal30DEC((0))NoBED03
77BED04011Demand in fourth quarterdecimal30DEC((0))NoBED04
78LANGU012Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
79BED01012Demand in first quarterdecimal30DEC((0))NoBED01
80BED02012Demand in second quarterdecimal30DEC((0))NoBED02
81BED03012Demand in third quarterdecimal30DEC((0))NoBED03
82BED04012Demand in fourth quarterdecimal30DEC((0))NoBED04
83LANGU013Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
84BED01013Demand in first quarterdecimal30DEC((0))NoBED01
85BED02013Demand in second quarterdecimal30DEC((0))NoBED02
86BED03013Demand in third quarterdecimal30DEC((0))NoBED03
87BED04013Demand in fourth quarterdecimal30DEC((0))NoBED04
88LANGU014Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
89BED01014Demand in first quarterdecimal30DEC((0))NoBED01
90BED02014Demand in second quarterdecimal30DEC((0))NoBED02
91BED03014Demand in third quarterdecimal30DEC((0))NoBED03
92BED04014Demand in fourth quarterdecimal30DEC((0))NoBED04
93LANGU015Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
94BED01015Demand in first quarterdecimal30DEC((0))NoBED01
95BED02015Demand in second quarterdecimal30DEC((0))NoBED02
96BED03015Demand in third quarterdecimal30DEC((0))NoBED03
97BED04015Demand in fourth quarterdecimal30DEC((0))NoBED04
98LANGU016Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
99BED01016Demand in first quarterdecimal30DEC((0))NoBED01
100BED02016Demand in second quarterdecimal30DEC((0))NoBED02
101BED03016Demand in third quarterdecimal30DEC((0))NoBED03
102BED04016Demand in fourth quarterdecimal30DEC((0))NoBED04
103LANGU017Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
104BED01017Demand in first quarterdecimal30DEC((0))NoBED01
105BED02017Demand in second quarterdecimal30DEC((0))NoBED02
106BED03017Demand in third quarterdecimal30DEC((0))NoBED03
107BED04017Demand in fourth quarterdecimal30DEC((0))NoBED04
108LANGU018Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
109BED01018Demand in first quarterdecimal30DEC((0))NoBED01
110BED02018Demand in second quarterdecimal30DEC((0))NoBED02
111BED03018Demand in third quarterdecimal30DEC((0))NoBED03
112BED04018Demand in fourth quarterdecimal30DEC((0))NoBED04
113LANGU019Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
114BED01019Demand in first quarterdecimal30DEC((0))NoBED01
115BED02019Demand in second quarterdecimal30DEC((0))NoBED02
116BED03019Demand in third quarterdecimal30DEC((0))NoBED03
117BED04019Demand in fourth quarterdecimal30DEC((0))NoBED04
118LANGU020Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
119BED01020Demand in first quarterdecimal30DEC((0))NoBED01
120BED02020Demand in second quarterdecimal30DEC((0))NoBED02
121BED03020Demand in third quarterdecimal30DEC((0))NoBED03
122BED04020Demand in fourth quarterdecimal30DEC((0))NoBED04
123LANGU021Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
124BED01021Demand in first quarterdecimal30DEC((0))NoBED01
125BED02021Demand in second quarterdecimal30DEC((0))NoBED02
126BED03021Demand in third quarterdecimal30DEC((0))NoBED03
127BED04021Demand in fourth quarterdecimal30DEC((0))NoBED04
128LANGU022Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
129BED01022Demand in first quarterdecimal30DEC((0))NoBED01
130BED02022Demand in second quarterdecimal30DEC((0))NoBED02
131BED03022Demand in third quarterdecimal30DEC((0))NoBED03
132BED04022Demand in fourth quarterdecimal30DEC((0))NoBED04
133LANGU023Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
134BED01023Demand in first quarterdecimal30DEC((0))NoBED01
135BED02023Demand in second quarterdecimal30DEC((0))NoBED02
136BED03023Demand in third quarterdecimal30DEC((0))NoBED03
137BED04023Demand in fourth quarterdecimal30DEC((0))NoBED04
138LANGU024Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
139BED01024Demand in first quarterdecimal30DEC((0))NoBED01
140BED02024Demand in second quarterdecimal30DEC((0))NoBED02
141BED03024Demand in third quarterdecimal30DEC((0))NoBED03
142BED04024Demand in fourth quarterdecimal30DEC((0))NoBED04
143LANGU025Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
144BED01025Demand in first quarterdecimal30DEC((0))NoBED01
145BED02025Demand in second quarterdecimal30DEC((0))NoBED02
146BED03025Demand in third quarterdecimal30DEC((0))NoBED03
147BED04025Demand in fourth quarterdecimal30DEC((0))NoBED04
148LANGU026Language Keychar10LANG(N' ')NoT002LANGU Allow NULL? 
149BED01026Demand in first quarterdecimal30DEC((0))NoBED01
150BED02026Demand in second quarterdecimal30DEC((0))NoBED02
151BED03026Demand in third quarterdecimal30DEC((0))NoBED03
152BED04026Demand in fourth quarterdecimal30DEC((0))NoBED04
NamePrimaryUniqueTypeColumns
HRP1020~0YesYesCLUSTEREDSEQNR, VARYF, ENDDA, BEGDA, ISTAT, SUBTY, OBJID, OTYPE, PLVAR, MANDT
HRP1020~1NoNoNONCLUSTEREDMANDT, PLVAR, OTJID

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy