P01EL_DBKE SAP (Data Module Notice/Dismissal (DBKE) ELENA) Table details

Dictionary Type: Table
Description: Data Module Notice/Dismissal (DBKE) ELENA




ABAP Code to SELECT data from P01EL_DBKE
Related tables to P01EL_DBKE
Access table P01EL_DBKE




Table field list including key, data, relationships and ABAP select examples

P01EL_DBKE is a standard SAP Table which is used to store Data Module Notice/Dismissal (DBKE) ELENA data and is available within R/3 SAP systems depending on the version and release level.

The P01EL_DBKE table consists of various fields, each holding specific information or linking keys about Data Module Notice/Dismissal (DBKE) ELENA data available in SAP. These include GUID (Unique Key for Identification of Notification), AVEND (End of Employment Relationship), AVBFR (Fixed-Term Employment/Work Relationship), AVBFSCHR (Fixed-Term Contract Was Concluded in Writing).. 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 P01EL_DBKE 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
GUIDUnique Key for Identification of Notification P01_SVGUIDCHAR32SYSUUID_C
AVENDEnd of Employment Relationship P01_SV_EL_AVENDDATS8DATUM
AVBFRFixed-Term Employment/Work Relationship P01_SV_EL_AVBFRCHAR1P01_SV_EL_AVBFR
AVBFSCHRFixed-Term Contract Was Concluded in Writing P01_SV_EL_AVBFSCHRCHAR1P01_SV_EL_AVBFSCHR
AVBFURSPEnd Date of Fixed-Term Employment Relationship P01_SV_EL_AVBFURSPDATS8DATUM
AVBFABSCHLConclusion of Fixed-Term Work Contract P01_SV_EL_AVBFABSCHLDATS8DATUM
AVBFABVLExtension of Fixed-Term Work Contract P01_SV_EL_AVBFABVLDATS8DATUM
AVBFRLFixed Term At Least Two Months P01_SV_EL_AVBFRLCHAR1P01_SV_EL_AVBFRL
AVKUEAMDate of Dismissal or Termination P01_SV_EL_AVKUEAMDATS8DATUM
AVUWFWZIrrevocable Release from Work with Continued Pay P01_SV_EL_AVUWFWZCHAR1P01_SV_EL_AVUWFWZ
AVUWFWZBEGStart Date of Irrevocable Release from Work P01_SV_EL_AVUWFWZBEGDATS8DATUM
AVUWFWZENDEnd Date of Irrevocable Release from Work P01_SV_EL_AVUWFWZENDDATS8DATUM
AVLETZTRLLast Complete Payroll P01_SV_EL_AVLETZTRLCHAR6PRIOD
AVKUEDUDismissal/Termination of Employment Relationship By P01_SV_EL_AVKUEDUNUMC1P01_SV_EL_AVKUEDU
AVKUESCHWritten Notice or Dismissal P01_SV_EL_AVKUESCHCHAR1P01_SV_EL_AVKUESCH
AVKUEBETRDismissal for Operational Reasons P01_SV_EL_AVKUEBETRCHAR1P01_SV_EL_AVKUEBETR
AVKUESCHUKLDismissal Protection Lawsuit Filed P01_SV_EL_AVKUESCHUKLCHAR1P01_SV_EL_AVKUESCHUKL
AVKUEZUSTCommunication Type of Termination P01_SV_EL_AVKUEZUSTNUMC1P01_SV_EL_AVKUEZUST
AVKUEALReason for Notice or Dismissal P01_SV_EL_AVKUEALCHAR1P01_SV_EL_AVKUEAL
AVKUEALAMWritten Warning for Reason for Notice P01_SV_EL_AVKUEALAMCHAR1P01_SV_EL_AVKUEALAM
AVAMDATDate of Previous Written Warning P01_SV_EL_AVAMDATDATS8DATUM
VWIVERDetails of Repudiatory Conduct P01_SV_EL_VWIVERCHAR255
AVKUEZVBAdditional Notice Agreements P01_SV_EL_AVKUEZVBCHAR1P01_SV_EL_AVKUEZVB
SAWSocial Selection Made P01_SV_EL_SAWNUMC1P01_SV_EL_SAW
SAWPRNAName of Employment Office for Social Selection Check P01_SV_EL_SAWPRNACHAR30P01_SV_EL_SAWPRNA
AGKUEAMDate When Employer Would Have Notified EE of Termination P01_SV_EL_AGKUEAMDATS8DATUM
AGKUEZUDate When Termination by Employer Would Have Started P01_SV_EL_AGKUEZUDATS8DATUM
KFPeriod of Notice P01_SV_EL_KFNUMC3P01_SV_EL_KF
KFZETime Unit for Notice Period P01_SV_EL_KFZENUMC1P01_SV_EL_KFZE
KFBZReference Date/Time of Notice Period P01_SV_EL_KFBZNUMC1P01_SV_EL_KFBZ
KAExcluded from Termination P01_SV_EL_KACHAR1P01_SV_EL_KA
KAUUnlimited Exclusion from Termination P01_SV_EL_KAUCHAR1P01_SV_EL_KAU
KAUAUGReason for Canceling Unlimited Exclusion from Termination P01_SV_EL_KAUAUGCHAR30P01_SV_EL_KAUAUG
KABGGReason for Limited Exclusion from Termination P01_SV_EL_KABGGCHAR30P01_SV_EL_KABGG
OKGLOrdinary Notice of Dismissal Permitted Only If Special Paymt P01_SV_EL_OKGLCHAR1P01_SV_EL_OKGL
OKGLFGDismissal w/ Due Notice for Ord.Dismissal with Special Paymt P01_SV_EL_OKGLFGCHAR1P01_SV_EL_OKGLFG
AVENLZBenefits Paymt at Termination of Employmt/Work Relationship P01_SV_EL_AVENLZCHAR1P01_SV_EL_AVENLZ
AVENLZGReason for Uncertainty of Benefits Payment P01_SV_EL_AVENLZGCHAR30P01_SV_EL_AVENLZG
BVEGENRemuneration/Salary After End of Employment Relationship P01_SV_EL_BVEGENCHAR1P01_SV_EL_BVEGEN
BVEGENBRemuneration/Salary After End Employmt/Work Rel. Until Date P01_SV_EL_BVEGENBDATS8DATUM
AVENUAGLeave Compensation for Termination of Employment Relationshp P01_SV_EL_AVENUAGCHAR1P01_SV_EL_AVENUAG
BVENURLeave Duration After End of Employment Relationship P01_SV_EL_AVENURDATS8DATUM
AVENVLEarly Retirement Benefit for Termination of Employment Rel. P01_SV_EL_AVENVLCHAR1P01_SV_EL_AVENVL
AVENVGBStart of Early Retirement Pension at End of Employment Rel. P01_SV_EL_AVENVGBDATS8DATUM
AVENVGAmount of Early Retiremt Pension As % of Gross Remuneration P01_SV_EL_AVENVGNUMC5P01_SV_EL_AVENVG
ABFMONATSeverance Pay up to 0.5 Monthly Salaries P01_SV_EL_ABFMONATCHAR1P01_SV_EL_ABFMONAT
ABFGEZIf Severance Pay Were to Be Paid P01_SV_EL_ABFGEZCHAR1P01_SV_EL_ABFGEZ
SAWPRSCName of Employment Office for Social Selection Check P01_SV_EL_SAWPRSCNUMC3P01_SV_EL_SAWPRSCH_T5D33
KAUAUG_002Reason for Canceling Unlimited Exclusion from Termination P01_SV_EL_KAUAUG_002CHAR1P01_SV_EL_KAUAUG_002
AVENLZG_002Reason for Uncertainty of Benefits Payment P01_SV_EL_AVENLZG_002NUMC2P01_SV_EL_AVENLZG_002

Key field Non-key field



How do I retrieve data from SAP table P01EL_DBKE using ABAP code

The following ABAP code Example will allow you to do a basic selection on P01EL_DBKE to SELECT all data from the table
DATA: WA_P01EL_DBKE TYPE P01EL_DBKE.

SELECT SINGLE *
FROM P01EL_DBKE
INTO CORRESPONDING FIELDS OF WA_P01EL_DBKE
WHERE...

How to access SAP table P01EL_DBKE

Within an ECC or HANA version of SAP you can also view further information about P01EL_DBKE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!