SAP ABAP Table V_T5SPP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_T5SPP	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

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	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
3	PERPA	☑	IPERI	CHAR6	CHAR	6	0	In-period for payroll
4	EVNTY	☑	P23_EVNTY	P23_EVNTY	CHAR	2	0	Event Type for ALECTA
5	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
6	SPPDI	☐	P23_SPPDI	P23_SPPDI	CHAR	3	0	Cost Center
7	ANSAL	☐	ANSAL_15	P_AMT08V	CURR	15	2	Annual salary
8	MOSAL	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
9	MOBEN	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
10	PRVPY	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
11	AVEL3	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
12	ASALD	☐	P23_ASALD	XFELD	CHAR	1	0	Annual salary decrease for ALECTA
13	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
14	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
15	PERID	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
16	PLTYP	☐	BEN_TYPE	BEN_TYPE	CHAR	4	0	Benefit plan type
17	BPLAN	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan
18	ORGNO	☐	P23_ORGNO	P23_ORGNO	NUMC	10	0	Organization number
19	MNSAL	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
20	FITWK	☐	P23_FITWK		CHAR	3	0	Employee is Fit for Work
21	ABSPC	☐	P23_ABSPC		CHAR	2	0	Percentage of Absence
22	IDALE	☐	P23_IDALE		CHAR	10	0	ALECTA Pension Plan Identifier
23	RLEAV	☐	P23_RLEAV		CHAR	1	0	Reason for Leaving
24	PBEGD	☐	P23_PBEGD	DATUM	DATS	8	0	Start date of Long term parental leave
25	ALTPS	☐	P23_ALTPS		CHAR	2	0	EE had Alternative Pension Solution at Previous Employer

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_T5SPP	MANDT	T000	MANDT	KEY	1	CN
2	V_T5SPP	PERNR	PA0003	PERNR	KEY	1	CN

History

Last changed by/on	SAP	20110809
SAP Release Created in