PDBKNW SAP (Construction Industry Social Fund Proced: Employee Statement) Table details
Description: Construction Industry Social Fund Proced: Employee Statement
Table field list including key, data, relationships and ABAP select examples
PDBKNW is a standard SAP Table which is used to store Construction Industry Social Fund Proced: Employee Statement data and is available within R/3 SAP systems depending on the version and release level.
The PDBKNW table consists of various fields, each holding specific information or linking keys about Construction Industry Social Fund Proced: Employee Statement data available in SAP. These include PERNR (Personnel Number), INPER (In-Period for Evaluation for Social Fund Procedure), FPPER (For-Period for Evaluation for Social Fund Procedure), SEQNO (Key Field Sequence Number for SFP Data Records).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP PDBKNW table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
INPER | In-Period for Evaluation for Social Fund Procedure | P01B_BKINP | ACCP | 6 | P01B_BKPER | ||||
FPPER | For-Period for Evaluation for Social Fund Procedure | P01B_BKFUP | ACCP | 6 | P01B_BKPER | ||||
SEQNO | Key Field Sequence Number for SFP Data Records | P01B_BKSEQ | NUMC | 2 | NUM2 | ||||
KENID | Identifier of Record | P01B_BKSID | CHAR | 5 | P01B_BKSID | ||||
ZVKAN | Employee Number at a Construction Social Insurance Fund | P01B_BKANR | NUMC | 13 | NUM13 | ||||
BNRSK | Company Number at a Social Fund - Construction Industry | P01B_BKBNR | NUMC | 8 | P01B_BKBNR | ||||
BEGDA | Start of Notification Period | P01B_BKBEG | DATS | 8 | DATUM | ||||
ENDDA | End of Notification Period | P01B_BKEND | DATS | 8 | DATUM | ||||
RVJUT | Number of Leave Days | P01B_BKUTG | DEC | 2 | DEC2S | ||||
RVJUV | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
RVJGT | Number of Leave Days | P01B_BKUTG | DEC | 2 | DEC2S | ||||
RVJGV | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
RVJVT | Number of Leave Days | P01B_BKUTG | DEC | 2 | DEC2S | ||||
RVJVV | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
BTAGE | Employment Days for Employee Statement | P01B_BKBTA | DEC | 3 | DEC03 | ||||
BLOHN | Gross Wage for Employee Statement | P01B_BKBLN | CURR | 9(2) | WERTV5 | ||||
PSATZ | Percentage for Leave Remuneration | P01B_BKPRS | NUMC | 4 | NUM4 | ||||
UVERG | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
AGLST | Number of Lost Hours | P01B_BKANS | DEC | 6(2) | DEC4_2 | ||||
AGLBT | Adjustment Amount | P01B_BKAGB | CURR | 7(2) | WERTV4 | ||||
ULJUT | Number of Leave Days | P01B_BKUTG | DEC | 2 | DEC2S | ||||
ULJUV | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
ULJGT | Number of Leave Days | P01B_BKUTG | DEC | 2 | DEC2S | ||||
ULJGV | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
ULJVT | Number of Leave Days | P01B_BKUTG | DEC | 2 | DEC2S | ||||
ULJVV | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
LAGBT | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
ULJRT | Number of Leave Days | P01B_BKUTG | DEC | 2 | DEC2S | ||||
ULJRV | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
WAERS | Currency Key | CURCY | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
MSCHL | Notification Key for Data Record ANMEL | P01B_BKMSA | NUMC | 4 | P01B_BKMSA | ||||
BTAGE_VAG | Employment Days for Employee Statement (Prev.ER, Current Yr) | P01B_BKBTA_VAG | DEC | 3 | DEC03 | ||||
BLOHN_VAG | Gross Wage for Employee Statement (Prev. ER, Current Year) | P01B_BKBLN_VAG | CURR | 9(2) | WERTV5 | ||||
PSATZ_VAG | Percentage for Leave Remuneration (Prev. ER, Current Year) | P01B_BKPRS_VAG | NUMC | 4 | NUM4 | ||||
ULJUT_VAG | Number of Leave Days (Previous Employer, Current Year) | P01B_BKUTG_VAG | DEC | 2 | DEC2S | ||||
ULJUV_VAG | Leave Remuneration (Previous Employer, Current Year) | P01B_BKUVG_VAG | CURR | 7(2) | WERTV4 | ||||
AGLST_VAG | Number of Lost Hours (Previous Employer, Current Year) | P01B_BKANS_VAG | DEC | 6(2) | DEC4_2 | ||||
AGLBT_VAG | Adjustment Amount (Previous Employer, Current Year) | P01B_BKAGB_VAG | CURR | 7(2) | WERTV4 | ||||
ULJRT_VAG | Remaining Leave Days (Previous Employer, Current Year) | P01B_BKUTR_VAG | DEC | 2 | DEC2S | ||||
ULJRV_VAG | Remaining Leave Remunation (Previous Employer, Current Year) | P01B_BKUVR_VAG | CURR | 7(2) | WERTV4 | ||||
RVJUT_VAG | Leave Days from Previous Year from Previous Employer | P01B_BKRVT_VAG | DEC | 2 | DEC2S | ||||
RVJUV_VAG | Leave Remuneration from Previous Year from Previous Employer | P01B_BKRVV_VAG | CURR | 7(2) | WERTV4 | ||||
RVJGT_VAG | Leave Days Granted in Previous Year by Previous Employer | P01B_BKRGT_VAG | DEC | 2 | DEC2S | ||||
RVJGV_VAG | Leave Remuneration Granted in Previous Year by Previous ER | P01B_BKRGV_VAG | CURR | 7(2) | WERTV4 | ||||
DATUM_VAG | Date for Infotype 0190 | P01B_DATUM_VAG | DATS | 8 | DATUM | ||||
BTAGE_INSG | Employment Days Current Year (PER + Current Work Relations.) | P01B_BTAGE_INSG | DEC | 3 | DEC03 | ||||
BLOHN_INSG | Gross Wage Current Year (PER + Current Working Relationship) | P01B_BLOHN_INSG | CURR | 9(2) | WERTV5 | ||||
ULJUT_INSG | Leave Days Entitlement (PER Curr. Yr + Curr. ER in Curr. Yr) | P01B_BKUTG_G_LF | DEC | 2 | DEC2S | ||||
ULJUV_INSG | Leave Remuneration Entitl. (PER Curr. Year + CER Curr. Year) | P01B_BKUVG_G_LF | CURR | 7(2) | WERTV4 | ||||
ULJRT_NVG_LFD | Total Available Leave Days Entitlement Current Year | P01B_BKUTR_G_LF | DEC | 2 | DEC2S | ||||
ULJRV_NVG_LFD | Available Total Entitlement Leave Remuneration in Current Yr | P01B_BKUVR_G_LF | CURR | 7(2) | WERTV4 | ||||
VA_T_VJ_LFDJ | Total Available Leave Days Entitlement (Prev. + Curr. Years) | P01B_BKUTG_VJ_LFDJ | DEC | 2 | DEC2S | ||||
VA_V_VJ_LFDJ | Total Available Entitlement to Leave Remuneration (PY + CY) | P01B_BKUTV_VJ_LFDJ | CURR | 7(2) | WERTV4 | ||||
UDIVI | Divisor: Leave Accrual | P01B_UDIVI | DEC | 4(2) | DEC2_2 | ||||
UDIVI_VAG | Divisor: Leave Accrual Previous Employer | P01B_UDIVI_VAG | DEC | 4(2) | DEC2_2 | ||||
UVERG_VAG | Leave Remuneration from Gross Pay All Prev. ERs Current Year | P01B_BKUVERG_VAG | CURR | 7(2) | WERTV4 | ||||
ULJGT_VAG | Leave Days Granted (Previous Employer, Current Year) | P01B_BKUGT_VAG | DEC | 2 | DEC2S | ||||
ULJGV_VAG | Leave Remuneration Granted (Previous Employer, Current Year) | P01B_BKUGV_VAG | CURR | 7(2) | WERTV4 | ||||
ULJGT_INSG | Leave Days Granted (PER Current Year + Current in Curr. Yr) | P01B_BKUGT_G_LF | DEC | 2 | DEC2S | ||||
ULJGV_INSG | Leave Remuneration Granted (Prev. ER Curr. Year + Curr. Yr.) | P01B_BKUGV_G_LF | CURR | 7(2) | WERTV4 | ||||
BEGDA_AUSB | Start Date of Traineeship | P01B_BEG_AUSB | DATS | 8 | DATUM | ||||
ENDDA_AUSB | End Date of Traineeship | P01B_END_AUSB | DATS | 8 | DATUM | ||||
BEGDA_DPFL | Start Date of Statutory Official Duty | P01B_BEG_GDPFL | DATS | 8 | DATUM | ||||
ENDDA_DPFL | End Date of Statutory Official Duty | P01B_END_GDPFL | DATS | 8 | DATUM | ||||
BNRSK_VAG | Previous Employer's Company Number at CI Social Fund | P01B_BKBNR_VAG | NUMC | 8 | P01B_BKBNR | ||||
MKLJA | MLR from Illness, Current Year, Entitlement | P01B_MKLJA | CURR | 7(2) | WERTV4 | ||||
MKLJS | MLR from Illness, Current Year, Lost Hours | P01B_MKLJS | DEC | 6(2) | DEC4_2 | ||||
MSLJA | MLR from SRHC, Current Year, Entitlement | P01B_MSLJA | CURR | 7(2) | WERTV4 | ||||
MSLJS | MLR from SRHC, Current Year, Lost Hours | P01B_MSLJS | DEC | 5(2) | DEC3_2 | ||||
MKLJA_VAG | MLR from Illness, Current Year, Entitlement Previous ER | P01B_MKLJA_VAG | CURR | 7(2) | WERTV4 | ||||
MKLJS_VAG | MLR from Illness, Current Year, Lost Hours Previous ER | P01B_MKLJS_VAG | DEC | 6(2) | DEC4_2 | ||||
MSLJA_VAG | MLR from SRHC, Current Year, Entitlement Previous ER | P01B_MSLJA_VAG | CURR | 7(2) | WERTV4 | ||||
MSLJS_VAG | MLR from SRHC, Current Year, Lost Hours Previous ER | P01B_MSLJS_VAG | DEC | 5(2) | DEC3_2 | ||||
MKVJA | MLR from Illness, Previous Year, Entitlement | P01B_MKVJA | CURR | 7(2) | WERTV4 | ||||
MSVJA | MLR from SRHC, Previous Year, Entitlement | P01B_MSVJA | CURR | 7(2) | WERTV4 | ||||
MKVJA_VAG | MLR from Illness, Previous Year, Entitlement Previous ER | P01B_MKVJA_VAG | CURR | 7(2) | WERTV4 | ||||
MSVJA_VAG | MLR from SRHC, Previous Year, Entitlement Previous ER | P01B_MSVJA_VAG | CURR | 7(2) | WERTV4 | ||||
MKVVA | MLR from Illness, 2 Years Ago, Entitlement | P01B_MKVVA | CURR | 7(2) | WERTV4 | ||||
MKVVA_VAG | MLR from Illness, 2 Years Ago, Entitlement, Previous ER | P01B_MKVVA_VAG | CURR | 7(2) | WERTV4 |
Key field | Non-key field |
How do I retrieve data from SAP table PDBKNW using ABAP code
The following ABAP code Example will allow you to do a basic selection on PDBKNW to SELECT all data from the tableDATA: WA_PDBKNW TYPE PDBKNW.
SELECT SINGLE *
FROM PDBKNW
INTO CORRESPONDING FIELDS OF WA_PDBKNW
WHERE...
How to access SAP table PDBKNW
Within an ECC or HANA version of SAP you can also view further information about PDBKNW and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects