SAP ABAP Table HRDESV_EL_S_DBKE_DB (Data Fields of DBKE from Database)

Hierarchy

☛ SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
   ⤷ PY-DE-NT-NI (Application Component) Social Insurance
     ⤷ P01S (Package) HR Germany: Social Insurance

Basic Data

Table Category	INTTAB	Structure
Structure	HRDESV_EL_S_DBKE_DB	Table Relationship Diagram
Short Description	Data Fields of DBKE from Database

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
2	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
3	AVEND	☐	P01_SV_EL_AVEND	DATUM	DATS	8	0	End of Employment Relationship
4	AVBFR	☐	P01_SV_EL_AVBFR	P01_SV_EL_AVBFR	CHAR	1	0	Fixed-Term Employment/Work Relationship
5	AVBFSCHR	☐	P01_SV_EL_AVBFSCHR	P01_SV_EL_AVBFSCHR	CHAR	1	0	Fixed-Term Contract Was Concluded in Writing
6	AVBFURSP	☐	P01_SV_EL_AVBFURSP	DATUM	DATS	8	0	End Date of Fixed-Term Employment Relationship
7	AVBFABSCHL	☐	P01_SV_EL_AVBFABSCHL	DATUM	DATS	8	0	Conclusion of Fixed-Term Work Contract
8	AVBFABVL	☐	P01_SV_EL_AVBFABVL	DATUM	DATS	8	0	Extension of Fixed-Term Work Contract
9	AVBFRL	☐	P01_SV_EL_AVBFRL	P01_SV_EL_AVBFRL	CHAR	1	0	Fixed Term At Least Two Months
10	AVKUEAM	☐	P01_SV_EL_AVKUEAM	DATUM	DATS	8	0	Date of Dismissal or Termination
11	AVUWFWZ	☐	P01_SV_EL_AVUWFWZ	P01_SV_EL_AVUWFWZ	CHAR	1	0	Irrevocable Release from Work with Continued Pay
12	AVUWFWZBEG	☐	P01_SV_EL_AVUWFWZBEG	DATUM	DATS	8	0	Start Date of Irrevocable Release from Work
13	AVUWFWZEND	☐	P01_SV_EL_AVUWFWZEND	DATUM	DATS	8	0	End Date of Irrevocable Release from Work
14	AVLETZTRL	☐	P01_SV_EL_AVLETZTRL	PRIOD	CHAR	6	0	Last Complete Payroll
15	AVKUEDU	☐	P01_SV_EL_AVKUEDU	P01_SV_EL_AVKUEDU	NUMC	1	0	Dismissal/Termination of Employment Relationship By
16	AVKUESCH	☐	P01_SV_EL_AVKUESCH	P01_SV_EL_AVKUESCH	CHAR	1	0	Written Notice or Dismissal
17	AVKUEBETR	☐	P01_SV_EL_AVKUEBETR	P01_SV_EL_AVKUEBETR	CHAR	1	0	Dismissal for Operational Reasons
18	AVKUESCHUKL	☐	P01_SV_EL_AVKUESCHUKL	P01_SV_EL_AVKUESCHUKL	CHAR	1	0	Dismissal Protection Lawsuit Filed
19	AVKUEZUST	☐	P01_SV_EL_AVKUEZUST	P01_SV_EL_AVKUEZUST	NUMC	1	0	Communication Type of Termination
20	AVKUEAL	☐	P01_SV_EL_AVKUEAL	P01_SV_EL_AVKUEAL	CHAR	1	0	Reason for Notice or Dismissal
21	AVKUEALAM	☐	P01_SV_EL_AVKUEALAM	P01_SV_EL_AVKUEALAM	CHAR	1	0	Written Warning for Reason for Notice
22	AVAMDAT	☐	P01_SV_EL_AVAMDAT	DATUM	DATS	8	0	Date of Previous Written Warning
23	VWIVER	☐	P01_SV_EL_VWIVER		CHAR	255	0	Details of Repudiatory Conduct
24	AVKUEZVB	☐	P01_SV_EL_AVKUEZVB	P01_SV_EL_AVKUEZVB	CHAR	1	0	Additional Notice Agreements
25	SAW	☐	P01_SV_EL_SAW	P01_SV_EL_SAW	NUMC	1	0	Social Selection Made
26	SAWPRNA	☐	P01_SV_EL_SAWPRNA	P01_SV_EL_SAWPRNA	CHAR	30	0	Name of Employment Office for Social Selection Check
27	AGKUEAM	☐	P01_SV_EL_AGKUEAM	DATUM	DATS	8	0	Date When Employer Would Have Notified EE of Termination
28	AGKUEZU	☐	P01_SV_EL_AGKUEZU	DATUM	DATS	8	0	Date When Termination by Employer Would Have Started
29	KF	☐	P01_SV_EL_KF	P01_SV_EL_KF	NUMC	3	0	Period of Notice
30	KFZE	☐	P01_SV_EL_KFZE	P01_SV_EL_KFZE	NUMC	1	0	Time Unit for Notice Period
31	KFBZ	☐	P01_SV_EL_KFBZ	P01_SV_EL_KFBZ	NUMC	1	0	Reference Date/Time of Notice Period
32	KA	☐	P01_SV_EL_KA	P01_SV_EL_KA	CHAR	1	0	Excluded from Termination
33	KAU	☐	P01_SV_EL_KAU	P01_SV_EL_KAU	CHAR	1	0	Unlimited Exclusion from Termination
34	KAUAUG	☐	P01_SV_EL_KAUAUG	P01_SV_EL_KAUAUG	CHAR	30	0	Reason for Canceling Unlimited Exclusion from Termination
35	KABGG	☐	P01_SV_EL_KABGG	P01_SV_EL_KABGG	CHAR	30	0	Reason for Limited Exclusion from Termination
36	OKGL	☐	P01_SV_EL_OKGL	P01_SV_EL_OKGL	CHAR	1	0	Ordinary Notice of Dismissal Permitted Only If Special Paymt
37	OKGLFG	☐	P01_SV_EL_OKGLFG	P01_SV_EL_OKGLFG	CHAR	1	0	Dismissal w/ Due Notice for Ord.Dismissal with Special Paymt
38	AVENLZ	☐	P01_SV_EL_AVENLZ	P01_SV_EL_AVENLZ	CHAR	1	0	Benefits Paymt at Termination of Employmt/Work Relationship
39	AVENLZG	☐	P01_SV_EL_AVENLZG	P01_SV_EL_AVENLZG	CHAR	30	0	Reason for Uncertainty of Benefits Payment
40	BVEGEN	☐	P01_SV_EL_BVEGEN	P01_SV_EL_BVEGEN	CHAR	1	0	Remuneration/Salary After End of Employment Relationship
41	BVEGENB	☐	P01_SV_EL_BVEGENB	DATUM	DATS	8	0	Remuneration/Salary After End Employmt/Work Rel. Until Date
42	AVENUAG	☐	P01_SV_EL_AVENUAG	P01_SV_EL_AVENUAG	CHAR	1	0	Leave Compensation for Termination of Employment Relationshp
43	BVENUR	☐	P01_SV_EL_AVENUR	DATUM	DATS	8	0	Leave Duration After End of Employment Relationship
44	AVENVL	☐	P01_SV_EL_AVENVL	P01_SV_EL_AVENVL	CHAR	1	0	Early Retirement Benefit for Termination of Employment Rel.
45	AVENVGB	☐	P01_SV_EL_AVENVGB	DATUM	DATS	8	0	Start of Early Retirement Pension at End of Employment Rel.
46	AVENVG	☐	P01_SV_EL_AVENVG	P01_SV_EL_AVENVG	NUMC	5	0	Amount of Early Retiremt Pension As % of Gross Remuneration
47	ABFMONAT	☐	P01_SV_EL_ABFMONAT	P01_SV_EL_ABFMONAT	CHAR	1	0	Severance Pay up to 0.5 Monthly Salaries
48	ABFGEZ	☐	P01_SV_EL_ABFGEZ	P01_SV_EL_ABFGEZ	CHAR	1	0	If Severance Pay Were to Be Paid
49	SAWPRSC	☐	P01_SV_EL_SAWPRSC	P01_SV_EL_SAWPRSC	NUMC	3	0	Employment Office Key for Social Selection Check
50	KAUAUG_002	☐	P01_SV_EL_KAUAUG_002	P01_SV_EL_KAUAUG_002	CHAR	1	0	Reason for Canceling Unlimited Exclusion from Termination
51	AVENLZG_002	☐	P01_SV_EL_AVENLZG_002	P01_SV_EL_AVENLZG_002	NUMC	2	0	Reason for Uncertainty of Benefits Payment

History

Last changed by/on	SAP	20110809
SAP Release Created in