T7IEE SAP (EHECS: Return Data) Table details
Dictionary Type: Table
Description: EHECS: Return Data
Description: EHECS: Return Data
Table field list including key, data, relationships and ABAP select examples
T7IEE is a standard SAP Table which is used to store EHECS: Return Data data and is available within R/3 SAP systems depending on the version and release level.
The T7IEE table consists of various fields, each holding specific information or linking keys about EHECS: Return Data data available in SAP. These include MANDT (Client), RYEAR (EHECS: Year), RQUTR (EHECS: Quarter), ERNIE (Employer's Registered Number).. 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: Can be enhanced (character-type or numeric)
SAP T7IEE 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 | |||
RYEAR | EHECS: Year | P11_YEAR | NUMC | 4 | |||||
RQUTR | EHECS: Quarter | P11_QUARTER | CHAR | 1 | |||||
ERNIE | Employer's Registered Number | PIE_ERNIE | CHAR | 9 | PIE_ERNIE | ||||
AEDTM | Changed On | AEDAT | DATS | 8 | DATUM | ||||
ATIME | Time | UZEIT | TIMS | 6 | UZEIT | ||||
UNAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
RLOCK | EHECS: Release Indicator | P11_RLOCK | CHAR | 1 | |||||
RTYPE | EHECS: Report Type | P11_RTYPE | CHAR | 1 | |||||
ER_NAME | Employer Name | PIE_ENAME | CHAR | 30 | PIE_ENAME | ||||
LINE0 | Employer address line | PIE_EADDR | CHAR | 30 | PIE_EADDR | ||||
LINE1 | Employer address line | PIE_EADDR | CHAR | 30 | PIE_EADDR | ||||
LINE2 | Employer address line | PIE_EADDR | CHAR | 30 | PIE_EADDR | ||||
LINE3 | HR-IE: Legal reporting Address line 4 | P11_ADRS4 | CHAR | 80 | CHAR80 | ||||
RCHAD | EHECS: Change Name/Address of IE Employer | P11_CHADR | CHAR | 1 | |||||
CPNAME | EHECS: Contact Person Name | P11_CPNM | CHAR | 40 | CHAR40K | ||||
PHONE | EHECS:Contact Person Phone Number | P11_CPPHN | CHAR | 14 | |||||
EHECS: Contact Person E-mail Address | P11_CPEML | CHAR | 80 | P11_CPEML | |||||
CPSTN | EHECS: Contact Person Position | P11_CPSTN | CHAR | 40 | CHAR40K | ||||
RDATE | EHECS: Document Date | P11_DOCDATE | DATS | 8 | |||||
CMNTS | EHECS: Comments | P11_CMNTS | CHAR | 255 | |||||
FSTFTMG | EHECS: Number Full Time Managers at first day of Quarter | P11_FSFTMG | DEC | 5 | DEC5 | ||||
FSTFTCL | EHECS: Number Full Time Clerical at first day of Quarter | P11_FSFTCL | DEC | 5 | DEC5 | ||||
FSTFTOT | EHECS: Number Full Time Other at first day of Quarter | P11_FSFTOT | DEC | 5 | DEC5 | ||||
LSTFTMG | EHECS: Number Full Time Managers at last day of Quarter | P11_LSFTMG | DEC | 5 | DEC5 | ||||
LSTFTCL | EHECS: Number Full Time Clerical at last day of Quarter | P11_LSFTCL | DEC | 5 | DEC5 | ||||
LSTFTOT | EHECS: Number Full Time Other at last day of Quarter | P11_LSFTOT | DEC | 5 | DEC5 | ||||
HIREFTMG | EHECS: Number Full Time Managers Hired during Quarter | P11_HRFTMG | DEC | 5 | DEC5 | ||||
HIREFTCL | EHECS: Number Full Time Clerical Hired during Quarter | P11_HRFTCL | DEC | 5 | DEC5 | ||||
HIREFTOT | EHECS: Number Full Time Other Hired during Quarter | P11_HRFTOT | DEC | 5 | DEC5 | ||||
FSTPTMG | EHECS: Number Part Time Managers at first day of Quarter | P11_FSPTMG | DEC | 5 | DEC5 | ||||
FSTPTCL | EHECS: Number Part Time Clerical at first day of Quarter | P11_FSPTCL | DEC | 5 | DEC5 | ||||
FSTPTOT | EHECS: Number Part Time Other at first day of Quarter | P11_FSPTOT | DEC | 5 | DEC5 | ||||
LSTPTMG | EHECS: Number Part Time Managers at last day of Quarter | P11_LSPTMG | DEC | 5 | DEC5 | ||||
LSTPTCL | EHECS: Number Part Time Clerical at last day of Quarter | P11_LSPTCL | DEC | 5 | DEC5 | ||||
LSTPTOT | EHECS: Number Part Time Other at last day of Quarter | P11_LSPTOT | DEC | 5 | DEC5 | ||||
HIREPTMG | EHECS: Number Part Time Managers Hired during Quarter | P11_HRPTMG | DEC | 5 | DEC5 | ||||
HIREPTCL | EHECS: Number Part Time Clerical Hired during Quarter | P11_HRPTCL | DEC | 5 | DEC5 | ||||
HIREPTOT | EHECS: Number Part Time Other Hired during Quarter | P11_HRPTOT | DEC | 5 | DEC5 | ||||
APPMG | EHECS: Average Number Apprentice Managers | P11_APPMG | DEC | 7(2) | DEC5_2 | ||||
APPCL | EHECS: Average Number Apprentice Clerical | P11_APPCL | DEC | 7(2) | DEC5_2 | ||||
APPOT | EHECS: Average Number Apprentice Other | P11_APPOT | DEC | 7(2) | DEC5_2 | ||||
OTPERMG | EHECS: Average Number Other Persons Managers | P11_OTPRMG | DEC | 7(2) | DEC5_2 | ||||
OTPERCL | EHECS: Average Number Other Persons Clerical | P11_OTPRCL | DEC | 7(2) | DEC5_2 | ||||
OTPEROT | EHECS: Average Number Other Persons Other | P11_OTPROT | DEC | 7(2) | DEC5_2 | ||||
VACMG | EHECS: Number Job Vacancies Managers | P11_VACMG | DEC | 5 | DEC5 | ||||
VACCL | EHECS: Number Job Vacancies Clerical | P11_VACCL | DEC | 5 | DEC5 | ||||
VACOT | EHECS: Number Job Vacancies Other | P11_VACOT | DEC | 5 | DEC5 | ||||
NMWMG | EHECS: Number at National Minimum Wage Managers | P11_NMWMG | DEC | 5 | DEC5 | ||||
NMWCL | EHECS: Number at National Minimum Wage Clerical | P11_NMWCL | DEC | 5 | DEC5 | ||||
NMWOT | EHECS: Number at National Minimum Wage Other | P11_NMWOT | DEC | 5 | DEC5 | ||||
REGWGFTMG | EHECS: Regular Wages Full Time Managers | P11_RWFTMG | DEC | 11(2) | DEC9_2 | ||||
REGWGFTCL | EHECS: Regular Wages Full Time Clerical | P11_RWFTCL | DEC | 11(2) | DEC9_2 | ||||
REGWGFTOT | EHECS: Regular Wages Full Time Other | P11_RWFTOT | DEC | 11(2) | DEC9_2 | ||||
OVRTFTMG | EHECS: Overtime Payments Full Time Managers | P11_OTFTMG | DEC | 11(2) | DEC9_2 | ||||
OVRTFTCL | EHECS: Overtime Payments Full Time Clerical | P11_OTFTCL | DEC | 11(2) | DEC9_2 | ||||
OVRTFTOT | EHECS: Overtime Payments Full Time Other | P11_OTFTOT | DEC | 11(2) | DEC9_2 | ||||
IRRBFTMG | EHECS: Irregular Bonuses Full Time Managers | P11_IBFTMG | DEC | 11(2) | DEC9_2 | ||||
IRRBFTCL | EHECS: Irregular Bonuses Full Time Clerical | P11_IBFTCL | DEC | 11(2) | DEC9_2 | ||||
IRRBFTOT | EHECS: Irregular Bonuses Full Time Other | P11_IBFTOT | DEC | 11(2) | DEC9_2 | ||||
REGWGPTMG | EHECS: Regular Wages Part Time Managers | P11_RWPTMG | DEC | 11(2) | DEC9_2 | ||||
REGWGPTCL | EHECS: Regular Wages Part Time Clerical | P11_RWPTCL | DEC | 11(2) | DEC9_2 | ||||
REGWGPTOT | EHECS: Regular Wages Part Time Other | P11_RWPTOT | DEC | 11(2) | DEC9_2 | ||||
OVRTPTMG | EHECS: Overtime Payments Part Time Managers | P11_OTPTMG | DEC | 11(2) | DEC9_2 | ||||
OVRTPTCL | EHECS: Overtime Payments Part Time Clerical | P11_OTPTCL | DEC | 11(2) | DEC9_2 | ||||
OVRTPTOT | EHECS: Overtime Payments Part Time Other | P11_OTPTOT | DEC | 11(2) | DEC9_2 | ||||
IRRBPTMG | EHECS: Irregular Bonuses Part Time Managers | P11_IBPTMG | DEC | 11(2) | DEC9_2 | ||||
IRRBPTCL | EHECS: Irregular Bonuses Part Time Clerical | P11_IBPTCL | DEC | 11(2) | DEC9_2 | ||||
IRRBPTOT | EHECS: Irregular Bonuses Part Time Other | P11_IBPTOT | DEC | 11(2) | DEC9_2 | ||||
APPWGMG | EHECS: Total Wages Apprentices Managers | P11_APWGMG | DEC | 11(2) | DEC9_2 | ||||
APPWGCL | EHECS: Total Wages Apprentices Clerical | P11_APWGCL | DEC | 11(2) | DEC9_2 | ||||
APPWGOT | EHECS: Total Wages Apprentices Other | P11_APWGOT | DEC | 11(2) | DEC9_2 | ||||
CHRSFTMG | EHECS: Contracted Hours Full Time Managers | P11_CHFTMG | DEC | 9(2) | DEC7_2 | ||||
CHRSFTCL | EHECS: Contracted Hours Full Time Clerical | P11_CHFTCL | DEC | 9(2) | DEC7_2 | ||||
CHRSFTOT | EHECS: Contracted Hours Full Time Other | P11_CHFTOT | DEC | 9(2) | DEC7_2 | ||||
OTHRFTMG | EHECS: Overtime Hours Full Time Managers | P11_OHFTMG | DEC | 9(2) | DEC7_2 | ||||
OTHRFTCL | EHECS: Overtime Hours Full Time Clerical | P11_OHFTCL | DEC | 9(2) | DEC7_2 | ||||
OTHRFTOT | EHECS: Overtime Hours Full Time Other | P11_OHFTOT | DEC | 9(2) | DEC7_2 | ||||
CHRSPTMG | EHECS: Contracted Hours Part Time Managers | P11_CHPTMG | DEC | 9(2) | DEC7_2 | ||||
CHRSPTCL | EHECS: Contracted Hours Part Time Clerical | P11_CHPTCL | DEC | 9(2) | DEC7_2 | ||||
CHRSPTOT | EHECS: Contracted Hours Part Time Other | P11_CHPTOT | DEC | 9(2) | DEC7_2 | ||||
OTHRPTMG | EHECS: Overtime Hours Part Time Managers | P11_OHPTMG | DEC | 9(2) | DEC7_2 | ||||
OTHRPTCL | EHECS: Overtime Hours Part Time Clerical | P11_OHPTCL | DEC | 9(2) | DEC7_2 | ||||
OTHRPTOT | EHECS: Overtime Hours Part Time Other | P11_OHPTOT | DEC | 9(2) | DEC7_2 | ||||
CHRSAPMG | EHECS: Contracted Hours Apprentice Managers | P11_CHAPMG | DEC | 9(2) | DEC7_2 | ||||
CHRSAPCL | EHECS: Contracted Hours Apprentice Clerical | P11_CHAPCL | DEC | 9(2) | DEC7_2 | ||||
CHRSAPOT | EHECS: Contracted Hours Apprentice Other | P11_CHAPOT | DEC | 9(2) | DEC7_2 | ||||
OTHRAPMG | EHECS: Overtime Hours Apprentice Managers | P11_OHAPMG | DEC | 9(2) | DEC7_2 | ||||
OTHRAPCL | EHECS: Overtime Hours Apprentice Clerical | P11_OHAPCL | DEC | 9(2) | DEC7_2 | ||||
OTHRAPOT | EHECS: Overtime Hours Apprentice Other | P11_OHAPOT | DEC | 9(2) | DEC7_2 | ||||
ALFTMG | EHECS: Annual Leave Full Time Managers | P11_ALFTMG | DEC | 9(2) | DEC7_2 | ||||
ALFTCL | EHECS: Annual Leave Full Time Clerical | P11_ALFTCL | DEC | 9(2) | DEC7_2 | ||||
ALFTOT | EHECS: Annual Leave Full Time Other | P11_ALFTOT | DEC | 9(2) | DEC7_2 | ||||
MATFTMG | EHECS: Maternity Leave Full Time Managers | P11_MTFTMG | DEC | 9(2) | DEC7_2 | ||||
MATFTCL | EHECS: Maternity Leave Full Time Clerical | P11_MTFTCL | DEC | 9(2) | DEC7_2 | ||||
MATFTOT | EHECS: Maternity Leave Full Time Other | P11_MTFTOT | DEC | 9(2) | DEC7_2 | ||||
SICFTMG | EHECS: Sick Leave Full Time Managers | P11_SCFTMG | DEC | 9(2) | DEC7_2 | ||||
SICFTCL | EHECS: Sick Leave Full Time Clerical | P11_SCFTCL | DEC | 9(2) | DEC7_2 | ||||
SICFTOT | EHECS: Sick Leave Full Time Other | P11_SCFTOT | DEC | 9(2) | DEC7_2 | ||||
OTLFTMG | EHECS: Other Leave Full Time Managers | P11_OLFTMG | DEC | 9(2) | DEC7_2 | ||||
OTLFTCL | EHECS: Other Leave Full Time Clerical | P11_OLFTCL | DEC | 9(2) | DEC7_2 | ||||
OTLFTOT | EHECS: Other Leave Full Time Other | P11_OLFTOT | DEC | 9(2) | DEC7_2 | ||||
ALPTMG | EHECS: Annual Leave Part Time Managers | P11_ALPTMG | DEC | 9(2) | DEC7_2 | ||||
ALPTCL | EHECS: Annual Leave Part Time Clerical | P11_ALPTCL | DEC | 9(2) | DEC7_2 | ||||
ALPTOT | EHECS: Annual Leave Part Time Other | P11_ALPTOT | DEC | 9(2) | DEC7_2 | ||||
MATPTMG | EHECS: Maternity Leave Part Time Managers | P11_MTPTMG | DEC | 9(2) | DEC7_2 | ||||
MATPTCL | EHECS: Maternity Leave Part Time Clerical | P11_MTPTCL | DEC | 9(2) | DEC7_2 | ||||
MATPTOT | EHECS: Maternity Leave Part Time Other | P11_MTPTOT | DEC | 9(2) | DEC7_2 | ||||
SICPTMG | EHECS: Sick Leave Part Time Managers | P11_SCPTMG | DEC | 9(2) | DEC7_2 | ||||
SICPTCL | EHECS: Sick Leave Part Time Clerical | P11_SCPTCL | DEC | 9(2) | DEC7_2 | ||||
SICPTOT | EHECS: Sick Leave Part Time Other | P11_SCPTOT | DEC | 9(2) | DEC7_2 | ||||
OTLPTMG | EHECS: Other Leave Part Time Managers | P11_OLPTMG | DEC | 9(2) | DEC7_2 | ||||
OTLPTCL | EHECS: Other Leave Part Time Clerical | P11_OLPTCL | DEC | 9(2) | DEC7_2 | ||||
OTLPTOT | EHECS: Other Leave Part Time Other | P11_OLPTOT | DEC | 9(2) | DEC7_2 | ||||
LAPMG | EHECS: All Leave Apprentice Managers | P11_LAPMG | DEC | 9(2) | DEC7_2 | ||||
LAPCL | EHECS: All Leave Apprentice Clerical | P11_LAPCL | DEC | 9(2) | DEC7_2 | ||||
LAPOT | EHECS: All Leave Apprentice Other | P11_LAPOT | DEC | 9(2) | DEC7_2 | ||||
PENMG | EHECS: Employer's Pension Contribution Managers | P11_PENMG | DEC | 11(2) | DEC9_2 | ||||
PENCL | EHECS: Employer's Pension Contribution Clerical | P11_PENCL | DEC | 11(2) | DEC9_2 | ||||
PENOT | EHECS: Employer's Pension Contribution Other | P11_PENOT | DEC | 11(2) | DEC9_2 | ||||
LIBINS | EHECS: Employer's Liability Insurance Premiums | P11_LIBINS | DEC | 11(2) | DEC9_2 | ||||
PRSIMG | EHECS: Employer's PRSI Managers | P11_PRSIMG | DEC | 11(2) | DEC9_2 | ||||
PRSICL | EHECS: Employer's PRSI Clerical | P11_PRSICL | DEC | 11(2) | DEC9_2 | ||||
PRSIOT | EHECS: Employer's PRSI Other | P11_PRSIOT | DEC | 11(2) | DEC9_2 | ||||
INCCTMG | EHECS: Income Continuance Insurance Managers | P11_INCTMG | DEC | 11(2) | DEC9_2 | ||||
INCCTCL | EHECS: Income Continuance Insurance Clerical | P11_INCTCL | DEC | 11(2) | DEC9_2 | ||||
INCCTOT | EHECS: Income Continuance Insurance Other | P11_INCTOT | DEC | 11(2) | DEC9_2 | ||||
REDMG | EHECS: Redundancy Payments Managers | P11_REDMG | DEC | 11(2) | DEC9_2 | ||||
REDCL | EHECS: Redundancy Payments Clerical | P11_REDCL | DEC | 11(2) | DEC9_2 | ||||
REDOT | EHECS: Redundancy Payments Other | P11_REDOT | DEC | 11(2) | DEC9_2 | ||||
OTSOCMG | EHECS: Other Employee-related Payments Managers | P11_OTSCMG | DEC | 11(2) | DEC9_2 | ||||
OTSOCCL | EHECS: Other Employee-related Payments Clerical | P11_OTSCCL | DEC | 11(2) | DEC9_2 | ||||
OTSOCOT | EHECS: Other Employee-related Payments Other | P11_OTSCOT | DEC | 11(2) | DEC9_2 | ||||
SSECAPMG | EHECS: Total Soc. Security Contributions Apprentice Managers | P11_SSAPMG | DEC | 11(2) | DEC9_2 | ||||
SSECAPCL | EHECS: Total Soc. Security Contributions Apprentice Clerical | P11_SSAPCL | DEC | 11(2) | DEC9_2 | ||||
SSECAPOT | EHECS: Total Soc. Security Contributions Apprentice Other | P11_SSAPOT | DEC | 11(2) | DEC9_2 | ||||
CARMG | EHECS: Company Car Benefit. Managers | P11_CARMG | DEC | 11(2) | DEC9_2 | ||||
CARCL | EHECS: Company Car Benefit. Clerical | P11_CARCL | DEC | 11(2) | DEC9_2 | ||||
CAROT | EHECS: Company Car Benefit. Other | P11_CAROT | DEC | 11(2) | DEC9_2 | ||||
STKSMG | EHECS: Stock Options Benefit. Managers | P11_STKSMG | DEC | 11(2) | DEC9_2 | ||||
STKSCL | EHECS: Stock Options Benefit. Clerical | P11_STKSCL | DEC | 11(2) | DEC9_2 | ||||
STKSOT | EHECS: Stock Options Benefit. Other | P11_STKSOT | DEC | 11(2) | DEC9_2 | ||||
VHIMG | EHECS: VHI Benefit. Managers | P11_VHIMG | DEC | 11(2) | DEC9_2 | ||||
VHICL | EHECS: VHI Benefit. Clerical | P11_VHICL | DEC | 11(2) | DEC9_2 | ||||
VHIOT | EHECS: VHI Benefit. Other | P11_VHIOT | DEC | 11(2) | DEC9_2 | ||||
HSEMG | EHECS: Staff Housing Benefit. Managers | P11_HSEMG | DEC | 11(2) | DEC9_2 | ||||
HSECL | EHECS: Staff Housing Benefit. Clerical | P11_HSECL | DEC | 11(2) | DEC9_2 | ||||
HSEOT | EHECS: Staff Housing Benefit. Other | P11_HSEOT | DEC | 11(2) | DEC9_2 | ||||
OTBENMG | EHECS: Other Benefit. Managers | P11_OTBNMG | DEC | 11(2) | DEC9_2 | ||||
OTBENCL | EHECS: Other Benefit. Clerical | P11_OTBNCL | DEC | 11(2) | DEC9_2 | ||||
OTBENOT | EHECS: Other Benefit. Other | P11_OTBNOT | DEC | 11(2) | DEC9_2 | ||||
TREXP | EHECS: Training Costs | P11_TREXP | DEC | 11(2) | DEC9_2 | ||||
OTEXP | EHECS: Other Expenditure | P11_OTEXP | DEC | 11(2) | DEC9_2 | ||||
TRSUB | EHECS: Training subsidies (FAS) | P11_TRSUB | DEC | 11(2) | DEC9_2 | ||||
OTSUB | EHECS: Other subsidies (e.g. IDA) | P11_OTSUB | DEC | 11(2) | DEC9_2 | ||||
RFUND | EHECS: Refunds from DSFA & DETE | P11_RFUND | DEC | 11(2) | DEC9_2 |
Key field | Non-key field |
How do I retrieve data from SAP table T7IEE using ABAP code
The following ABAP code Example will allow you to do a basic selection on T7IEE to SELECT all data from the tableDATA: WA_T7IEE TYPE T7IEE.
SELECT SINGLE *
FROM T7IEE
INTO CORRESPONDING FIELDS OF WA_T7IEE
WHERE...
How to access SAP table T7IEE
Within an ECC or HANA version of SAP you can also view further information about T7IEE 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