HRESS_D_CATS_FAV - CATS Favorites: database table

CATS Favorites: database table information is stored in SAP table HRESS_D_CATS_FAV.
It is part of development package PAOC_CATS_ESS_WDA in software component PA-ESS-XX-WDA. This development package consists of objects that can be grouped under "CATS Application".

Fields for table HRESS_D_CATS_FAV

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
.INCLUDEXHRESS_S_CATS_FAV_KEY0
MANDTClientXMANDTCLNT6*
UNAMEUser NameXUNAMECHAR24
VARIANTData Entry ProfileXCATSVARIANCHAR16*
OBJ_TYPECATS Favorite: object typeXHRESS_CATS_FAV_OBJ_TYPECHAR4
IDCATS Favorite: ID for favorite nameXHRESS_CATS_FAV_IDDEC11
PERNRPersonnel NumberXPERNR_DNUMC16
WORKDAYComponent of the Version NumberXCHAR2CHAR4
ROW_NUMLine Position in CATS TemplateXTEMPLATE_ZEILENUMC6
WORKDATEDateXCATSDATEDATS16
NAMECATS Favorite: DescriptionHRESS_CATS_FAV_DESCRIPTIONCHAR60
DEFAULTKZBoolean Variable (X = True, - = False, Space = Unknown)BOOLEANCHAR2
.INCLUDECATS_OBJ0
SKOSTLSender Cost CenterSKOSTLCHAR20*
LSTARActivity TypeLSTARCHAR12CSLA
SEBELNSending purchase orderSEBELNCHAR20*
SEBELPSending purchase order itemSEBELPNUMC10*
SPRZNRSender Business ProcessSPRZNRCHAR24*
LSTNRActivity NumberASNUMCHAR36*
RKOSTLReceiver Cost CenterEKOSTLCHAR20*
RPROJReceiver WBS ElementEPROJNUMC16*
RAUFNRReceiver OrderEAUFNRCHAR24*
RNPLNRNetwork numberNW_AUFNRCHAR24*
RAUFPLRouting number of operations in the orderCO_AUFPLNUMC20
RAPLZLGeneral counter for orderCO_APLZLNUMC16*
RKDAUFReceiver sales orderEKDAUCHAR20
RKDPOSItem number in receiver sales orderEKDPONUMC12
RKSTRReceiver cost objectEKSTRCHAR24*
RPRZNRReceiver business processEPRZNRCHAR24*
PAOBJNRProfitability Segment Number (CO-PA)RKEOBJNRNUMC20
FUNDReceiver FundFM_EFONDSCHAR20*
FUNC_AREAReceiving Functional AreaEFKTBERCHAR32*
GRANT_NBRReceiver GrantGM_GRANT_RECEIVERCHAR40*
S_FUNDSender fundFM_SFONDSCHAR20*
S_FUNC_AREASending Functional AreaSFKTBERCHAR32*
S_GRANT_NBRSender GrantGM_GRANT_SENDERCHAR40*
BUDGET_PDFM: Receiver Budget PeriodFM_EBUDGET_PERIODCHAR20*
SBUDGET_PDFM: Sender Budget PeriodFM_SBUDGET_PERIODCHAR20*
SERVICE_DOC_TYPEService Document TypeFCO_SRVDOC_TYPECHAR8
SERVICE_DOC_IDService Document IDFCO_SRVDOC_IDCHAR20
SERVICE_DOC_ITEM_IDService Document Item IDFCO_SRVDOC_ITEM_IDNUMC12
OVERTIMECATOvertime CategoryCATS_OVERTIME_CATEGORYCHAR8*
.INCLUDE/CPD/S_SS_PROJ_INCLUDE0
WORK_ITEM_IDWork Item ID/CPD/PFP_WORKITEM_IDCHAR20
.INCLUDECATS_INCL10
AWARTAttendance or Absence TypeAWARTCHAR8*
LGARTWage TypeLGARTCHAR8*
KAPIDCapacity IDKAPIDNUMC16*
SPLITSplit numberCY_SPLITINT11
REINRTrip NumberREINRNUMC20
WABLNRNumber of Material DocumentMBLNRCHAR20
VERSLOvertime Compensation TypeVRSCHCHAR2T555R
WTARTTax area work centerHRWRKARCHAR8
BWGRLValuation basisCATSBWGRLCURR7
WAERSCurrency KeyWAERSCUKY10TCURC
AUFKZExtra Pay IndicatorAUFKNCHAR2
TRFGRPay Scale GroupTRFGRCHAR16*
TRFSTPay Scale LevelTRFSTCHAR4*
PRAKNPremium NumberPRAKNCHAR4*
PRAKZPremium IndicatorPRAKZNUMC8
OTYPEObject TypeOTYPECHAR4T778O
PLANSPositionPLANSNUMC16*
KOKRSControlling AreaKOKRSCHAR8TKA01
MEINHUnit of Measure for DisplayMEINHUNIT6T006
TCURRTransaction CurrencyTWAERCUKY10TCURC
PRICEPrice in Transaction CurrencyCATSPRICECURR6
ARBIDObject IDOBJEKTIDNUMC16
WERKSPlantWERKS_DCHAR8T001W
AUTYPOrder categoryAUFTYPNUMC4
HRCOSTASGCost Accounting VariantsCATSHRCOCHAR2
HRKOSTLCost CenterCATSHRKOSTLCHAR20*
HRLSTARActivity TypeCATSHRLSTARCHAR12
HRFUNDMaster FundCATSHRFUNDCHAR20*
HRFUNC_AREAMaster Functional AreaCATSHRFUNC_AREACHAR32*
HRGRANT_NBRMaster GrantCATSHRGRANT_NBRCHAR40*
BEMOTAccounting IndicatorBEMOTCHAR4*
UNITUnit of MeasurementMSEHIUNIT6*
STATKEYFIGStatistical key figureSTAGRCHAR12*
TASKTYPETask TypeCATSTASKTYPECHAR8
TASKLEVELTask LevelCATSTASKLEVELCHAR16
TASKCOMPONENTTask componentCATSTASKCOMPONENTCHAR16
BUKRSCompany CodeBUKRSCHAR8
CPR_GUIDProject GUIDCATS_CPR_GUIDCHAR64
CPR_EXTIDExternal Project IDCATS_CPR_EXTIDCHAR48
CPR_OBJGUIDObject IDCATS_CPR_OBJGUIDCHAR64
CPR_OBJGEXTIDExternal ID of Project SubobjectCATS_CPR_OBJGEXTIDCHAR48
CPR_OBJTYPEcProjects Object TypeCATS_CPR_OBJTYPECHAR6
HRBUDGET_PDMaster Budget PeriodCATSHR_BUDGET_PERIODCHAR20*
.INCLUDECATS_INCL20
ERSDACreated OnCATS_ERSDADATS16
ERSTMTime of EntryCATS_CPUTMTIMS12
ERNAMUser Creating RecordCATS_ERNAMCHAR24
LAEDADate of Last ChangeCATS_LAEDADATS16
LAETMLast Changed AtCATS_LAETMTIMS12
AENAMName of Person Who Changed ObjectAENAMCHAR24
APNAMName of person who approved dataCATSAPNAMCHAR24
APDATDate of ApprovalCATSAPDATDATS16
WORKITEMIDWork item IDSWW_WIIDNUMC24*
LOGSYSLogical systemLOGSYSCHAR20*
STATUSProcessing statusCATSSTATUSCHAR4
REFCOUNTERReference Counter for Record to be ChangedCATSREFCOUCHAR24
REASONReason for rejectionCATSREASONCHAR8*
BELNRDocument no.CATSBELNRCHAR20
EXTSYSTEMLogical system of source documentHR_AWSYSCHAR20*
EXTAPPLICATIONExternal ApplicationHR_AWTYPCHAR10
EXTDOCUMENTNODocument numberHR_AWKEYCHAR40
TASKCOUNTERCATS: Task CounterCATSTASKCOUNTERCHAR20
.INCLUDECATS_CELL0
CATSHOURSHoursCATSHOURSQUAN3
BEGUZStart timeCATSBEGUZTIMS12
ENDUZEnd timeCATSENDUZTIMS12
VTKENPrevious Day IndicatorVTKENCHAR2
ALLDFRecord is for Full DayALLDFCHAR2
OFMNWRemaining workREMNWQUAN4
PEDDForecast finish date of operation from confirmationCO_PEDDDATS16
AUERUPartial/Final ConfirmationAUERU_VSCHAR2
LTXA1Short TextCATSSHORTTCHAR80
LONGTEXTLong TextCATSLONGTECHAR2
ERUZUIndicator: Partial confirmationERUZUCHAR2
CATSAMOUNTCATS AmountCATSAMOUNTCURR7
CATSQUANTITYTime Sheet: Number (Unit of Measure)CATSNUMBERQUAN8
.INCLUDECI_CATSDB0
.INCLU--AP/PPA/T_CI_CATSDB_APPEND0
.INCLUDE/PPA/T_CI_CATSDB0
/PPA/OBJKTObject type: order/project/cost ctr/network/attendance/PPA/T_OBJKTCHAR4
/PPA/SICHTEntry view time/expenses/costs/material/billing suggestion/PPA/T_SICHTCHAR2
/PPA/DAUERCalculated duration in hours/PPA/T_DAUERQUAN3
/PPA/MENGEQuantity/PPA/T_MENGEDEC7
/PPA/LSTNRService numberLSTNRCHAR80MARA
/PPA/TAXKMTax classification materialTAXKMCHAR2*
/PPA/MWSKZTax on sales/purchases codeMWSKZCHAR4*
/PPA/KKARTCredit Card/PPA/T_KKARTCHAR12/PPA/T_CIT
/PPA/RUECKCompletion confirmation number for the operationCO_RUECKNUMC20
/PPA/ACTVYActivity/PPA/T_ACTIVITYCHAR60/PPA/T_CT
/PPA/PLOSPLocation of activity output/PPA/T_PLOSPCHAR30
/PPA/TICNRTicket No./PPA/T_TICNRCHAR40
/PPA/FLIDBilling layout control identification number/PPA/T_FLIDCHAR20
/PPA/ANSNRReservation (subtype by concurrent employment)/PPA/THRANSNRCHAR8
/PPA/CLIENTBAPI interface client (SAPGUI, WebDynpro, mobile, external�)/PPA/T_BAPI_INTFCLIENTCHAR6
/PPA/VARIANTData Entry ProfileCATSVARIANCHAR16TCATS
/PPA/AL_ASSIGNEDProTime: Archive- Item is attached to a CATS document/PPA/T_AL_ASSIGNEDCHAR2
/PPA/REF_ATAB_PTReference between Att/Abs and Perf.Time/PPA/T_REF_ATTABS_PTIMECHAR24
/PPA/AUTO_ADDEDAutomaticly inserted document/PPA/T_AUTO_ADDEDCHAR2
/PPA/CC_GROUP_IDCredit Card Group ID/PPA/T_CC_GROUP_IDCHAR16/PPA/T_CC_STATUS
/PPA/CC_TRANS_REFCredit Card Transaction Reference/PPA/T_CC_TRANS_REFCHAR48
/PPA/CC_TRANS_DATCredit Card Transaction Date/PPA/T_CC_TRANS_DATDATS16
/PPA/OBJECT_TYPEProTime Core: Object type unique/PPA/T_OBJECT_TYPECHAR4
/PPA/OBJECT_KEYProTime Core: Object key unique/PPA/T_OBJECT_KEYCHAR84
.INCLUDE/PPA/T_STATOBJ0
/PPA/RKOSTLReceiver Cost CenterEKOSTLCHAR20*
/PPA/RPROJReceiver WBS ElementEPROJNUMC16*
/PPA/RAUFNRReceiver OrderEAUFNRCHAR24*
/PPA/RNPLNRNetwork numberNW_AUFNRCHAR24*
/PPA/RAUFPLRouting number of operations in the orderCO_AUFPLNUMC20
/PPA/RAPLZLGeneral counter for orderCO_APLZLNUMC16*
/PPA/RKDAUFReceiver sales orderEKDAUCHAR20
/PPA/RKDPOSItem number in receiver sales orderEKDPONUMC12
.INCLUDE/PPA/T_CI_CATSDB_EXT0
/PPA/DUMMYDummy function in length 1DUMMYCHAR2
.INCLUDECATS_EXTEN0
VORNROperation/Activity NumberVORNRCHAR8
UVORNSuboperationUVORNCHAR8
BEDIDID of the Capacity Requirements RecordBEDIDNUMC24*
KAPARCapacity categoryKAPARTCHAR6*
ARBPLWork CenterARBPLCHAR16
POSIDWork Breakdown Structure Element (WBS Element)PS_POSIDCHAR48
LASTUSEDUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)TZNTSTMPLDEC11
Privacy Policy