| 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 | T000 | MANDT | Allow NULL? |
| 2 | PERNR | DEUEV: Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | D3PERNR | Allow NULL? |
| 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | D3JAHR | Allow NULL? |
| 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | D3MNR | Allow NULL? |
| 5 | VF | Data Record Procedure Indicator | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | D3VF | Allow NULL? |
| 6 | BBNRAB | HR-DDU: Company Number of Logical Sender | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | D3BBNRAB | Allow NULL? |
| 7 | BBNREP | Company Number of Logical Recipient | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | D3BBNREP | Allow NULL? |
| 8 | VERNR | Version Number | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | D3VERNR | Allow NULL? |
| 9 | ED | Creation Date and Time of the Data Record | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | D3ED | Allow NULL? |
| 10 | FEKZ | Indicator for Data Records with Errors | char | 1 | 0 | NUMC | (N'0') | Yes | | D3FEKZ | Allow NULL? |
| 11 | FEAN | Number of Data Record Errors | char | 1 | 0 | NUMC | (N'0') | Yes | | D3FEAN | Allow NULL? |
| 12 | VSNR | Pension Insurance Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | D3VSNR | Allow NULL? |
| 13 | VSTR | HR-DDU: Insurer | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | D3VSTR | Allow NULL? |
| 14 | BBNRVU | Company Number of Responsible Party (Employer) | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | D3BBNRVU | Allow NULL? |
| 15 | AZVU | DEUEV: File Number of Responsible Party (Employer) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | D3AZVU | Allow NULL? |
| 16 | BBNRKK | Company Number of Health Insurance Fund | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | D3BBNRKK | Allow NULL? |
| 17 | AZKK | Health Insurer Reference | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | D3AZKK | Allow NULL? |
| 18 | BBNRAS | HR-DDU: Company Number of Accounting Office | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | D3BBNRAS | Allow NULL? |
| 19 | PERSGR | DEUEV: Person Group Key | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | D3PERSGR | Allow NULL? |
| 20 | GD | Submission Reason for DEUEV Notification | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | D3GD | Allow NULL? |
| 21 | SASC | Nationality Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | D3SASC | Allow NULL? |
| 22 | MMME | HR-DDU: DBME Data Module Available | char | 1 | 0 | CHAR | (N' ') | Yes | | D3MMME | Allow NULL? |
| 23 | MMNA | HR-DDU: DMNA Data Module Available | char | 1 | 0 | CHAR | (N' ') | Yes | | D3MMNA | Allow NULL? |
| 24 | MMGB | HR-DDU: DBGB Data Module Available | char | 1 | 0 | CHAR | (N' ') | Yes | | D3MMGB | Allow NULL? |
| 25 | MMAN | HR-DDU: Data Module DBAN Available | char | 1 | 0 | CHAR | (N' ') | Yes | | D3MMAN | Allow NULL? |
| 26 | MMEU | HR-DDU: DBEU Data Module Available | char | 1 | 0 | CHAR | (N' ') | Yes | | D3MMEU | Allow NULL? |
| 27 | MMSO | DEUEV: DBUV Data Module Available | char | 1 | 0 | CHAR | (N' ') | Yes | | D3MMSO | Allow NULL? |
| 28 | MMKS | HR-DDU: DBKS Data Module Available | char | 1 | 0 | CHAR | (N' ') | Yes | | D3MMKS | Allow NULL? |
| 29 | MMSV | HR-DDU: DBSV Data Module Available | char | 1 | 0 | CHAR | (N' ') | Yes | | D3MMSV | Allow NULL? |
| 30 | MMVR | HR-DDU: DBVR Data Module Available | char | 1 | 0 | CHAR | (N' ') | Yes | | D3MMVR | Allow NULL? |
| 31 | MMRG | HR-DDU: DBRG Data Module Available | char | 1 | 0 | CHAR | (N' ') | Yes | | D3MMRG | Allow NULL? |
| 32 | KENNZUE | HR-DDU: Previous Notification Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | D3KENNZUE | Allow NULL? |
| 33 | RESERVE | HR-DDU: Reserve Field Initially 10-Digit | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | | D3RES10 | Allow NULL? |
| 34 | MMKV | DEUEV Data Module DBKV Exists | char | 1 | 0 | CHAR | (N' ') | No | | P01_SV_D3_MMKV | Allow NULL? |
