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 :: Korea
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA08122221HR Master Record: Infotype 0812Korea
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, SUB01, OBJ01, NUM01, NAM01, CNT01, AMT01, CUR01, SUB02, OBJ02, NUM02, NAM02, CNT02, AMT02, CUR02, SUB03, OBJ03, NUM03, NAM03, CNT03, AMT03, CUR03, SUB04, OBJ04, NUM04, NAM04, CNT04, AMT04, CUR04, SUB05, OBJ05, NUM05, NAM05, CNT05, AMT05, CUR05, SUB06, OBJ06, NUM06, NAM06, CNT06, AMT06, CUR06, SUB07, OBJ07, NUM07, NAM07, CNT07, AMT07, CUR07, SUB08, OBJ08, NUM08, NAM08, CNT08, AMT08, CUR08, SUB09, OBJ09, NUM09, NAM09, CNT09, AMT09, CUR09, SUB10, OBJ10, NUM10, NAM10, CNT10, AMT10, CUR10, SUB11, OBJ11, NUM11, NAM11, CNT11, AMT11, CUR11, SUB12, OBJ12, NUM12, NAM12, CNT12, AMT12, CUR12, SUB13, OBJ13, NUM13, NAM13, CNT13, AMT13, CUR13, SUB14, OBJ14, NUM14, NAM14, CNT14, AMT14, CUR14, SUB15, OBJ15, NUM15, NAM15, CNT15, AMT15, CUR15, SUB16, OBJ16, NUM16, NAM16, CNT16, AMT16, CUR16, SUB17, OBJ17, NUM17, NAM17, CNT17, AMT17, CUR17, SUB18, OBJ18, NUM18, NAM18, CNT18, AMT18, CUR18, CDT01, CDA01, CDT02, CDA02, CDT03, CDA03, CDT04, CDA04, CDT05, CDA05, CDT06, CDA06, CDT07, CDA07, CDT08, CDA08, CDT09, CDA09, CDT10, CDA10, CDT11, CDA11, CDT12, CDA12, CDT13, CDA13, CDT14, CDA14, CDT15, CDA15, CDT16, CDA16, CDT17, CDA17, CDT18, CDA18, FLNTS, PCD01, PCD02, PCD03, PCD04, PCD05, PCD06, PCD07, PCD08, PCD09, PCD10, PCD11, PCD12, PCD13, PCD14, PCD15, PCD16, PCD17, PCD18, STY01, STY02, STY03, STY04, STY05, STY06, STY07, STY08, STY09, STY10, STY11, STY12, STY13, STY14, STY15, STY16, STY17, STY18 FROM PA0812
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? 
24SUB01Subtypenvarchar40 Allow NULL? 
25OBJ01Object Identificationnvarchar20 Allow NULL? 
26NUM01Biz number of supplynvarchar100 Allow NULL? 
27NAM01Name of supplynvarchar400 Allow NULL? 
28CNT01Count for medical expense by cashnvarchar50 Allow NULL? 
29AMT01Amount for medical expense paid by cashdecimal102
30CUR01Medical expense currencynvarchar50 Allow NULL? 
31SUB02Subtypenvarchar40 Allow NULL? 
32OBJ02Object Identificationnvarchar20 Allow NULL? 
33NUM02Biz number of supplynvarchar100 Allow NULL? 
34NAM02Name of supplynvarchar400 Allow NULL? 
35CNT02Count for medical expense by cashnvarchar50 Allow NULL? 
36AMT02Amount for medical expense paid by cashdecimal102
37CUR02Medical expense currencynvarchar50 Allow NULL? 
38SUB03Subtypenvarchar40 Allow NULL? 
39OBJ03Object Identificationnvarchar20 Allow NULL? 
40NUM03Biz number of supplynvarchar100 Allow NULL? 
41NAM03Name of supplynvarchar400 Allow NULL? 
42CNT03Count for medical expense by cashnvarchar50 Allow NULL? 
43AMT03Amount for medical expense paid by cashdecimal102
44CUR03Medical expense currencynvarchar50 Allow NULL? 
45SUB04Subtypenvarchar40 Allow NULL? 
46OBJ04Object Identificationnvarchar20 Allow NULL? 
47NUM04Biz number of supplynvarchar100 Allow NULL? 
48NAM04Name of supplynvarchar400 Allow NULL? 
49CNT04Count for medical expense by cashnvarchar50 Allow NULL? 
50AMT04Amount for medical expense paid by cashdecimal102
51CUR04Medical expense currencynvarchar50 Allow NULL? 
52SUB05Subtypenvarchar40 Allow NULL? 
53OBJ05Object Identificationnvarchar20 Allow NULL? 
54NUM05Biz number of supplynvarchar100 Allow NULL? 
55NAM05Name of supplynvarchar400 Allow NULL? 
56CNT05Count for medical expense by cashnvarchar50 Allow NULL? 
57AMT05Amount for medical expense paid by cashdecimal102
58CUR05Medical expense currencynvarchar50 Allow NULL? 
59SUB06Subtypenvarchar40 Allow NULL? 
60OBJ06Object Identificationnvarchar20 Allow NULL? 
61NUM06Biz number of supplynvarchar100 Allow NULL? 
62NAM06Name of supplynvarchar400 Allow NULL? 
63CNT06Count for medical expense by cashnvarchar50 Allow NULL? 
64AMT06Amount for medical expense paid by cashdecimal102
65CUR06Medical expense currencynvarchar50 Allow NULL? 
66SUB07Subtypenvarchar40 Allow NULL? 
67OBJ07Object Identificationnvarchar20 Allow NULL? 
68NUM07Biz number of supplynvarchar100 Allow NULL? 
69NAM07Name of supplynvarchar400 Allow NULL? 
70CNT07Count for medical expense by cashnvarchar50 Allow NULL? 
71AMT07Amount for medical expense paid by cashdecimal102
72CUR07Medical expense currencynvarchar50 Allow NULL? 
73SUB08Subtypenvarchar40 Allow NULL? 
74OBJ08Object Identificationnvarchar20 Allow NULL? 
75NUM08Biz number of supplynvarchar100 Allow NULL? 
76NAM08Name of supplynvarchar400 Allow NULL? 
77CNT08Count for medical expense by cashnvarchar50 Allow NULL? 
78AMT08Amount for medical expense paid by cashdecimal102
79CUR08Medical expense currencynvarchar50 Allow NULL? 
80SUB09Subtypenvarchar40 Allow NULL? 
81OBJ09Object Identificationnvarchar20 Allow NULL? 
82NUM09Biz number of supplynvarchar100 Allow NULL? 
83NAM09Name of supplynvarchar400 Allow NULL? 
84CNT09Count for medical expense by cashnvarchar50 Allow NULL? 
85AMT09Amount for medical expense paid by cashdecimal102
86CUR09Medical expense currencynvarchar50 Allow NULL? 
87SUB10Subtypenvarchar40 Allow NULL? 
88OBJ10Object Identificationnvarchar20 Allow NULL? 
89NUM10Biz number of supplynvarchar100 Allow NULL? 
90NAM10Name of supplynvarchar400 Allow NULL? 
91CNT10Count for medical expense by cashnvarchar50 Allow NULL? 
92AMT10Amount for medical expense paid by cashdecimal102
93CUR10Medical expense currencynvarchar50 Allow NULL? 
94SUB11Subtypenvarchar40 Allow NULL? 
95OBJ11Object Identificationnvarchar20 Allow NULL? 
96NUM11Biz number of supplynvarchar100 Allow NULL? 
97NAM11Name of supplynvarchar400 Allow NULL? 
98CNT11Count for medical expense by cashnvarchar50 Allow NULL? 
99AMT11Amount for medical expense paid by cashdecimal102
100CUR11Medical expense currencynvarchar50 Allow NULL? 
101SUB12Subtypenvarchar40 Allow NULL? 
102OBJ12Object Identificationnvarchar20 Allow NULL? 
103NUM12Biz number of supplynvarchar100 Allow NULL? 
104NAM12Name of supplynvarchar400 Allow NULL? 
105CNT12Count for medical expense by cashnvarchar50 Allow NULL? 
106AMT12Amount for medical expense paid by cashdecimal102
107CUR12Medical expense currencynvarchar50 Allow NULL? 
108SUB13Subtypenvarchar40 Allow NULL? 
109OBJ13Object Identificationnvarchar20 Allow NULL? 
110NUM13Biz number of supplynvarchar100 Allow NULL? 
111NAM13Name of supplynvarchar400 Allow NULL? 
112CNT13Count for medical expense by cashnvarchar50 Allow NULL? 
113AMT13Amount for medical expense paid by cashdecimal102
114CUR13Medical expense currencynvarchar50 Allow NULL? 
115SUB14Subtypenvarchar40 Allow NULL? 
116OBJ14Object Identificationnvarchar20 Allow NULL? 
117NUM14Biz number of supplynvarchar100 Allow NULL? 
118NAM14Name of supplynvarchar400 Allow NULL? 
119CNT14Count for medical expense by cashnvarchar50 Allow NULL? 
120AMT14Amount for medical expense paid by cashdecimal102
121CUR14Medical expense currencynvarchar50 Allow NULL? 
122SUB15Subtypenvarchar40 Allow NULL? 
123OBJ15Object Identificationnvarchar20 Allow NULL? 
124NUM15Biz number of supplynvarchar100 Allow NULL? 
125NAM15Name of supplynvarchar400 Allow NULL? 
126CNT15Count for medical expense by cashnvarchar50 Allow NULL? 
127AMT15Amount for medical expense paid by cashdecimal102
128CUR15Medical expense currencynvarchar50 Allow NULL? 
129SUB16Subtypenvarchar40 Allow NULL? 
130OBJ16Object Identificationnvarchar20 Allow NULL? 
131NUM16Biz number of supplynvarchar100 Allow NULL? 
132NAM16Name of supplynvarchar400 Allow NULL? 
133CNT16Count for medical expense by cashnvarchar50 Allow NULL? 
134AMT16Amount for medical expense paid by cashdecimal102
135CUR16Medical expense currencynvarchar50 Allow NULL? 
136SUB17Subtypenvarchar40 Allow NULL? 
137OBJ17Object Identificationnvarchar20 Allow NULL? 
138NUM17Biz number of supplynvarchar100 Allow NULL? 
139NAM17Name of supplynvarchar400 Allow NULL? 
140CNT17Count for medical expense by cashnvarchar50 Allow NULL? 
141AMT17Amount for medical expense paid by cashdecimal102
142CUR17Medical expense currencynvarchar50 Allow NULL? 
143SUB18Subtypenvarchar40 Allow NULL? 
144OBJ18Object Identificationnvarchar20 Allow NULL? 
145NUM18Biz number of supplynvarchar100 Allow NULL? 
146NAM18Name of supplynvarchar400 Allow NULL? 
147CNT18Count for medical expense by cashnvarchar50 Allow NULL? 
148AMT18Amount for medical expense paid by cashdecimal102
149CUR18Medical expense currencynvarchar50 Allow NULL? 
150CDT01Credit Card count for medical expnvarchar50 Allow NULL? 
151CDA01Credit amount for medical expensedecimal92
152CDT02Credit Card count for medical expnvarchar50 Allow NULL? 
153CDA02Credit amount for medical expensedecimal92
154CDT03Credit Card count for medical expnvarchar50 Allow NULL? 
155CDA03Credit amount for medical expensedecimal92
156CDT04Credit Card count for medical expnvarchar50 Allow NULL? 
157CDA04Credit amount for medical expensedecimal92
158CDT05Credit Card count for medical expnvarchar50 Allow NULL? 
159CDA05Credit amount for medical expensedecimal92
160CDT06Credit Card count for medical expnvarchar50 Allow NULL? 
161CDA06Credit amount for medical expensedecimal92
162CDT07Credit Card count for medical expnvarchar50 Allow NULL? 
163CDA07Credit amount for medical expensedecimal92
164CDT08Credit Card count for medical expnvarchar50 Allow NULL? 
165CDA08Credit amount for medical expensedecimal92
166CDT09Credit Card count for medical expnvarchar50 Allow NULL? 
167CDA09Credit amount for medical expensedecimal92
168CDT10Credit Card count for medical expnvarchar50 Allow NULL? 
169CDA10Credit amount for medical expensedecimal92
170CDT11Credit Card count for medical expnvarchar50 Allow NULL? 
171CDA11Credit amount for medical expensedecimal92
172CDT12Credit Card count for medical expnvarchar50 Allow NULL? 
173CDA12Credit amount for medical expensedecimal92
174CDT13Credit Card count for medical expnvarchar50 Allow NULL? 
175CDA13Credit amount for medical expensedecimal92
176CDT14Credit Card count for medical expnvarchar50 Allow NULL? 
177CDA14Credit amount for medical expensedecimal92
178CDT15Credit Card count for medical expnvarchar50 Allow NULL? 
179CDA15Credit amount for medical expensedecimal92
180CDT16Credit Card count for medical expnvarchar50 Allow NULL? 
181CDA16Credit amount for medical expensedecimal92
182CDT17Credit Card count for medical expnvarchar50 Allow NULL? 
183CDA17Credit amount for medical expensedecimal92
184CDT18Credit Card count for medical expnvarchar50 Allow NULL? 
185CDA18Credit amount for medical expensedecimal92
186FLNTSFlag for NTS data or otherschar10 Allow NULL? 
187PCD01Proof Code for Medical Expense Classificationchar10 Allow NULL? 
188PCD02Proof Code for Medical Expense Classificationchar10 Allow NULL? 
189PCD03Proof Code for Medical Expense Classificationchar10 Allow NULL? 
190PCD04Proof Code for Medical Expense Classificationchar10 Allow NULL? 
191PCD05Proof Code for Medical Expense Classificationchar10 Allow NULL? 
192PCD06Proof Code for Medical Expense Classificationchar10 Allow NULL? 
193PCD07Proof Code for Medical Expense Classificationchar10 Allow NULL? 
194PCD08Proof Code for Medical Expense Classificationchar10 Allow NULL? 
195PCD09Proof Code for Medical Expense Classificationchar10 Allow NULL? 
196PCD10Proof Code for Medical Expense Classificationchar10 Allow NULL? 
197PCD11Proof Code for Medical Expense Classificationchar10 Allow NULL? 
198PCD12Proof Code for Medical Expense Classificationchar10 Allow NULL? 
199PCD13Proof Code for Medical Expense Classificationchar10 Allow NULL? 
200PCD14Proof Code for Medical Expense Classificationchar10 Allow NULL? 
201PCD15Proof Code for Medical Expense Classificationchar10 Allow NULL? 
202PCD16Proof Code for Medical Expense Classificationchar10 Allow NULL? 
203PCD17Proof Code for Medical Expense Classificationchar10 Allow NULL? 
204PCD18Proof Code for Medical Expense Classificationchar10 Allow NULL? 
205STY01Expense Categorychar10 Allow NULL? 
206STY02Expense Categorychar10 Allow NULL? 
207STY03Expense Categorychar10 Allow NULL? 
208STY04Expense Categorychar10 Allow NULL? 
209STY05Expense Categorychar10 Allow NULL? 
210STY06Expense Categorychar10 Allow NULL? 
211STY07Expense Categorychar10 Allow NULL? 
212STY08Expense Categorychar10 Allow NULL? 
213STY09Expense Categorychar10 Allow NULL? 
214STY10Expense Categorychar10 Allow NULL? 
215STY11Expense Categorychar10 Allow NULL? 
216STY12Expense Categorychar10 Allow NULL? 
217STY13Expense Categorychar10 Allow NULL? 
218STY14Expense Categorychar10 Allow NULL? 
219STY15Expense Categorychar10 Allow NULL? 
220STY16Expense Categorychar10 Allow NULL? 
221STY17Expense Categorychar10 Allow NULL? 
222STY18Expense Categorychar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0812~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT