| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | INPER | In-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | FPPER | For-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | SEQNO | Key Field Sequence Number for SFP Data Records | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | KENID | Identifier of Record | nvarchar | 5 | 0 | | | | Allow NULL? |
| 7 | RZNSK | Data Center Number of Social Fund (R) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | RZNAG | Data Center Number for Company for Social Fund (R) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | BNRSK | Company Number at a Social Fund - Construction Industry | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | NUS01 | Unused Numeric Field - Length 7 | nvarchar | 7 | 0 | | | | Allow NULL? |
| 11 | NUS02 | Version Number Component | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | RZDAT | Creation Date of Data Medium | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | VERNR | Version of Data Medium Exchange | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | FNAME | Name of Company for Social Fund | nvarchar | 22 | 0 | | | | Allow NULL? |
| 15 | ZVKAN | Employee Number at a Construction Social Insurance Fund | nvarchar | 13 | 0 | | | | Allow NULL? |
| 16 | SKPNR | Personnel Number for Notifications in SFP | nvarchar | 13 | 0 | | | | Allow NULL? |
| 17 | MDART | Notification Type for Data Record AUMEL | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | ABRMO | Payroll Month in Social Fund Procedure | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | ABRJA | Payroll Year in Social Fund Procedure | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | BEGDA | Start of Notification Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | ENDDA | End of Notification Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | STONR | Number of Cancellation for Evaluation Data Records SFP | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | WAERS | Currency Key for Social Fund Procedure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | ALOHN | Trainee Remuneration for AUMEL | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | NUS03 | Character field of length 6 | nvarchar | 6 | 0 | | | | Allow NULL? |
| 26 | UAUSJ | Leave Entitlement in Final Year of Traineeship AUMEL | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | GAUSJ | Leave Days Granted in Final Year of Traineeship AUMEL | nvarchar | 2 | 0 | | | | Allow NULL? |
| 28 | NACHN | Last Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 29 | VORNA | First Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 30 | NUS04 | 17-Char. Field | nvarchar | 17 | 0 | | | | Allow NULL? |
