HRESS_D_CATS_FAV SAP (CATS Favorites: database table) Table details
Dictionary Type: Table
Description: CATS Favorites: database table
Description: CATS Favorites: database table
ABAP Code to SELECT data from HRESS_D_CATS_FAV
Related tables to HRESS_D_CATS_FAV
Access table HRESS_D_CATS_FAV
Related tables to HRESS_D_CATS_FAV
Access table HRESS_D_CATS_FAV
Table field list including key, data, relationships and ABAP select examples
HRESS_D_CATS_FAV is a standard SAP Table which is used to store CATS Favorites: database table data and is available within R/3 SAP systems depending on the version and release level.
The HRESS_D_CATS_FAV table consists of various fields, each holding specific information or linking keys about CATS Favorites: database table data available in SAP. These include MANDT (Client), UNAME (User Name), VARIANT (Data Entry Profile), OBJ_TYPE (CATS Favorite: object type).. 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 (Deep)
SAP HRESS_D_CATS_FAV 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 | |||
UNAME | User Name | UNAME | CHAR | 12 | UNAME | ||||
VARIANT | Data Entry Profile | CATSVARIAN | CHAR | 8 | Assigned to domain | CATSVARIAN | CVR | ||
OBJ_TYPE | CATS Favorite: object type | HRESS_CATS_FAV_OBJ_TYPE | CHAR | 2 | HRESS_CATS_FAV_OBJ_TYPE | ||||
ID | CATS Favorite: ID for favorite name | HRESS_CATS_FAV_ID | DEC | 21(7) | TZNTSTMPL | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
WORKDAY | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
ROW_NUM | Line Position in CATS Template | TEMPLATE_ZEILE | NUMC | 3 | NUMC3 | ||||
WORKDATE | Date | CATSDATE | DATS | 8 | DATUM | ||||
NAME | CATS Favorite: Description | HRESS_CATS_FAV_DESCRIPTION | CHAR | 30 | HRESS_CATS_FAV_DESCRIPTION | ||||
DEFAULTKZ | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
SKOSTL | Sender Cost Center | SKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KSK | |
LSTAR | Activity Type | LSTAR | CHAR | 6 | CSLA | LSTAR | LAR | LART_EMPTY | |
SEBELN | Sending purchase order | SEBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | ||
SEBELP | Sending purchase order item | SEBELP | NUMC | 5 | Assigned to domain | EBELP | |||
SPRZNR | Sender Business Process | SPRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | ||
LSTNR | Activity Number | ASNUM | CHAR | 18 | Assigned to domain | ALPHA | ASNUM | ASN | |
RKOSTL | Receiver Cost Center | EKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KSK | |
RPROJ | Receiver WBS element | EPROJ | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
RAUFNR | Receiver Order | EAUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
RNPLNR | Network number | NW_AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
RAUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
RAPLZL | General counter for order | CO_APLZL | NUMC | 8 | Assigned to domain | CO_APLZL | |||
RKDAUF | Receiver sales order | EKDAU | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
RKDPOS | Item number in receiver sales order | EKDPO | NUMC | 6 | Assigned to domain | POSNR | |||
RKSTR | Receiver cost object | EKSTR | CHAR | 12 | Assigned to domain | KSTRG | |||
RPRZNR | Receiver business process | EPRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | ||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
FUND | Receiver fund | FM_EFONDS | CHAR | 10 | Assigned to domain | BP_GEBER | RECEIVER_FUND | ||
FUNC_AREA | Receiving Functional Area | EFKTBER | CHAR | 16 | Assigned to domain | FKBER | |||
GRANT_NBR | Receiver Grant | GM_GRANT_RECEIVER | CHAR | 20 | ALPHA | GM_GRANT_NBR | |||
S_FUND | Sender fund | FM_SFONDS | CHAR | 10 | Assigned to domain | BP_GEBER | SENDER_FUND | ||
S_FUNC_AREA | Sending Functional Area | SFKTBER | CHAR | 16 | Assigned to domain | FKBER | |||
S_GRANT_NBR | Sender Grant | GM_GRANT_SENDER | CHAR | 20 | ALPHA | GM_GRANT_NBR | |||
BUDGET_PD | FM: Receiver Budget Period | FM_EBUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
SBUDGET_PD | FM: Sender Budget Period | FM_SBUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
AWART | Attendance or Absence Type | AWART | CHAR | 4 | Assigned to domain | AWART | |||
LGART | Wage Type | LGART | CHAR | 4 | Assigned to domain | LGART | |||
KAPID | Capacity ID | KAPID | NUMC | 8 | Assigned to domain | KAPID | |||
SPLIT | Split number | CY_SPLIT | INT1 | 3 | INT1 | ||||
REINR | Trip Number | REINR | NUMC | 10 | REINR | ||||
WABLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
VERSL | Overtime Compensation Type | VRSCH | CHAR | 1 | T555R | VRSCH | |||
WTART | Tax area work center | HRWRKAR | CHAR | 4 | HRWRKAR | ||||
BWGRL | Valuation basis | CATSBWGRL | CURR | 13(2) | WERTV7 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
AUFKZ | Extra Pay Indicator | AUFKN | CHAR | 1 | AUFKN | ||||
TRFGR | Pay Scale Group | TRFGR | CHAR | 8 | Assigned to domain | TRFGR | |||
TRFST | Pay Scale Level | TRFST | CHAR | 2 | Assigned to domain | TRFST | |||
PRAKN | Premium Number | PRAKN | CHAR | 2 | Assigned to domain | PRAKN | |||
PRAKZ | Premium Indicator | PRAKZ | NUMC | 4 | PRAKZ | ||||
OTYPE | Object Type | OTYPE | CHAR | 2 | T778O | OTYPE | POT | ||
PLANS | Position | PLANS | NUMC | 8 | Assigned to domain | PLANS | |||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
MEINH | Unit of Measure for Display | MEINH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TCURR | Transaction Currency | TWAER | CUKY | 5 | TCURC | WAERS | FWS | ||
PRICE | Price in Transaction Currency | CATSPRICE | CURR | 11(2) | WERTV6 | ||||
ARBID | Object ID | OBJEKTID | NUMC | 8 | NUM08 | PON | |||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
AUTYP | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
HRCOSTASG | Cost Accounting Variants | CATSHRCO | CHAR | 1 | CATSHRCO | ||||
HRKOSTL | Cost Center | CATSHRKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
HRLSTAR | Activity Type | CATSHRLSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART | |
HRFUND | Master Fund | CATSHRFUND | CHAR | 10 | Assigned to domain | BP_GEBER | |||
HRFUNC_AREA | Master Functional Area | CATSHRFUNC_AREA | CHAR | 16 | Assigned to domain | FKBER | |||
HRGRANT_NBR | Master Grant | CATSHRGRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | |||
BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | Assigned to domain | BEMOT | |||
UNIT | Unit of Measurement | MSEHI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
STATKEYFIG | Statistical key figure | STAGR | CHAR | 6 | Assigned to domain | STAGR | STA | ||
TASKTYPE | Task Type | CATSTASKTYPE | CHAR | 4 | CATSTASKTYPE | ||||
TASKLEVEL | Task Level | CATSTASKLEVEL | CHAR | 8 | CATSTASKLEVEL | ||||
TASKCOMPONENT | Task component | CATSTASKCOMPONENT | CHAR | 8 | CATSTASKCOMPONENT | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
CPR_GUID | Project GUID | CATS_CPR_GUID | CHAR | 32 | SYSUUID_C | ||||
CPR_EXTID | External Project ID | CATS_CPR_EXTID | CHAR | 24 | CHAR24 | ||||
CPR_OBJGUID | Object ID | CATS_CPR_OBJGUID | CHAR | 32 | SYSUUID_C | ||||
CPR_OBJGEXTID | External ID of Project Subobject | CATS_CPR_OBJGEXTID | CHAR | 24 | CHAR24 | ||||
CPR_OBJTYPE | cProjects Object Type | CATS_CPR_OBJTYPE | CHAR | 3 | CHAR3 | ||||
HRBUDGET_PD | Master Budget Period | CATSHR_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | |||
ERSDA | Created on | CATS_ERSDA | DATS | 8 | DATUM | ||||
ERSTM | Time of Entry | CATS_CPUTM | TIMS | 6 | UZEIT | ||||
ERNAM | User Who Created Data Record | CATS_ERNAM | CHAR | 12 | USNAM | ||||
LAEDA | Date of Last Change | CATS_LAEDA | DATS | 8 | DATUM | ||||
LAETM | Time of Last Change | CATS_LAETM | TIMS | 6 | UZEIT | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
APNAM | Name of person who approved data | CATSAPNAM | CHAR | 12 | UNAME | ||||
APDAT | Date of Approval | CATSAPDAT | DATS | 8 | DATUM | ||||
WORKITEMID | Work item ID | SWW_WIID | NUMC | 12 | Assigned to domain | SWW_WIID | WID | ||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
STATUS | Processing status | CATSSTATUS | CHAR | 2 | CATSSTATUS | ||||
REFCOUNTER | Reference Counter for Record to be Changed | CATSREFCOU | CHAR | 12 | CHAR12 | ||||
REASON | Reason for rejection | CATSREASON | CHAR | 4 | Assigned to domain | CATSREASON | |||
BELNR | Document Number | CATSBELNR | CHAR | 10 | ALPHA | BELNR | |||
EXTSYSTEM | Logical system of source document | HR_AWSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
EXTAPPLICATION | External Application | HR_AWTYP | CHAR | 5 | HR_AWTYP | ||||
EXTDOCUMENTNO | Document number | HR_AWKEY | CHAR | 20 | AWKEY | ||||
TASKCOUNTER | CATS: Task Counter | CATSTASKCOUNTER | CHAR | 10 | ALPHA | BELNR | |||
CATSHOURS | Hours | CATSHOURS | QUAN | 4(2) | CATSHOURS | ||||
BEGUZ | Start time | CATSBEGUZ | TIMS | 6 | UZEIT | ||||
ENDUZ | End time | CATSENDUZ | TIMS | 6 | UZEIT | ||||
VTKEN | Previous Day Indicator | VTKEN | CHAR | 1 | XFELD | ||||
ALLDF | Record is for Full Day | ALLDF | CHAR | 1 | XFELD | ||||
OFMNW | Remaining work | REMNW | QUAN | 7(1) | ARBEIT | ||||
PEDD | Forecast finish date of operation from confirmation | CO_PEDD | DATS | 8 | DATUM | ||||
AUERU | Partial/Final Confirmation | AUERU_VS | CHAR | 1 | AUERU_VS | ||||
LTXA1 | Short Text | CATSSHORTT | CHAR | 40 | TEXT40 | ||||
LONGTEXT | Long Text | CATSLONGTE | CHAR | 1 | XFELD | ||||
ERUZU | Indicator: Partial confirmation | ERUZU | CHAR | 1 | XFELD | ||||
CATSAMOUNT | CATS Amount | CATSAMOUNT | CURR | 13(2) | CATSAMOUNT | ||||
CATSQUANTITY | Time Sheet: Number (Unit of Measure) | CATSNUMBER | QUAN | 15(3) | CQUA8 | ||||
ZCPR_GUID | 0 | ||||||||
ZCPR_EXTID | 0 | ||||||||
ZCPR_OBJGUID | 0 | ||||||||
ZCPR_OBJGEXTID | 0 | ||||||||
ZCPR_OBJTYPE | 0 | ||||||||
YYRPM_REL_TYPE | Relation Type | Y23_RPM_REL_TYPE | CHAR | 3 | CHAR3 | ||||
YYRPM_PROJ_GUID | Project GUID (xRPM) | Y23_RPM_PROJ_GUID | CHAR | 32 | CHAR32 | ||||
YYRPM_PROJ_ID | Project ID (ext.) | Y23_RPM_PROJ_ID | CHAR | 24 | CHAR24 | ||||
YYRPM_RES_GUID | Resource GUID (xRPM) | Y23_RPM_RES_GUID | CHAR | 32 | CHAR32 | ||||
YYRPM_RES_ID | Resource ID (ext.) | Y23_RPM_RES_ID | CHAR | 24 | CHAR24 | ||||
YYRPM_ROLE_GUID | Role GUID (xRPM) | Y23_RPM_ROLE_GUID | CHAR | 32 | CHAR32 | ||||
YYRPM_ROLE_ID | Role ID (ext.) | Y23_RPM_ROLE_ID | CHAR | 24 | CHAR24 | ||||
YYRPM_TASK_GUID | Task GUID (xRPM) | Y23_RPM_TASK_GUID | CHAR | 32 | CHAR32 | ||||
YYRPM_TASK_ID | Task ID | Y23_RPM_TASK_ID | CHAR | 24 | CHAR24 | ||||
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
UVORN | Suboperation | UVORN | CHAR | 4 | NUMCV | VORNR | |||
BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | Assigned to domain | BEDID | |||
KAPAR | Capacity category | KAPART | CHAR | 3 | Assigned to domain | KAPART | CAA | ||
ARBPL | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
LASTUSED | UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) | TZNTSTMPL | DEC | 21(7) | TZNTSTMPL |
Key field | Non-key field |
How do I retrieve data from SAP table HRESS_D_CATS_FAV using ABAP code
The following ABAP code Example will allow you to do a basic selection on HRESS_D_CATS_FAV to SELECT all data from the tableDATA: WA_HRESS_D_CATS_FAV TYPE HRESS_D_CATS_FAV.
SELECT SINGLE *
FROM HRESS_D_CATS_FAV
INTO CORRESPONDING FIELDS OF WA_HRESS_D_CATS_FAV
WHERE...
How to access SAP table HRESS_D_CATS_FAV
Within an ECC or HANA version of SAP you can also view further information about HRESS_D_CATS_FAV 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