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.0PA00272461HR Master Record: Infotype 0027 (Cost Distribution)Personnel 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, KSTAR, KBU01, KGB01, KST01, KPR01, KBU02, KGB02, KST02, KPR02, KBU03, KGB03, KST03, KPR03, KBU04, KGB04, KST04, KPR04, KBU05, KGB05, KST05, KPR05, KBU06, KGB06, KST06, KPR06, KBU07, KGB07, KST07, KPR07, KBU08, KGB08, KST08, KPR08, KBU09, KGB09, KST09, KPR09, KBU10, KGB10, KST10, KPR10, KBU11, KGB11, KST11, KPR11, KBU12, KGB12, KST12, KPR12, KBU13, KGB13, KST13, KPR13, KBU14, KGB14, KST14, KPR14, KBU15, KGB15, KST15, KPR15, KBU16, KGB16, KST16, KPR16, KBU17, KGB17, KST17, KPR17, KBU18, KGB18, KST18, KPR18, KBU19, KGB19, KST19, KPR19, KBU20, KGB20, KST20, KPR20, KBU21, KGB21, KST21, KPR21, KBU22, KGB22, KST22, KPR22, KBU23, KGB23, KST23, KPR23, KBU24, KGB24, KST24, KPR24, KBU25, KGB25, KST25, KPR25, FCT01, FCD01, FKBER01, GRANT01, FCT02, FCD02, FKBER02, GRANT02, FCT03, FCD03, FKBER03, GRANT03, FCT04, FCD04, FKBER04, GRANT04, FCT05, FCD05, FKBER05, GRANT05, FCT06, FCD06, FKBER06, GRANT06, FCT07, FCD07, FKBER07, GRANT07, FCT08, FCD08, FKBER08, GRANT08, FCT09, FCD09, FKBER09, GRANT09, FCT10, FCD10, FKBER10, GRANT10, FCT11, FCD11, FKBER11, GRANT11, FCT12, FCD12, FKBER12, GRANT12, AUF01, AUF02, AUF03, AUF04, AUF05, AUF06, AUF07, AUF08, AUF09, AUF10, AUF11, AUF12, AUF13, AUF14, AUF15, AUF16, AUF17, AUF18, AUF19, AUF20, AUF21, AUF22, AUF23, AUF24, AUF25, PSP01, PSP02, PSP03, PSP04, PSP05, PSP06, PSP07, PSP08, PSP09, PSP10, PSP11, PSP12, PSP13, PSP14, PSP15, PSP16, PSP17, PSP18, PSP19, PSP20, PSP21, PSP22, PSP23, PSP24, PSP25, SGM01, SGM02, SGM03, SGM04, SGM05, SGM06, SGM07, SGM08, SGM09, SGM10, SGM11, SGM12, BUDGET_PD01, BUDGET_PD02, BUDGET_PD03, BUDGET_PD04, BUDGET_PD05, BUDGET_PD06, BUDGET_PD07, BUDGET_PD08, BUDGET_PD09, BUDGET_PD10, BUDGET_PD11, BUDGET_PD12 FROM PA0027
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? 
24KSTARCosts to be distributednvarchar40 Allow NULL? 
25KBU01Company Codenvarchar40 Allow NULL? 
26KGB01Business Areanvarchar40 Allow NULL? 
27KST01Cost Centernvarchar100 Allow NULL? 
28KPR01Cost center percentagedecimal52
29KBU02Company Codenvarchar40 Allow NULL? 
30KGB02Business Areanvarchar40 Allow NULL? 
31KST02Cost Centernvarchar100 Allow NULL? 
32KPR02Cost center percentagedecimal52
33KBU03Company Codenvarchar40 Allow NULL? 
34KGB03Business Areanvarchar40 Allow NULL? 
35KST03Cost Centernvarchar100 Allow NULL? 
36KPR03Cost center percentagedecimal52
37KBU04Company Codenvarchar40 Allow NULL? 
38KGB04Business Areanvarchar40 Allow NULL? 
39KST04Cost Centernvarchar100 Allow NULL? 
40KPR04Cost center percentagedecimal52
41KBU05Company Codenvarchar40 Allow NULL? 
42KGB05Business Areanvarchar40 Allow NULL? 
43KST05Cost Centernvarchar100 Allow NULL? 
44KPR05Cost center percentagedecimal52
45KBU06Company Codenvarchar40 Allow NULL? 
46KGB06Business Areanvarchar40 Allow NULL? 
47KST06Cost Centernvarchar100 Allow NULL? 
48KPR06Cost center percentagedecimal52
49KBU07Company Codenvarchar40 Allow NULL? 
50KGB07Business Areanvarchar40 Allow NULL? 
51KST07Cost Centernvarchar100 Allow NULL? 
52KPR07Cost center percentagedecimal52
53KBU08Company Codenvarchar40 Allow NULL? 
54KGB08Business Areanvarchar40 Allow NULL? 
55KST08Cost Centernvarchar100 Allow NULL? 
56KPR08Cost center percentagedecimal52
57KBU09Company Codenvarchar40 Allow NULL? 
58KGB09Business Areanvarchar40 Allow NULL? 
59KST09Cost Centernvarchar100 Allow NULL? 
60KPR09Cost center percentagedecimal52
61KBU10Company Codenvarchar40 Allow NULL? 
62KGB10Business Areanvarchar40 Allow NULL? 
63KST10Cost Centernvarchar100 Allow NULL? 
64KPR10Cost center percentagedecimal52
65KBU11Company Codenvarchar40 Allow NULL? 
66KGB11Business Areanvarchar40 Allow NULL? 
67KST11Cost Centernvarchar100 Allow NULL? 
68KPR11Cost center percentagedecimal52
69KBU12Company Codenvarchar40 Allow NULL? 
70KGB12Business Areanvarchar40 Allow NULL? 
71KST12Cost Centernvarchar100 Allow NULL? 
72KPR12Cost center percentagedecimal52
73KBU13Company Codenvarchar40 Allow NULL? 
74KGB13Business Areanvarchar40 Allow NULL? 
75KST13Cost Centernvarchar100 Allow NULL? 
76KPR13Cost center percentagedecimal52
77KBU14Company Codenvarchar40 Allow NULL? 
78KGB14Business Areanvarchar40 Allow NULL? 
79KST14Cost Centernvarchar100 Allow NULL? 
80KPR14Cost center percentagedecimal52
81KBU15Company Codenvarchar40 Allow NULL? 
82KGB15Business Areanvarchar40 Allow NULL? 
83KST15Cost Centernvarchar100 Allow NULL? 
84KPR15Cost center percentagedecimal52
85KBU16Company Codenvarchar40 Allow NULL? 
86KGB16Business Areanvarchar40 Allow NULL? 
87KST16Cost Centernvarchar100 Allow NULL? 
88KPR16Cost center percentagedecimal52
89KBU17Company Codenvarchar40 Allow NULL? 
90KGB17Business Areanvarchar40 Allow NULL? 
91KST17Cost Centernvarchar100 Allow NULL? 
92KPR17Cost center percentagedecimal52
93KBU18Company Codenvarchar40 Allow NULL? 
94KGB18Business Areanvarchar40 Allow NULL? 
95KST18Cost Centernvarchar100 Allow NULL? 
96KPR18Cost center percentagedecimal52
97KBU19Company Codenvarchar40 Allow NULL? 
98KGB19Business Areanvarchar40 Allow NULL? 
99KST19Cost Centernvarchar100 Allow NULL? 
100KPR19Cost center percentagedecimal52
101KBU20Company Codenvarchar40 Allow NULL? 
102KGB20Business Areanvarchar40 Allow NULL? 
103KST20Cost Centernvarchar100 Allow NULL? 
104KPR20Cost center percentagedecimal52
105KBU21Company Codenvarchar40 Allow NULL? 
106KGB21Business Areanvarchar40 Allow NULL? 
107KST21Cost Centernvarchar100 Allow NULL? 
108KPR21Cost center percentagedecimal52
109KBU22Company Codenvarchar40 Allow NULL? 
110KGB22Business Areanvarchar40 Allow NULL? 
111KST22Cost Centernvarchar100 Allow NULL? 
112KPR22Cost center percentagedecimal52
113KBU23Company Codenvarchar40 Allow NULL? 
114KGB23Business Areanvarchar40 Allow NULL? 
115KST23Cost Centernvarchar100 Allow NULL? 
116KPR23Cost center percentagedecimal52
117KBU24Company Codenvarchar40 Allow NULL? 
118KGB24Business Areanvarchar40 Allow NULL? 
119KST24Cost Centernvarchar100 Allow NULL? 
120KPR24Cost center percentagedecimal52
121KBU25Company Codenvarchar40 Allow NULL? 
122KGB25Business Areanvarchar40 Allow NULL? 
123KST25Cost Centernvarchar100 Allow NULL? 
124KPR25Cost center percentagedecimal52
125FCT01Funds Centernvarchar160 Allow NULL? 
126FCD01Fundnvarchar100 Allow NULL? 
127FKBER01Functional Areanvarchar160 Allow NULL? 
128GRANT01Grantnvarchar200 Allow NULL? 
129FCT02Funds Centernvarchar160 Allow NULL? 
130FCD02Fundnvarchar100 Allow NULL? 
131FKBER02Functional Areanvarchar160 Allow NULL? 
132GRANT02Grantnvarchar200 Allow NULL? 
133FCT03Funds Centernvarchar160 Allow NULL? 
134FCD03Fundnvarchar100 Allow NULL? 
135FKBER03Functional Areanvarchar160 Allow NULL? 
136GRANT03Grantnvarchar200 Allow NULL? 
137FCT04Funds Centernvarchar160 Allow NULL? 
138FCD04Fundnvarchar100 Allow NULL? 
139FKBER04Functional Areanvarchar160 Allow NULL? 
140GRANT04Grantnvarchar200 Allow NULL? 
141FCT05Funds Centernvarchar160 Allow NULL? 
142FCD05Fundnvarchar100 Allow NULL? 
143FKBER05Functional Areanvarchar160 Allow NULL? 
144GRANT05Grantnvarchar200 Allow NULL? 
145FCT06Funds Centernvarchar160 Allow NULL? 
146FCD06Fundnvarchar100 Allow NULL? 
147FKBER06Functional Areanvarchar160 Allow NULL? 
148GRANT06Grantnvarchar200 Allow NULL? 
149FCT07Funds Centernvarchar160 Allow NULL? 
150FCD07Fundnvarchar100 Allow NULL? 
151FKBER07Functional Areanvarchar160 Allow NULL? 
152GRANT07Grantnvarchar200 Allow NULL? 
153FCT08Funds Centernvarchar160 Allow NULL? 
154FCD08Fundnvarchar100 Allow NULL? 
155FKBER08Functional Areanvarchar160 Allow NULL? 
156GRANT08Grantnvarchar200 Allow NULL? 
157FCT09Funds Centernvarchar160 Allow NULL? 
158FCD09Fundnvarchar100 Allow NULL? 
159FKBER09Functional Areanvarchar160 Allow NULL? 
160GRANT09Grantnvarchar200 Allow NULL? 
161FCT10Funds Centernvarchar160 Allow NULL? 
162FCD10Fundnvarchar100 Allow NULL? 
163FKBER10Functional Areanvarchar160 Allow NULL? 
164GRANT10Grantnvarchar200 Allow NULL? 
165FCT11Funds Centernvarchar160 Allow NULL? 
166FCD11Fundnvarchar100 Allow NULL? 
167FKBER11Functional Areanvarchar160 Allow NULL? 
168GRANT11Grantnvarchar200 Allow NULL? 
169FCT12Funds Centernvarchar160 Allow NULL? 
170FCD12Fundnvarchar100 Allow NULL? 
171FKBER12Functional Areanvarchar160 Allow NULL? 
172GRANT12Grantnvarchar200 Allow NULL? 
173AUF01Order Numbernvarchar120 Allow NULL? 
174AUF02Order Numbernvarchar120 Allow NULL? 
175AUF03Order Numbernvarchar120 Allow NULL? 
176AUF04Order Numbernvarchar120 Allow NULL? 
177AUF05Order Numbernvarchar120 Allow NULL? 
178AUF06Order Numbernvarchar120 Allow NULL? 
179AUF07Order Numbernvarchar120 Allow NULL? 
180AUF08Order Numbernvarchar120 Allow NULL? 
181AUF09Order Numbernvarchar120 Allow NULL? 
182AUF10Order Numbernvarchar120 Allow NULL? 
183AUF11Order Numbernvarchar120 Allow NULL? 
184AUF12Order Numbernvarchar120 Allow NULL? 
185AUF13Order Numbernvarchar120 Allow NULL? 
186AUF14Order Numbernvarchar120 Allow NULL? 
187AUF15Order Numbernvarchar120 Allow NULL? 
188AUF16Order Numbernvarchar120 Allow NULL? 
189AUF17Order Numbernvarchar120 Allow NULL? 
190AUF18Order Numbernvarchar120 Allow NULL? 
191AUF19Order Numbernvarchar120 Allow NULL? 
192AUF20Order Numbernvarchar120 Allow NULL? 
193AUF21Order Numbernvarchar120 Allow NULL? 
194AUF22Order Numbernvarchar120 Allow NULL? 
195AUF23Order Numbernvarchar120 Allow NULL? 
196AUF24Order Numbernvarchar120 Allow NULL? 
197AUF25Order Numbernvarchar120 Allow NULL? 
198PSP01Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
199PSP02Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
200PSP03Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
201PSP04Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
202PSP05Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
203PSP06Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
204PSP07Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
205PSP08Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
206PSP09Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
207PSP10Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
208PSP11Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
209PSP12Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
210PSP13Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
211PSP14Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
212PSP15Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
213PSP16Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
214PSP17Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
215PSP18Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
216PSP19Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
217PSP20Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
218PSP21Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
219PSP22Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
220PSP23Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
221PSP24Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
222PSP25Work Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
223SGM01Segment for Segmental Reportingnvarchar100 Allow NULL? 
224SGM02Segment for Segmental Reportingnvarchar100 Allow NULL? 
225SGM03Segment for Segmental Reportingnvarchar100 Allow NULL? 
226SGM04Segment for Segmental Reportingnvarchar100 Allow NULL? 
227SGM05Segment for Segmental Reportingnvarchar100 Allow NULL? 
228SGM06Segment for Segmental Reportingnvarchar100 Allow NULL? 
229SGM07Segment for Segmental Reportingnvarchar100 Allow NULL? 
230SGM08Segment for Segmental Reportingnvarchar100 Allow NULL? 
231SGM09Segment for Segmental Reportingnvarchar100 Allow NULL? 
232SGM10Segment for Segmental Reportingnvarchar100 Allow NULL? 
233SGM11Segment for Segmental Reportingnvarchar100 Allow NULL? 
234SGM12Segment for Segmental Reportingnvarchar100 Allow NULL? 
235BUDGET_PD01FM: Budget Periodnvarchar100 Allow NULL? 
236BUDGET_PD02FM: Budget Periodnvarchar100 Allow NULL? 
237BUDGET_PD03FM: Budget Periodnvarchar100 Allow NULL? 
238BUDGET_PD04FM: Budget Periodnvarchar100 Allow NULL? 
239BUDGET_PD05FM: Budget Periodnvarchar100 Allow NULL? 
240BUDGET_PD06FM: Budget Periodnvarchar100 Allow NULL? 
241BUDGET_PD07FM: Budget Periodnvarchar100 Allow NULL? 
242BUDGET_PD08FM: Budget Periodnvarchar100 Allow NULL? 
243BUDGET_PD09FM: Budget Periodnvarchar100 Allow NULL? 
244BUDGET_PD10FM: Budget Periodnvarchar100 Allow NULL? 
245BUDGET_PD11FM: Budget Periodnvarchar100 Allow NULL? 
246BUDGET_PD12FM: Budget Periodnvarchar100 Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0027~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT