	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

225 COLUMNS | 1 INDEXES | ERP 6.0 | PA0542 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Korea
1	ERP EHP7	6.0	PA0542	225	1	Y.E.A. KR	Korea

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, COM01, BUS01, SAL01, BON01, INT01, RET01, OUT01, OVR01, OTH01, MED01, NPM01, EIM01, FLD01, FRI01, FRE01, COM02, BUS02, SAL02, BON02, INT02, RET02, OUT02, OVR02, OTH02, MED02, NPM02, EIM02, FLD02, FRI02, FRE02, COM03, BUS03, SAL03, BON03, INT03, RET03, OUT03, OVR03, OTH03, MED03, NPM03, EIM03, FLD03, FRI03, FRE03, COM04, BUS04, SAL04, BON04, INT04, RET04, OUT04, OVR04, OTH04, MED04, NPM04, EIM04, FLD04, FRI04, FRE04, COM05, BUS05, SAL05, BON05, INT05, RET05, OUT05, OVR05, OTH05, MED05, NPM05, EIM05, FLD05, FRI05, FRE05, FOTIS, SUBIS, FMDOH, FMDED, SUBME, FCEEE, FCECU, SUBCE, FLGDO, FDSDO, FPRDO, SUBRD, SAVNM, SAVAM, ACQDT, REPAY, APPDT, CRDCD, ABPLA, ABJOB, ABDUR, ABPAY, TAXCT, KORCR, GETDT, PUTDT, FTCHI, FTCES, FPERP, FPERN, FINVT, FINVS, ABN01, SPT01, ABN02, SPT02, ABN03, SPT03, ABN04, SPT04, ABN05, SPT05, FTCLS, FOHIS, FHADI, FTCLP, COMST, SPCDO, FCEWF, FCEHD, DRTCD, HSINS, HSSAV, EEHSS, LHSSV, DON30, POLDN, CONMA, CONRE, CONFU, CRDDP, GIROE, CASHE, FORCT, FORCK, INTTL, DUPEX, RETPE, TINVS, PINVS, OTHPI, ONP01, ONP02, ONP03, ONP04, ONP05, RSN01, RSN02, RSN03, RSN04, RSN05, STK01, STK02, STK03, STK04, STK05, FOR01, CLD01, FOR02, CLD02, FOR03, CLD03, FOR04, CLD04, FOR05, CLD05, REP01, REP02, REP03, REP04, REP05, TPA01, TPA02, TPA03, TPA04, TPA05, DESDO, RELDO, SMBFI, LTSF1, LTSF2, LTSF3, NINVS, INDIF, INSLN, SFENP, SFEHI, MRNTD, INDPL, PDCID, HSHLD, VINVS, INTFN, INTOT, INVST, IRLWL, EXTAX FROM PA0542

TOP ERP 6.0 | PA0542 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	COM01	Previous Company / Taxpayer Association Name	nvarchar	24	0	Allow NULL?
25	BUS01	Previous Company / Taxpayer Association Business Number	nvarchar	12	0	Allow NULL?
26	SAL01	Regular salary from the previous company	decimal	11	2
27	BON01	Previous company's bonus	decimal	11	2
28	INT01	Income tax paid in the previous company	decimal	9	2
29	RET01	Resident tax paid in the previous company	decimal	9	2
30	OUT01	Non-taxable overseas income from previous company	decimal	9	2
31	OVR01	Non-taxable overtime from previous company	decimal	9	2
32	OTH01	Other non-taxable income from previous company	decimal	9	2
33	MED01	Medical insurance premium from previous company	decimal	9	2
34	NPM01	National pension premium from previous company	decimal	9	2
35	EIM01	Employment insurance premium from previous company	decimal	9	2
36	FLD01	Field engineer deduction	decimal	9	2
37	FRI01	Exemption by income tax law in previous company	decimal	9	2
38	FRE01	Exempted tax amount by tax exemption law	decimal	9	2
39	COM02	Previous Company / Taxpayer Association Name	nvarchar	24	0	Allow NULL?
40	BUS02	Previous Company / Taxpayer Association Business Number	nvarchar	12	0	Allow NULL?
41	SAL02	Regular salary from the previous company	decimal	11	2
42	BON02	Previous company's bonus	decimal	11	2
43	INT02	Income tax paid in the previous company	decimal	9	2
44	RET02	Resident tax paid in the previous company	decimal	9	2
45	OUT02	Non-taxable overseas income from previous company	decimal	9	2
46	OVR02	Non-taxable overtime from previous company	decimal	9	2
47	OTH02	Other non-taxable income from previous company	decimal	9	2
48	MED02	Medical insurance premium from previous company	decimal	9	2
49	NPM02	National pension premium from previous company	decimal	9	2
50	EIM02	Employment insurance premium from previous company	decimal	9	2
51	FLD02	Field engineer deduction	decimal	9	2
52	FRI02	Exemption by income tax law in previous company	decimal	9	2
53	FRE02	Exempted tax amount by tax exemption law	decimal	9	2
54	COM03	Previous Company / Taxpayer Association Name	nvarchar	24	0	Allow NULL?
55	BUS03	Previous Company / Taxpayer Association Business Number	nvarchar	12	0	Allow NULL?
56	SAL03	Regular salary from the previous company	decimal	11	2
57	BON03	Previous company's bonus	decimal	11	2
58	INT03	Income tax paid in the previous company	decimal	9	2
59	RET03	Resident tax paid in the previous company	decimal	9	2
60	OUT03	Non-taxable overseas income from previous company	decimal	9	2
61	OVR03	Non-taxable overtime from previous company	decimal	9	2
62	OTH03	Other non-taxable income from previous company	decimal	9	2
63	MED03	Medical insurance premium from previous company	decimal	9	2
64	NPM03	National pension premium from previous company	decimal	9	2
65	EIM03	Employment insurance premium from previous company	decimal	9	2
66	FLD03	Field engineer deduction	decimal	9	2
67	FRI03	Exemption by income tax law in previous company	decimal	9	2
68	FRE03	Exempted tax amount by tax exemption law	decimal	9	2
69	COM04	Previous Company / Taxpayer Association Name	nvarchar	24	0	Allow NULL?
70	BUS04	Previous Company / Taxpayer Association Business Number	nvarchar	12	0	Allow NULL?
71	SAL04	Regular salary from the previous company	decimal	11	2
72	BON04	Previous company's bonus	decimal	11	2
73	INT04	Income tax paid in the previous company	decimal	9	2
74	RET04	Resident tax paid in the previous company	decimal	9	2
75	OUT04	Non-taxable overseas income from previous company	decimal	9	2
76	OVR04	Non-taxable overtime from previous company	decimal	9	2
77	OTH04	Other non-taxable income from previous company	decimal	9	2
78	MED04	Medical insurance premium from previous company	decimal	9	2
79	NPM04	National pension premium from previous company	decimal	9	2
80	EIM04	Employment insurance premium from previous company	decimal	9	2
81	FLD04	Field engineer deduction	decimal	9	2
82	FRI04	Exemption by income tax law in previous company	decimal	9	2
83	FRE04	Exempted tax amount by tax exemption law	decimal	9	2
84	COM05	Previous Company / Taxpayer Association Name	nvarchar	24	0	Allow NULL?
85	BUS05	Previous Company / Taxpayer Association Business Number	nvarchar	12	0	Allow NULL?
86	SAL05	Regular salary from the previous company	decimal	11	2
87	BON05	Previous company's bonus	decimal	11	2
88	INT05	Income tax paid in the previous company	decimal	9	2
89	RET05	Resident tax paid in the previous company	decimal	9	2
90	OUT05	Non-taxable overseas income from previous company	decimal	9	2
91	OVR05	Non-taxable overtime from previous company	decimal	9	2
92	OTH05	Other non-taxable income from previous company	decimal	9	2
93	MED05	Medical insurance premium from previous company	decimal	9	2
94	NPM05	National pension premium from previous company	decimal	9	2
95	EIM05	Employment insurance premium from previous company	decimal	9	2
96	FLD05	Field engineer deduction	decimal	9	2
97	FRI05	Exemption by income tax law in previous company	decimal	9	2
98	FRE05	Exempted tax amount by tax exemption law	decimal	9	2
99	FOTIS	Insurance premium expense	decimal	10	2
100	SUBIS	Date of submitting application for other insurance premium	nvarchar	8	0	Allow NULL?
101	FMDOH	Medical expenses for the aged	decimal	10	2
102	FMDED	Medical expense for the employee or dependents	decimal	10	2
103	SUBME	Date of submitting application for medical expense	nvarchar	8	0	Allow NULL?
104	FCEEE	Education expense for employee him/herself	decimal	10	2
105	FCECU	Educational expenses for dependents	decimal	9	2
106	SUBCE	Date of application for cultural & educational expense	nvarchar	8	0	Allow NULL?
107	FLGDO	Legal donations	decimal	9	2
108	FDSDO	Donations to appointed associations	decimal	9	2
109	FPRDO	Interest Payment for Housing Loan (6M)	decimal	9	2
110	SUBRD	Date of submitting receipt for donation	nvarchar	8	0	Allow NULL?
111	SAVNM	House savings name	nvarchar	30	0	Allow NULL?
112	SAVAM	The saving amount for housing	decimal	9	2
113	ACQDT	Date of buying or renting a house	nvarchar	8	0	Allow NULL?
114	REPAY	Annual repayment for the principal of housing loan	decimal	9	2
115	APPDT	Date of application for housing fee	nvarchar	8	0	Allow NULL?
116	CRDCD	Expense for credit card	decimal	10	2
117	ABPLA	Working place for overseas employee	nvarchar	30	0	Allow NULL?
118	ABJOB	Employee's job during working overseas	nvarchar	30	0	Allow NULL?
119	ABDUR	The number of months during working overseas	nvarchar	3	0	Allow NULL?
120	ABPAY	Total earned income during working overseas	decimal	11	2
121	TAXCT	Tax paid country	nvarchar	3	0	Allow NULL?
122	KORCR	Tax paid oversea in Korean WON	decimal	11	2
123	GETDT	Date of getting application for overseas tax credit	nvarchar	8	0	Allow NULL?
124	PUTDT	Date of submitting application for overseas tax credit	nvarchar	8	0	Allow NULL?
125	FTCHI	Payment for the housing loan interest	decimal	13	2
126	FTCES	Payment for employee stock saving	decimal	13	2
127	FPERP	Payment for personal pension savings	decimal	11	2
128	FPERN	Payment for pension savings (from 2001.01.01)	decimal	11	2
129	FINVT	Investment (30%)	decimal	11	2
130	FINVS	Investment (15%)	decimal	11	2
131	ABN01	Previous company's acknowledged bonus	decimal	11	2
132	SPT01	Special tax paid in the previous company	decimal	9	2
133	ABN02	Previous company's acknowledged bonus	decimal	11	2
134	SPT02	Special tax paid in the previous company	decimal	9	2
135	ABN03	Previous company's acknowledged bonus	decimal	11	2
136	SPT03	Special tax paid in the previous company	decimal	9	2
137	ABN04	Previous company's acknowledged bonus	decimal	11	2
138	SPT04	Special tax paid in the previous company	decimal	9	2
139	ABN05	Previous company's acknowledged bonus	decimal	11	2
140	SPT05	Special tax paid in the previous company	decimal	9	2
141	FTCLS	Long term stock saving for current year	decimal	11	2
142	FOHIS	Insurance premium for handicapped person	decimal	10	2
143	FHADI	Medical expenses for the handicapped	decimal	9	2
144	FTCLP	long term stock savings for previous year	decimal	11	2
145	COMST	Company stock	decimal	11	2
146	SPCDO	Special donation	decimal	9	2
147	FCEWF	Educational expense for employee's spouse	decimal	9	2
148	FCEHD	Educational expense for the handicapped	decimal	10	2
149	DRTCD	Expense for direct card	decimal	9	2
150	HSINS	Housing installment amount	decimal	9	2
151	HSSAV	Housing saving amount	decimal	10	2
152	EEHSS	Employee housing saving amount	decimal	10	2
153	LHSSV	Long-term housing saving amount	decimal	9	2
154	DON30	30% deduction donation amount	decimal	9	2
155	POLDN	Political donation amount	decimal	9	2
156	CONMA	Congratulations and condo-lences: times of marriage	char	1	0	Allow NULL?
157	CONRE	Congratulations and condo-lences: times of removal	char	1	0	Allow NULL?
158	CONFU	Congratulations and condo-lences: times of funeral	char	1	0	Allow NULL?
159	CRDDP	Expense paid by dependant's credit card	decimal	9	2
160	GIROE	Expense paid by giro institution	decimal	9	2
161	CASHE	Expense paid by cash	decimal	10	2
162	FORCT	Pre-paid tax amount in foreign currency	decimal	9	2
163	FORCK	Pre-paid tax currency in foreign currency	nvarchar	5	0	Allow NULL?
164	INTTL	Interest Payment for Housing Loan (10M)	decimal	9	2
165	DUPEX	Medical Expense for Non-dependents	decimal	9	2
166	RETPE	Retirement pension	decimal	10	2
167	TINVS	Investment Since Jan. 2007	decimal	11	2
168	PINVS	Investment Till Dec. 2006	decimal	11	2
169	OTHPI	Other Pension Insurance	decimal	10	2
170	ONP01	Other NP Premium from Previous Company	decimal	10	2
171	ONP02	Other NP Premium from Previous Company	decimal	10	2
172	ONP03	Other NP Premium from Previous Company	decimal	10	2
173	ONP04	Other NP Premium from Previous Company	decimal	10	2
174	ONP05	Other NP Premium from Previous Company	decimal	10	2
175	RSN01	Research non-taxable from previous company	decimal	9	2
176	RSN02	Research non-taxable from previous company	decimal	9	2
177	RSN03	Research non-taxable from previous company	decimal	9	2
178	RSN04	Research non-taxable from previous company	decimal	9	2
179	RSN05	Research non-taxable from previous company	decimal	9	2
180	STK01	Previous Company's Stock Option	decimal	11	2
181	STK02	Previous Company's Stock Option	decimal	11	2
182	STK03	Previous Company's Stock Option	decimal	11	2
183	STK04	Previous Company's Stock Option	decimal	11	2
184	STK05	Previous Company's Stock Option	decimal	11	2
185	FOR01	Foreigner non-taxable from previous company	decimal	9	2
186	CLD01	Childcare non-taxable from previous company	decimal	9	2
187	FOR02	Foreigner non-taxable from previous company	decimal	9	2
188	CLD02	Childcare non-taxable from previous company	decimal	9	2
189	FOR03	Foreigner non-taxable from previous company	decimal	9	2
190	CLD03	Childcare non-taxable from previous company	decimal	9	2
191	FOR04	Foreigner non-taxable from previous company	decimal	9	2
192	CLD04	Childcare non-taxable from previous company	decimal	9	2
193	FOR05	Foreigner non-taxable from previous company	decimal	9	2
194	CLD05	Childcare non-taxable from previous company	decimal	9	2
195	REP01	Retirement Pension From Previous Company	decimal	10	2
196	REP02	Retirement Pension From Previous Company	decimal	10	2
197	REP03	Retirement Pension From Previous Company	decimal	10	2
198	REP04	Retirement Pension From Previous Company	decimal	10	2
199	REP05	Retirement Pension From Previous Company	decimal	10	2
200	TPA01	Indicator for Taxpayer Association	char	1	0	Allow NULL?
201	TPA02	Indicator for Taxpayer Association	char	1	0	Allow NULL?
202	TPA03	Indicator for Taxpayer Association	char	1	0	Allow NULL?
203	TPA04	Indicator for Taxpayer Association	char	1	0	Allow NULL?
204	TPA05	Indicator for Taxpayer Association	char	1	0	Allow NULL?
205	DESDO	Other Designation Donation	decimal	9	2
206	RELDO	Religious Donation	decimal	9	2
207	SMBFI	Small Biz Insurance Funds	decimal	11	2
208	LTSF1	Investment in Long-Term Stock Fund (First Year)	decimal	11	2
209	LTSF2	Investment in Long-Term Stock Fund (Second Year)	decimal	11	2
210	LTSF3	Investment in Long-Term Stock Fund (Third Year)	decimal	11	2
211	NINVS	Investment Since Jan. 2009	decimal	11	2
212	INDIF	Income Reduction for Job Keeping	decimal	13	2
213	INSLN	Interest Payment for Housing Loan (15M)	decimal	11	2
214	SFENP	National Pension Premium for Self-Insured Employee	decimal	9	2
215	SFEHI	Health Insurance Premium for Self-Insured Employee	decimal	9	2
216	MRNTD	Total Monthly Rent Amount	decimal	11	2
217	INDPL	Repayment to Individual Lender	decimal	9	2
218	PDCID	Personal Deduction Changed Indicator	char	1	0	Allow NULL?
219	HSHLD	Householder Indicator	char	1	0	Allow NULL?
220	VINVS	Investment Since Jan. 2012 for Venture Enterprises	decimal	11	2
221	INTFN	Fix interest/Non-deferred loan payment (15M)	decimal	11	2
222	INTOT	Other Housing Interest Loan Payment (5M)	decimal	9	2
223	INVST	Investment Since January 2012	decimal	11	2
224	IRLWL	Interest Payment for Housing Rental Loan without a Lump-sum	decimal	11	2
225	EXTAX	Exception Tax	char	1	0	Allow NULL?

TOP ERP 6.0 | PA0542 INDEXES

Name	Primary	Unique	Type	Columns
PA0542~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

225 COLUMNS | 1 INDEXES | ERP 6.0 | PA0542 TABLE

TOP ERP 6.0 | PA0542 COLUMNS

TOP ERP 6.0 | PA0542 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

225 COLUMNS | 1 INDEXES | ERP 6.0 | PA0542 TABLE

TOPERP 6.0 | PA0542 COLUMNS

TOPERP 6.0 | PA0542 INDEXES

TOP ERP 6.0 | PA0542 COLUMNS

TOP ERP 6.0 | PA0542 INDEXES