HRPAYDE_EHGL_BASE SAP (HR-DGL: Data Record of Salary and Wage Structure) Structure details
Description: HR-DGL: Data Record of Salary and Wage Structure
Related tables to HRPAYDE_EHGL_BASE
Access table HRPAYDE_EHGL_BASE
Structure field list including key, data, relationships and ABAP select examples
HRPAYDE_EHGL_BASE 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-DGL: Data Record of 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_BASE TYPE HRPAYDE_EHGL_BASE.
The HRPAYDE_EHGL_BASE table consists of various fields, each holding specific information or linking keys about HR-DGL: Data Record of Salary and Wage Structure data available in SAP. These include TARIFNR (Column 05: Sequence Number of Collective Agreement), LSTGR (Column 06: Benefits Group), GESCH (Column 07: Gender), GEBMO (Column 08: Birth Month).. 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_BASE 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 |
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 | ||||
GEBMO | Column 08: Birth Month | P_GEBMO | CHAR | 2 | CHAR2 | ||||
GEBJH | Column 08: Birth Year | P_GEBJH | CHAR | 4 | CHAR4 | ||||
HIREMO | Column 09: Entry Month | P_HIREMO | CHAR | 2 | CHAR2 | ||||
HIREY | Column 09: Entry Year | P_HIREY | CHAR | 4 | CHAR4 | ||||
FIREMO | Column 10: Leaving Month | P_FIREMO | CHAR | 2 | CHAR2 | ||||
LSTKL | Column 11: Employment Tax Class | P_LSTKL | CHAR | 1 | CHAR1 | ||||
KIFRB | Spalte 12: Tax Exemption for Children | P_KIFRB | NUMC | 3 | NUMC03 | ||||
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 (Contract) | P_WOABZ | NUMC | 4 | NUMC04 | ||||
STDBEZ | Column 19: Total Hours Paid | P_STDBEZ | NUMC | 5 | NUMC05 | ||||
NSTDBZ | Column 20: Paid Regular Working Hours | P_NSTDBZ | NUMC | 5 | NUMC05 | ||||
MESTD | Column 21: Paid Overtime Hours | P_MESTD | NUMC | 5 | NUMC05 | ||||
ZGTHA | Column 22: Starting Flextime Credit | P_ZGTHA | NUMC | 5 | NUMC05 | ||||
ZGTHE | Column 23: Ending Flextime Credit | P_ZGTHE | NUMC | 5 | NUMC05 | ||||
WAERS | Currency | P_WAERS | CHAR | 1 | CHAR1 | ||||
BETRG24 | Column 24: Total Gross (Period) | P_BETRG24 | NUMC | 6 | NUMC06 | ||||
BETRG25 | Spalte 25: Overtime (Period) | P_BETRG25 | NUMC | 6 | NUMC06 | ||||
BETRG26 | Column 26: Shift Work Bonus (Period) | P_BETRG26 | NUMC | 4 | NUMC04 | ||||
BETRG27 | Spalte 27: Sunday Work Bonus (Period) | P_BETRG27 | NUMC | 4 | NUMC04 | ||||
BETRG28 | Column 28: Night Work Bonus (Period) | P_BETRG28 | NUMC | 4 | NUMC04 | ||||
BETRG29 | Column 29: Employment Tax (Period) | P_BETRG29 | NUMC | 5 | NUMC05 | ||||
BETRG30 | Column 30: Pension and Unemployment Insurance (Period) | P_BETRG30 | NUMC | 5 | NUMC05 | ||||
BETRG31 | Column 31: Health and Care Indurance (Period) | P_BETRG31 | NUMC | 5 | NUMC05 | ||||
BETRG32 | Column 32: Gross Remuneration (Year) | P_BETRG32 | NUMC | 7 | NUMC07 | ||||
BETRG33 | Column 33: Special Payments (Year) | P_BETRG33 | NUMC | 7 | NUMC07 | ||||
BETRG34 | Column 34: Net Remuneration (Year) | P_BETRG34 | NUMC | 7 | NUMC07 | ||||
URLAUB | Column 35: Leave Entitlement | P_URLAUB | CHAR | 2 | CHAR02 | ||||
ANZHL36 | Column 36: Monthly Working Hours | P_ANZHL36 | NUMC | 5 | NUMC05 | ||||
ANZHL37 | Column 37: working Hours 1- 28 October | P_ANZHL37 | NUMC | 5 | NUMC05 | ||||
ANZHL38 | Column 38: Working Hours 29- 31 October | P_ANZHL38 | NUMC | 5 | NUMC05 | ||||
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_BASE using ABAP code?
As HRPAYDE_EHGL_BASE 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_BASE as there is no data to select.How to access SAP table HRPAYDE_EHGL_BASE
Within an ECC or HANA version of SAP you can also view further information about HRPAYDE_EHGL_BASE 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