HRPAYDE_EHGL SAP (HR-DEH: Work Table Salary and Wage Structure) Structure details
Description: HR-DEH: Work Table Salary and Wage Structure
Structure field list including key, data, relationships and ABAP select examples
HRPAYDE_EHGL is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "HR-DEH: Work Table Salary and Wage Structure" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_HRPAYDE_EHGL TYPE HRPAYDE_EHGL.
The HRPAYDE_EHGL table consists of various fields, each holding specific information or linking keys about HR-DEH: Work Table Salary and Wage Structure data available in SAP. These include BTRTL (Personnel Subarea), KENBE (Company ID Number), ANSTA (Employment status), ABART (Employee subgroup grouping for personnel calculation rule).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP HRPAYDE_EHGL structure 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 |
WERKS | Personnel Area | PERSA | CHAR | 4 | Assigned to domain | PERSA | PBR | ||
BTRTL | Personnel Subarea | BTRTL | CHAR | 4 | Assigned to domain | BTRTL | PBS | ||
KENBE | Company ID Number | P01_KENBE | CHAR | 6 | CHAR6 | ||||
ANSTA | Employment status | ANSTA | NUMC | 1 | NUM1 | ||||
ABART | Employee subgroup grouping for personnel calculation rule | ABRAR | CHAR | 1 | Assigned to domain | ABRAR | |||
TYPEU | Indicator: EU or German Law | P_TYPEU | CHAR | 1 | CHAR1 | ||||
WERKS_TEXT | Personnel Area Text | PBTXT | CHAR | 30 | TEXT30 | ||||
BTRTL_TEXT | Personnel Subarea Text | BTRTX | CHAR | 15 | TEXT15 | ||||
ANSTA_TEXT | Employment Status Text | P01_ANSTA_TEXT | CHAR | 30 | TEXT30 | ||||
ABART_TEXT | Payroll Type Text | P01_ABART_TEXT | CHAR | 30 | TEXT30 | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
LFDNR | Sequence Number | P01_LFDNR1 | CHAR | 5 | CHAR5 | ||||
TARIF | Column 04: Pay Scale Group | P_TARIF | CHAR | 10 | CHAR10 | ||||
TARIFNR | Column 05: Sequence Number of Collective Agreement | P_TARIFNR | CHAR | 1 | CHAR1 | ||||
LSTGR | Column 06: Benefits Group | P_LSTGR | CHAR | 1 | CHAR1 | ||||
GESCH | Column 07: Gender | P_GESCH | CHAR | 1 | GESCH | ||||
GBDAT | Column 08: Date of Birth | P_GBDAT | DATS | 8 | PDATE | GBDAT | |||
HIRE | Column 09: Entry Date | P_HIRE | DATS | 8 | DATUM | ||||
FIRE | Column 10: Leaving | P_FIRE | DATS | 8 | DATUM | ||||
LSTKL | Column 11: Employment Tax Class | P_LSTKL | CHAR | 1 | CHAR1 | ||||
KIFRB | Column 12: Tax Exemptions for Children | P_KDFBT | DEC | 3(1) | DEC2_1 | ||||
DUETA | Column 13: Field A of Insurance No. | P_DUETA | CHAR | 3 | CHAR3 | ||||
STBRF | Column 14: Field B Left Part of Insurance No. | P_STBRF | CHAR | 1 | CHAR1 | ||||
AUSBG | Column 14: Field B Right Part of Insurance No. | P_AUSBG | CHAR | 1 | CHAR1 | ||||
VART | Column 15: Type of Work Contract | P_VART | CHAR | 1 | CHAR1 | ||||
LOHNF | Spalte 16: Wage System | P_LOHNF | CHAR | 1 | CHAR1 | ||||
TECHN | Column 17: Technical Job | P_TECHN | CHAR | 1 | CHAR1 | ||||
WOABZ | Column 18: Weekly Working Time | P_WOSTD | DEC | 5(2) | STDAZ | ||||
ANZHL19 | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
ANZHL20 | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
ANZHL21 | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
ANZHL22 | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
ANZHL23 | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
WAERS | Currency | P_WAERS | CHAR | 1 | CHAR1 | ||||
BETRG24 | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
BETRG25 | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
BETRG26 | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
BETRG27 | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
BETRG28 | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
BETRG29 | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
BETRG30 | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
BETRG31 | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
BETRG32 | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
BETRG33 | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
BETRG34 | HR Payroll: Amount | MAXBT | CURR | 15(2) | PRBETRG | ||||
URLAUB | Leave entitlement | PTM_HENTITLE | DEC | 10(5) | PTM_QUONUM | ||||
ANZHL36 | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
ANZHL37 | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
ANZHL38 | HR payroll: Number | PRANZ | DEC | 15(2) | PRANZHL | ||||
FELD39 | Spalte 39: Empty Field | P_FELD39 | CHAR | 7 | CHAR07 |
Key field | Non-key field |
How do I retrieve data from SAP structure HRPAYDE_EHGL using ABAP code?
As HRPAYDE_EHGL is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on HRPAYDE_EHGL as there is no data to select.How to access SAP table HRPAYDE_EHGL
Within an ECC or HANA version of SAP you can also view further information about HRPAYDE_EHGL 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