PDBKNE SAP (Construction Industry Social Fund Proced: NEMEL Data Records) Table details
Description: Construction Industry Social Fund Proced: NEMEL Data Records
Table field list including key, data, relationships and ABAP select examples
PDBKNE is a standard SAP Table which is used to store Construction Industry Social Fund Proced: NEMEL Data Records data and is available within R/3 SAP systems depending on the version and release level.
The PDBKNE table consists of various fields, each holding specific information or linking keys about Construction Industry Social Fund Proced: NEMEL Data Records 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 PDBKNE 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 | ||||
RZNSK | Data Center Number of Social Fund (R) | P01B_BKRZE | CHAR | 8 | P01B_BKRZN_R | ||||
RZNAG | Data Center Number for Company for Social Fund (R) | P01B_BKRZA | CHAR | 8 | P01B_BKRZN_R | ||||
BNRSK | Company Number at a Social Fund - Construction Industry | P01B_BKBNR | NUMC | 8 | P01B_BKBNR | ||||
NUS01 | Unused Numeric Field - Length 7 | P01B_BKNU7 | NUMC | 7 | NUM7 | ||||
NUS02 | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
RZDAT | Creation Date of Data Medium | P01B_RZDAT | DATS | 8 | SYDATS | ||||
VERNR | Version of Data Medium Exchange | P01B_BKVNR | NUMC | 2 | NUM2 | ||||
FNAME | Name of Company for Social Fund | P01B_BKFNA | CHAR | 22 | CHAR22 | ||||
ZVKAN | Employee Number at a Construction Social Insurance Fund | P01B_BKANR | NUMC | 13 | NUM13 | ||||
SKPNR | Personnel Number for Notifications in SFP | P01B_BKPNR | CHAR | 13 | CHAR13 | ||||
MDART | Notification Type for Data Record NEMEL | P01B_BKMAE | NUMC | 2 | P01B_BKMAE | ||||
BEGDA | Start of Notification Period | P01B_BKBEG | DATS | 8 | DATUM | ||||
STONR | Number of Cancellation for Evaluation Data Records SFP | P01B_BKSNR | NUMC | 2 | NUM2 | ||||
WAERS | Currency Key for Social Fund Procedure | P01B_BKWAE | CHAR | 3 | CHAR3 | ||||
BTAGE | Employment Days for Data Record URMEL | P01B_BKBTG | NUMC | 3 | NUM3 | ||||
BLOHN | Gross Wage for Data Record URMEL | P01B_BKBLO | NUMC | 8 | NUM8 | ||||
AGLST | Number of Lost Hours for Data Record URMEL | P01B_BKAFS | NUMC | 6 | NUMC6 | ||||
UTAGE | Number of Leave Days | P01B_BKUTE | NUMC | 4 | NUMC4 | ||||
UVERG | Leave Remuneration Entitlement | P01B_BKUVE | NUMC | 8 | NUMC8 | ||||
RTAGE | Remaining Leave Days for Data Record RAMEL | P01B_BKRTG | NUMC | 2 | NUM2 | ||||
RVERG | Leave Remuneration Entitlement | P01B_BKUVE | NUMC | 8 | NUMC8 | ||||
KENAJ | SFP: Indicator: Final Year of Traineeship / Young Person | P01B_BKKAJ | CHAR | 1 | CHAR1 | ||||
NACHN | Last Name | P01B_BKNAM | CHAR | 30 | CHAR30 | ||||
VORNA | First Name | P01B_BKVNA | CHAR | 30 | CHAR30 |
Key field | Non-key field |
How do I retrieve data from SAP table PDBKNE using ABAP code
The following ABAP code Example will allow you to do a basic selection on PDBKNE to SELECT all data from the tableDATA: WA_PDBKNE TYPE PDBKNE.
SELECT SINGLE *
FROM PDBKNE
INTO CORRESPONDING FIELDS OF WA_PDBKNE
WHERE...
How to access SAP table PDBKNE
Within an ECC or HANA version of SAP you can also view further information about PDBKNE 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