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 :: Recruitment
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PB00281781HR Master Record: Infotype 0028 (Int. Medical Service)Recruitment
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, EXDAT, LXDAT, RESUL, DIANR, SBJ01, JNF01, NMF01, DTF01, WTF01, SBJ02, JNF02, NMF02, DTF02, WTF02, SBJ03, JNF03, NMF03, DTF03, WTF03, SBJ04, JNF04, NMF04, DTF04, WTF04, SBJ05, JNF05, NMF05, DTF05, WTF05, SBJ06, JNF06, NMF06, DTF06, WTF06, SBJ07, JNF07, NMF07, DTF07, WTF07, SBJ08, JNF08, NMF08, DTF08, WTF08, SBJ09, JNF09, NMF09, DTF09, WTF09, SBJ10, JNF10, NMF10, DTF10, WTF10, SBJ11, JNF11, NMF11, DTF11, WTF11, SBJ12, JNF12, NMF12, DTF12, WTF12, SBJ13, JNF13, NMF13, DTF13, WTF13, SBJ14, JNF14, NMF14, DTF14, WTF14, SBJ15, JNF15, NMF15, DTF15, WTF15, SBJ16, JNF16, NMF16, DTF16, WTF16, SBJ17, JNF17, NMF17, DTF17, WTF17, SBJ18, JNF18, NMF18, DTF18, WTF18, SBJ19, JNF19, NMF19, DTF19, WTF19, SBJ20, JNF20, NMF20, DTF20, WTF20, SBJ21, JNF21, NMF21, DTF21, WTF21, SBJ22, JNF22, NMF22, DTF22, WTF22, SBJ23, JNF23, NMF23, DTF23, WTF23, SBJ24, JNF24, NMF24, DTF24, WTF24, SBJ25, JNF25, NMF25, DTF25, WTF25, SBJ26, JNF26, NMF26, DTF26, WTF26, SBJ27, JNF27, NMF27, DTF27, WTF27, SBJ28, JNF28, NMF28, DTF28, WTF28, SBJ29, JNF29, NMF29, DTF29, WTF29, SBJ30, JNF30, NMF30, DTF30, WTF30, EXTYP FROM PB0028
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2PERNRApplicant 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? 
24EXDATExamination datenvarchar80 Allow NULL? 
25LXDATDate of last examinationnvarchar80 Allow NULL? 
26RESULResultnvarchar20 Allow NULL? 
27DIANRDiagnosis numbernvarchar80 Allow NULL? 
28SBJ01Examination areanvarchar20 Allow NULL? 
29JNF01Yes/No field for internal medical servicechar10 Allow NULL? 
30NMF01Valuedecimal82
31DTF01Examination datenvarchar80 Allow NULL? 
32WTF01Proficiencynvarchar100 Allow NULL? 
33SBJ02Examination areanvarchar20 Allow NULL? 
34JNF02Yes/No field for internal medical servicechar10 Allow NULL? 
35NMF02Valuedecimal82
36DTF02Examination datenvarchar80 Allow NULL? 
37WTF02Proficiencynvarchar100 Allow NULL? 
38SBJ03Examination areanvarchar20 Allow NULL? 
39JNF03Yes/No field for internal medical servicechar10 Allow NULL? 
40NMF03Valuedecimal82
41DTF03Examination datenvarchar80 Allow NULL? 
42WTF03Proficiencynvarchar100 Allow NULL? 
43SBJ04Examination areanvarchar20 Allow NULL? 
44JNF04Yes/No field for internal medical servicechar10 Allow NULL? 
45NMF04Valuedecimal82
46DTF04Examination datenvarchar80 Allow NULL? 
47WTF04Proficiencynvarchar100 Allow NULL? 
48SBJ05Examination areanvarchar20 Allow NULL? 
49JNF05Yes/No field for internal medical servicechar10 Allow NULL? 
50NMF05Valuedecimal82
51DTF05Examination datenvarchar80 Allow NULL? 
52WTF05Proficiencynvarchar100 Allow NULL? 
53SBJ06Examination areanvarchar20 Allow NULL? 
54JNF06Yes/No field for internal medical servicechar10 Allow NULL? 
55NMF06Valuedecimal82
56DTF06Examination datenvarchar80 Allow NULL? 
57WTF06Proficiencynvarchar100 Allow NULL? 
58SBJ07Examination areanvarchar20 Allow NULL? 
59JNF07Yes/No field for internal medical servicechar10 Allow NULL? 
60NMF07Valuedecimal82
61DTF07Examination datenvarchar80 Allow NULL? 
62WTF07Proficiencynvarchar100 Allow NULL? 
63SBJ08Examination areanvarchar20 Allow NULL? 
64JNF08Yes/No field for internal medical servicechar10 Allow NULL? 
65NMF08Valuedecimal82
66DTF08Examination datenvarchar80 Allow NULL? 
67WTF08Proficiencynvarchar100 Allow NULL? 
68SBJ09Examination areanvarchar20 Allow NULL? 
69JNF09Yes/No field for internal medical servicechar10 Allow NULL? 
70NMF09Valuedecimal82
71DTF09Examination datenvarchar80 Allow NULL? 
72WTF09Proficiencynvarchar100 Allow NULL? 
73SBJ10Examination areanvarchar20 Allow NULL? 
74JNF10Yes/No field for internal medical servicechar10 Allow NULL? 
75NMF10Valuedecimal82
76DTF10Examination datenvarchar80 Allow NULL? 
77WTF10Proficiencynvarchar100 Allow NULL? 
78SBJ11Examination areanvarchar20 Allow NULL? 
79JNF11Yes/No field for internal medical servicechar10 Allow NULL? 
80NMF11Valuedecimal82
81DTF11Examination datenvarchar80 Allow NULL? 
82WTF11Proficiencynvarchar100 Allow NULL? 
83SBJ12Examination areanvarchar20 Allow NULL? 
84JNF12Yes/No field for internal medical servicechar10 Allow NULL? 
85NMF12Valuedecimal82
86DTF12Examination datenvarchar80 Allow NULL? 
87WTF12Proficiencynvarchar100 Allow NULL? 
88SBJ13Examination areanvarchar20 Allow NULL? 
89JNF13Yes/No field for internal medical servicechar10 Allow NULL? 
90NMF13Valuedecimal82
91DTF13Examination datenvarchar80 Allow NULL? 
92WTF13Proficiencynvarchar100 Allow NULL? 
93SBJ14Examination areanvarchar20 Allow NULL? 
94JNF14Yes/No field for internal medical servicechar10 Allow NULL? 
95NMF14Valuedecimal82
96DTF14Examination datenvarchar80 Allow NULL? 
97WTF14Proficiencynvarchar100 Allow NULL? 
98SBJ15Examination areanvarchar20 Allow NULL? 
99JNF15Yes/No field for internal medical servicechar10 Allow NULL? 
100NMF15Valuedecimal82
101DTF15Examination datenvarchar80 Allow NULL? 
102WTF15Proficiencynvarchar100 Allow NULL? 
103SBJ16Examination areanvarchar20 Allow NULL? 
104JNF16Yes/No field for internal medical servicechar10 Allow NULL? 
105NMF16Valuedecimal82
106DTF16Examination datenvarchar80 Allow NULL? 
107WTF16Proficiencynvarchar100 Allow NULL? 
108SBJ17Examination areanvarchar20 Allow NULL? 
109JNF17Yes/No field for internal medical servicechar10 Allow NULL? 
110NMF17Valuedecimal82
111DTF17Examination datenvarchar80 Allow NULL? 
112WTF17Proficiencynvarchar100 Allow NULL? 
113SBJ18Examination areanvarchar20 Allow NULL? 
114JNF18Yes/No field for internal medical servicechar10 Allow NULL? 
115NMF18Valuedecimal82
116DTF18Examination datenvarchar80 Allow NULL? 
117WTF18Proficiencynvarchar100 Allow NULL? 
118SBJ19Examination areanvarchar20 Allow NULL? 
119JNF19Yes/No field for internal medical servicechar10 Allow NULL? 
120NMF19Valuedecimal82
121DTF19Examination datenvarchar80 Allow NULL? 
122WTF19Proficiencynvarchar100 Allow NULL? 
123SBJ20Examination areanvarchar20 Allow NULL? 
124JNF20Yes/No field for internal medical servicechar10 Allow NULL? 
125NMF20Valuedecimal82
126DTF20Examination datenvarchar80 Allow NULL? 
127WTF20Proficiencynvarchar100 Allow NULL? 
128SBJ21Examination areanvarchar20 Allow NULL? 
129JNF21Yes/No field for internal medical servicechar10 Allow NULL? 
130NMF21Valuedecimal82
131DTF21Examination datenvarchar80 Allow NULL? 
132WTF21Proficiencynvarchar100 Allow NULL? 
133SBJ22Examination areanvarchar20 Allow NULL? 
134JNF22Yes/No field for internal medical servicechar10 Allow NULL? 
135NMF22Valuedecimal82
136DTF22Examination datenvarchar80 Allow NULL? 
137WTF22Proficiencynvarchar100 Allow NULL? 
138SBJ23Examination areanvarchar20 Allow NULL? 
139JNF23Yes/No field for internal medical servicechar10 Allow NULL? 
140NMF23Valuedecimal82
141DTF23Examination datenvarchar80 Allow NULL? 
142WTF23Proficiencynvarchar100 Allow NULL? 
143SBJ24Examination areanvarchar20 Allow NULL? 
144JNF24Yes/No field for internal medical servicechar10 Allow NULL? 
145NMF24Valuedecimal82
146DTF24Examination datenvarchar80 Allow NULL? 
147WTF24Proficiencynvarchar100 Allow NULL? 
148SBJ25Examination areanvarchar20 Allow NULL? 
149JNF25Yes/No field for internal medical servicechar10 Allow NULL? 
150NMF25Valuedecimal82
151DTF25Examination datenvarchar80 Allow NULL? 
152WTF25Proficiencynvarchar100 Allow NULL? 
153SBJ26Examination areanvarchar20 Allow NULL? 
154JNF26Yes/No field for internal medical servicechar10 Allow NULL? 
155NMF26Valuedecimal82
156DTF26Examination datenvarchar80 Allow NULL? 
157WTF26Proficiencynvarchar100 Allow NULL? 
158SBJ27Examination areanvarchar20 Allow NULL? 
159JNF27Yes/No field for internal medical servicechar10 Allow NULL? 
160NMF27Valuedecimal82
161DTF27Examination datenvarchar80 Allow NULL? 
162WTF27Proficiencynvarchar100 Allow NULL? 
163SBJ28Examination areanvarchar20 Allow NULL? 
164JNF28Yes/No field for internal medical servicechar10 Allow NULL? 
165NMF28Valuedecimal82
166DTF28Examination datenvarchar80 Allow NULL? 
167WTF28Proficiencynvarchar100 Allow NULL? 
168SBJ29Examination areanvarchar20 Allow NULL? 
169JNF29Yes/No field for internal medical servicechar10 Allow NULL? 
170NMF29Valuedecimal82
171DTF29Examination datenvarchar80 Allow NULL? 
172WTF29Proficiencynvarchar100 Allow NULL? 
173SBJ30Examination areanvarchar20 Allow NULL? 
174JNF30Yes/No field for internal medical servicechar10 Allow NULL? 
175NMF30Valuedecimal82
176DTF30Examination datenvarchar80 Allow NULL? 
177WTF30Proficiencynvarchar100 Allow NULL? 
178EXTYPExamination typenvarchar40 Allow NULL? 
NamePrimaryUniqueTypeColumns
PB0028~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT