| 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 | STRAS | Street, ZVE-PBS | nvarchar | 30 | 0 | CHAR | (N' ') | No | | P01P_STRAS | Allow NULL? |
| 14 | HAUSN | House Number, ZVE-PBS | nvarchar | 10 | 0 | CHAR | (N' ') | No | | P01P_HAUSN | Allow NULL? |
| 15 | POSTF | P.O. Box, ZVE-PBS | nvarchar | 10 | 0 | CHAR | (N' ') | No | | P01P_POSTF | Allow NULL? |
| 16 | LDKNZ | Country (License Plate) Code | nvarchar | 3 | 0 | CHAR | (N' ') | No | | D3LDKZ | Allow NULL? |
| 17 | PSTLZ | Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | No | | D3PLZ | Allow NULL? |
| 18 | WOORT | City of Residence, ZVE-PBS | nvarchar | 30 | 0 | CHAR | (N' ') | No | | P01P_WOORT | Allow NULL? |
| 19 | ADART | Address Type, ZVE-PBS | char | 1 | 0 | CHAR | (N' ') | No | | P01P_ADART | Allow NULL? |
| 20 | ZSVMK | Delivery Note (c/o Smith), DATUEV-ZVE | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P01P_ZSVMK | Allow NULL? |