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
Personnel Management :: Personnel Administration
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA06602551HR master record infortype 0660Personnel Administration
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, EMRTX, SIBEG, SIEND, HIRED, PRYEA, ACYEA, WAERS, MSA01, MSA02, MSA03, MSA04, MSA05, MSA06, MSA07, MSA08, MSA09, MSA10, MSA11, MSA12, MSA13, MSA14, MSA15, MSA16, MSA17, MSA18, MSA19, MSA20, MSA21, MSA22, MSA23, MSA24, ABE01, AEN01, ACO01, ABE02, AEN02, ACO02, ABE03, AEN03, ACO03, ABE04, AEN04, ACO04, ABE05, AEN05, ACO05, ABE06, AEN06, ACO06, ABE07, AEN07, ACO07, ABE08, AEN08, ACO08, ABE09, AEN09, ACO09, ABE10, AEN10, ACO10, ABE11, AEN11, ACO11, ABE12, AEN12, ACO12, ABE13, AEN13, ACO13, ABE14, AEN14, ACO14, ABE15, AEN15, ACO15, ABE16, AEN16, ACO16, ABE17, AEN17, ACO17, ABE18, AEN18, ACO18, ABE19, AEN19, ACO19, ABE20, AEN20, ACO20, NRJ01, NRI01, NRM01, NRD01, NRJ02, NRI02, NRM02, NRD02, NRJ03, NRI03, NRM03, NRD03, NRJ04, NRI04, NRM04, NRD04, NRJ05, NRI05, NRM05, NRD05, NRJ06, NRI06, NRM06, NRD06, NRJ07, NRI07, NRM07, NRD07, NRJ08, NRI08, NRM08, NRD08, NRJ09, NRI09, NRM09, NRD09, NRJ10, NRI10, NRM10, NRD10, NRJ11, NRI11, NRM11, NRD11, NRJ12, NRI12, NRM12, NRD12, NRJ13, NRI13, NRM13, NRD13, NRJ14, NRI14, NRM14, NRD14, NRJ15, NRI15, NRM15, NRD15, NRJ16, NRI16, NRM16, NRD16, NRJ17, NRI17, NRM17, NRD17, NRJ18, NRI18, NRM18, NRD18, NRJ19, NRI19, NRM19, NRD19, NRJ20, NRI20, NRM20, NRD20, KIF01, KIF02, KIF03, KIF04, KIF05, KIF06, KIF07, KIF08, KIF09, KIF10, KIF11, KIF12, KIF13, KIF14, KIF15, KIF16, KIF17, KIF18, KIF19, KIF20, JOGVT, LGA01, LGA02, LGA03, LGA04, LGA05, LGA06, LGA07, LGA08, LGA09, LGA10, LGA11, LGA12, LGA13, LGA14, LGA15, LGA16, LGA17, LGA18, LGA19, LGA20, AWA01, AWA02, AWA03, AWA04, AWA05, AWA06, AWA07, AWA08, AWA09, AWA10, AWA11, AWA12, AWA13, AWA14, AWA15, AWA16, AWA17, AWA18, AWA19, AWA20 FROM PA0660
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? 
24EMRTXName of employernvarchar500 Allow NULL? 
25SIBEGInsurance relationship fromnvarchar80 Allow NULL? 
26SIENDInsurance relationship tonvarchar80 Allow NULL? 
27HIREDEntry datenvarchar80 Allow NULL? 
28PRYEAYear before entrynvarchar40 Allow NULL? 
29ACYEAEntry yearnvarchar40 Allow NULL? 
30WAERSCurrency Keynvarchar50 Allow NULL? 
31MSA01Monthly income (contribution paid)decimal92
32MSA02Monthly income (contribution paid)decimal92
33MSA03Monthly income (contribution paid)decimal92
34MSA04Monthly income (contribution paid)decimal92
35MSA05Monthly income (contribution paid)decimal92
36MSA06Monthly income (contribution paid)decimal92
37MSA07Monthly income (contribution paid)decimal92
38MSA08Monthly income (contribution paid)decimal92
39MSA09Monthly income (contribution paid)decimal92
40MSA10Monthly income (contribution paid)decimal92
41MSA11Monthly income (contribution paid)decimal92
42MSA12Monthly income (contribution paid)decimal92
43MSA13Monthly income (contribution paid)decimal92
44MSA14Monthly income (contribution paid)decimal92
45MSA15Monthly income (contribution paid)decimal92
46MSA16Monthly income (contribution paid)decimal92
47MSA17Monthly income (contribution paid)decimal92
48MSA18Monthly income (contribution paid)decimal92
49MSA19Monthly income (contribution paid)decimal92
50MSA20Monthly income (contribution paid)decimal92
51MSA21Monthly income (contribution paid)decimal92
52MSA22Monthly income (contribution paid)decimal92
53MSA23Monthly income (contribution paid)decimal92
54MSA24Monthly income (contribution paid)decimal92
55ABE01Absence beginnvarchar80 Allow NULL? 
56AEN01Absence endnvarchar80 Allow NULL? 
57ACO01Absence typechar10 Allow NULL? 
58ABE02Absence beginnvarchar80 Allow NULL? 
59AEN02Absence endnvarchar80 Allow NULL? 
60ACO02Absence typechar10 Allow NULL? 
61ABE03Absence beginnvarchar80 Allow NULL? 
62AEN03Absence endnvarchar80 Allow NULL? 
63ACO03Absence typechar10 Allow NULL? 
64ABE04Absence beginnvarchar80 Allow NULL? 
65AEN04Absence endnvarchar80 Allow NULL? 
66ACO04Absence typechar10 Allow NULL? 
67ABE05Absence beginnvarchar80 Allow NULL? 
68AEN05Absence endnvarchar80 Allow NULL? 
69ACO05Absence typechar10 Allow NULL? 
70ABE06Absence beginnvarchar80 Allow NULL? 
71AEN06Absence endnvarchar80 Allow NULL? 
72ACO06Absence typechar10 Allow NULL? 
73ABE07Absence beginnvarchar80 Allow NULL? 
74AEN07Absence endnvarchar80 Allow NULL? 
75ACO07Absence typechar10 Allow NULL? 
76ABE08Absence beginnvarchar80 Allow NULL? 
77AEN08Absence endnvarchar80 Allow NULL? 
78ACO08Absence typechar10 Allow NULL? 
79ABE09Absence beginnvarchar80 Allow NULL? 
80AEN09Absence endnvarchar80 Allow NULL? 
81ACO09Absence typechar10 Allow NULL? 
82ABE10Absence beginnvarchar80 Allow NULL? 
83AEN10Absence endnvarchar80 Allow NULL? 
84ACO10Absence typechar10 Allow NULL? 
85ABE11Absence beginnvarchar80 Allow NULL? 
86AEN11Absence endnvarchar80 Allow NULL? 
87ACO11Absence typechar10 Allow NULL? 
88ABE12Absence beginnvarchar80 Allow NULL? 
89AEN12Absence endnvarchar80 Allow NULL? 
90ACO12Absence typechar10 Allow NULL? 
91ABE13Absence beginnvarchar80 Allow NULL? 
92AEN13Absence endnvarchar80 Allow NULL? 
93ACO13Absence typechar10 Allow NULL? 
94ABE14Absence beginnvarchar80 Allow NULL? 
95AEN14Absence endnvarchar80 Allow NULL? 
96ACO14Absence typechar10 Allow NULL? 
97ABE15Absence beginnvarchar80 Allow NULL? 
98AEN15Absence endnvarchar80 Allow NULL? 
99ACO15Absence typechar10 Allow NULL? 
100ABE16Absence beginnvarchar80 Allow NULL? 
101AEN16Absence endnvarchar80 Allow NULL? 
102ACO16Absence typechar10 Allow NULL? 
103ABE17Absence beginnvarchar80 Allow NULL? 
104AEN17Absence endnvarchar80 Allow NULL? 
105ACO17Absence typechar10 Allow NULL? 
106ABE18Absence beginnvarchar80 Allow NULL? 
107AEN18Absence endnvarchar80 Allow NULL? 
108ACO18Absence typechar10 Allow NULL? 
109ABE19Absence beginnvarchar80 Allow NULL? 
110AEN19Absence endnvarchar80 Allow NULL? 
111ACO19Absence typechar10 Allow NULL? 
112ABE20Absence beginnvarchar80 Allow NULL? 
113AEN20Absence endnvarchar80 Allow NULL? 
114ACO20Absence typechar10 Allow NULL? 
115NRJ01Irregular income - payment titlenvarchar150 Allow NULL? 
116NRI01Irregular income - payment amountdecimal92
117NRM01Irregular income - payment relevance monthnvarchar60 Allow NULL? 
118NRD01Irregular income - payment relevance durationnvarchar50 Allow NULL? 
119NRJ02Irregular income - payment titlenvarchar150 Allow NULL? 
120NRI02Irregular income - payment amountdecimal92
121NRM02Irregular income - payment relevance monthnvarchar60 Allow NULL? 
122NRD02Irregular income - payment relevance durationnvarchar50 Allow NULL? 
123NRJ03Irregular income - payment titlenvarchar150 Allow NULL? 
124NRI03Irregular income - payment amountdecimal92
125NRM03Irregular income - payment relevance monthnvarchar60 Allow NULL? 
126NRD03Irregular income - payment relevance durationnvarchar50 Allow NULL? 
127NRJ04Irregular income - payment titlenvarchar150 Allow NULL? 
128NRI04Irregular income - payment amountdecimal92
129NRM04Irregular income - payment relevance monthnvarchar60 Allow NULL? 
130NRD04Irregular income - payment relevance durationnvarchar50 Allow NULL? 
131NRJ05Irregular income - payment titlenvarchar150 Allow NULL? 
132NRI05Irregular income - payment amountdecimal92
133NRM05Irregular income - payment relevance monthnvarchar60 Allow NULL? 
134NRD05Irregular income - payment relevance durationnvarchar50 Allow NULL? 
135NRJ06Irregular income - payment titlenvarchar150 Allow NULL? 
136NRI06Irregular income - payment amountdecimal92
137NRM06Irregular income - payment relevance monthnvarchar60 Allow NULL? 
138NRD06Irregular income - payment relevance durationnvarchar50 Allow NULL? 
139NRJ07Irregular income - payment titlenvarchar150 Allow NULL? 
140NRI07Irregular income - payment amountdecimal92
141NRM07Irregular income - payment relevance monthnvarchar60 Allow NULL? 
142NRD07Irregular income - payment relevance durationnvarchar50 Allow NULL? 
143NRJ08Irregular income - payment titlenvarchar150 Allow NULL? 
144NRI08Irregular income - payment amountdecimal92
145NRM08Irregular income - payment relevance monthnvarchar60 Allow NULL? 
146NRD08Irregular income - payment relevance durationnvarchar50 Allow NULL? 
147NRJ09Irregular income - payment titlenvarchar150 Allow NULL? 
148NRI09Irregular income - payment amountdecimal92
149NRM09Irregular income - payment relevance monthnvarchar60 Allow NULL? 
150NRD09Irregular income - payment relevance durationnvarchar50 Allow NULL? 
151NRJ10Irregular income - payment titlenvarchar150 Allow NULL? 
152NRI10Irregular income - payment amountdecimal92
153NRM10Irregular income - payment relevance monthnvarchar60 Allow NULL? 
154NRD10Irregular income - payment relevance durationnvarchar50 Allow NULL? 
155NRJ11Irregular income - payment titlenvarchar150 Allow NULL? 
156NRI11Irregular income - payment amountdecimal92
157NRM11Irregular income - payment relevance monthnvarchar60 Allow NULL? 
158NRD11Irregular income - payment relevance durationnvarchar50 Allow NULL? 
159NRJ12Irregular income - payment titlenvarchar150 Allow NULL? 
160NRI12Irregular income - payment amountdecimal92
161NRM12Irregular income - payment relevance monthnvarchar60 Allow NULL? 
162NRD12Irregular income - payment relevance durationnvarchar50 Allow NULL? 
163NRJ13Irregular income - payment titlenvarchar150 Allow NULL? 
164NRI13Irregular income - payment amountdecimal92
165NRM13Irregular income - payment relevance monthnvarchar60 Allow NULL? 
166NRD13Irregular income - payment relevance durationnvarchar50 Allow NULL? 
167NRJ14Irregular income - payment titlenvarchar150 Allow NULL? 
168NRI14Irregular income - payment amountdecimal92
169NRM14Irregular income - payment relevance monthnvarchar60 Allow NULL? 
170NRD14Irregular income - payment relevance durationnvarchar50 Allow NULL? 
171NRJ15Irregular income - payment titlenvarchar150 Allow NULL? 
172NRI15Irregular income - payment amountdecimal92
173NRM15Irregular income - payment relevance monthnvarchar60 Allow NULL? 
174NRD15Irregular income - payment relevance durationnvarchar50 Allow NULL? 
175NRJ16Irregular income - payment titlenvarchar150 Allow NULL? 
176NRI16Irregular income - payment amountdecimal92
177NRM16Irregular income - payment relevance monthnvarchar60 Allow NULL? 
178NRD16Irregular income - payment relevance durationnvarchar50 Allow NULL? 
179NRJ17Irregular income - payment titlenvarchar150 Allow NULL? 
180NRI17Irregular income - payment amountdecimal92
181NRM17Irregular income - payment relevance monthnvarchar60 Allow NULL? 
182NRD17Irregular income - payment relevance durationnvarchar50 Allow NULL? 
183NRJ18Irregular income - payment titlenvarchar150 Allow NULL? 
184NRI18Irregular income - payment amountdecimal92
185NRM18Irregular income - payment relevance monthnvarchar60 Allow NULL? 
186NRD18Irregular income - payment relevance durationnvarchar50 Allow NULL? 
187NRJ19Irregular income - payment titlenvarchar150 Allow NULL? 
188NRI19Irregular income - payment amountdecimal92
189NRM19Irregular income - payment relevance monthnvarchar60 Allow NULL? 
190NRD19Irregular income - payment relevance durationnvarchar50 Allow NULL? 
191NRJ20Irregular income - payment titlenvarchar150 Allow NULL? 
192NRI20Irregular income - payment amountdecimal92
193NRM20Irregular income - payment relevance monthnvarchar60 Allow NULL? 
194NRD20Irregular income - payment relevance durationnvarchar50 Allow NULL? 
195KIF01nvarchar80 Allow NULL? 
196KIF02nvarchar80 Allow NULL? 
197KIF03nvarchar80 Allow NULL? 
198KIF04nvarchar80 Allow NULL? 
199KIF05nvarchar80 Allow NULL? 
200KIF06nvarchar80 Allow NULL? 
201KIF07nvarchar80 Allow NULL? 
202KIF08nvarchar80 Allow NULL? 
203KIF09nvarchar80 Allow NULL? 
204KIF10nvarchar80 Allow NULL? 
205KIF11nvarchar80 Allow NULL? 
206KIF12nvarchar80 Allow NULL? 
207KIF13nvarchar80 Allow NULL? 
208KIF14nvarchar80 Allow NULL? 
209KIF15nvarchar80 Allow NULL? 
210KIF16nvarchar80 Allow NULL? 
211KIF17nvarchar80 Allow NULL? 
212KIF18nvarchar80 Allow NULL? 
213KIF19nvarchar80 Allow NULL? 
214KIF20nvarchar80 Allow NULL? 
215JOGVTchar10 Allow NULL? 
216LGA01Wage Typenvarchar40 Allow NULL? 
217LGA02Wage Typenvarchar40 Allow NULL? 
218LGA03Wage Typenvarchar40 Allow NULL? 
219LGA04Wage Typenvarchar40 Allow NULL? 
220LGA05Wage Typenvarchar40 Allow NULL? 
221LGA06Wage Typenvarchar40 Allow NULL? 
222LGA07Wage Typenvarchar40 Allow NULL? 
223LGA08Wage Typenvarchar40 Allow NULL? 
224LGA09Wage Typenvarchar40 Allow NULL? 
225LGA10Wage Typenvarchar40 Allow NULL? 
226LGA11Wage Typenvarchar40 Allow NULL? 
227LGA12Wage Typenvarchar40 Allow NULL? 
228LGA13Wage Typenvarchar40 Allow NULL? 
229LGA14Wage Typenvarchar40 Allow NULL? 
230LGA15Wage Typenvarchar40 Allow NULL? 
231LGA16Wage Typenvarchar40 Allow NULL? 
232LGA17Wage Typenvarchar40 Allow NULL? 
233LGA18Wage Typenvarchar40 Allow NULL? 
234LGA19Wage Typenvarchar40 Allow NULL? 
235LGA20Wage Typenvarchar40 Allow NULL? 
236AWA01Attendance or Absence Typenvarchar40 Allow NULL? 
237AWA02Attendance or Absence Typenvarchar40 Allow NULL? 
238AWA03Attendance or Absence Typenvarchar40 Allow NULL? 
239AWA04Attendance or Absence Typenvarchar40 Allow NULL? 
240AWA05Attendance or Absence Typenvarchar40 Allow NULL? 
241AWA06Attendance or Absence Typenvarchar40 Allow NULL? 
242AWA07Attendance or Absence Typenvarchar40 Allow NULL? 
243AWA08Attendance or Absence Typenvarchar40 Allow NULL? 
244AWA09Attendance or Absence Typenvarchar40 Allow NULL? 
245AWA10Attendance or Absence Typenvarchar40 Allow NULL? 
246AWA11Attendance or Absence Typenvarchar40 Allow NULL? 
247AWA12Attendance or Absence Typenvarchar40 Allow NULL? 
248AWA13Attendance or Absence Typenvarchar40 Allow NULL? 
249AWA14Attendance or Absence Typenvarchar40 Allow NULL? 
250AWA15Attendance or Absence Typenvarchar40 Allow NULL? 
251AWA16Attendance or Absence Typenvarchar40 Allow NULL? 
252AWA17Attendance or Absence Typenvarchar40 Allow NULL? 
253AWA18Attendance or Absence Typenvarchar40 Allow NULL? 
254AWA19Attendance or Absence Typenvarchar40 Allow NULL? 
255AWA20Attendance or Absence Typenvarchar40 Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0660~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT