| 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 | BAUTY | Employee Subgroup Grouping for Construction Pay | char | 1 | 0 | | | | Allow NULL? |
| 17 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | ABRMO | Payroll Month in Social Fund Procedure | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | ABRJA | Payroll Year in Social Fund Procedure | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | WAERS | Currency Key for Social Fund Procedure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | BLSUM | Total Gross Wages of All Industrial Employees | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | ANZGE | Number of Industrial Workers | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | BEIGE | Contribution (Without Trainees Remuneration) | nvarchar | 9 | 0 | | | | Allow NULL? |
| 25 | ANZAN | Number of Employees Liable for Contributions (Monthly Cont.) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | BEIAN | Employee Contribution | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | ANZTA | Number Days for Employees | nvarchar | 3 | 0 | | | | Allow NULL? |
| 28 | BEIAT | Daily Contributions for Employees | nvarchar | 6 | 0 | | | | Allow NULL? |
| 29 | BLWBU | Total Gross Wages for Winter Constr. Contrib. Indust. Employ | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | ANZGW | Number of Industrial Workers - Winter Construction Promotion | nvarchar | 4 | 0 | | | | Allow NULL? |
| 31 | UMLWB | Winter Construction Promotion Contribution | nvarchar | 9 | 0 | | | | Allow NULL? |
| 32 | LFDBE | Sequence Number for BEMEL Transferred Each Month | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | STRME | Tax Code: Notification Portions of Workers, Employees | char | 1 | 0 | | | | Allow NULL? |
| 34 | STREG | Tax Code: Notification Supplement Employee Notification Area | char | 1 | 0 | | | | Allow NULL? |
