SAP ABAP Table P11_VHI_PERNR_EXCL_LIST (HR-IE: Personnel numbers excluded from VHI upload)

Hierarchy

☛ SAP_HRCIE (Software Component) Sub component SAP_HRCIE of SAP_HR
   ⤷ PA-PA-IE (Application Component) Ireland
     ⤷ PB11 (Package) HR master data: Ireland

Basic Data

Table Category	INTTAB	Structure
Structure	P11_VHI_PERNR_EXCL_LIST	Table Relationship Diagram
Short Description	HR-IE: Personnel numbers excluded from VHI upload

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	HR-IE: General List output header
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
4	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
5	NAME1	☐	PBTXT	TEXT30	CHAR	30	0	Personnel Area Text
6	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
7	BTEXT	☐	BTRTX	TEXT15	CHAR	15	0	Personnel Subarea Text
8	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	T501
9	PGTXT	☐	PGTXT	TEXT20	CHAR	20	0	Name of Employee Group
10	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	T503K
11	PKTXT	☐	PKTXT	TEXT20	CHAR	20	0	Name of Employee Subgroup
12	ORGEH	☐	ORGEH	ORGEH	NUMC	8	0	Organizational Unit	T527X
13	ORGTX	☐	ORGTX	TEXT25	CHAR	25	0	Short Text of Organizational Unit
14	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
15	KOSTT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
16	ABKRS	☐	ABKRS	ABKRS	CHAR	2	0	Payroll Area	T549A
17	ABKTX	☐	ABKTX	TEXT20	CHAR	20	0	Payroll Area Text
18	PERNR	☐	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
19	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
20	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
21	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
22	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
23	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
24	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
25	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
26	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
27	.INCLUDE	☐				0	0	HR Master Record: Infotype 0386 (VHI Scheme)
28	LGART	☐	LGART	LGART	CHAR	4	0	Wage Type	T512Z
29	BETRG	☐	BETRG	WERTV5	CURR	9	2	Amount
30	ANZHL	☐	ANZHL	ANZHL	DEC	7	2	Number
31	ZEINH	☐	PT_ZEINH	RPMSH	CHAR	3	0	Time/Measurement Unit	T538A
32	UWDAT	☐	UWDAT	DATUM	DATS	8	0	Date of Bank Transfer
33	MODEL	☐	MODE1	MODEL	CHAR	4	0	Payment Model	T549W
34	VHIGP	☐	PIE_VHIGP	NUM05	NUMC	5	0	Company Group Number
35	VHIPN	☐	PIE_VHIPN	NUM10	NUMC	10	0	Policy Number
36	VHIRN	☐	PIE_VHIRN	NUM02	NUMC	2	0	Renewal Number
37	VHIPL	☐	PIE_VHIPL	PIE_VHIPL	CHAR	1	0	Plan Type
38	VHIHD	☐	PIE_VHIHD	TEXT30	CHAR	30	0	Policy Holder
39	VHIAD	☐	PIE_VHIAD	NUM02	NUMC	2	0	Number of Adults on the Health Insurance Policy
40	VHICH	☐	PIE_VHICH	NUM02	NUMC	2	0	Number of Children on Health Insurance Policy
41	VHIXA	☐	PIE_VHIXA	NUM02	NUMC	2	0	Extra Adults on Health Insurance Policy
42	VHIAN	☐	PIE_VHIAN	PIE_CRNCY	CURR	11	2	Annual Subscription
43	VHISB	☐	PIE_VHISB	PIE_CRNCY	CURR	11	2	Annual Employer Subsidy Towards Health Insurance
44	VHIBL	☐	PIE_VHIBL	PIE_CRNCY	CURR	11	2	Contribution Balance
45	VHIFQ	☐	TEXT10	TEXT10	CHAR	10	0	Text (10 Characters)
46	VHICM	☐	PIE_VHICM	TEXT12	CHAR	12	0	Comment about deduction being made
47	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
48	WTYP2	☐	LGART	LGART	CHAR	4	0	Wage Type	*
49	VHIPP	☐	PIE_VHIPP	PIE_CRNCY	CURR	11	2	Per period contribution
50	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P11_VHI_PERNR_EXCL_LIST	ABKRS	T549A	ABKRS
2	P11_VHI_PERNR_EXCL_LIST	BTRTL	T001P	BTRTL
3	P11_VHI_PERNR_EXCL_LIST	LGART	T512Z	LGART
4	P11_VHI_PERNR_EXCL_LIST	MODEL	T549W	MODEL
5	P11_VHI_PERNR_EXCL_LIST	ORGEH	T527X	ORGEH
6	P11_VHI_PERNR_EXCL_LIST	PERSG	T501	PERSG
7	P11_VHI_PERNR_EXCL_LIST	PERSK	T503K	PERSK
8	P11_VHI_PERNR_EXCL_LIST	WAERS	TCURC	WAERS
9	P11_VHI_PERNR_EXCL_LIST	WERKS	T500P	PERSA
10	P11_VHI_PERNR_EXCL_LIST	ZEINH	T538A	ZEINH

History

Last changed by/on	SAP	20081217
SAP Release Created in	500