	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

214 COLUMNS | 1 INDEXES | ERP 6.0 | PA0377 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Benefits
1	ERP EHP7	6.0	PA0377	214	1	HR Master Record: Infotype 0377 (Miscellaneous 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, ELIDT, ELDTO, PARDT, ENRTY, EVENT, LEVL1, SALOV, COVOV, ADDNO, PRETX, EEAMT, EEPCT, EEUNT, PTAMT, PTPCT, PTUNT, PSTTX, BCAMT, BCPCT, BCUNT, BPAMT, BPPCT, BPUNT, BPTTX, PERIO, CRAMO, CURRE, RLPTY, 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, INV01, IPT01, INV02, IPT02, INV03, IPT03, INV04, IPT04, INV05, IPT05, INV06, IPT06, INV07, IPT07, INV08, IPT08, INV09, IPT09, INV10, IPT10, INV11, IPT11, INV12, IPT12, INV13, IPT13, INV14, IPT14, INV15, IPT15, INV16, IPT16, INV17, IPT17, INV18, IPT18, INV19, IPT19, INV20, IPT20 FROM PA0377

TOP ERP 6.0 | PA0377 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	ELIDT	Benefit calculated eligibility date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEN_ELIDT	Allow NULL?
28	ELDTO	Benefit override eligibility date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEN_ELIDTO	Allow NULL?
29	PARDT	Benefit date of first participation in plan	nvarchar	8	0	DATS	(N'00000000')	Yes		BEN_PARTDT	Allow NULL?
30	ENRTY	Benefit Type of Plan Enrollment	char	1	0	CHAR	(N' ')	Yes		BEN_ENRTYP	Allow NULL?
31	EVENT	Benefit adjustment reason	nvarchar	4	0	CHAR	(N' ')	Yes	T74HA	BEN_EVENT	Allow NULL?
32	LEVL1	Benefit miscellaneous plan option	nvarchar	4	0	CHAR	(N' ')	Yes	T74FL	BEN_LEVEL1	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	PRETX	Benefit Indicator Deductions Based on Pre-Tax	char	1	0	CHAR	(N' ')	Yes		BEN_PRETX	Allow NULL?
37	EEAMT	Benefit Employee Pre-Tax Contribution Amount	decimal	13	2	CURR	((0))	Yes		BEN_EECAMT
38	EEPCT	Benefit EE Pre-Tax Contribution Percentage	decimal	5	2	DEC	((0))	Yes		BEN_EECPCT
39	EEUNT	Benefit Employee Pre-Tax Contribution Number of Units	decimal	9	0	DEC	((0))	Yes		BEN_EEUNT
40	PTAMT	Benefit EE Post-Tax Contribution Amount	decimal	13	2	CURR	((0))	Yes		BEN_PTAMT
41	PTPCT	Benefit EE Post-Tax Contribution Percentage	decimal	5	2	DEC	((0))	Yes		BEN_PTPCT
42	PTUNT	Benefit EE Post-Tax Contribution Number of Units	decimal	9	0	DEC	((0))	Yes		BEN_PTUNT
43	PSTTX	Benefit Indicator Start Post-Tax Contribution Deduct. Immed.	char	1	0	CHAR	(N' ')	Yes		BEN_PSTTX	Allow NULL?
44	BCAMT	Benefit Employee Pre-Tax Contribution Amount for Bonus	decimal	13	2	CURR	((0))	Yes		BEN_BCAMT
45	BCPCT	Benefit Employee Pre-Tax Contribution Percentage for Bonus	decimal	5	2	DEC	((0))	Yes		BEN_BCPCT
46	BCUNT	Benefit EE Pre-Tax Contribution Number of Units for Bonus	decimal	9	0	DEC	((0))	Yes		BEN_BCUNT
47	BPAMT	Benefit Employee Post-Tax Contribution Amount for Bonus	decimal	13	2	CURR	((0))	Yes		BEN_BPAMT
48	BPPCT	Benefit Employee Post-Tax Contribution Percentage for Bonus	decimal	5	2	DEC	((0))	Yes		BEN_BPPCT
49	BPUNT	Benefit EE Post-Tax Contr. Number of Units for Bonus	decimal	9	0	DEC	((0))	Yes		BEN_BPUNT
50	BPTTX	Benefit Start Bonus Post-Tax Contribution Deduction Immed.	char	1	0	CHAR	(N' ')	Yes		BEN_BPTTX	Allow NULL?
51	PERIO	Benefit Period for Calculations	nvarchar	2	0	NUMC	(N'00')	Yes		BEN_PERIOD	Allow NULL?
52	CRAMO	Benefit Alternative Credit Amount	decimal	13	2	CURR	((0))	Yes		BEN_CRAMO
53	CURRE	Benefit Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	BEN_CURR	Allow NULL?
54	RLPTY	Benefit type of dependent/beneficiary for benefit plan	char	1	0	CHAR	(N' ')	Yes		BEN_RLPTYP	Allow NULL?
55	ITS01	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
56	DTY01	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
57	DID01	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
58	BPT01	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
59	ITS02	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
60	DTY02	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
61	DID02	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
62	BPT02	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
63	ITS03	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
64	DTY03	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
65	DID03	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
66	BPT03	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
67	ITS04	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
68	DTY04	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
69	DID04	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
70	BPT04	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
71	ITS05	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
72	DTY05	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
73	DID05	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
74	BPT05	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
75	ITS06	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
76	DTY06	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
77	DID06	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
78	BPT06	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
79	ITS07	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
80	DTY07	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
81	DID07	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
82	BPT07	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
83	ITS08	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
84	DTY08	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
85	DID08	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
86	BPT08	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
87	ITS09	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
88	DTY09	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
89	DID09	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
90	BPT09	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
91	ITS10	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
92	DTY10	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
93	DID10	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
94	BPT10	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
95	ITS11	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
96	DTY11	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
97	DID11	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
98	BPT11	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
99	ITS12	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
100	DTY12	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
101	DID12	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
102	BPT12	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
103	ITS13	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
104	DTY13	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
105	DID13	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
106	BPT13	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
107	ITS14	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
108	DTY14	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
109	DID14	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
110	BPT14	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
111	ITS15	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
112	DTY15	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
113	DID15	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
114	BPT15	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
115	ITS16	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
116	DTY16	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
117	DID16	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
118	BPT16	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
119	ITS17	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
120	DTY17	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
121	DID17	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
122	BPT17	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
123	ITS18	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
124	DTY18	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
125	DID18	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
126	BPT18	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
127	ITS19	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
128	DTY19	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
129	DID19	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
130	BPT19	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
131	ITS20	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
132	DTY20	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
133	DID20	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
134	BPT20	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
135	CIS01	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
136	CTY01	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
137	CID01	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
138	CPT01	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
139	CIS02	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
140	CTY02	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
141	CID02	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
142	CPT02	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
143	CIS03	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
144	CTY03	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
145	CID03	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
146	CPT03	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
147	CIS04	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
148	CTY04	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
149	CID04	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
150	CPT04	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
151	CIS05	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
152	CTY05	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
153	CID05	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
154	CPT05	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
155	CIS06	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
156	CTY06	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
157	CID06	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
158	CPT06	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
159	CIS07	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
160	CTY07	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
161	CID07	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
162	CPT07	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
163	CIS08	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
164	CTY08	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
165	CID08	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
166	CPT08	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
167	CIS09	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
168	CTY09	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
169	CID09	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
170	CPT09	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
171	CIS10	Benefit Infotype Switch	char	1	0	NUMC	(N'0')	Yes		BEN_INFTYS	Allow NULL?
172	CTY10	Benefit dependent type	nvarchar	4	0	CHAR	(N' ')	Yes		BEN_DEPTYP	Allow NULL?
173	CID10	Benefit dependent object ID	nvarchar	2	0	CHAR	(N' ')	Yes		BEN_DEPID	Allow NULL?
174	CPT10	Benefit Payout Percentage for Beneficiaries	decimal	3	0	DEC	((0))	Yes		BEN_BPRCNT
175	INV01	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
176	IPT01	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
177	INV02	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
178	IPT02	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
179	INV03	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
180	IPT03	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
181	INV04	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
182	IPT04	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
183	INV05	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
184	IPT05	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
185	INV06	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
186	IPT06	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
187	INV07	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
188	IPT07	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
189	INV08	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
190	IPT08	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
191	INV09	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
192	IPT09	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
193	INV10	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
194	IPT10	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
195	INV11	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
196	IPT11	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
197	INV12	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
198	IPT12	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
199	INV13	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
200	IPT13	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
201	INV14	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
202	IPT14	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
203	INV15	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
204	IPT15	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
205	INV16	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
206	IPT16	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
207	INV17	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
208	IPT17	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
209	INV18	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
210	IPT18	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
211	INV19	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
212	IPT19	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT
213	INV20	Benefit Investment for Savings Plans	nvarchar	4	0	CHAR	(N' ')	Yes	T5UBN	BEN_INVEST	Allow NULL?
214	IPT20	Benefit investment percentage	decimal	3	0	DEC	((0))	Yes		BEN_INVPCT

TOP ERP 6.0 | PA0377 INDEXES

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

214 COLUMNS | 1 INDEXES | ERP 6.0 | PA0377 TABLE

TOP ERP 6.0 | PA0377 COLUMNS

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

214 COLUMNS | 1 INDEXES | ERP 6.0 | PA0377 TABLE

TOPERP 6.0 | PA0377 COLUMNS

TOPERP 6.0 | PA0377 INDEXES

TOP ERP 6.0 | PA0377 COLUMNS

TOP ERP 6.0 | PA0377 INDEXES