SAP ABAP Table V_T5S0P_ALL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_T5S0P_ALL	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	WERKS	☑	PERSA	PERSA	CHAR	4	0	Personnel Area	T001P
3	BTRTL	☑	BTRTL_001P	BTRTL	CHAR	4	0	Personnel Subarea
4	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
5	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
6	ORGNO	☐	P23_ORGNO	P23_ORGNO	NUMC	10	0	Organization number
7	LANKD	☐	P23_LANKD	P23_LANKD	CHAR	2	0	Region Key
8	KOMKD	☐	P23_KOMKD	P23_KOMKD	CHAR	2	0	Municipality key
9	SCBWP	☐	P23_SCBWP	P23_SCBWP	CHAR	5	0	SCB work place number
10	TABKD	☐	P23_TABKD	P23_TABKD	NUMC	3	0	Tax Table Number	T5S3A
11	TAKKD	☐	P23_TAKKD	P23_TAKKD	NUMC	1	0	Tax column	T5S3B
12	CFARN	☐	P23_CFARN	P23_CFARN	CHAR	9	0	CFAR number
13	SPPID	☐	P23_SPPID	P23_SPPID	CHAR	6	0	User-id for ALECTA
14	SPPDI	☐	P23_SPPDI	P23_SPPDI	CHAR	3	0	Cost Center
15	SPPCO	☐	P23_SPPCO	P23_SPPCO	CHAR	1	0	ALECTA code
16	SAFNO	☐	P23_SAFNO	P23_SAFNO	CHAR	7	0	SN number (Svenskt Näringsliv)
17	SAFWP	☐	P23_SAFWP	P23_SAFWP	CHAR	3	0	SN work place number
18	SAFUN	☐	P23_SAFUN	P23_SAFUN	CHAR	2	0	Union SN
19	METNR	☐	P23_METNR	CHAR04	CHAR	4	0	Union department
20	METPC	☐	P23_PROZS	P23_PROZS	DEC	5	2	Union due percentage
21	SIFNR	☐	P23_SIFNR	NUM10	NUMC	10	0	SIF number
22	AAREA	☐	P23_AAREA	P23_AAREA	CHAR	3	0	Agreement area ('Avtalsområde')
23	BUSIN	☐	P23_BUSIN	P23_BUSIN	CHAR	1	0	Not used
24	AMFNR	☐	P23_AMFNR	P23_AMFNR	CHAR	7	0	AMF number
25	COREC	☐	P23_COREC	P23_COREC	CHAR	1	0	Corporate reduction of employers contribution indicator
26	REGEC	☐	P23_REGEC	P23_REGEC	CHAR	1	0	Regional reduction of employers contribution indicator
27	CPIS	☐	P23_CPIS	P23_CPIS	CHAR	1	0	Compulsory pension insurance status	T5SPA
28	BTEXT	☐	BTRTX	TEXT15	CHAR	15	0	Personnel Subarea Text
29	NAME1	☐	PBTXT	TEXT30	CHAR	30	0	Personnel Area Text
30	MOLGA	☐	MOLGA	MOLGA	CHAR	2	0	Country Grouping	T500L
31	IDAL1	☐	P23_IDAL1		CHAR	10	0	ALECTA department 1 Pension Plan Identifier
32	IDAL2	☐	P23_IDAL2		CHAR	10	0	ALECTA department 2 Pension Plan Identifier
33	SPPRI	☐	P23_SPPRI	XFELD	CHAR	1	0	Service Sector Company

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_T5S0P_ALL	CPIS	T5SPA	CPIS		1	CN
2	V_T5S0P_ALL	MANDT	T000	MANDT		1	CN
3	V_T5S0P_ALL	MOLGA	T500L	MOLGA	REF	1	CN
4	V_T5S0P_ALL	TABKD	T5S3A	TABKD		1	CN
5	V_T5S0P_ALL	TAKKD	T5S3B	TAKKD		1	CN
6	V_T5S0P_ALL	WERKS	T001P	WERKS		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in