SAP Table T5DPBSZVZVE
Supplementary Pension Institute
T5DPBSZVZVE (Supplementary Pension Institute) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T5DPBSZVZVE to other SAP tables.
T5DPBSZVZVE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
ANLAR
Investment Type
|
P01_ANLAR | T5DR1 |
CHAR
|
4 | 0 | |||||||||||
|
AINSL
Key for Investment Institution
|
P01_AINSL | T5DRB |
CHAR
|
8 | 0 | |||||||||||
|
ENDDA
End Date
|
ENDDA |
DATS
|
8 | 0 | ||||||||||||
|
ZVEGR
Group of SPI
|
P01P_ZVEGR | T5DPBSZVZGE |
CHAR
|
5 | 0 | |||||||||||
|
PZVER
Type of Check Digit Procedure
|
PZVER |
CHAR
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
FINAN
Financing of the SPI (Obsolete, Depends on Ring-Fencing)
|
P01P_FINAN |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
DABNA
File Name
|
DABNA |
CHAR
|
4 | 0 | ||||||||||||
|
||||||||||||||||
|
MFACT
Notification Factory
|
P01P_MFACT | SEOCLASS |
CHAR
|
30 | 0 | |||||||||||
|
MKORR
Reporting Corrections: Corrections or Cancel/New?
|
P01P_MKORR |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MDIFF
Are difference records required (yes/no)?
|
P01P_MDIFF |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MSUMM
Are totals records required (yes/no)?
|
P01P_MSUMM |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MJMAB
Is Annual Report Required Despite Existing Deregistration?
|
P01P_MJMAB |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
JMDTA
Is Separate Data Medium for Annual Report Required?
|
P01P_JMDTA |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MUMAG
Is the employer's contribution amount to be reported?
|
P01P_MUMAG |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MUMAN
Is the employee's contribution amount to be reported?
|
P01P_MUMAN |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MBEAG
Report the employer's contribution? (Obsolete:always report)
|
P01P_MBEAG |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MBEAN
Report the employee's contribution? (Obsolete:always report)
|
P01P_MBEAN |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MSANI
Report the reorganization pay?
|
P01P_MSANI |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MSTRU
Key for Notification Record Structures
|
P01P_MSTRU | T5DPBSZVST |
CHAR
|
2 | 0 | |||||||||||
|
EMFSA
Payee key for bank transfers
|
EMFSL_521B |
CHAR
|
8 | 0 | ||||||||||||
|
EMFSB
Payee key for bank transfers
|
EMFSL_521B |
CHAR
|
8 | 0 | ||||||||||||
|
ZULNR
License Number of SPI Data Center
|
P01P_ZULNR |
CHAR
|
4 | 0 | ||||||||||||
T5DPBSZVZVE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T5DPBSZVZVE | AINSL | T5DPBSZVZVE | AINSL |
T5DRB
AVmG: Investment Institute
|
AINSL |
| T5DPBSZVZVE | AINSL | T5DPBSZVZVE | ENDDA |
T5DRB
AVmG: Investment Institute
|
ENDDA |
| T5DPBSZVZVE | AINSL | T5DPBSZVZVE | MANDT |
T5DRB
AVmG: Investment Institute
|
MANDT |
| T5DPBSZVZVE | AINSL | T5DPBSZVZVE | ANLAR |
T5DRB
AVmG: Investment Institute
|
ANLAR |
| T5DPBSZVZVE | ANLAR | SYST | MANDT |
T5DR1
AVmG: Investment Types
|
MANDT |
| T5DPBSZVZVE | ANLAR | T5DPBSZVZVE | ANLAR |
T5DR1
AVmG: Investment Types
|
ANLAR |
| T5DPBSZVZVE | MANDT | T5DPBSZVZVE | MANDT |
T000
Clients
|
MANDT |
| T5DPBSZVZVE | MFACT | T5DPBSZVZVE | MFACT |
SEOCLASS
Class/Interface
|
CLSNAME |
| T5DPBSZVZVE | MSTRU | T5DPBSZVZVE | MANDT |
T5DPBSZVST
Notification Record Structures for Data Medium
|
MANDT |
| T5DPBSZVZVE | MSTRU | T5DPBSZVZVE | MSTRU |
T5DPBSZVST
Notification Record Structures for Data Medium
|
MSTRU |
| T5DPBSZVZVE | MSTRU | * |
T5DPBSZVST
Notification Record Structures for Data Medium
|
ENDDA | |
| T5DPBSZVZVE | ZVEGR | T5DPBSZVZVE | ZVEGR |
T5DPBSZVZGE
Definition of SPI Group: Entity
|
ZVEGR |
| T5DPBSZVZVE | ZVEGR | T5DPBSZVZVE | MANDT |
T5DPBSZVZGE
Definition of SPI Group: Entity
|
MANDT |