HRESS_D_CATS_FAV SAP (CATS Favorites: database table) Table details

Dictionary Type: 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




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
UNAMEUser Name UNAMECHAR12UNAME
VARIANTData Entry Profile CATSVARIANCHAR8Assigned to domainCATSVARIANCVR
OBJ_TYPECATS Favorite: object type HRESS_CATS_FAV_OBJ_TYPECHAR2HRESS_CATS_FAV_OBJ_TYPE
IDCATS Favorite: ID for favorite name HRESS_CATS_FAV_IDDEC21(7) TZNTSTMPL
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
WORKDAYVersion Number Component CHAR2CHAR2CHAR2
ROW_NUMLine Position in CATS Template TEMPLATE_ZEILENUMC3NUMC3
WORKDATEDate CATSDATEDATS8DATUM
NAMECATS Favorite: Description HRESS_CATS_FAV_DESCRIPTIONCHAR30HRESS_CATS_FAV_DESCRIPTION
DEFAULTKZBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
SKOSTLSender Cost Center SKOSTLCHAR10Assigned to domainALPHAKOSTLKSK
LSTARActivity Type LSTARCHAR6CSLALSTARLARLART_EMPTY
SEBELNSending purchase order SEBELNCHAR10Assigned to domainALPHAEBELN
SEBELPSending purchase order item SEBELPNUMC5Assigned to domainEBELP
SPRZNRSender Business Process SPRZNRCHAR12Assigned to domainALPHACO_PRZNR
LSTNRActivity Number ASNUMCHAR18Assigned to domainALPHAASNUMASN
RKOSTLReceiver Cost Center EKOSTLCHAR10Assigned to domainALPHAKOSTLKSK
RPROJReceiver WBS element EPROJNUMC8Assigned to domainKONPRPS_POSNR
RAUFNRReceiver Order EAUFNRCHAR12Assigned to domainALPHAAUFNR
RNPLNRNetwork number NW_AUFNRCHAR12Assigned to domainALPHAAUFNRANR
RAUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
RAPLZLGeneral counter for order CO_APLZLNUMC8Assigned to domainCO_APLZL
RKDAUFReceiver sales order EKDAUCHAR10Assigned to domainALPHAVBELN
RKDPOSItem number in receiver sales order EKDPONUMC6Assigned to domainPOSNR
RKSTRReceiver cost object EKSTRCHAR12Assigned to domainKSTRG
RPRZNRReceiver business process EPRZNRCHAR12Assigned to domainALPHACO_PRZNR
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
FUNDReceiver fund FM_EFONDSCHAR10Assigned to domainBP_GEBERRECEIVER_FUND
FUNC_AREAReceiving Functional Area EFKTBERCHAR16Assigned to domainFKBER
GRANT_NBRReceiver Grant GM_GRANT_RECEIVERCHAR20ALPHAGM_GRANT_NBR
S_FUNDSender fund FM_SFONDSCHAR10Assigned to domainBP_GEBERSENDER_FUND
S_FUNC_AREASending Functional Area SFKTBERCHAR16Assigned to domainFKBER
S_GRANT_NBRSender Grant GM_GRANT_SENDERCHAR20ALPHAGM_GRANT_NBR
BUDGET_PDFM: Receiver Budget Period FM_EBUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
SBUDGET_PDFM: Sender Budget Period FM_SBUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
AWARTAttendance or Absence Type AWARTCHAR4Assigned to domainAWART
LGARTWage Type LGARTCHAR4Assigned to domainLGART
KAPIDCapacity ID KAPIDNUMC8Assigned to domainKAPID
SPLITSplit number CY_SPLITINT13INT1
REINRTrip Number REINRNUMC10REINR
WABLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
VERSLOvertime Compensation Type VRSCHCHAR1T555RVRSCH
WTARTTax area work center HRWRKARCHAR4HRWRKAR
BWGRLValuation basis CATSBWGRLCURR13(2) WERTV7
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
AUFKZExtra Pay Indicator AUFKNCHAR1AUFKN
TRFGRPay Scale Group TRFGRCHAR8Assigned to domainTRFGR
TRFSTPay Scale Level TRFSTCHAR2Assigned to domainTRFST
PRAKNPremium Number PRAKNCHAR2Assigned to domainPRAKN
PRAKZPremium Indicator PRAKZNUMC4PRAKZ
OTYPEObject Type OTYPECHAR2T778OOTYPEPOT
PLANSPosition PLANSNUMC8Assigned to domainPLANS
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
MEINHUnit of Measure for Display MEINHUNIT3T006CUNITMEINS
TCURRTransaction Currency TWAERCUKY5TCURCWAERSFWS
PRICEPrice in Transaction Currency CATSPRICECURR11(2) WERTV6
ARBIDObject ID OBJEKTIDNUMC8NUM08PON
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
AUTYPOrder category AUFTYPNUMC2AUFTYP
HRCOSTASGCost Accounting Variants CATSHRCOCHAR1CATSHRCO
HRKOSTLCost Center CATSHRKOSTLCHAR10Assigned to domainALPHAKOSTLKOS
HRLSTARActivity Type CATSHRLSTARCHAR6Assigned to domainLSTARLARLART
HRFUNDMaster Fund CATSHRFUNDCHAR10Assigned to domainBP_GEBER
HRFUNC_AREAMaster Functional Area CATSHRFUNC_AREACHAR16Assigned to domainFKBER
HRGRANT_NBRMaster Grant CATSHRGRANT_NBRCHAR20ALPHAGM_GRANT_NBR
BEMOTAccounting Indicator BEMOTCHAR2Assigned to domainBEMOT
UNITUnit of Measurement MSEHIUNIT3Assigned to domainCUNITMEINS
STATKEYFIGStatistical key figure STAGRCHAR6Assigned to domainSTAGRSTA
TASKTYPETask Type CATSTASKTYPECHAR4CATSTASKTYPE
TASKLEVELTask Level CATSTASKLEVELCHAR8CATSTASKLEVEL
TASKCOMPONENTTask component CATSTASKCOMPONENTCHAR8CATSTASKCOMPONENT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
CPR_GUIDProject GUID CATS_CPR_GUIDCHAR32SYSUUID_C
CPR_EXTIDExternal Project ID CATS_CPR_EXTIDCHAR24CHAR24
CPR_OBJGUIDObject ID CATS_CPR_OBJGUIDCHAR32SYSUUID_C
CPR_OBJGEXTIDExternal ID of Project Subobject CATS_CPR_OBJGEXTIDCHAR24CHAR24
CPR_OBJTYPEcProjects Object Type CATS_CPR_OBJTYPECHAR3CHAR3
HRBUDGET_PDMaster Budget Period CATSHR_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIOD
ERSDACreated on CATS_ERSDADATS8DATUM
ERSTMTime of Entry CATS_CPUTMTIMS6UZEIT
ERNAMUser Who Created Data Record CATS_ERNAMCHAR12USNAM
LAEDADate of Last Change CATS_LAEDADATS8DATUM
LAETMTime of Last Change CATS_LAETMTIMS6UZEIT
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
APNAMName of person who approved data CATSAPNAMCHAR12UNAME
APDATDate of Approval CATSAPDATDATS8DATUM
WORKITEMIDWork item ID SWW_WIIDNUMC12Assigned to domainSWW_WIIDWID
LOGSYSLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
STATUSProcessing status CATSSTATUSCHAR2CATSSTATUS
REFCOUNTERReference Counter for Record to be Changed CATSREFCOUCHAR12CHAR12
REASONReason for rejection CATSREASONCHAR4Assigned to domainCATSREASON
BELNRDocument Number CATSBELNRCHAR10ALPHABELNR
EXTSYSTEMLogical system of source document HR_AWSYSCHAR10Assigned to domainALPHALOGSYS
EXTAPPLICATIONExternal Application HR_AWTYPCHAR5HR_AWTYP
EXTDOCUMENTNODocument number HR_AWKEYCHAR20AWKEY
TASKCOUNTERCATS: Task Counter CATSTASKCOUNTERCHAR10ALPHABELNR
CATSHOURSHours CATSHOURSQUAN4(2) CATSHOURS
BEGUZStart time CATSBEGUZTIMS6UZEIT
ENDUZEnd time CATSENDUZTIMS6UZEIT
VTKENPrevious Day Indicator VTKENCHAR1XFELD
ALLDFRecord is for Full Day ALLDFCHAR1XFELD
OFMNWRemaining work REMNWQUAN7(1) ARBEIT
PEDDForecast finish date of operation from confirmation CO_PEDDDATS8DATUM
AUERUPartial/Final Confirmation AUERU_VSCHAR1AUERU_VS
LTXA1Short Text CATSSHORTTCHAR40TEXT40
LONGTEXTLong Text CATSLONGTECHAR1XFELD
ERUZUIndicator: Partial confirmation ERUZUCHAR1XFELD
CATSAMOUNTCATS Amount CATSAMOUNTCURR13(2) CATSAMOUNT
CATSQUANTITYTime Sheet: Number (Unit of Measure) CATSNUMBERQUAN15(3) CQUA8
ZCPR_GUID 0
ZCPR_EXTID 0
ZCPR_OBJGUID 0
ZCPR_OBJGEXTID 0
ZCPR_OBJTYPE 0
YYRPM_REL_TYPERelation Type Y23_RPM_REL_TYPECHAR3CHAR3
YYRPM_PROJ_GUIDProject GUID (xRPM) Y23_RPM_PROJ_GUIDCHAR32CHAR32
YYRPM_PROJ_IDProject ID (ext.) Y23_RPM_PROJ_IDCHAR24CHAR24
YYRPM_RES_GUIDResource GUID (xRPM) Y23_RPM_RES_GUIDCHAR32CHAR32
YYRPM_RES_IDResource ID (ext.) Y23_RPM_RES_IDCHAR24CHAR24
YYRPM_ROLE_GUIDRole GUID (xRPM) Y23_RPM_ROLE_GUIDCHAR32CHAR32
YYRPM_ROLE_IDRole ID (ext.) Y23_RPM_ROLE_IDCHAR24CHAR24
YYRPM_TASK_GUIDTask GUID (xRPM) Y23_RPM_TASK_GUIDCHAR32CHAR32
YYRPM_TASK_IDTask ID Y23_RPM_TASK_IDCHAR24CHAR24
VORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
UVORNSuboperation UVORNCHAR4NUMCVVORNR
BEDIDID of the capacity requirements record BEDIDNUMC12Assigned to domainBEDID
KAPARCapacity category KAPARTCHAR3Assigned to domainKAPARTCAA
ARBPLWork center ARBPLCHAR8ARBPLAGR
POSIDWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
LASTUSEDUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) TZNTSTMPLDEC21(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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!