| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BNRSK | Company Number at a Social Fund - Construction Industry | 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 | ZVKAS | Social Fund | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | STATS | Status of Data Record in Social Fund Procedure | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | BESCH | Indicator for Certified Data Record | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | WERKS | Sending Personnel Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | BTRTL | Sending Personnel Subarea | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | RZNSK | Data Center Number of Social Fund (R) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | RZNAG | Data Center Number for Company for Social Fund (R) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | NUS01 | Unused Numeric Field - Length 7 | nvarchar | 7 | 0 | | | | Allow NULL? |
| 15 | NUS02 | Version Number Component | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | RZDAT | Creation Date of Data Medium | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | VERNR | Version of Data Medium Exchange | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | FNAME | Name of Company for Social Fund | nvarchar | 22 | 0 | | | | Allow NULL? |
| 19 | ZVKAN | Employee Number at a Construction Social Insurance Fund | nvarchar | 13 | 0 | | | | Allow NULL? |
| 20 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | ABRMO | Payroll Month in Social Fund Procedure | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | ABRJA | Payroll Year in Social Fund Procedure | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | WAERS | Currency Key for Social Fund Procedure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | BLSUM | Total Gross Wages of All Industrial Employees | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | ANZGE | Number of Industrial Workers | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | BEIGE | Contribution (Without Trainees Remuneration) | nvarchar | 9 | 0 | | | | Allow NULL? |
| 28 | ANZAN | Number of Employees Liable for Contributions (Monthly Cont.) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 29 | BEIAN | Employee Contribution | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | ANZTA | Number Days for Employees | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | BEIAT | Daily Contributions for Employees | nvarchar | 6 | 0 | | | | Allow NULL? |
| 32 | BLWBU | Total Gross Wages for Winter Constr. Contrib. Indust. Employ | nvarchar | 10 | 0 | | | | Allow NULL? |
| 33 | ANZGW | Number of Industrial Workers - Winter Construction Promotion | nvarchar | 4 | 0 | | | | Allow NULL? |
| 34 | UMLWB | Winter Construction Promotion Contribution | nvarchar | 9 | 0 | | | | Allow NULL? |
| 35 | LFDBE | Sequence Number for BEMEL Transferred Each Month | nvarchar | 2 | 0 | | | | Allow NULL? |
| 36 | STRME | Tax Code: Notification Portions of Workers, Employees | char | 1 | 0 | | | | Allow NULL? |
| 37 | STREG | Tax Code: Notification Supplement Employee Notification Area | char | 1 | 0 | | | | Allow NULL? |
| 38 | REPRT | Calling Program | nvarchar | 40 | 0 | | | | Allow NULL? |
| 39 | UNAME | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 40 | GDATE | Local Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | GTIME | Local Time | nvarchar | 6 | 0 | | | | Allow NULL? |
