SAP ABAP Table PA0051 (HR Master Record Infotype 0051 (VBL/SPI Data))

Hierarchy

☛ SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
   ⤷ PY-DE-PS (Application Component) Public Sector
     ⤷ P01O_ZV (Package) SP Notification Program for Public Sector Germany

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0051	Table Relationship Diagram
Short Description	HR Master Record Infotype 0051 (VBL/SPI Data)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	Key for HR Master Data
3	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
4	SUBTY	☑	SUBTY	SUBTY	CHAR	4	0	Subtype
5	OBJPS	☑	OBJPS	OBJPS	CHAR	2	0	Object Identification
6	SPRPS	☑	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
7	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
8	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
9	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
10	.INCLUDE	☐				0	0	HR Master Record: Control Field
11	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
12	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
14	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
15	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
16	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
17	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
18	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
19	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
20	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
24	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
26	.INCLUDE	☐				0	0	HR Master Record Infotype 0051 (VBL/SPI Data)
27	VBLPF	☐	VBLPF	P01P_VBLPF	CHAR	1	0	Employee's Insurance Liability
28	PFBIS	☐	PFBIS	CHAR3	CHAR	3	0	Maximum Age for Insurance
29	BEINB	☐	BEINB	KMONAT	NUMC	2	0	Period for higher assessment threshold
30	PAUST	☐	PAUST	PAUST	CHAR	1	0	Tax Indicator
31	VBLNR	☐	VBLNO	CHAR10	CHAR	10	0	Insurance Number (Public Sector) (Obsolete with ZVMP)
32	TTART	☐	TTART	VBLAK	CHAR	2	0	Job in Special Case (Obsolete with ZVMP)	T535V
33	VVZVE	☐	VVZVE	XFELD	CHAR	1	0	Previous insurance at another SPI
34	ARGZU	☐	ARGZU	XFELD	CHAR	1	0	Previous Employer's Contribution (Obsolete with ZVMP)
35	BEZVE	☐	BEZVE	XFELD	CHAR	1	0	Previous exemption from ZVE
36	ZWVER	☐	DZWVER	XFELD	CHAR	1	0	Second Insurance Contract
37	AGRND	☐	AGRND	VBLAK	CHAR	2	0	Deregistration Reason (Obsolete with ZVMP)	T535V
38	SWTBE	☐	SWTBE	SWTBE	CHAR	1	0	Employment Type (Obsolete with ZVMP)
39	WIEDE	☐	WIEDE	XFELD	CHAR	1	0	Rehiring of Seasonal/Forestry Workers (Obsolete with ZVMP)
40	ZVSOD	☐	DZVSOD	CHAR1	CHAR	1	0	Supplementary Pension (Civil Service) (Obsolete with ZVMP)
41	ZVEID	☐	VWOID	VZVID	CHAR	2	0	Different ID for SPI (Obsolete with ZVMP)	T5D5Z
42	UMLAN	☐	UMLAN	XFELD	CHAR	1	0	Indicator: Is contribution amount to be paid to employee?
43	FAMST	☐	FAMSTZV	FAMSTZV	CHAR	1	0	Material Status (for SP Notifications) (Obsolete with ZVMP)
44	ANSKG	☐	ANSKGZV	ANSKGZV	CHAR	1	0	Entitlm. to Child Allowance (SP Notifs) (Obsolete with ZVMP)
45	ZSUML	☐	VZSUML	XFELD	CHAR	1	0	Additional Contribution Amount/Contribution from 2002
46	VTMOD	☐	P01_VTMOD	P01_VTMOD	CHAR	4	0	AVmG: Contract Model	T5DR3
47	KZ_ALTBESTAND	☐	P01P_KZ_ALTBESTAND	XFELD	CHAR	1	0	Key Fig., Prior-Year Acquisitions (Due to Retro. Financing)
48	ANZKE	☐	P01P_ZV_ANZ_KIND_ELTERNZEIT_N	P01P_ZV_ANZ_KIND_ELTERNZEIT	NUMC	2	0	Suppl. Pension: No. of Children Entitled to Parental Leave
49	.INCLUDE	☐				0	0	Employer Identification
50	WERKS_SUM	☐	PERSA_SUM	PERSA	CHAR	4	0	Personnel Area Reporting	T5DPBSZVAGE
51	BTRTL_SUM	☐	BTRTL_SUM	BTRTL	CHAR	4	0	Personnel Subarea Reporting	T5DPBSZVAGE
52	VAKEY	☐	P01P_VARKEY	CHAR08	CHAR	8	0	Variable Key for Employer Table	T5DPBSZVAGE
53	VERNR	☐	P01P_VERNR	P01P_VERNR	CHAR	12	0	Supp. Insurance Number
54	ABMGR	☐	P01P_ABMGR	P01P_ABMGR	CHAR	2	0	Deregistration Reason of DATUEV-ZVE
55	NONOT	☐	P01P_NONOT	XFELD	CHAR	1	0	Switch: Do Not Transfer Notifications
56	STMOD	☐	P01P_ZVSTEU	P01P_ZVSTEU	CHAR	2	0	Supplementary Pension: Tax Model	T5D5H
57	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0051	AGRND	T535V	IDENT
2	PA0051	BTRTL_SUM	T5DPBSZVAGE	WERKS_SUM	KEY	1	CN
3	PA0051	MANDT	T000	MANDT	KEY	1	CN
4	PA0051	PERNR	PA0003	PERNR	KEY	1	CN
5	PA0051	PREAS	T530E	PREAS	REF	C	CN
6	PA0051	STMOD	T5D5H	STMOD	KEY	1	CN
7	PA0051	TTART	T535V	IDENT
8	PA0051	VAKEY	T5DPBSZVAGE	BTRTL_SUM	KEY	1	CN
9	PA0051	VTMOD	T5DR3	VTMOD
10	PA0051	ZVEID	T5D5Z	ZVEID

History

Last changed by/on	SAP	20060703
SAP Release Created in