| 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 | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PERNR_D | Allow NULL? |
| 3 | INPER | In-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | ACCP | (N' ') | No | | P01B_BKINP | Allow NULL? |
| 4 | FPPER | For-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | ACCP | (N' ') | No | | P01B_BKFUP | Allow NULL? |
| 5 | SEQNO | Key Field Sequence Number for SFP Data Records | nvarchar | 2 | 0 | NUMC | (N'00') | No | | P01B_BKSEQ | Allow NULL? |
| 6 | KENID | Identifier of Record | nvarchar | 5 | 0 | CHAR | (N' ') | No | | P01B_BKSID | Allow NULL? |
| 7 | ZVKAN | Employee Number at a Construction Social Insurance Fund | nvarchar | 13 | 0 | NUMC | (N'0000000000000') | Yes | | P01B_BKANR | Allow NULL? |
| 8 | BNRSK | Company Number at a Social Fund - Construction Industry | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | P01B_BKBNR | Allow NULL? |
| 9 | BEGDA | Start of Notification Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01B_BKBEG | Allow NULL? |
| 10 | ENDDA | End of Notification Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01B_BKEND | Allow NULL? |
| 11 | RVJUT | Number of Leave Days | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKUTG | |
| 12 | RVJUV | Leave Remuneration | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUVG | |
| 13 | RVJGT | Number of Leave Days | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKUTG | |
| 14 | RVJGV | Leave Remuneration | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUVG | |
| 15 | RVJVT | Number of Leave Days | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKUTG | |
| 16 | RVJVV | Leave Remuneration | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUVG | |
| 17 | BTAGE | Employment Days for Employee Statement | decimal | 3 | 0 | DEC | ((0)) | Yes | | P01B_BKBTA | |
| 18 | BLOHN | Gross Wage for Employee Statement | decimal | 9 | 2 | CURR | ((0)) | Yes | | P01B_BKBLN | |
| 19 | PSATZ | Percentage for Leave Remuneration | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | P01B_BKPRS | Allow NULL? |
| 20 | UVERG | Leave Remuneration | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUVG | |
| 21 | AGLST | Number of Lost Hours | decimal | 6 | 2 | DEC | ((0)) | Yes | | P01B_BKANS | |
| 22 | AGLBT | Adjustment Amount | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKAGB | |
| 23 | ULJUT | Number of Leave Days | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKUTG | |
| 24 | ULJUV | Leave Remuneration | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUVG | |
| 25 | ULJGT | Number of Leave Days | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKUTG | |
| 26 | ULJGV | Leave Remuneration | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUVG | |
| 27 | ULJVT | Number of Leave Days | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKUTG | |
| 28 | ULJVV | Leave Remuneration | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUVG | |
| 29 | LAGBT | Leave Remuneration | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUVG | |
| 30 | ULJRT | Number of Leave Days | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKUTG | |
| 31 | ULJRV | Leave Remuneration | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUVG | |
| 32 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | CURCY | Allow NULL? |
| 33 | MSCHL | Notification Key for Data Record ANMEL | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | P01B_BKMSA | Allow NULL? |
| 34 | BTAGE_VAG | Employment Days for Employee Statement (Prev.ER, Current Yr) | decimal | 3 | 0 | DEC | ((0)) | Yes | | P01B_BKBTA_VAG | |
| 35 | BLOHN_VAG | Gross Wage for Employee Statement (Prev. ER, Current Year) | decimal | 9 | 2 | CURR | ((0)) | Yes | | P01B_BKBLN_VAG | |
| 36 | PSATZ_VAG | Percentage for Leave Remuneration (Prev. ER, Current Year) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | P01B_BKPRS_VAG | Allow NULL? |
| 37 | ULJUT_VAG | Number of Leave Days (Previous Employer, Current Year) | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKUTG_VAG | |
| 38 | ULJUV_VAG | Leave Remuneration (Previous Employer, Current Year) | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUVG_VAG | |
| 39 | AGLST_VAG | Number of Lost Hours (Previous Employer, Current Year) | decimal | 6 | 2 | DEC | ((0)) | Yes | | P01B_BKANS_VAG | |
| 40 | AGLBT_VAG | Adjustment Amount (Previous Employer, Current Year) | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKAGB_VAG | |
| 41 | ULJRT_VAG | Remaining Leave Days (Previous Employer, Current Year) | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKUTR_VAG | |
| 42 | ULJRV_VAG | Remaining Leave Remunation (Previous Employer, Current Year) | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUVR_VAG | |
| 43 | RVJUT_VAG | Leave Days from Previous Year from Previous Employer | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKRVT_VAG | |
| 44 | RVJUV_VAG | Leave Remuneration from Previous Year from Previous Employer | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKRVV_VAG | |
| 45 | RVJGT_VAG | Leave Days Granted in Previous Year by Previous Employer | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKRGT_VAG | |
| 46 | RVJGV_VAG | Leave Remuneration Granted in Previous Year by Previous ER | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKRGV_VAG | |
| 47 | DATUM_VAG | Date for Infotype 0190 | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01B_DATUM_VAG | Allow NULL? |
| 48 | BTAGE_INSG | Employment Days Current Year (PER + Current Work Relations.) | decimal | 3 | 0 | DEC | ((0)) | Yes | | P01B_BTAGE_INSG | |
| 49 | BLOHN_INSG | Gross Wage Current Year (PER + Current Working Relationship) | decimal | 9 | 2 | CURR | ((0)) | Yes | | P01B_BLOHN_INSG | |
| 50 | ULJUT_INSG | Leave Days Entitlement (PER Curr. Yr + Curr. ER in Curr. Yr) | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKUTG_G_LF | |
| 51 | ULJUV_INSG | Leave Remuneration Entitl. (PER Curr. Year + CER Curr. Year) | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUVG_G_LF | |
| 52 | ULJRT_NVG_LFD | Total Available Leave Days Entitlement Current Year | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKUTR_G_LF | |
| 53 | ULJRV_NVG_LFD | Available Total Entitlement Leave Remuneration in Current Yr | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUVR_G_LF | |
| 54 | VA_T_VJ_LFDJ | Total Available Leave Days Entitlement (Prev. + Curr. Years) | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKUTG_VJ_LFDJ | |
| 55 | VA_V_VJ_LFDJ | Total Available Entitlement to Leave Remuneration (PY + CY) | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUTV_VJ_LFDJ | |
| 56 | UDIVI | Divisor: Leave Accrual | decimal | 4 | 2 | DEC | ((0)) | Yes | | P01B_UDIVI | |
| 57 | UDIVI_VAG | Divisor: Leave Accrual Previous Employer | decimal | 4 | 2 | DEC | ((0)) | Yes | | P01B_UDIVI_VAG | |
| 58 | UVERG_VAG | Leave Remuneration from Gross Pay All Prev. ERs Current Year | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUVERG_VAG | |
| 59 | ULJGT_VAG | Leave Days Granted (Previous Employer, Current Year) | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKUGT_VAG | |
| 60 | ULJGV_VAG | Leave Remuneration Granted (Previous Employer, Current Year) | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUGV_VAG | |
| 61 | ULJGT_INSG | Leave Days Granted (PER Current Year + Current in Curr. Yr) | decimal | 2 | 0 | DEC | ((0)) | Yes | | P01B_BKUGT_G_LF | |
| 62 | ULJGV_INSG | Leave Remuneration Granted (Prev. ER Curr. Year + Curr. Yr.) | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_BKUGV_G_LF | |
| 63 | BEGDA_AUSB | Start Date of Traineeship | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01B_BEG_AUSB | Allow NULL? |
| 64 | ENDDA_AUSB | End Date of Traineeship | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01B_END_AUSB | Allow NULL? |
| 65 | BEGDA_DPFL | Start Date of Statutory Official Duty | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01B_BEG_GDPFL | Allow NULL? |
| 66 | ENDDA_DPFL | End Date of Statutory Official Duty | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01B_END_GDPFL | Allow NULL? |
| 67 | BNRSK_VAG | Previous Employer's Company Number at CI Social Fund | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | P01B_BKBNR_VAG | Allow NULL? |
| 68 | MKLJA | MLR from Illness, Current Year, Entitlement | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_MKLJA | |
| 69 | MKLJS | MLR from Illness, Current Year, Lost Hours | decimal | 6 | 2 | DEC | ((0)) | Yes | | P01B_MKLJS | |
| 70 | MSLJA | MLR from SRHC, Current Year, Entitlement | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_MSLJA | |
| 71 | MSLJS | MLR from SRHC, Current Year, Lost Hours | decimal | 5 | 2 | DEC | ((0)) | Yes | | P01B_MSLJS | |
| 72 | MKLJA_VAG | MLR from Illness, Current Year, Entitlement Previous ER | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_MKLJA_VAG | |
| 73 | MKLJS_VAG | MLR from Illness, Current Year, Lost Hours Previous ER | decimal | 6 | 2 | DEC | ((0)) | Yes | | P01B_MKLJS_VAG | |
| 74 | MSLJA_VAG | MLR from SRHC, Current Year, Entitlement Previous ER | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_MSLJA_VAG | |
| 75 | MSLJS_VAG | MLR from SRHC, Current Year, Lost Hours Previous ER | decimal | 5 | 2 | DEC | ((0)) | Yes | | P01B_MSLJS_VAG | |
| 76 | MKVJA | MLR from Illness, Previous Year, Entitlement | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_MKVJA | |
| 77 | MSVJA | MLR from SRHC, Previous Year, Entitlement | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_MSVJA | |
| 78 | MKVJA_VAG | MLR from Illness, Previous Year, Entitlement Previous ER | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_MKVJA_VAG | |
| 79 | MSVJA_VAG | MLR from SRHC, Previous Year, Entitlement Previous ER | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_MSVJA_VAG | |
| 80 | MKVVA | MLR from Illness, 2 Years Ago, Entitlement | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_MKVVA | |
| 81 | MKVVA_VAG | MLR from Illness, 2 Years Ago, Entitlement, Previous ER | decimal | 7 | 2 | CURR | ((0)) | Yes | | P01B_MKVVA_VAG | |
