SAP ABAP Table T5D5Z (Supplementary Pension Public Sector: SPI Data)

Hierarchy

☛ SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
   ⤷ PY-DE-PS (Application Component) Public Sector
     ⤷ P01O (Package) HR Germany: Public Sector

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T5D5Z	Table Relationship Diagram
Short Description	Supplementary Pension Public Sector: SPI Data

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	*
2	ZVEID	☑	VZVID	VZVID	CHAR	2	0	SPI ID (Obsolete with ZVMP)
3	KTEXT	☐	TXZVK	TXT25	CHAR	25	0	Designation of Supplementary Pension Institute
4	MEKEY	☐	VMEKY	VMEKY	NUMC	2	0	Notification Key	T5D5D
5	MGKEY	☐	VMGKY	VMGKY	NUMC	2	0	Notification Reason Key	T5D5E
6	KOKEY	☐	VKOKY	VKOKY	NUMC	2	0	Combination Key	T5D5G
7	CAKEY	☐	VCAKY	VCAKY	NUMC	2	0	Payroll Key	T5D5C
8	STIDA	☐	STIDA	STIDA	NUMC	4	0	Day and Month of Key Date for Notification of Differences
9	TAGGE	☐	TAGGE	XFELD	CHAR	1	0	Indicator: Absences must be reported for exact days
10	ANZUB	☐	ANZUB	XFELD	CHAR	1	0	Indicator: Correction of Group Registrations Summarized
11	ANMEL	☐	ANMEL	XFELD	CHAR	1	0	Indicator: Registrations on Data Medium
12	ANBER	☐	ANBER	XFELD	CHAR	1	0	Indicator: Correction of Registrations on Data Medium
13	ANSTO	☐	ANSTO	XFELD	CHAR	1	0	Indicator: Reversal of Registrations on Data Medium
14	ABMEL	☐	ABMEL	XFELD	CHAR	1	0	Indicator: Deregistrations on Data Medium
15	ABBER	☐	ABBER	XFELD	CHAR	1	0	Indicator: Correction of Deregistration on Data Medium
16	ABSTO	☐	ABSTO	XFELD	CHAR	1	0	Indicator: Reversal of Deregistrations on Data Medium
17	JAMEL	☐	JAMEL	XFELD	CHAR	1	0	Indicator: Whether Annual Reports are on Data Medium
18	JABER	☐	JABER	XFELD	CHAR	1	0	Indic.: Correction of Annual Reports on Data Medium
19	JASTO	☐	JASTO	XFELD	CHAR	1	0	Indicator: Reversal of Annual Reports on Data Medium
20	ADRDV	☐	VARGA	VARGA	CHAR	8	0	Layout rule for address type	T536A
21	ZULNR	☐	NRZLG	NRZLG	CHAR	4	0	Registration Number for VBL
22	DABNA	☐	DABNA	DABNA	CHAR	4	0	File Name
23	DASNA	☐	DASNA	DASNA	CHAR	6	0	Name of File on the Data Carrier
24	LFDNR	☐	DNRLF	DNRLF	CHAR	4	0	Sequential File Number for Data Carrier Notifications
25	ADRZV	☐	VARGA	VARGA	CHAR	8	0	Layout rule for address type	T536A
26	PFZUW	☐	HR_PFZUW	HR_PFZUW	CHAR	1	0	Supplementary Pension Liability for Special Payment
27	PZVER	☐	PZVER	PZVER	CHAR	2	0	Type of Check Digit Procedure
28	VBLID	☐	VBLID	VBLID	NUMC	2	0	Indicator: Supplementary Pension Institute
29	FOPOS	☐	FOPOS	CHAR9	CHAR	9	0	Output Format of Positive Amounts on Data Medium
30	FONEG	☐	FONEG	CHAR9	CHAR	9	0	Output Format of Negative Amounts on Data Medium
31	SVVER	☐	SVVER	SVVER	CHAR	8	0	Supplementary SI	T5D1H
32	WOKNZ	☐	WOKNZ	WOKNZ	CHAR	1	0	West/East Indicator
33	UELID	☐	P01P_ZV_UELID	PDEP_ZV_UELID	CHAR	3	0	AKA Number of SPI (Forwarding Number)
34	AINSL	☐	P01_AINSL	P01_AINSL	CHAR	8	0	AVmG: Key for Investment Institution	T5DRB

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T5D5Z	ADRDV	T536A	VARGU
2	T5D5Z	ADRZV	T536A	VARGU
3	T5D5Z	AINSL	T5DRB	AINSL
4	T5D5Z	CAKEY	T5D5C	CAKEY	KEY
5	T5D5Z	KOKEY	T5D5G	KOKEY	KEY
6	T5D5Z	MEKEY	T5D5D	MEKEY	KEY
7	T5D5Z	MGKEY	T5D5E	MGKEY	KEY
8	T5D5Z	SVVER	T5D1H	SVVER

History

Last changed by/on	SAP	20030108
SAP Release Created in