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
Payroll :: Australia :: Public Sector
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA05082461HR-AU-PS: Master Data For Prior ServicePublic Sector
SQL:  selectupdate insert create

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

SELECT MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR, AEDTM, UNAME, HISTO, ITXEX, REFEX, ORDEX, ITBLD, PREAS, FLAG1, FLAG2, FLAG3, FLAG4, RESE1, RESE2, GRPVL, AGENT, DEPTS, FPFLG, HRPWK, PERCT, CTLSL, CTSKL, CTTER, CTAFP, ACCDT, ELGDT, BLVE1, BOBL1, BFLG1, BLVE2, BOBL2, BFLG2, BLVE3, BOBL3, BFLG3, BLVE4, BOBL4, BFLG4, LVE01, BEG01, END01, MTH01, DAY01, PFT01, PAY01, CAS01, LVE02, BEG02, END02, MTH02, DAY02, PFT02, PAY02, CAS02, LVE03, BEG03, END03, MTH03, DAY03, PFT03, PAY03, CAS03, LVE04, BEG04, END04, MTH04, DAY04, PFT04, PAY04, CAS04, LVE05, BEG05, END05, MTH05, DAY05, PFT05, PAY05, CAS05, LVE06, BEG06, END06, MTH06, DAY06, PFT06, PAY06, CAS06, LVE07, BEG07, END07, MTH07, DAY07, PFT07, PAY07, CAS07, LVE08, BEG08, END08, MTH08, DAY08, PFT08, PAY08, CAS08, LVE09, BEG09, END09, MTH09, DAY09, PFT09, PAY09, CAS09, LVE10, BEG10, END10, MTH10, DAY10, PFT10, PAY10, CAS10, LVE11, BEG11, END11, MTH11, DAY11, PFT11, PAY11, CAS11, LVE12, BEG12, END12, MTH12, DAY12, PFT12, PAY12, CAS12, LVE13, BEG13, END13, MTH13, DAY13, PFT13, PAY13, CAS13, LVE14, BEG14, END14, MTH14, DAY14, PFT14, PAY14, CAS14, LVE15, BEG15, END15, MTH15, DAY15, PFT15, PAY15, CAS15, LVE16, BEG16, END16, MTH16, DAY16, PFT16, PAY16, CAS16, LVE17, BEG17, END17, MTH17, DAY17, PFT17, PAY17, CAS17, LVE18, BEG18, END18, MTH18, DAY18, PFT18, PAY18, CAS18, LVE19, BEG19, END19, MTH19, DAY19, PFT19, PAY19, CAS19, LVE20, BEG20, END20, MTH20, DAY20, PFT20, PAY20, CAS20, LVE21, BEG21, END21, MTH21, DAY21, PFT21, PAY21, CAS21, LVE22, BEG22, END22, MTH22, DAY22, PFT22, PAY22, CAS22, LVE23, BEG23, END23, MTH23, DAY23, PFT23, PAY23, CAS23, LVE24, BEG24, END24, MTH24, DAY24, PFT24, PAY24, CAS24, LVE25, BEG25, END25, MTH25, DAY25, PFT25, PAY25, CAS25 FROM PA0508
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2PERNRPersonnel numbernvarchar80 Allow NULL? 
3SUBTYSubtypenvarchar40 Allow NULL? 
4OBJPSObject Identificationnvarchar20 Allow NULL? 
5SPRPSLock Indicator for HR Master Data Recordchar10 Allow NULL? 
6ENDDAEnd Datenvarchar80 Allow NULL? 
7BEGDAStart Datenvarchar80 Allow NULL? 
8SEQNRNumber of Infotype Record with Same Keynvarchar30 Allow NULL? 
9AEDTMChanged Onnvarchar80 Allow NULL? 
10UNAMEName of Person Who Changed Objectnvarchar120 Allow NULL? 
11HISTOHistorical Record Flagchar10 Allow NULL? 
12ITXEXText Exists for Infotypechar10 Allow NULL? 
13REFEXReference Fields Exist (Primary/Secondary Costs)char10 Allow NULL? 
14ORDEXConfirmation Fields Existchar10 Allow NULL? 
15ITBLDInfotype Screen Controlnvarchar20 Allow NULL? 
16PREASReason for Changing Master Datanvarchar20 Allow NULL? 
17FLAG1Reserved Field/Unused Fieldchar10 Allow NULL? 
18FLAG2Reserved Field/Unused Fieldchar10 Allow NULL? 
19FLAG3Reserved Field/Unused Fieldchar10 Allow NULL? 
20FLAG4Reserved Field/Unused Fieldchar10 Allow NULL? 
21RESE1Reserved Field/Unused Field of Length 2nvarchar20 Allow NULL? 
22RESE2Reserved Field/Unused Field of Length 2nvarchar20 Allow NULL? 
23GRPVLGrouping Value for Personnel Assignmentsnvarchar40 Allow NULL? 
24AGENTName of agent for the last servicenvarchar300 Allow NULL? 
25DEPTSDepartmentnvarchar200 Allow NULL? 
26FPFLGFull or part time flagchar10 Allow NULL? 
27HRPWKHours work per weekdecimal52
28PERCTEmployment percentagedecimal52
29CTLSLCount for LSLchar10 Allow NULL? 
30CTSKLCount for Sick Leavechar10 Allow NULL? 
31CTTERCount for terminationchar10 Allow NULL? 
32CTAFPCustomer Specificchar10 Allow NULL? 
33ACCDTAccrual anniversary datenvarchar80 Allow NULL? 
34ELGDTEligibility Datenvarchar80 Allow NULL? 
35BLVE1Leave type for Prior Servicenvarchar40 Allow NULL? 
36BOBL1Leave taken in prior service in monthsdecimal80
37BFLG1Opening balance flag ( Full / Part Time balance )char10 Allow NULL? 
38BLVE2Leave type for Prior Servicenvarchar40 Allow NULL? 
39BOBL2Leave taken in prior service in monthsdecimal80
40BFLG2Opening balance flag ( Full / Part Time balance )char10 Allow NULL? 
41BLVE3Leave type for Prior Servicenvarchar40 Allow NULL? 
42BOBL3Leave taken in prior service in monthsdecimal80
43BFLG3Opening balance flag ( Full / Part Time balance )char10 Allow NULL? 
44BLVE4Leave type for Prior Servicenvarchar40 Allow NULL? 
45BOBL4Leave taken in prior service in monthsdecimal80
46BFLG4Opening balance flag ( Full / Part Time balance )char10 Allow NULL? 
47LVE01Leave type for Prior Servicenvarchar40 Allow NULL? 
48BEG01Begin Day of leave takennvarchar80 Allow NULL? 
49END01End date of leave takennvarchar80 Allow NULL? 
50MTH01Leave taken in prior service in monthsdecimal80
51DAY01Leave taken in prior service in daysdecimal52
52PFT01Leave taken in Part or Full time counterchar10 Allow NULL? 
53PAY01FULL OR HALF PAY COUNTERchar10 Allow NULL? 
54CAS01Not to count as servicechar10 Allow NULL? 
55LVE02Leave type for Prior Servicenvarchar40 Allow NULL? 
56BEG02Start Datenvarchar80 Allow NULL? 
57END02End Datenvarchar80 Allow NULL? 
58MTH02Leave taken in prior service in monthsdecimal80
59DAY02Leave taken in prior service in daysdecimal52
60PFT02Leave taken in Part or Full time counterchar10 Allow NULL? 
61PAY02FULL OR HALF PAY COUNTERchar10 Allow NULL? 
62CAS02Not to count as servicechar10 Allow NULL? 
63LVE03Leave type for Prior Servicenvarchar40 Allow NULL? 
64BEG03Start Datenvarchar80 Allow NULL? 
65END03End Datenvarchar80 Allow NULL? 
66MTH03Leave taken in prior service in monthsdecimal80
67DAY03Leave taken in prior service in daysdecimal52
68PFT03Leave taken in Part or Full time counterchar10 Allow NULL? 
69PAY03FULL OR HALF PAY COUNTERchar10 Allow NULL? 
70CAS03Not to count as servicechar10 Allow NULL? 
71LVE04Leave type for Prior Servicenvarchar40 Allow NULL? 
72BEG04Start Datenvarchar80 Allow NULL? 
73END04End Datenvarchar80 Allow NULL? 
74MTH04Leave taken in prior service in monthsdecimal80
75DAY04Leave taken in prior service in daysdecimal52
76PFT04Leave taken in Part or Full time counterchar10 Allow NULL? 
77PAY04FULL OR HALF PAY COUNTERchar10 Allow NULL? 
78CAS04Not to count as servicechar10 Allow NULL? 
79LVE05Leave type for Prior Servicenvarchar40 Allow NULL? 
80BEG05Start Datenvarchar80 Allow NULL? 
81END05End Datenvarchar80 Allow NULL? 
82MTH05Leave taken in prior service in monthsdecimal80
83DAY05Leave taken in prior service in daysdecimal52
84PFT05Leave taken in Part or Full time counterchar10 Allow NULL? 
85PAY05FULL OR HALF PAY COUNTERchar10 Allow NULL? 
86CAS05Not to count as servicechar10 Allow NULL? 
87LVE06Leave type for Prior Servicenvarchar40 Allow NULL? 
88BEG06Start Datenvarchar80 Allow NULL? 
89END06End Datenvarchar80 Allow NULL? 
90MTH06Leave taken in prior service in monthsdecimal80
91DAY06Leave taken in prior service in daysdecimal52
92PFT06Leave taken in Part or Full time counterchar10 Allow NULL? 
93PAY06FULL OR HALF PAY COUNTERchar10 Allow NULL? 
94CAS06Not to count as servicechar10 Allow NULL? 
95LVE07Leave type for Prior Servicenvarchar40 Allow NULL? 
96BEG07Start Datenvarchar80 Allow NULL? 
97END07End Datenvarchar80 Allow NULL? 
98MTH07Leave taken in prior service in monthsdecimal80
99DAY07Leave taken in prior service in daysdecimal52
100PFT07Leave taken in Part or Full time counterchar10 Allow NULL? 
101PAY07FULL OR HALF PAY COUNTERchar10 Allow NULL? 
102CAS07Not to count as servicechar10 Allow NULL? 
103LVE08Leave type for Prior Servicenvarchar40 Allow NULL? 
104BEG08Start Datenvarchar80 Allow NULL? 
105END08End Datenvarchar80 Allow NULL? 
106MTH08Leave taken in prior service in monthsdecimal80
107DAY08Leave taken in prior service in daysdecimal52
108PFT08Leave taken in Part or Full time counterchar10 Allow NULL? 
109PAY08FULL OR HALF PAY COUNTERchar10 Allow NULL? 
110CAS08Not to count as servicechar10 Allow NULL? 
111LVE09Leave type for Prior Servicenvarchar40 Allow NULL? 
112BEG09Start Datenvarchar80 Allow NULL? 
113END09End Datenvarchar80 Allow NULL? 
114MTH09Leave taken in prior service in monthsdecimal80
115DAY09Leave taken in prior service in daysdecimal52
116PFT09Leave taken in Part or Full time counterchar10 Allow NULL? 
117PAY09FULL OR HALF PAY COUNTERchar10 Allow NULL? 
118CAS09Not to count as servicechar10 Allow NULL? 
119LVE10Leave type for Prior Servicenvarchar40 Allow NULL? 
120BEG10Start Datenvarchar80 Allow NULL? 
121END10End Datenvarchar80 Allow NULL? 
122MTH10Leave taken in prior service in monthsdecimal80
123DAY10Leave taken in prior service in daysdecimal52
124PFT10Leave taken in Part or Full time counterchar10 Allow NULL? 
125PAY10FULL OR HALF PAY COUNTERchar10 Allow NULL? 
126CAS10Not to count as servicechar10 Allow NULL? 
127LVE11Leave type for Prior Servicenvarchar40 Allow NULL? 
128BEG11Start Datenvarchar80 Allow NULL? 
129END11End Datenvarchar80 Allow NULL? 
130MTH11Leave taken in prior service in monthsdecimal80
131DAY11Leave taken in prior service in daysdecimal52
132PFT11Leave taken in Part or Full time counterchar10 Allow NULL? 
133PAY11FULL OR HALF PAY COUNTERchar10 Allow NULL? 
134CAS11Not to count as servicechar10 Allow NULL? 
135LVE12Leave type for Prior Servicenvarchar40 Allow NULL? 
136BEG12Start Datenvarchar80 Allow NULL? 
137END12End Datenvarchar80 Allow NULL? 
138MTH12Leave taken in prior service in monthsdecimal80
139DAY12Leave taken in prior service in daysdecimal52
140PFT12Leave taken in Part or Full time counterchar10 Allow NULL? 
141PAY12FULL OR HALF PAY COUNTERchar10 Allow NULL? 
142CAS12Not to count as servicechar10 Allow NULL? 
143LVE13Leave type for Prior Servicenvarchar40 Allow NULL? 
144BEG13Start Datenvarchar80 Allow NULL? 
145END13End Datenvarchar80 Allow NULL? 
146MTH13Leave taken in prior service in monthsdecimal80
147DAY13Leave taken in prior service in daysdecimal52
148PFT13Leave taken in Part or Full time counterchar10 Allow NULL? 
149PAY13FULL OR HALF PAY COUNTERchar10 Allow NULL? 
150CAS13Not to count as servicechar10 Allow NULL? 
151LVE14Leave type for Prior Servicenvarchar40 Allow NULL? 
152BEG14Start Datenvarchar80 Allow NULL? 
153END14End Datenvarchar80 Allow NULL? 
154MTH14Leave taken in prior service in monthsdecimal80
155DAY14Leave taken in prior service in daysdecimal52
156PFT14Leave taken in Part or Full time counterchar10 Allow NULL? 
157PAY14FULL OR HALF PAY COUNTERchar10 Allow NULL? 
158CAS14Not to count as servicechar10 Allow NULL? 
159LVE15Leave type for Prior Servicenvarchar40 Allow NULL? 
160BEG15Start Datenvarchar80 Allow NULL? 
161END15End Datenvarchar80 Allow NULL? 
162MTH15Leave taken in prior service in monthsdecimal80
163DAY15Leave taken in prior service in daysdecimal52
164PFT15Leave taken in Part or Full time counterchar10 Allow NULL? 
165PAY15FULL OR HALF PAY COUNTERchar10 Allow NULL? 
166CAS15Not to count as servicechar10 Allow NULL? 
167LVE16Leave type for Prior Servicenvarchar40 Allow NULL? 
168BEG16Start Datenvarchar80 Allow NULL? 
169END16End Datenvarchar80 Allow NULL? 
170MTH16Leave taken in prior service in monthsdecimal80
171DAY16Leave taken in prior service in daysdecimal52
172PFT16Leave taken in Part or Full time counterchar10 Allow NULL? 
173PAY16FULL OR HALF PAY COUNTERchar10 Allow NULL? 
174CAS16Not to count as servicechar10 Allow NULL? 
175LVE17Leave type for Prior Servicenvarchar40 Allow NULL? 
176BEG17Start Datenvarchar80 Allow NULL? 
177END17End Datenvarchar80 Allow NULL? 
178MTH17Leave taken in prior service in monthsdecimal80
179DAY17Leave taken in prior service in daysdecimal52
180PFT17Leave taken in Part or Full time counterchar10 Allow NULL? 
181PAY17FULL OR HALF PAY COUNTERchar10 Allow NULL? 
182CAS17Not to count as servicechar10 Allow NULL? 
183LVE18Leave type for Prior Servicenvarchar40 Allow NULL? 
184BEG18Start Datenvarchar80 Allow NULL? 
185END18End Datenvarchar80 Allow NULL? 
186MTH18Leave taken in prior service in monthsdecimal80
187DAY18Leave taken in prior service in daysdecimal52
188PFT18Leave taken in Part or Full time counterchar10 Allow NULL? 
189PAY18FULL OR HALF PAY COUNTERchar10 Allow NULL? 
190CAS18Not to count as servicechar10 Allow NULL? 
191LVE19Leave type for Prior Servicenvarchar40 Allow NULL? 
192BEG19Start Datenvarchar80 Allow NULL? 
193END19End Datenvarchar80 Allow NULL? 
194MTH19Leave taken in prior service in monthsdecimal80
195DAY19Leave taken in prior service in daysdecimal52
196PFT19Leave taken in Part or Full time counterchar10 Allow NULL? 
197PAY19FULL OR HALF PAY COUNTERchar10 Allow NULL? 
198CAS19Not to count as servicechar10 Allow NULL? 
199LVE20Leave type for Prior Servicenvarchar40 Allow NULL? 
200BEG20Start Datenvarchar80 Allow NULL? 
201END20End Datenvarchar80 Allow NULL? 
202MTH20Leave taken in prior service in monthsdecimal80
203DAY20Leave taken in prior service in daysdecimal52
204PFT20Leave taken in Part or Full time counterchar10 Allow NULL? 
205PAY20FULL OR HALF PAY COUNTERchar10 Allow NULL? 
206CAS20Not to count as servicechar10 Allow NULL? 
207LVE21Leave type for Prior Servicenvarchar40 Allow NULL? 
208BEG21Start Datenvarchar80 Allow NULL? 
209END21End Datenvarchar80 Allow NULL? 
210MTH21Leave taken in prior service in monthsdecimal80
211DAY21Leave taken in prior service in daysdecimal52
212PFT21Leave taken in Part or Full time counterchar10 Allow NULL? 
213PAY21FULL OR HALF PAY COUNTERchar10 Allow NULL? 
214CAS21Not to count as servicechar10 Allow NULL? 
215LVE22Leave type for Prior Servicenvarchar40 Allow NULL? 
216BEG22Start Datenvarchar80 Allow NULL? 
217END22End Datenvarchar80 Allow NULL? 
218MTH22Leave taken in prior service in monthsdecimal80
219DAY22Leave taken in prior service in daysdecimal52
220PFT22Leave taken in Part or Full time counterchar10 Allow NULL? 
221PAY22FULL OR HALF PAY COUNTERchar10 Allow NULL? 
222CAS22Not to count as servicechar10 Allow NULL? 
223LVE23Leave type for Prior Servicenvarchar40 Allow NULL? 
224BEG23Start Datenvarchar80 Allow NULL? 
225END23End Datenvarchar80 Allow NULL? 
226MTH23Leave taken in prior service in monthsdecimal80
227DAY23Leave taken in prior service in daysdecimal52
228PFT23Leave taken in Part or Full time counterchar10 Allow NULL? 
229PAY23FULL OR HALF PAY COUNTERchar10 Allow NULL? 
230CAS23Not to count as servicechar10 Allow NULL? 
231LVE24Leave type for Prior Servicenvarchar40 Allow NULL? 
232BEG24Start Datenvarchar80 Allow NULL? 
233END24End Datenvarchar80 Allow NULL? 
234MTH24Leave taken in prior service in monthsdecimal80
235DAY24Leave taken in prior service in daysdecimal52
236PFT24Leave taken in Part or Full time counterchar10 Allow NULL? 
237PAY24FULL OR HALF PAY COUNTERchar10 Allow NULL? 
238CAS24Not to count as servicechar10 Allow NULL? 
239LVE25Leave type for Prior Servicenvarchar40 Allow NULL? 
240BEG25Start Datenvarchar80 Allow NULL? 
241END25End Datenvarchar80 Allow NULL? 
242MTH25Leave taken in prior service in monthsdecimal80
243DAY25Leave taken in prior service in daysdecimal52
244PFT25Leave taken in Part or Full time counterchar10 Allow NULL? 
245PAY25FULL OR HALF PAY COUNTERchar10 Allow NULL? 
246CAS25Not to count as servicechar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0508~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT