P01EL_DBEN SAP (Data Modules ELENA Basic Data for Employer and Employee) Table details
Description: Data Modules ELENA Basic Data for Employer and Employee
Table field list including key, data, relationships and ABAP select examples
P01EL_DBEN is a standard SAP Table which is used to store Data Modules ELENA Basic Data for Employer and Employee data and is available within R/3 SAP systems depending on the version and release level.
The P01EL_DBEN table consists of various fields, each holding specific information or linking keys about Data Modules ELENA Basic Data for Employer and Employee data available in SAP. These include GUID (Unique Key for Identification of Notification), AVBEG (Start of the Work/Employment Relationship), STKL (Tax class), FKT (Factor for Tax Calculation).. 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_DBEN 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 | Assigned to domain | MANDT | |||
GUID | Unique Key for Identification of Notification | P01_SVGUID | CHAR | 32 | SYSUUID_C | ||||
AVBEG | Start of the Work/Employment Relationship | P01_SV_EL_AVBEG | DATS | 8 | DATS | ||||
STKL | Tax class | P01_SV_EL_STKL | CHAR | 1 | STRKL | ||||
FKT | Factor for Tax Calculation | P01_SV_EL_FKT | NUMC | 4 | NUMC4 | ||||
KINDFRB | Tax Exemption for Children | P01_SV_EL_KINDFRB | NUMC | 3 | P01_SV_EL_KINDFRB | ||||
TTSC | Occupational Code | P01_SV_EL_TTSC | CHAR | 9 | D3TTSC | ||||
KENNZRK | Place of Work (Legal Area) Indicator | P01_SV_EL_KENNZRK | CHAR | 1 | D3KENNZRK | ||||
BYGR | Contribution Group | P01_SV_EL_BYGR | NUMC | 4 | D3BYGR | ||||
AZWOECH | Weekly Working Time | P01_SV_EL_AZWOECH | NUMC | 4 | P01_SV_EL_AZWOECH | ||||
VSTBREGLF | +/- for Regular Gross Remuneration Subject to Tax | P01_SV_EL_VZSTBREGLF | CHAR | 1 | P01_SV_VZ | ||||
STBREGLF | Current Gross Remuneration Subject to Tax | P01_SV_EL_STBREGLF | NUMC | 10 | P01_SV_EL_BETRAG | ||||
VSTBREGSO | +/- Sign for Other Gross Remuneration Subject to Tax | P01_SV_EL_STBREGSO | CHAR | 1 | P01_SV_VZ | ||||
STBREGSO | Other Gross Remuneration Subject to Tax | P01_SV_EL_STRBEGSO | NUMC | 10 | P01_SV_EL_BETRAG | ||||
SVBREGLF | Current Gross Remuneration Subject to SI Contributions | P01_SV_EL_SVBREGLF | NUMC | 10 | P01_SV_EL_BETRAG | ||||
SVBREGE | One-Time SI Gross Payment | P01_SV_EL_SVBREGE | NUMC | 10 | P01_SV_EL_BETRAG | ||||
VGSBREG | +/- for Total Gross Remuneration | P01_SV_EL_VZGSBREG | CHAR | 1 | P01_SV_VZ | ||||
GSBREG | Total Gross Remuneration | P01_SV_EL_GSBREG | NUMC | 10 | P01_SV_EL_BETRAG | ||||
KVLF | HI Payments on Regular Remunerations | P01_SV_EL_KVLF | NUMC | 10 | P01_SV_EL_BETRAG | ||||
KVE | HI Payments on Non-Recurring Remunerations | P01_SV_EL_KVE | NUMC | 10 | P01_SV_EL_BETRAG | ||||
RVLF | PI Contributions on Current Remuneration | P01_SV_EL_RVLF | NUMC | 10 | P01_SV_EL_BETRAG | ||||
RVE | PI Contributions on Once-Only Payments | P01_SV_EL_RVE | NUMC | 10 | P01_SV_EL_BETRAG | ||||
AVLF | UI Contributions on Current Remuneration | P01_SV_EL_AVLF | NUMC | 10 | P01_SV_EL_BETRAG | ||||
AVE | UI Contributions on One-Time Payments | P01_SV_EL_AVE | NUMC | 10 | P01_SV_EL_BETRAG | ||||
PVLF | CI Contribution for Current Remuneration | P01_SV_EL_PVLF | NUMC | 10 | P01_SV_EL_BETRAG | ||||
PVE | Care Insurance Contribution for Once-Only Payments | P01_SV_EL_PVE | NUMC | 10 | P01_SV_EL_BETRAG | ||||
VLSTLF | +/- for Employment Tax Regular | P01_SV_EL_VZLSTLF | CHAR | 1 | P01_SV_VZ | ||||
LSTLF | Employment Tax on Regular Payments | P01_SV_EL_LSTLF | NUMC | 10 | P01_SV_EL_BETRAG | ||||
VLSTSOB | +/- for Employment Tax on Other Payments | P01_SV_EL_VZLSTSOB | CHAR | 1 | P01_SV_VZ | ||||
LSTSOB | Employment Tax Other Payment | P01_SV_EL_LSTSOB | NUMC | 10 | P01_SV_EL_BETRAG | ||||
VSOLILF | +/- for Reunification Tax Regular | P01_SV_EL_VZSOLILF | CHAR | 1 | P01_SV_VZ | ||||
SOLILF | Reunification Tax Current | P01_SV_EL_SOLILF | NUMC | 10 | P01_SV_EL_BETRAG | ||||
VSOLISOB | +/- for Reunification Tax on Other Payments | P01_SV_EL_VZSOLISOB | CHAR | 1 | P01_SV_VZ | ||||
SOLISOB | Reunification Tax on Other Payments | P01_SV_EL_SOLISOB | NUMC | 10 | P01_SV_EL_BETRAG | ||||
VKISTLF | +/- for Church Tax on Regular Payments | P01_SV_EL_VZKISTLF | CHAR | 1 | P01_SV_VZ | ||||
KISTLF | Church Tax on Regular Payments | P01_SV_EL_KISTLF | NUMC | 10 | P01_SV_EL_BETRAG | ||||
VKISTSOB | +/- for Church Tax on Other Payments | P01_SV_EL_VZKISTSOB | CHAR | 1 | P01_SV_VZ | ||||
KISTSOB | Church Tax on Other Payments | P01_SV_EL_KISTSOB | NUMC | 10 | P01_SV_EL_BETRAG | ||||
STAPAG | Employer's Tax Deduction Obligation | P01_SV_EL_STAPAG | CHAR | 1 | P01_SV_EL_STAPAG |
Key field | Non-key field |
How do I retrieve data from SAP table P01EL_DBEN using ABAP code
The following ABAP code Example will allow you to do a basic selection on P01EL_DBEN to SELECT all data from the tableDATA: WA_P01EL_DBEN TYPE P01EL_DBEN.
SELECT SINGLE *
FROM P01EL_DBEN
INTO CORRESPONDING FIELDS OF WA_P01EL_DBEN
WHERE...
How to access SAP table P01EL_DBEN
Within an ECC or HANA version of SAP you can also view further information about P01EL_DBEN 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