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 :: Japan
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA05602091HR Master Record: Infotype 0560Japan
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, ANSAL, ANCUR, ADRTE, WAER1, LGA01, BET01, ANZ01, EIN01, OPK01, LGA02, BET02, ANZ02, EIN02, OPK02, LGA03, BET03, ANZ03, EIN03, OPK03, LGA04, BET04, ANZ04, EIN04, OPK04, LGA05, BET05, ANZ05, EIN05, OPK05, LGA06, BET06, ANZ06, EIN06, OPK06, LGA07, BET07, ANZ07, EIN07, OPK07, LGA08, BET08, ANZ08, EIN08, OPK08, LGA09, BET09, ANZ09, EIN09, OPK09, LGA10, BET10, ANZ10, EIN10, OPK10, LGA11, BET11, ANZ11, EIN11, OPK11, LGA12, BET12, ANZ12, EIN12, OPK12, LGA13, BET13, ANZ13, EIN13, OPK13, LGA14, BET14, ANZ14, EIN14, OPK14, LGA15, BET15, ANZ15, EIN15, OPK15, LGA16, BET16, ANZ16, EIN16, OPK16, LGA17, BET17, ANZ17, EIN17, OPK17, LGA18, BET18, ANZ18, EIN18, OPK18, LGA19, BET19, ANZ19, EIN19, OPK19, LGA20, BET20, ANZ20, EIN20, OPK20, WAER2, LGR01, BER01, ANH01, EIH01, OPE01, LGR02, BER02, ANH02, EIH02, OPE02, LGR03, BER03, ANH03, EIH03, OPE03, LGR04, BER04, ANH04, EIH04, OPE04, LGR05, BER05, ANH05, EIH05, OPE05, LGR06, BER06, ANH06, EIH06, OPE06, LGR07, BER07, ANH07, EIH07, OPE07, LGR08, BER08, ANH08, EIH08, OPE08, LGR09, BER09, ANH09, EIH09, OPE09, LGR10, BER10, ANH10, EIH10, OPE10, IND01, IND02, IND03, IND04, IND05, IND06, IND07, IND08, IND09, IND10, IND11, IND12, IND13, IND14, IND15, IND16, IND17, IND18, IND19, IND20, INB01, INB02, INB03, INB04, INB05, INB06, INB07, INB08, INB09, INB10, PYCLS FROM PA0560
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? 
24ANSALAnnual salarydecimal152
25ANCURCurrency Key for Annual Salarynvarchar50 Allow NULL? 
26ADRTEAssumed domestic deduction rate (Overseas salary) JPdecimal42
27WAER1Currency Keynvarchar50 Allow NULL? 
28LGA01Wage Typenvarchar40 Allow NULL? 
29BET01Wage Type Amount for Paymentsdecimal132
30ANZ01Numberdecimal72
31EIN01Time/Measurement Unitnvarchar30 Allow NULL? 
32OPK01Operation Indicator for Wage Typeschar10 Allow NULL? 
33LGA02Wage Typenvarchar40 Allow NULL? 
34BET02Wage Type Amount for Paymentsdecimal132
35ANZ02Numberdecimal72
36EIN02Time/Measurement Unitnvarchar30 Allow NULL? 
37OPK02Operation Indicator for Wage Typeschar10 Allow NULL? 
38LGA03Wage Typenvarchar40 Allow NULL? 
39BET03Wage Type Amount for Paymentsdecimal132
40ANZ03Numberdecimal72
41EIN03Time/Measurement Unitnvarchar30 Allow NULL? 
42OPK03Operation Indicator for Wage Typeschar10 Allow NULL? 
43LGA04Wage Typenvarchar40 Allow NULL? 
44BET04Wage Type Amount for Paymentsdecimal132
45ANZ04Numberdecimal72
46EIN04Time/Measurement Unitnvarchar30 Allow NULL? 
47OPK04Operation Indicator for Wage Typeschar10 Allow NULL? 
48LGA05Wage Typenvarchar40 Allow NULL? 
49BET05Wage Type Amount for Paymentsdecimal132
50ANZ05Numberdecimal72
51EIN05Time/Measurement Unitnvarchar30 Allow NULL? 
52OPK05Operation Indicator for Wage Typeschar10 Allow NULL? 
53LGA06Wage Typenvarchar40 Allow NULL? 
54BET06Wage Type Amount for Paymentsdecimal132
55ANZ06Numberdecimal72
56EIN06Time/Measurement Unitnvarchar30 Allow NULL? 
57OPK06Operation Indicator for Wage Typeschar10 Allow NULL? 
58LGA07Wage Typenvarchar40 Allow NULL? 
59BET07Wage Type Amount for Paymentsdecimal132
60ANZ07Numberdecimal72
61EIN07Time/Measurement Unitnvarchar30 Allow NULL? 
62OPK07Operation Indicator for Wage Typeschar10 Allow NULL? 
63LGA08Wage Typenvarchar40 Allow NULL? 
64BET08Wage Type Amount for Paymentsdecimal132
65ANZ08Numberdecimal72
66EIN08Time/Measurement Unitnvarchar30 Allow NULL? 
67OPK08Operation Indicator for Wage Typeschar10 Allow NULL? 
68LGA09Wage Typenvarchar40 Allow NULL? 
69BET09Wage Type Amount for Paymentsdecimal132
70ANZ09Numberdecimal72
71EIN09Time/Measurement Unitnvarchar30 Allow NULL? 
72OPK09Operation Indicator for Wage Typeschar10 Allow NULL? 
73LGA10Wage Typenvarchar40 Allow NULL? 
74BET10Wage Type Amount for Paymentsdecimal132
75ANZ10Numberdecimal72
76EIN10Time/Measurement Unitnvarchar30 Allow NULL? 
77OPK10Operation Indicator for Wage Typeschar10 Allow NULL? 
78LGA11Wage Typenvarchar40 Allow NULL? 
79BET11Wage Type Amount for Paymentsdecimal132
80ANZ11Numberdecimal72
81EIN11Time/Measurement Unitnvarchar30 Allow NULL? 
82OPK11Operation Indicator for Wage Typeschar10 Allow NULL? 
83LGA12Wage Typenvarchar40 Allow NULL? 
84BET12Wage Type Amount for Paymentsdecimal132
85ANZ12Numberdecimal72
86EIN12Time/Measurement Unitnvarchar30 Allow NULL? 
87OPK12Operation Indicator for Wage Typeschar10 Allow NULL? 
88LGA13Wage Typenvarchar40 Allow NULL? 
89BET13Wage Type Amount for Paymentsdecimal132
90ANZ13Numberdecimal72
91EIN13Time/Measurement Unitnvarchar30 Allow NULL? 
92OPK13Operation Indicator for Wage Typeschar10 Allow NULL? 
93LGA14Wage Typenvarchar40 Allow NULL? 
94BET14Wage Type Amount for Paymentsdecimal132
95ANZ14Numberdecimal72
96EIN14Time/Measurement Unitnvarchar30 Allow NULL? 
97OPK14Operation Indicator for Wage Typeschar10 Allow NULL? 
98LGA15Wage Typenvarchar40 Allow NULL? 
99BET15Wage Type Amount for Paymentsdecimal132
100ANZ15Numberdecimal72
101EIN15Time/Measurement Unitnvarchar30 Allow NULL? 
102OPK15Operation Indicator for Wage Typeschar10 Allow NULL? 
103LGA16Wage Typenvarchar40 Allow NULL? 
104BET16Wage Type Amount for Paymentsdecimal132
105ANZ16Numberdecimal72
106EIN16Time/Measurement Unitnvarchar30 Allow NULL? 
107OPK16Operation Indicator for Wage Typeschar10 Allow NULL? 
108LGA17Wage Typenvarchar40 Allow NULL? 
109BET17Wage Type Amount for Paymentsdecimal132
110ANZ17Numberdecimal72
111EIN17Time/Measurement Unitnvarchar30 Allow NULL? 
112OPK17Operation Indicator for Wage Typeschar10 Allow NULL? 
113LGA18Wage Typenvarchar40 Allow NULL? 
114BET18Wage Type Amount for Paymentsdecimal132
115ANZ18Numberdecimal72
116EIN18Time/Measurement Unitnvarchar30 Allow NULL? 
117OPK18Operation Indicator for Wage Typeschar10 Allow NULL? 
118LGA19Wage Typenvarchar40 Allow NULL? 
119BET19Wage Type Amount for Paymentsdecimal132
120ANZ19Numberdecimal72
121EIN19Time/Measurement Unitnvarchar30 Allow NULL? 
122OPK19Operation Indicator for Wage Typeschar10 Allow NULL? 
123LGA20Wage Typenvarchar40 Allow NULL? 
124BET20Wage Type Amount for Paymentsdecimal132
125ANZ20Numberdecimal72
126EIN20Time/Measurement Unitnvarchar30 Allow NULL? 
127OPK20Operation Indicator for Wage Typeschar10 Allow NULL? 
128WAER2Currency Keynvarchar50 Allow NULL? 
129LGR01Wage Typenvarchar40 Allow NULL? 
130BER01Wage Type Amount for Paymentsdecimal132
131ANH01Numberdecimal72
132EIH01Time/Measurement Unitnvarchar30 Allow NULL? 
133OPE01Operation Indicator for Wage Typeschar10 Allow NULL? 
134LGR02Wage Typenvarchar40 Allow NULL? 
135BER02Wage Type Amount for Paymentsdecimal132
136ANH02Numberdecimal72
137EIH02Time/Measurement Unitnvarchar30 Allow NULL? 
138OPE02Operation Indicator for Wage Typeschar10 Allow NULL? 
139LGR03Wage Typenvarchar40 Allow NULL? 
140BER03Wage Type Amount for Paymentsdecimal132
141ANH03Numberdecimal72
142EIH03Time/Measurement Unitnvarchar30 Allow NULL? 
143OPE03Operation Indicator for Wage Typeschar10 Allow NULL? 
144LGR04Wage Typenvarchar40 Allow NULL? 
145BER04Wage Type Amount for Paymentsdecimal132
146ANH04Numberdecimal72
147EIH04Time/Measurement Unitnvarchar30 Allow NULL? 
148OPE04Operation Indicator for Wage Typeschar10 Allow NULL? 
149LGR05Wage Typenvarchar40 Allow NULL? 
150BER05Wage Type Amount for Paymentsdecimal132
151ANH05Numberdecimal72
152EIH05Time/Measurement Unitnvarchar30 Allow NULL? 
153OPE05Operation Indicator for Wage Typeschar10 Allow NULL? 
154LGR06Wage Typenvarchar40 Allow NULL? 
155BER06Wage Type Amount for Paymentsdecimal132
156ANH06Numberdecimal72
157EIH06Time/Measurement Unitnvarchar30 Allow NULL? 
158OPE06Operation Indicator for Wage Typeschar10 Allow NULL? 
159LGR07Wage Typenvarchar40 Allow NULL? 
160BER07Wage Type Amount for Paymentsdecimal132
161ANH07Numberdecimal72
162EIH07Time/Measurement Unitnvarchar30 Allow NULL? 
163OPE07Operation Indicator for Wage Typeschar10 Allow NULL? 
164LGR08Wage Typenvarchar40 Allow NULL? 
165BER08Wage Type Amount for Paymentsdecimal132
166ANH08Numberdecimal72
167EIH08Time/Measurement Unitnvarchar30 Allow NULL? 
168OPE08Operation Indicator for Wage Typeschar10 Allow NULL? 
169LGR09Wage Typenvarchar40 Allow NULL? 
170BER09Wage Type Amount for Paymentsdecimal132
171ANH09Numberdecimal72
172EIH09Time/Measurement Unitnvarchar30 Allow NULL? 
173OPE09Operation Indicator for Wage Typeschar10 Allow NULL? 
174LGR10Wage Typenvarchar40 Allow NULL? 
175BER10Wage Type Amount for Paymentsdecimal132
176ANH10Numberdecimal72
177EIH10Time/Measurement Unitnvarchar30 Allow NULL? 
178OPE10Operation Indicator for Wage Typeschar10 Allow NULL? 
179IND01Indicator for indirect valuationchar10 Allow NULL? 
180IND02Indicator for indirect valuationchar10 Allow NULL? 
181IND03Indicator for indirect valuationchar10 Allow NULL? 
182IND04Indicator for indirect valuationchar10 Allow NULL? 
183IND05Indicator for indirect valuationchar10 Allow NULL? 
184IND06Indicator for indirect valuationchar10 Allow NULL? 
185IND07Indicator for indirect valuationchar10 Allow NULL? 
186IND08Indicator for indirect valuationchar10 Allow NULL? 
187IND09Indicator for indirect valuationchar10 Allow NULL? 
188IND10Indicator for indirect valuationchar10 Allow NULL? 
189IND11Indicator for indirect valuationchar10 Allow NULL? 
190IND12Indicator for indirect valuationchar10 Allow NULL? 
191IND13Indicator for indirect valuationchar10 Allow NULL? 
192IND14Indicator for indirect valuationchar10 Allow NULL? 
193IND15Indicator for indirect valuationchar10 Allow NULL? 
194IND16Indicator for indirect valuationchar10 Allow NULL? 
195IND17Indicator for indirect valuationchar10 Allow NULL? 
196IND18Indicator for indirect valuationchar10 Allow NULL? 
197IND19Indicator for indirect valuationchar10 Allow NULL? 
198IND20Indicator for indirect valuationchar10 Allow NULL? 
199INB01Indicator for indirect valuationchar10 Allow NULL? 
200INB02Indicator for indirect valuationchar10 Allow NULL? 
201INB03Indicator for indirect valuationchar10 Allow NULL? 
202INB04Indicator for indirect valuationchar10 Allow NULL? 
203INB05Indicator for indirect valuationchar10 Allow NULL? 
204INB06Indicator for indirect valuationchar10 Allow NULL? 
205INB07Indicator for indirect valuationchar10 Allow NULL? 
206INB08Indicator for indirect valuationchar10 Allow NULL? 
207INB09Indicator for indirect valuationchar10 Allow NULL? 
208INB10Indicator for indirect valuationchar10 Allow NULL? 
209PYCLSPayment classchar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0560~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT