	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

178 COLUMNS | 1 INDEXES | ERP 6.0 | PA0028 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration
1	ERP EHP7	6.0	PA0028	178	1	HR Master Record: Infotype 0028 (Int. Medical Service)	Personnel Administration

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 PA0028

TOP ERP 6.0 | PA0028 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	0	NUMC	(N'00000000')	No	PA0003	PERSNO	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	0	CHAR	(N' ')	No		SUBTY	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	0	CHAR	(N' ')	No		OBJPS	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	0	CHAR	(N' ')	No		SPRPS	Allow NULL?
6	ENDDA	End Date	nvarchar	8	0	DATS	(N'00000000')	No		ENDDA	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	0	DATS	(N'00000000')	No		BEGDA	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	NUMC	(N'000')	No		SEQNR	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
11	HISTO	Historical Record Flag	char	1	0	CHAR	(N' ')	Yes		HISTO	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	0	CHAR	(N' ')	Yes		ITXEX	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	CHAR	(N' ')	Yes		PRFEX	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	0	CHAR	(N' ')	Yes		ORDEX	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	0	CHAR	(N' ')	Yes		ITBLD	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	0	CHAR	(N' ')	Yes	T530E	PREAS	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	0	CHAR	(N' ')	Yes		PCCE_GPVAL	Allow NULL?
24	EXDAT	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
25	LXDAT	Date of last examination	nvarchar	8	0	DATS	(N'00000000')	Yes		LXDAT	Allow NULL?
26	RESUL	Result	nvarchar	2	0	CHAR	(N' ')	Yes		RESUL	Allow NULL?
27	DIANR	Diagnosis number	nvarchar	8	0	CHAR	(N' ')	Yes		DIANR	Allow NULL?
28	SBJ01	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
29	JNF01	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
30	NMF01	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
31	DTF01	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
32	WTF01	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
33	SBJ02	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
34	JNF02	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
35	NMF02	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
36	DTF02	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
37	WTF02	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
38	SBJ03	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
39	JNF03	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
40	NMF03	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
41	DTF03	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
42	WTF03	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
43	SBJ04	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
44	JNF04	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
45	NMF04	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
46	DTF04	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
47	WTF04	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
48	SBJ05	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
49	JNF05	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
50	NMF05	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
51	DTF05	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
52	WTF05	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
53	SBJ06	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
54	JNF06	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
55	NMF06	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
56	DTF06	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
57	WTF06	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
58	SBJ07	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
59	JNF07	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
60	NMF07	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
61	DTF07	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
62	WTF07	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
63	SBJ08	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
64	JNF08	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
65	NMF08	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
66	DTF08	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
67	WTF08	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
68	SBJ09	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
69	JNF09	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
70	NMF09	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
71	DTF09	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
72	WTF09	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
73	SBJ10	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
74	JNF10	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
75	NMF10	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
76	DTF10	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
77	WTF10	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
78	SBJ11	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
79	JNF11	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
80	NMF11	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
81	DTF11	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
82	WTF11	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
83	SBJ12	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
84	JNF12	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
85	NMF12	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
86	DTF12	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
87	WTF12	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
88	SBJ13	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
89	JNF13	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
90	NMF13	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
91	DTF13	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
92	WTF13	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
93	SBJ14	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
94	JNF14	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
95	NMF14	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
96	DTF14	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
97	WTF14	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
98	SBJ15	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
99	JNF15	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
100	NMF15	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
101	DTF15	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
102	WTF15	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
103	SBJ16	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
104	JNF16	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
105	NMF16	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
106	DTF16	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
107	WTF16	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
108	SBJ17	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
109	JNF17	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
110	NMF17	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
111	DTF17	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
112	WTF17	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
113	SBJ18	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
114	JNF18	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
115	NMF18	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
116	DTF18	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
117	WTF18	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
118	SBJ19	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
119	JNF19	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
120	NMF19	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
121	DTF19	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
122	WTF19	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
123	SBJ20	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
124	JNF20	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
125	NMF20	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
126	DTF20	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
127	WTF20	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
128	SBJ21	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
129	JNF21	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
130	NMF21	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
131	DTF21	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
132	WTF21	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
133	SBJ22	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
134	JNF22	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
135	NMF22	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
136	DTF22	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
137	WTF22	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
138	SBJ23	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
139	JNF23	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
140	NMF23	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
141	DTF23	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
142	WTF23	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
143	SBJ24	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
144	JNF24	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
145	NMF24	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
146	DTF24	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
147	WTF24	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
148	SBJ25	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
149	JNF25	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
150	NMF25	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
151	DTF25	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
152	WTF25	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
153	SBJ26	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
154	JNF26	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
155	NMF26	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
156	DTF26	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
157	WTF26	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
158	SBJ27	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
159	JNF27	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
160	NMF27	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
161	DTF27	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
162	WTF27	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
163	SBJ28	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
164	JNF28	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
165	NMF28	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
166	DTF28	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
167	WTF28	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
168	SBJ29	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
169	JNF29	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
170	NMF29	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
171	DTF29	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
172	WTF29	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
173	SBJ30	Examination area	nvarchar	2	0	CHAR	(N' ')	Yes	T578Z	SBJKT	Allow NULL?
174	JNF30	Yes/No field for internal medical service	char	1	0	CHAR	(N' ')	Yes		JNFLD	Allow NULL?
175	NMF30	Value	decimal	8	2	DEC	((0))	Yes		NMFLD
176	DTF30	Examination date	nvarchar	8	0	DATS	(N'00000000')	Yes		USDAT	Allow NULL?
177	WTF30	Proficiency	nvarchar	10	0	CHAR	(N' ')	Yes	T578X	WTFLD	Allow NULL?
178	EXTYP	Examination type	nvarchar	4	0	CHAR	(N' ')	Yes	T591A	EXTYP	Allow NULL?

TOP ERP 6.0 | PA0028 INDEXES

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

178 COLUMNS | 1 INDEXES | ERP 6.0 | PA0028 TABLE

TOP ERP 6.0 | PA0028 COLUMNS

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

178 COLUMNS | 1 INDEXES | ERP 6.0 | PA0028 TABLE

TOPERP 6.0 | PA0028 COLUMNS

TOPERP 6.0 | PA0028 INDEXES

TOP ERP 6.0 | PA0028 COLUMNS

TOP ERP 6.0 | PA0028 INDEXES