SAP ABAP Table T5SPP (HR-SE: Information needed to be reported to Alecta)

Hierarchy

☛ SAP_HRCSE (Software Component) Sub component SAP_HRCSE of SAP_HR
   ⤷ PY-SE (Application Component) Sweden
     ⤷ PC23 (Package) HR accounting: Sweden

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T5SPP	Table Relationship Diagram
Short Description	HR-SE: Information needed to be reported to Alecta

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	RUNDT	☐	P23_RUNDT	CHAR14	CHAR	14	0	HR-SE: Date of report run
7	SPPID	☐	P23_SPPID	P23_SPPID	CHAR	6	0	User-id for ALECTA
8	SPPNO	☐	P23_SPPNO	P23_SPPNO	CHAR	6	0	SPP number
9	SPPDI	☐	P23_SPPDI	P23_SPPDI	CHAR	3	0	Cost Center
10	SPPRI	☐	P23_SPPRI	XFELD	CHAR	1	0	Service Sector Company
11	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
12	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
13	PERID	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
14	BAREA	☐	BEN_AREA	BEN_AREA	CHAR	2	0	Benefit area	T5UB3
15	PLTYP	☐	BEN_TYPE	BEN_TYPE	CHAR	4	0	Benefit plan type	T5UB1
16	BPLAN	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	T5UBA
17	ANSAL	☐	ANSAL_15	P_AMT08V	CURR	15	2	Annual salary
18	MOSAL	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
19	MOBEN	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
20	PRVPY	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
21	AVEL3	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
22	ASALD	☐	P23_ASALD	XFELD	CHAR	1	0	Annual salary decrease for ALECTA
23	ORGNO	☐	P23_ORGNO	P23_ORGNO	NUMC	10	0	Organization number
24	MNSAL	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
25	FITWK	☐	P23_FITWK		CHAR	3	0	Employee is Fit for Work
26	ABSPC	☐	P23_ABSPC		CHAR	2	0	Percentage of Absence
27	IDALE	☐	P23_IDALE		CHAR	10	0	ALECTA Pension Plan Identifier
28	RLEAV	☐	P23_RLEAV		CHAR	1	0	Reason for Leaving
29	PBEGD	☐	P23_PBEGD	DATUM	DATS	8	0	Start date of Long term parental leave
30	ALTPS	☐	P23_ALTPS		CHAR	2	0	EE had Alternative Pension Solution at Previous Employer
31	MRSAL	☐	ANSAL_15	P_AMT08V	CURR	15	2	Annual salary

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T5SPP	BAREA	T5UB3	BAREA
2	T5SPP	BPLAN	T5UBA	BPLAN
3	T5SPP	MANDT	T000	MANDT	KEY	1	CN
4	T5SPP	PERNR	PA0003	PERNR	KEY	1	CN
5	T5SPP	PLTYP	T5UB1	PLTYP

History

Last changed by/on	SAP	20110809
SAP Release Created in	470