T5D5Z SAP (Supplementary Pension Public Sector: SPI Data) Table details
Dictionary Type: Table
Description: Supplementary Pension Public Sector: SPI Data
Description: Supplementary Pension Public Sector: SPI Data
Table field list including key, data, relationships and ABAP select examples
T5D5Z is a standard SAP Table which is used to store Supplementary Pension Public Sector: SPI Data data and is available within R/3 SAP systems depending on the version and release level.
The T5D5Z table consists of various fields, each holding specific information or linking keys about Supplementary Pension Public Sector: SPI Data data available in SAP. These include ZVEID (SPI ID (Obsolete with ZVMP)), KTEXT (Designation of Supplementary Pension Institute), MEKEY (Notification Key), MGKEY (Notification Reason Key).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP T5D5Z table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| ZVEID | SPI ID (Obsolete with ZVMP) | VZVID | CHAR | 2 | VZVID | ||||
| KTEXT | Designation of Supplementary Pension Institute | TXZVK | CHAR | 25 | TXT25 | ||||
| MEKEY | Notification Key | VMEKY | NUMC | 2 | T5D5D | VMEKY | |||
| MGKEY | Notification Reason Key | VMGKY | NUMC | 2 | T5D5E | VMGKY | |||
| KOKEY | Combination Key | VKOKY | NUMC | 2 | T5D5G | VKOKY | |||
| CAKEY | Payroll Key | VCAKY | NUMC | 2 | T5D5C | VCAKY | |||
| STIDA | Day and Month of Key Date for Notification of Differences | STIDA | NUMC | 4 | STIDA | ||||
| TAGGE | Indicator: Absences must be reported for exact days | TAGGE | CHAR | 1 | XFELD | ||||
| ANZUB | Indicator: Correction of Group Registrations Summarized | ANZUB | CHAR | 1 | XFELD | ||||
| ANMEL | Indicator: Registrations on Data Medium | ANMEL | CHAR | 1 | XFELD | ||||
| ANBER | Indicator: Correction of Registrations on Data Medium | ANBER | CHAR | 1 | XFELD | ||||
| ANSTO | Indicator: Reversal of Registrations on Data Medium | ANSTO | CHAR | 1 | XFELD | ||||
| ABMEL | Indicator: Deregistrations on Data Medium | ABMEL | CHAR | 1 | XFELD | ||||
| ABBER | Indicator: Correction of Deregistration on Data Medium | ABBER | CHAR | 1 | XFELD | ||||
| ABSTO | Indicator: Reversal of Deregistrations on Data Medium | ABSTO | CHAR | 1 | XFELD | ||||
| JAMEL | Indicator: Whether Annual Reports are on Data Medium | JAMEL | CHAR | 1 | XFELD | ||||
| JABER | Indic.: Correction of Annual Reports on Data Medium | JABER | CHAR | 1 | XFELD | ||||
| JASTO | Indicator: Reversal of Annual Reports on Data Medium | JASTO | CHAR | 1 | XFELD | ||||
| ADRDV | Layout rule for address type | VARGA | CHAR | 8 | T536A | VARGA | |||
| ZULNR | Registration Number for VBL | NRZLG | CHAR | 4 | NRZLG | ||||
| DABNA | File Name | DABNA | CHAR | 4 | DABNA | ||||
| DASNA | Name of File on the Data Carrier | DASNA | CHAR | 6 | DASNA | ||||
| LFDNR | Sequential File Number for Data Carrier Notifications | DNRLF | CHAR | 4 | DNRLF | ||||
| ADRZV | Layout rule for address type | VARGA | CHAR | 8 | T536A | VARGA | |||
| PFZUW | Supplementary Pension Liability for Special Payment | HR_PFZUW | CHAR | 1 | HR_PFZUW | ||||
| PZVER | Type of Check Digit Procedure | PZVER | CHAR | 2 | PZVER | ||||
| VBLID | Indicator: Supplementary Pension Institute | VBLID | NUMC | 2 | VBLID | ||||
| FOPOS | Output Format of Positive Amounts on Data Medium | FOPOS | CHAR | 9 | CHAR9 | ||||
| FONEG | Output Format of Negative Amounts on Data Medium | FONEG | CHAR | 9 | CHAR9 | ||||
| SVVER | Supplementary SI | SVVER | CHAR | 8 | T5D1H | SVVER | |||
| WOKNZ | West/East Indicator | WOKNZ | CHAR | 1 | WOKNZ | ||||
| UELID | AKA Number of SPI (Forwarding Number) | P01P_ZV_UELID | CHAR | 3 | PDEP_ZV_UELID | ||||
| AINSL | Key for Investment Institution | P01_AINSL | CHAR | 8 | T5DRB | P01_AINSL |
| Key field | Non-key field |
How do I retrieve data from SAP table T5D5Z using ABAP code
The following ABAP code Example will allow you to do a basic selection on T5D5Z to SELECT all data from the tableDATA: WA_T5D5Z TYPE T5D5Z.
SELECT SINGLE *
FROM T5D5Z
INTO CORRESPONDING FIELDS OF WA_T5D5Z
WHERE...
How to access SAP table T5D5Z
Within an ECC or HANA version of SAP you can also view further information about T5D5Z and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects