| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | PDPBSZVADM | MANDT | Allow NULL? |
| 2 | PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | P_PERNR | Allow NULL? |
| 3 | AUSWP | Evaluation Period | nvarchar | 6 | 0 | CHAR | (N' ') | No | | P01_AUSWP | Allow NULL? |
| 4 | ANLAR | Investment Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T5DR1 | P01_ANLAR | Allow NULL? |
| 5 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | CHAR | (N' ') | No | T5DPBSZVZVE | P01_AINSL | Allow NULL? |
| 6 | MRELE | Event Relevant for Notification | nvarchar | 2 | 0 | CHAR | (N' ') | No | T5DPBSZVER | P01P_MRELE | Allow NULL? |
| 7 | METYP | Notification Type | char | 1 | 0 | CHAR | (N' ') | No | T5DPBSZVTY | P01P_METYP | Allow NULL? |
| 8 | SEQMR | Seq. No. for Identical Events Relevant for Notif., ZVE-PBS | nvarchar | 2 | 0 | NUMC | (N'00') | No | | P01P_SEQMR | Allow NULL? |
| 9 | SEQSA | Sequence Number for Identical Record Types, ZVE-PBS | nvarchar | 2 | 0 | NUMC | (N'00') | No | | P01P_SEQSA | Allow NULL? |
| 10 | UEREV | Transfer Relevance of a Record, ZVE-PBS | char | 1 | 0 | CHAR | (N' ') | No | | P01P_UEREV | Allow NULL? |
| 11 | MTATB | Reason for Notification | nvarchar | 2 | 0 | CHAR | (N' ') | No | | P01P_MTATB | Allow NULL? |
| 12 | SATZA | Record Type, DATUEV-ZVE | nvarchar | 2 | 0 | CHAR | (N' ') | No | | P01P_SATZA | Allow NULL? |
| 13 | ABBEG | Start of Period, ZVE-PBS | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | P01P_ABBEG | Allow NULL? |
| 14 | ABEND | End of Period, ZVE-PBS | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | P01P_ABEND | Allow NULL? |
| 15 | EINZA | Payer (DATUEV-ZVE) | nvarchar | 2 | 0 | CHAR | (N' ') | No | | P01P_EINZA | Allow NULL? |
| 16 | VSMKM | Insurance Feature, DATUEV-ZVE | nvarchar | 2 | 0 | CHAR | (N' ') | No | | P01P_VSMKM | Allow NULL? |
| 17 | STMKM | Taxing Feature, DATUEV-ZVE | nvarchar | 2 | 0 | CHAR | (N' ') | No | | P01P_STMKM | Allow NULL? |
| 18 | ZPERI | Payment Period of Contributions, ZVE-PBS | nvarchar | 6 | 0 | CHAR | (N' ') | No | | P01P_ZPERI | Allow NULL? |
| 19 | PFENT | Remuneration Liable to SP Contributions/I BAT Excess | decimal | 9 | 2 | DEC | ((0)) | No | | P01P_PFENT | |
| 20 | BETRG | Contribution | decimal | 9 | 2 | DEC | ((0)) | No | | P01P_BETRG | |
| 21 | ANZKI | Number of Children for Parental Leave Entitlement | nvarchar | 2 | 0 | CHAR | (N' ') | No | | P01P_ANZKI | Allow NULL? |
| 22 | ZUFLJ | Year of Remuneration Accrual | nvarchar | 4 | 0 | CHAR | (N' ') | No | | P01P_ZUFLJ | Allow NULL? |
| 23 | GRDNZ | Reason for Retroactive Payment, ZVE-PBS | char | 1 | 0 | CHAR | (N' ') | No | | P01P_GRDNZ | Allow NULL? |
| 24 | NRABV | Number of Additional Work Relationship (for VBL Only) | char | 1 | 0 | CHAR | (N' ') | Yes | | P01P_NRABV | Allow NULL? |