	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

226 COLUMNS | 1 INDEXES | ERP 6.0 | PA0147 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Japan
1	ERP EHP7	6.0	PA0147	226	1	HR Master Record: Infotype 0147	Japan

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, APPTY, APPID, EVNM1, EVDT1, EVNM2, EVDT2, EVNMF, EVDTF, PSREG, DFGRP, PSCHG, DFLVL, APRT1, APPT1, APRT2, APPT2, APRTF, APPTF, APF0A, APD0A, APR0A, APP0A, APF0B, APD0B, APR0B, APP0B, APF0C, APD0C, APR0C, APP0C, APF0D, APD0D, APR0D, APP0D, APF0E, APD0E, APR0E, APP0E, APF0F, APD0F, APR0F, APP0F, APF01, APD01, APR01, APP01, APF02, APD02, APR02, APP02, APF03, APD03, APR03, APP03, APF04, APD04, APR04, APP04, APF05, APD05, APR05, APP05, APF06, APD06, APR06, APP06, APF07, APD07, APR07, APP07, APF08, APD08, APR08, APP08, APF09, APD09, APR09, APP09, APF10, APD10, APR10, APP10, APF11, APD11, APR11, APP11, APF12, APD12, APR12, APP12, APF13, APD13, APR13, APP13, APF14, APD14, APR14, APP14, APF15, APD15, APR15, APP15, APF16, APD16, APR16, APP16, APF17, APD17, APR17, APP17, APF18, APD18, APR18, APP18, APF19, APD19, APR19, APP19, APF20, APD20, APR20, APP20, APF21, APD21, APR21, APP21, APF22, APD22, APR22, APP22, APF23, APD23, APR23, APP23, APF24, APD24, APR24, APP24, APF25, APD25, APR25, APP25, APF26, APD26, APR26, APP26, APF27, APD27, APR27, APP27, APF28, APD28, APR28, APP28, APF29, APD29, APR29, APP29, APF30, APD30, APR30, APP30, APF31, APD31, APR31, APP31, APF32, APD32, APR32, APP32, APF33, APD33, APR33, APP33, APF34, APD34, APR34, APP34, APF35, APD35, APR35, APP35, APF36, APD36, APR36, APP36, APF37, APD37, APR37, APP37, APF38, APD38, APR38, APP38, APF39, APD39, APR39, APP39, APF40, APD40, APR40, APP40, KTRAT FROM PA0147

