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 :: Benefits
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA01692351HR Master Record: Infotype 0169 (Savings Plan)Benefits
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, BAREA, PLTYP, BPLAN, BENGR, BSTAT, ELIDT, ELDTO, PARDT, ENRTY, EVENT, PERIO, EEAMT, EEPCT, EEUNT, PTAMT, PTPCT, PTUNT, PSTTX, ROLLO, BCAMT, BCPCT, BCUNT, BPAMT, BPPCT, BPUNT, BPTTX, BROLL, SPADT, PAAMT, ACCTN, LIFEL, ITS01, DTY01, DID01, BPT01, ITS02, DTY02, DID02, BPT02, ITS03, DTY03, DID03, BPT03, ITS04, DTY04, DID04, BPT04, ITS05, DTY05, DID05, BPT05, ITS06, DTY06, DID06, BPT06, ITS07, DTY07, DID07, BPT07, ITS08, DTY08, DID08, BPT08, ITS09, DTY09, DID09, BPT09, ITS10, DTY10, DID10, BPT10, ITS11, DTY11, DID11, BPT11, ITS12, DTY12, DID12, BPT12, ITS13, DTY13, DID13, BPT13, ITS14, DTY14, DID14, BPT14, ITS15, DTY15, DID15, BPT15, ITS16, DTY16, DID16, BPT16, ITS17, DTY17, DID17, BPT17, ITS18, DTY18, DID18, BPT18, ITS19, DTY19, DID19, BPT19, ITS20, DTY20, DID20, BPT20, CIS01, CTY01, CID01, CPT01, CIS02, CTY02, CID02, CPT02, CIS03, CTY03, CID03, CPT03, CIS04, CTY04, CID04, CPT04, CIS05, CTY05, CID05, CPT05, CIS06, CTY06, CID06, CPT06, CIS07, CTY07, CID07, CPT07, CIS08, CTY08, CID08, CPT08, CIS09, CTY09, CID09, CPT09, CIS10, CTY10, CID10, CPT10, CURRE, INV01, IPT01, IAM01, INV02, IPT02, IAM02, INV03, IPT03, IAM03, INV04, IPT04, IAM04, INV05, IPT05, IAM05, INV06, IPT06, IAM06, INV07, IPT07, IAM07, INV08, IPT08, IAM08, INV09, IPT09, IAM09, INV10, IPT10, IAM10, INV11, IPT11, IAM11, INV12, IPT12, IAM12, INV13, IPT13, IAM13, INV14, IPT14, IAM14, INV15, IPT15, IAM15, INV16, IPT16, IAM16, INV17, IPT17, IAM17, INV18, IPT18, IAM18, INV19, IPT19, IAM19, INV20, IPT20, IAM20 FROM PA0169
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? 
24BAREABenefit areanvarchar20 Allow NULL? 
25PLTYPBenefit plan typenvarchar40 Allow NULL? 
26BPLANBenefit plannvarchar40 Allow NULL? 
27BENGRBenefit First Program Groupingnvarchar40 Allow NULL? 
28BSTATBenefit Second Program Groupingnvarchar40 Allow NULL? 
29ELIDTBenefit calculated eligibility datenvarchar80 Allow NULL? 
30ELDTOBenefit override eligibility datenvarchar80 Allow NULL? 
31PARDTBenefit date of first participation in plannvarchar80 Allow NULL? 
32ENRTYBenefit Type of Plan Enrollmentchar10 Allow NULL? 
33EVENTBenefit adjustment reasonnvarchar40 Allow NULL? 
34PERIOBenefit Period for Calculationsnvarchar20 Allow NULL? 
35EEAMTBenefit Employee Pre-Tax Contribution Amountdecimal132
36EEPCTBenefit EE Pre-Tax Contribution Percentagedecimal52
37EEUNTBenefit Employee Pre-Tax Contribution Number of Unitsdecimal90
38PTAMTBenefit EE Post-Tax Contribution Amountdecimal132
39PTPCTBenefit EE Post-Tax Contribution Percentagedecimal52
40PTUNTBenefit EE Post-Tax Contribution Number of Unitsdecimal90
41PSTTXBenefit Indicator Start Post-Tax Contribution Deduct. Immed.char10 Allow NULL? 
42ROLLOBenefit Indicator Pre-Tax Is Rolled Over to Post-Taxchar10 Allow NULL? 
43BCAMTBenefit Employee Pre-Tax Contribution Amount for Bonusdecimal132
44BCPCTBenefit Employee Pre-Tax Contribution Percentage for Bonusdecimal52
45BCUNTBenefit EE Pre-Tax Contribution Number of Units for Bonusdecimal90
46BPAMTBenefit Employee Post-Tax Contribution Amount for Bonusdecimal132
47BPPCTBenefit Employee Post-Tax Contribution Percentage for Bonusdecimal52
48BPUNTBenefit EE Post-Tax Contr. Number of Units for Bonusdecimal90
49BPTTXBenefit Start Bonus Post-Tax Contribution Deduction Immed.char10 Allow NULL? 
50BROLLBenefit Indicator Pre-Tax Is Rolled Over (Bonus)char10 Allow NULL? 
51SPADTBenefit Date of Spouse's Approvalnvarchar80 Allow NULL? 
52PAAMTBenefit Pension Adjustment Amountdecimal132
53ACCTNBenefit Account numbernvarchar200 Allow NULL? 
54LIFELBenefit Lifetime Contribution Limitdecimal152
55ITS01Benefit Infotype Switchchar10 Allow NULL? 
56DTY01Benefit dependent typenvarchar40 Allow NULL? 
57DID01Benefit dependent object IDnvarchar20 Allow NULL? 
58BPT01Benefit Payout Percentage for Beneficiariesdecimal30
59ITS02Benefit Infotype Switchchar10 Allow NULL? 
60DTY02Benefit dependent typenvarchar40 Allow NULL? 
61DID02Benefit dependent object IDnvarchar20 Allow NULL? 
62BPT02Benefit Payout Percentage for Beneficiariesdecimal30
63ITS03Benefit Infotype Switchchar10 Allow NULL? 
64DTY03Benefit dependent typenvarchar40 Allow NULL? 
65DID03Benefit dependent object IDnvarchar20 Allow NULL? 
66BPT03Benefit Payout Percentage for Beneficiariesdecimal30
67ITS04Benefit Infotype Switchchar10 Allow NULL? 
68DTY04Benefit dependent typenvarchar40 Allow NULL? 
69DID04Benefit dependent object IDnvarchar20 Allow NULL? 
70BPT04Benefit Payout Percentage for Beneficiariesdecimal30
71ITS05Benefit Infotype Switchchar10 Allow NULL? 
72DTY05Benefit dependent typenvarchar40 Allow NULL? 
73DID05Benefit dependent object IDnvarchar20 Allow NULL? 
74BPT05Benefit Payout Percentage for Beneficiariesdecimal30
75ITS06Benefit Infotype Switchchar10 Allow NULL? 
76DTY06Benefit dependent typenvarchar40 Allow NULL? 
77DID06Benefit dependent object IDnvarchar20 Allow NULL? 
78BPT06Benefit Payout Percentage for Beneficiariesdecimal30
79ITS07Benefit Infotype Switchchar10 Allow NULL? 
80DTY07Benefit dependent typenvarchar40 Allow NULL? 
81DID07Benefit dependent object IDnvarchar20 Allow NULL? 
82BPT07Benefit Payout Percentage for Beneficiariesdecimal30
83ITS08Benefit Infotype Switchchar10 Allow NULL? 
84DTY08Benefit dependent typenvarchar40 Allow NULL? 
85DID08Benefit dependent object IDnvarchar20 Allow NULL? 
86BPT08Benefit Payout Percentage for Beneficiariesdecimal30
87ITS09Benefit Infotype Switchchar10 Allow NULL? 
88DTY09Benefit dependent typenvarchar40 Allow NULL? 
89DID09Benefit dependent object IDnvarchar20 Allow NULL? 
90BPT09Benefit Payout Percentage for Beneficiariesdecimal30
91ITS10Benefit Infotype Switchchar10 Allow NULL? 
92DTY10Benefit dependent typenvarchar40 Allow NULL? 
93DID10Benefit dependent object IDnvarchar20 Allow NULL? 
94BPT10Benefit Payout Percentage for Beneficiariesdecimal30
95ITS11Benefit Infotype Switchchar10 Allow NULL? 
96DTY11Benefit dependent typenvarchar40 Allow NULL? 
97DID11Benefit dependent object IDnvarchar20 Allow NULL? 
98BPT11Benefit Payout Percentage for Beneficiariesdecimal30
99ITS12Benefit Infotype Switchchar10 Allow NULL? 
100DTY12Benefit dependent typenvarchar40 Allow NULL? 
101DID12Benefit dependent object IDnvarchar20 Allow NULL? 
102BPT12Benefit Payout Percentage for Beneficiariesdecimal30
103ITS13Benefit Infotype Switchchar10 Allow NULL? 
104DTY13Benefit dependent typenvarchar40 Allow NULL? 
105DID13Benefit dependent object IDnvarchar20 Allow NULL? 
106BPT13Benefit Payout Percentage for Beneficiariesdecimal30
107ITS14Benefit Infotype Switchchar10 Allow NULL? 
108DTY14Benefit dependent typenvarchar40 Allow NULL? 
109DID14Benefit dependent object IDnvarchar20 Allow NULL? 
110BPT14Benefit Payout Percentage for Beneficiariesdecimal30
111ITS15Benefit Infotype Switchchar10 Allow NULL? 
112DTY15Benefit dependent typenvarchar40 Allow NULL? 
113DID15Benefit dependent object IDnvarchar20 Allow NULL? 
114BPT15Benefit Payout Percentage for Beneficiariesdecimal30
115ITS16Benefit Infotype Switchchar10 Allow NULL? 
116DTY16Benefit dependent typenvarchar40 Allow NULL? 
117DID16Benefit dependent object IDnvarchar20 Allow NULL? 
118BPT16Benefit Payout Percentage for Beneficiariesdecimal30
119ITS17Benefit Infotype Switchchar10 Allow NULL? 
120DTY17Benefit dependent typenvarchar40 Allow NULL? 
121DID17Benefit dependent object IDnvarchar20 Allow NULL? 
122BPT17Benefit Payout Percentage for Beneficiariesdecimal30
123ITS18Benefit Infotype Switchchar10 Allow NULL? 
124DTY18Benefit dependent typenvarchar40 Allow NULL? 
125DID18Benefit dependent object IDnvarchar20 Allow NULL? 
126BPT18Benefit Payout Percentage for Beneficiariesdecimal30
127ITS19Benefit Infotype Switchchar10 Allow NULL? 
128DTY19Benefit dependent typenvarchar40 Allow NULL? 
129DID19Benefit dependent object IDnvarchar20 Allow NULL? 
130BPT19Benefit Payout Percentage for Beneficiariesdecimal30
131ITS20Benefit Infotype Switchchar10 Allow NULL? 
132DTY20Benefit dependent typenvarchar40 Allow NULL? 
133DID20Benefit dependent object IDnvarchar20 Allow NULL? 
134BPT20Benefit Payout Percentage for Beneficiariesdecimal30
135CIS01Benefit Infotype Switchchar10 Allow NULL? 
136CTY01Benefit dependent typenvarchar40 Allow NULL? 
137CID01Benefit dependent object IDnvarchar20 Allow NULL? 
138CPT01Benefit Payout Percentage for Beneficiariesdecimal30
139CIS02Benefit Infotype Switchchar10 Allow NULL? 
140CTY02Benefit dependent typenvarchar40 Allow NULL? 
141CID02Benefit dependent object IDnvarchar20 Allow NULL? 
142CPT02Benefit Payout Percentage for Beneficiariesdecimal30
143CIS03Benefit Infotype Switchchar10 Allow NULL? 
144CTY03Benefit dependent typenvarchar40 Allow NULL? 
145CID03Benefit dependent object IDnvarchar20 Allow NULL? 
146CPT03Benefit Payout Percentage for Beneficiariesdecimal30
147CIS04Benefit Infotype Switchchar10 Allow NULL? 
148CTY04Benefit dependent typenvarchar40 Allow NULL? 
149CID04Benefit dependent object IDnvarchar20 Allow NULL? 
150CPT04Benefit Payout Percentage for Beneficiariesdecimal30
151CIS05Benefit Infotype Switchchar10 Allow NULL? 
152CTY05Benefit dependent typenvarchar40 Allow NULL? 
153CID05Benefit dependent object IDnvarchar20 Allow NULL? 
154CPT05Benefit Payout Percentage for Beneficiariesdecimal30
155CIS06Benefit Infotype Switchchar10 Allow NULL? 
156CTY06Benefit dependent typenvarchar40 Allow NULL? 
157CID06Benefit dependent object IDnvarchar20 Allow NULL? 
158CPT06Benefit Payout Percentage for Beneficiariesdecimal30
159CIS07Benefit Infotype Switchchar10 Allow NULL? 
160CTY07Benefit dependent typenvarchar40 Allow NULL? 
161CID07Benefit dependent object IDnvarchar20 Allow NULL? 
162CPT07Benefit Payout Percentage for Beneficiariesdecimal30
163CIS08Benefit Infotype Switchchar10 Allow NULL? 
164CTY08Benefit dependent typenvarchar40 Allow NULL? 
165CID08Benefit dependent object IDnvarchar20 Allow NULL? 
166CPT08Benefit Payout Percentage for Beneficiariesdecimal30
167CIS09Benefit Infotype Switchchar10 Allow NULL? 
168CTY09Benefit dependent typenvarchar40 Allow NULL? 
169CID09Benefit dependent object IDnvarchar20 Allow NULL? 
170CPT09Benefit Payout Percentage for Beneficiariesdecimal30
171CIS10Benefit Infotype Switchchar10 Allow NULL? 
172CTY10Benefit dependent typenvarchar40 Allow NULL? 
173CID10Benefit dependent object IDnvarchar20 Allow NULL? 
174CPT10Benefit Payout Percentage for Beneficiariesdecimal30
175CURREBenefit Currency Keynvarchar50 Allow NULL? 
176INV01Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
177IPT01Benefit investment percentagedecimal30
178IAM01Benefit investment amountdecimal132
179INV02Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
180IPT02Benefit investment percentagedecimal30
181IAM02Benefit investment amountdecimal132
182INV03Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
183IPT03Benefit investment percentagedecimal30
184IAM03Benefit investment amountdecimal132
185INV04Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
186IPT04Benefit investment percentagedecimal30
187IAM04Benefit investment amountdecimal132
188INV05Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
189IPT05Benefit investment percentagedecimal30
190IAM05Benefit investment amountdecimal132
191INV06Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
192IPT06Benefit investment percentagedecimal30
193IAM06Benefit investment amountdecimal132
194INV07Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
195IPT07Benefit investment percentagedecimal30
196IAM07Benefit investment amountdecimal132
197INV08Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
198IPT08Benefit investment percentagedecimal30
199IAM08Benefit investment amountdecimal132
200INV09Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
201IPT09Benefit investment percentagedecimal30
202IAM09Benefit investment amountdecimal132
203INV10Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
204IPT10Benefit investment percentagedecimal30
205IAM10Benefit investment amountdecimal132
206INV11Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
207IPT11Benefit investment percentagedecimal30
208IAM11Benefit investment amountdecimal132
209INV12Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
210IPT12Benefit investment percentagedecimal30
211IAM12Benefit investment amountdecimal132
212INV13Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
213IPT13Benefit investment percentagedecimal30
214IAM13Benefit investment amountdecimal132
215INV14Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
216IPT14Benefit investment percentagedecimal30
217IAM14Benefit investment amountdecimal132
218INV15Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
219IPT15Benefit investment percentagedecimal30
220IAM15Benefit investment amountdecimal132
221INV16Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
222IPT16Benefit investment percentagedecimal30
223IAM16Benefit investment amountdecimal132
224INV17Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
225IPT17Benefit investment percentagedecimal30
226IAM17Benefit investment amountdecimal132
227INV18Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
228IPT18Benefit investment percentagedecimal30
229IAM18Benefit investment amountdecimal132
230INV19Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
231IPT19Benefit investment percentagedecimal30
232IAM19Benefit investment amountdecimal132
233INV20Benefit Investment for Savings Plansnvarchar40 Allow NULL? 
234IPT20Benefit investment percentagedecimal30
235IAM20Benefit investment amountdecimal132
NamePrimaryUniqueTypeColumns
PA0169~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT