PDBKUR SAP (Construction Industry Social Fund Proced: URMEL Data Records) Table details
Description: Construction Industry Social Fund Proced: URMEL Data Records
Table field list including key, data, relationships and ABAP select examples
PDBKUR is a standard SAP Table which is used to store Construction Industry Social Fund Proced: URMEL Data Records data and is available within R/3 SAP systems depending on the version and release level.
The PDBKUR table consists of various fields, each holding specific information or linking keys about Construction Industry Social Fund Proced: URMEL 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 PDBKUR 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 URMEL | P01B_BKMAU | NUMC | 2 | P01B_BKMAU | ||||
ABRMO | Payroll Month in Social Fund Procedure | P01B_BKAMO | NUMC | 2 | NUM2 | ||||
ABRJA | Payroll Year in Social Fund Procedure | P01B_BKAJA | NUMC | 4 | NUM4 | ||||
BEGDA | Start of Notification Period | P01B_BKBEG | DATS | 8 | DATUM | ||||
ENDDA | End of Notification Period | P01B_BKEND | 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 | ||||
AFSTD | Number of Lost Hours for Data Record URMEL | P01B_BKAFS | NUMC | 6 | NUMC6 | ||||
NUS03 | Field of length 16 | CHAR16 | CHAR | 16 | CHAR16 | ||||
GTAGE | Granted Leave Days for Data Record URMEL | P01B_BKGTG | NUMC | 2 | NUM2 | ||||
GVERG | Leave Remuneration Granted for Data Record URMEL | P01B_BKGVG | NUMC | 7 | NUM7 | ||||
GZUTG | Retained Leave Days for Data Record URMEL | P01B_BKZUT | NUMC | 2 | NUM2 | ||||
NUS06 | Not More Closely Defined Area, Possibly Used for Patchlevels | CHAR4 | CHAR | 4 | CHAR4 | ||||
GSTDG | Hours Worked for Data Record URMEL (Berlin | P01B_BKSTG | NUMC | 5 | NUMC5 | ||||
GSTDB | Hours Paid for Data Record URMEL (Berlin) | P01B_BKSTB | NUMC | 5 | NUMC5 | ||||
GBRTL | Gross Hourly Wage for Record URMEL (Berlin) | P01B_BKBST | NUMC | 4 | NUM4 | ||||
GLGRP | Wage Group (Berlin) | P01B_BKGRP | CHAR | 4 | CHAR4 | ||||
NACHN | Last Name | P01B_BKNAM | CHAR | 30 | CHAR30 | ||||
VORNA | First Name | P01B_BKVNA | CHAR | 30 | CHAR30 | ||||
NUS05 | Character field of 9 digits | CHAR9 | CHAR | 9 | CHAR9 | ||||
WEGAZ | Travel Allowance for Trainee Social Fund Berlin | P01B_WEGAZ | NUMC | 6 | NUM6 | ||||
UEBGB | Projected Hours Interim Payment Scaffolding Division Berlin | P01B_UEBGB | NUMC | 5 | NUM5 | ||||
WUZGB | Winter Leave Supplement Scaffolding Division Berlin | P01B_WUZGB | NUMC | 6 | NUM6 | ||||
AUSFK | Minimum Leave Remuneration - Lost Hours Illness | P01B_AUSFK | NUMC | 5 | NUM5 | ||||
AUSSK | Minimum Leave Remuneration - Lost Hours Seasonal RHC | P01B_AUSSK | NUMC | 5 | NUM5 | ||||
MUVAK | Minimum Leave Remuneration - Amount Lost Hours Illness | P01B_MUVAK | NUMC | 6 | NUM6 | ||||
MUVSK | Minimum Leave Remuneration - Amount Seasonal RHC | P01B_MUVSK | NUMC | 6 | NUM6 |
Key field | Non-key field |
How do I retrieve data from SAP table PDBKUR using ABAP code
The following ABAP code Example will allow you to do a basic selection on PDBKUR to SELECT all data from the tableDATA: WA_PDBKUR TYPE PDBKUR.
SELECT SINGLE *
FROM PDBKUR
INTO CORRESPONDING FIELDS OF WA_PDBKUR
WHERE...
How to access SAP table PDBKUR
Within an ECC or HANA version of SAP you can also view further information about PDBKUR 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