TOP ERP 6.0 | PA0147 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	0	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	0	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	0	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	0	Allow NULL?
6	ENDDA	End Date	nvarchar	8	0	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	0	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	0	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
11	HISTO	Historical Record Flag	char	1	0	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	0	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	0	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	0	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	0	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	0	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	0	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	0	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	0	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	0	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	0	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	0	Allow NULL?
24	APPTY	Personal appraisal type JP	nvarchar	4	0	Allow NULL?
25	APPID	Indicator for Personal Appraisal JP	nvarchar	2	0	Allow NULL?
26	EVNM1	Name of 1st evaluator	nvarchar	25	0	Allow NULL?
27	EVDT1	Date of 1st appraisal evaluation	nvarchar	8	0	Allow NULL?
28	EVNM2	Name of 2nd evaluator	nvarchar	25	0	Allow NULL?
29	EVDT2	Date of 2nd appraisal evaluation	nvarchar	8	0	Allow NULL?
30	EVNMF	Name of final evaluator	nvarchar	25	0	Allow NULL?
31	EVDTF	Date of final appraisal evaluation	nvarchar	8	0	Allow NULL?
32	PSREG	Indicator for automatic payscale regrading	char	1	0	Allow NULL?
33	DFGRP	difference of pay scale group	tinyint	3	0
34	PSCHG	Indicator for payscale group change	char	1	0	Allow NULL?
35	DFLVL	Difference of pay scale level	tinyint	3	0
36	APRT1	1st Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
37	APPT1	1st Point value for appraisal criterion	decimal	5	2
38	APRT2	2nd Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
39	APPT2	2nd Point value for appraisal criterion	decimal	5	2
40	APRTF	Final Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
41	APPTF	Final Point value for appraisal criterion	decimal	5	2
42	APF0A	Appraisals main feature	nvarchar	2	0	Allow NULL?
43	APD0A	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
44	APR0A	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
45	APP0A	Point value for appraisal criterion	decimal	5	2
46	APF0B	Appraisals main feature	nvarchar	2	0	Allow NULL?
47	APD0B	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
48	APR0B	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
49	APP0B	Point value for appraisal criterion	decimal	5	2
50	APF0C	Appraisals main feature	nvarchar	2	0	Allow NULL?
51	APD0C	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
52	APR0C	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
53	APP0C	Point value for appraisal criterion	decimal	5	2
54	APF0D	Appraisals main feature	nvarchar	2	0	Allow NULL?
55	APD0D	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
56	APR0D	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
57	APP0D	Point value for appraisal criterion	decimal	5	2
58	APF0E	Appraisals main feature	nvarchar	2	0	Allow NULL?
59	APD0E	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
60	APR0E	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
61	APP0E	Point value for appraisal criterion	decimal	5	2
62	APF0F	Appraisals main feature	nvarchar	2	0	Allow NULL?
63	APD0F	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
64	APR0F	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
65	APP0F	Point value for appraisal criterion	decimal	5	2
66	APF01	Appraisals main feature	nvarchar	2	0	Allow NULL?
67	APD01	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
68	APR01	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
69	APP01	Point value for appraisal criterion	decimal	5	2
70	APF02	Appraisals main feature	nvarchar	2	0	Allow NULL?
71	APD02	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
72	APR02	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
73	APP02	Point value for appraisal criterion	decimal	5	2
74	APF03	Appraisals main feature	nvarchar	2	0	Allow NULL?
75	APD03	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
76	APR03	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
77	APP03	Point value for appraisal criterion	decimal	5	2
78	APF04	Appraisals main feature	nvarchar	2	0	Allow NULL?
79	APD04	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
80	APR04	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
81	APP04	Point value for appraisal criterion	decimal	5	2
82	APF05	Appraisals main feature	nvarchar	2	0	Allow NULL?
83	APD05	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
84	APR05	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
85	APP05	Point value for appraisal criterion	decimal	5	2
86	APF06	Appraisals main feature	nvarchar	2	0	Allow NULL?
87	APD06	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
88	APR06	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
89	APP06	Point value for appraisal criterion	decimal	5	2
90	APF07	Appraisals main feature	nvarchar	2	0	Allow NULL?
91	APD07	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
92	APR07	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
93	APP07	Point value for appraisal criterion	decimal	5	2
94	APF08	Appraisals main feature	nvarchar	2	0	Allow NULL?
95	APD08	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
96	APR08	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
97	APP08	Point value for appraisal criterion	decimal	5	2
98	APF09	Appraisals main feature	nvarchar	2	0	Allow NULL?
99	APD09	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
100	APR09	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
101	APP09	Point value for appraisal criterion	decimal	5	2
102	APF10	Appraisals main feature	nvarchar	2	0	Allow NULL?
103	APD10	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
104	APR10	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
105	APP10	Point value for appraisal criterion	decimal	5	2
106	APF11	Appraisals main feature	nvarchar	2	0	Allow NULL?
107	APD11	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
108	APR11	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
109	APP11	Point value for appraisal criterion	decimal	5	2
110	APF12	Appraisals main feature	nvarchar	2	0	Allow NULL?
111	APD12	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
112	APR12	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
113	APP12	Point value for appraisal criterion	decimal	5	2
114	APF13	Appraisals main feature	nvarchar	2	0	Allow NULL?
115	APD13	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
116	APR13	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
117	APP13	Point value for appraisal criterion	decimal	5	2
118	APF14	Appraisals main feature	nvarchar	2	0	Allow NULL?
119	APD14	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
120	APR14	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
121	APP14	Point value for appraisal criterion	decimal	5	2
122	APF15	Appraisals main feature	nvarchar	2	0	Allow NULL?
123	APD15	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
124	APR15	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
125	APP15	Point value for appraisal criterion	decimal	5	2
126	APF16	Appraisals main feature	nvarchar	2	0	Allow NULL?
127	APD16	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
128	APR16	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
129	APP16	Point value for appraisal criterion	decimal	5	2
130	APF17	Appraisals main feature	nvarchar	2	0	Allow NULL?
131	APD17	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
132	APR17	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
133	APP17	Point value for appraisal criterion	decimal	5	2
134	APF18	Appraisals main feature	nvarchar	2	0	Allow NULL?
135	APD18	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
136	APR18	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
137	APP18	Point value for appraisal criterion	decimal	5	2
138	APF19	Appraisals main feature	nvarchar	2	0	Allow NULL?
139	APD19	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
140	APR19	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
141	APP19	Point value for appraisal criterion	decimal	5	2
142	APF20	Appraisals main feature	nvarchar	2	0	Allow NULL?
143	APD20	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
144	APR20	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
145	APP20	Point value for appraisal criterion	decimal	5	2
146	APF21	Appraisals main feature	nvarchar	2	0	Allow NULL?
147	APD21	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
148	APR21	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
149	APP21	Point value for appraisal criterion	decimal	5	2
150	APF22	Appraisals main feature	nvarchar	2	0	Allow NULL?
151	APD22	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
152	APR22	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
153	APP22	Point value for appraisal criterion	decimal	5	2
154	APF23	Appraisals main feature	nvarchar	2	0	Allow NULL?
155	APD23	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
156	APR23	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
157	APP23	Point value for appraisal criterion	decimal	5	2
158	APF24	Appraisals main feature	nvarchar	2	0	Allow NULL?
159	APD24	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
160	APR24	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
161	APP24	Point value for appraisal criterion	decimal	5	2
162	APF25	Appraisals main feature	nvarchar	2	0	Allow NULL?
163	APD25	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
164	APR25	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
165	APP25	Point value for appraisal criterion	decimal	5	2
166	APF26	Appraisals main feature	nvarchar	2	0	Allow NULL?
167	APD26	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
168	APR26	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
169	APP26	Point value for appraisal criterion	decimal	5	2
170	APF27	Appraisals main feature	nvarchar	2	0	Allow NULL?
171	APD27	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
172	APR27	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
173	APP27	Point value for appraisal criterion	decimal	5	2
174	APF28	Appraisals main feature	nvarchar	2	0	Allow NULL?
175	APD28	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
176	APR28	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
177	APP28	Point value for appraisal criterion	decimal	5	2
178	APF29	Appraisals main feature	nvarchar	2	0	Allow NULL?
179	APD29	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
180	APR29	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
181	APP29	Point value for appraisal criterion	decimal	5	2
182	APF30	Appraisals main feature	nvarchar	2	0	Allow NULL?
183	APD30	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
184	APR30	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
185	APP30	Point value for appraisal criterion	decimal	5	2
186	APF31	Appraisals main feature	nvarchar	2	0	Allow NULL?
187	APD31	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
188	APR31	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
189	APP31	Point value for appraisal criterion	decimal	5	2
190	APF32	Appraisals main feature	nvarchar	2	0	Allow NULL?
191	APD32	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
192	APR32	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
193	APP32	Point value for appraisal criterion	decimal	5	2
194	APF33	Appraisals main feature	nvarchar	2	0	Allow NULL?
195	APD33	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
196	APR33	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
197	APP33	Point value for appraisal criterion	decimal	5	2
198	APF34	Appraisals main feature	nvarchar	2	0	Allow NULL?
199	APD34	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
200	APR34	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
201	APP34	Point value for appraisal criterion	decimal	5	2
202	APF35	Appraisals main feature	nvarchar	2	0	Allow NULL?
203	APD35	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
204	APR35	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
205	APP35	Point value for appraisal criterion	decimal	5	2
206	APF36	Appraisals main feature	nvarchar	2	0	Allow NULL?
207	APD36	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
208	APR36	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
209	APP36	Point value for appraisal criterion	decimal	5	2
210	APF37	Appraisals main feature	nvarchar	2	0	Allow NULL?
211	APD37	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
212	APR37	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
213	APP37	Point value for appraisal criterion	decimal	5	2
214	APF38	Appraisals main feature	nvarchar	2	0	Allow NULL?
215	APD38	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
216	APR38	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
217	APP38	Point value for appraisal criterion	decimal	5	2
218	APF39	Appraisals main feature	nvarchar	2	0	Allow NULL?
219	APD39	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
220	APR39	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
221	APP39	Point value for appraisal criterion	decimal	5	2
222	APF40	Appraisals main feature	nvarchar	2	0	Allow NULL?
223	APD40	Appraisal Detail Feature	nvarchar	2	0	Allow NULL?
224	APR40	Appraisal Rank Criteria	nvarchar	3	0	Allow NULL?
225	APP40	Point value for appraisal criterion	decimal	5	2
226	KTRAT	Reduction rate from attendance	decimal	5	3

TOP ERP 6.0 | PA0147 INDEXES

Name	Primary	Unique	Type	Columns
PA0147~0	Yes	Yes	CLUSTERED	SEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

226 COLUMNS | 1 INDEXES | ERP 6.0 | PA0147 TABLE

TOP ERP 6.0 | PA0147 COLUMNS

TOP ERP 6.0 | PA0147 INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

226 COLUMNS | 1 INDEXES | ERP 6.0 | PA0147 TABLE

TOPERP 6.0 | PA0147 COLUMNS

TOPERP 6.0 | PA0147 INDEXES

TOP ERP 6.0 | PA0147 COLUMNS

TOP ERP 6.0 | PA0147 INDEXES