	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

165 COLUMNS | 1 INDEXES | ERP 6.0 | PA0168 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Benefits
1	ERP EHP7	6.0	PA0168	165	1	HR Master Record: Infotype 0168 (Insurance Plans)	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, BCOVR, SALOV, COVOV, ADDNO, CURRE, ENRTY, EVENT, EOGRP, EOIRQ, EOIPR, PRETX, CSTOV, BNCST, PERIO, 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 FROM PA0168

TOP ERP 6.0 | PA0168 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	BAREA	Benefit area	nvarchar	2	0	CHAR	(N' ')	Yes	T5UB3	BEN_AREA	Allow NULL?
25	PLTYP	Benefit plan type	nvarchar	4	0	CHAR	(N' ')	Yes	T5UB1	BEN_TYPE	Allow NULL?
26	BPLAN	Benefit plan	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBA	BEN_PLAN	Allow NULL?
27	BENGR	Benefit First Program Grouping	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBT	BEN_GROUP	Allow NULL?
28	BSTAT	Benefit Second Program Grouping	nvarchar	4	0	CHAR	(N' ')	Yes	T5UB9	BEN_EESTAT	Allow NULL?
29	ELIDT	Benefit calculated eligibility date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEN_ELIDT	Allow NULL?
30	ELDTO	Benefit override eligibility date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEN_ELIDTO	Allow NULL?
31	PARDT	Benefit date of first participation in plan	nvarchar	8	0	DATS	(N'00000000')	Yes		BEN_PARTDT	Allow NULL?
32	BCOVR	Benefit Insurance Option	nvarchar	4	0	CHAR	(N' ')	Yes	T74FA	BEN_COVLVL	Allow NULL?
33	SALOV	Benefit salary override amount	decimal	15	2	CURR	((0))	Yes		BEN_SALOVR
34	COVOV	Benefit Alternative Amount for Insurance Coverage Amount	decimal	15	2	CURR	((0))	Yes		BEN_COVOVR
35	ADDNO	Benefit Number of Additional Insurance Coverage Units	decimal	9	0	DEC	((0))	Yes		BEN_ADDNO
36	CURRE	Benefit Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	BEN_CURR	Allow NULL?
37	ENRTY	Benefit Type of Plan Enrollment	char	1	0	CHAR	(N' ')	Yes		BEN_ENRTYP	Allow NULL?
38	EVENT	Benefit adjustment reason	nvarchar	4	0	CHAR	(N' ')	Yes	T74HA	BEN_EVENT	Allow NULL?
39	EOGRP	Benefits End of Grace Period	nvarchar	8	0	DATS	(N'00000000')	Yes		BEN_EOGRP	Allow NULL?
40	EOIRQ	Benefit Statement of Insurability Required	char	1	0	CHAR	(N' ')	Yes		BEN_EOIRQ	Allow NULL?
41	EOIPR	Benefit Insurability Proven	char	1	0	CHAR	(N' ')	Yes		BEN_EOIPR	Allow NULL?
42	PRETX	Benefit Indicator Deductions Based on Pre-Tax	char	1	0	CHAR	(N' ')	Yes		BEN_PRETX	Allow NULL?
43	CSTOV	Benefit Alternative Amount for Costs	decimal	13	2	CURR	((0))	Yes		BEN_CSTOV
44	BNCST	Benefit Costs for Bonus Payment	decimal	13	2	CURR	((0))	Yes		BEN_BNCST
45	PERIO	Benefit Period for Calculations	nvarchar	2	0	NUMC	(N'00')	Yes		BEN_PERIOD	Allow NULL?
46	ITS01	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
47	DTY01	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
48	DID01	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
49	BPT01	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
50	ITS02	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
51	DTY02	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
52	DID02	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
53	BPT02	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
54	ITS03	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
55	DTY03	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
56	DID03	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
57	BPT03	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
58	ITS04	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
59	DTY04	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
60	DID04	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
61	BPT04	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
62	ITS05	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
63	DTY05	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
64	DID05	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
65	BPT05	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
66	ITS06	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
67	DTY06	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
68	DID06	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
69	BPT06	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
70	ITS07	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
71	DTY07	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
72	DID07	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
73	BPT07	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
74	ITS08	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
75	DTY08	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
76	DID08	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
77	BPT08	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
78	ITS09	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
79	DTY09	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
80	DID09	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
81	BPT09	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
82	ITS10	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
83	DTY10	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
84	DID10	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
85	BPT10	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
86	ITS11	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
87	DTY11	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
88	DID11	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
89	BPT11	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
90	ITS12	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
91	DTY12	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
92	DID12	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
93	BPT12	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
94	ITS13	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
95	DTY13	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
96	DID13	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
97	BPT13	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
98	ITS14	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
99	DTY14	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
100	DID14	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
101	BPT14	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
102	ITS15	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
103	DTY15	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
104	DID15	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
105	BPT15	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
106	ITS16	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
107	DTY16	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
108	DID16	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
109	BPT16	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
110	ITS17	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
111	DTY17	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
112	DID17	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
113	BPT17	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
114	ITS18	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
115	DTY18	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
116	DID18	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
117	BPT18	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
118	ITS19	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
119	DTY19	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
120	DID19	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
121	BPT19	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
122	ITS20	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
123	DTY20	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
124	DID20	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
125	BPT20	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
126	CIS01	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
127	CTY01	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
128	CID01	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
129	CPT01	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
130	CIS02	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
131	CTY02	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
132	CID02	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
133	CPT02	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
134	CIS03	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
135	CTY03	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
136	CID03	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
137	CPT03	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
138	CIS04	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
139	CTY04	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
140	CID04	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
141	CPT04	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
142	CIS05	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
143	CTY05	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
144	CID05	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
145	CPT05	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
146	CIS06	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
147	CTY06	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
148	CID06	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
149	CPT06	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
150	CIS07	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
151	CTY07	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
152	CID07	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
153	CPT07	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
154	CIS08	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
155	CTY08	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
156	CID08	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
157	CPT08	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
158	CIS09	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
159	CTY09	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
160	CID09	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
161	CPT09	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
162	CIS10	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
163	CTY10	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
164	CID10	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
165	CPT10	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT

TOP ERP 6.0 | PA0168 INDEXES

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

165 COLUMNS | 1 INDEXES | ERP 6.0 | PA0168 TABLE

TOP ERP 6.0 | PA0168 COLUMNS

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

165 COLUMNS | 1 INDEXES | ERP 6.0 | PA0168 TABLE

TOPERP 6.0 | PA0168 COLUMNS

TOPERP 6.0 | PA0168 INDEXES

TOP ERP 6.0 | PA0168 COLUMNS

TOP ERP 6.0 | PA0168 INDEXES