| 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 NEMEL | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | BEGDA | Start of Notification Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | STONR | Number of Cancellation for Evaluation Data Records SFP | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | WAERS | Currency Key for Social Fund Procedure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | BTAGE | Employment Days for Data Record URMEL | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | BLOHN | Gross Wage for Data Record URMEL | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | AGLST | Number of Lost Hours for Data Record URMEL | nvarchar | 6 | 0 | | | | Allow NULL? |
| 24 | UTAGE | Number of Leave Days | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | UVERG | Leave Remuneration Entitlement | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | RTAGE | Remaining Leave Days for Data Record RAMEL | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | RVERG | Leave Remuneration Entitlement | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | KENAJ | SFP: Indicator: Final Year of Traineeship / Young Person | char | 1 | 0 | | | | Allow NULL? |
| 29 | NACHN | Last Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 30 | VORNA | First Name | nvarchar | 30 | 0 | | | | Allow NULL? |
