SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

CATSDB Table in SAP | CATS: Database Table for Time Sheet Table & Fields List

CATSDB is a SAP table coming under CA module and SAP_APPL component.View details, Fields & related tables of CATSDB in SAP.

  • Table description : CATS: Database Table for Time Sheet
  • Module : CA-TS
  • Parent Module : CA
  • Package : CATS
  • Software Component : SAP_APPL
CATSDB table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP CATSDB Table Fields structure

FieldNoteData ElementDomain
.INCLUDECATS: Key fields    
MANDTClientMANDTMANDT
COUNTERCounter for Records in Time RecordingCATSCOUNTECHAR12
.INCLUDECATS: Secondary key    
PERNRPersonnel NumberPERNR_DPERNR
WORKDATEDateCATSDATEDATUM
.INCLUDECATS: Decoded Account Assignments    
SKOSTLSender Cost CenterSKOSTLKOSTL
LSTARActivity TypeLSTARLSTAR
SEBELNSending purchase orderSEBELNEBELN
SEBELPSending purchase order itemSEBELPEBELP
SPRZNRSender Business ProcessSPRZNRCO_PRZNR
LSTNRActivity NumberASNUMASNUM
RKOSTLReceiver Cost CenterEKOSTLKOSTL
RPROJReceiver WBS elementEPROJPS_POSNR
RAUFNRReceiver OrderEAUFNRAUFNR
RNPLNRNetwork numberNW_AUFNRAUFNR
RAUFPLRouting number of operations in the orderCO_AUFPLAUFPL
RAPLZLGeneral counter for orderCO_APLZLCO_APLZL
RKDAUFReceiver sales orderEKDAUVBELN
RKDPOSItem number in receiver sales orderEKDPOPOSNR
RKSTRReceiver cost objectEKSTRKSTRG
RPRZNRReceiver business processEPRZNRCO_PRZNR
PAOBJNRProfitability Segment Number (CO-PA)RKEOBJNRRKEOBJNR
FUNDReceiver fundFM_EFONDSBP_GEBER
FUNC_AREAReceiving Functional AreaEFKTBERFKBER
GRANT_NBRReceiver GrantGM_GRANT_RECEIVERGM_GRANT_NBR
S_FUNDSender fundFM_SFONDSBP_GEBER
S_FUNC_AREASending Functional AreaSFKTBERFKBER
S_GRANT_NBRSender GrantGM_GRANT_SENDERGM_GRANT_NBR
BUDGET_PDFM: Receiver Budget PeriodFM_EBUDGET_PERIODFM_BUDGET_PERIOD
SBUDGET_PDFM: Sender Budget PeriodFM_SBUDGET_PERIODFM_BUDGET_PERIOD
.INCLUDECATS: Include Structure for "Genuine" Account Assignments    
AWARTAttendance or Absence TypeAWARTAWART
LGARTWage TypeLGARTLGART
KAPIDCapacity IDKAPIDKAPID
SPLITSplit numberCY_SPLITINT1
REINRTrip NumberREINRREINR
WABLNRNumber of Material DocumentMBLNRBELNR
VERSLOvertime Compensation TypeVRSCHVRSCH
WTARTTax area work centerHRWRKARHRWRKAR
BWGRLValuation basisCATSBWGRLWERTV7
WAERSCurrency KeyWAERSWAERS
AUFKZExtra Pay IndicatorAUFKNAUFKN
TRFGRPay Scale GroupTRFGRTRFGR
TRFSTPay Scale LevelTRFSTTRFST
PRAKNPremium NumberPRAKNPRAKN
PRAKZPremium IndicatorPRAKZPRAKZ
OTYPEObject TypeOTYPEOTYPE
PLANSPositionPLANSPLANS
KOKRSControlling AreaKOKRSCACCD
MEINHUnit of Measure for DisplayMEINHMEINS
TCURRTransaction CurrencyTWAERWAERS
PRICEPrice in Transaction CurrencyCATSPRICEWERTV6
ARBIDObject IDOBJEKTIDNUM08
WERKSPlantWERKS_DWERKS
AUTYPOrder categoryAUFTYPAUFTYP
HRCOSTASGCost Accounting VariantsCATSHRCOCATSHRCO
HRKOSTLCost CenterCATSHRKOSTLKOSTL
HRLSTARActivity TypeCATSHRLSTARLSTAR
HRFUNDMaster FundCATSHRFUNDBP_GEBER
HRFUNC_AREAMaster Functional AreaCATSHRFUNC_AREAFKBER
HRGRANT_NBRMaster GrantCATSHRGRANT_NBRGM_GRANT_NBR
BEMOTAccounting IndicatorBEMOTBEMOT
UNITUnit of MeasurementMSEHIMEINS
STATKEYFIGStatistical key figureSTAGRSTAGR
TASKTYPETask TypeCATSTASKTYPECATSTASKTYPE
TASKLEVELTask LevelCATSTASKLEVELCATSTASKLEVEL
TASKCOMPONENTTask componentCATSTASKCOMPONENTCATSTASKCOMPONENT
BUKRSCompany CodeBUKRSBUKRS
CPR_GUIDProject GUIDCATS_CPR_GUIDSYSUUID_C
CPR_EXTIDExternal Project IDCATS_CPR_EXTIDCHAR24
CPR_OBJGUIDObject IDCATS_CPR_OBJGUIDSYSUUID_C
CPR_OBJGEXTIDExternal ID of Project SubobjectCATS_CPR_OBJGEXTIDCHAR24
CPR_OBJTYPEcProjects Object TypeCATS_CPR_OBJTYPECHAR3
HRBUDGET_PDMaster Budget PeriodCATSHR_BUDGET_PERIODFM_BUDGET_PERIOD
.INCLUDECATS: Include structure for statistical information    
ERSDACreated onCATS_ERSDADATUM
ERSTMTime of EntryCATS_CPUTMUZEIT
ERNAMUser Who Created RecordCATS_ERNAMUSNAM
LAEDADate of Last ChangeCATS_LAEDADATUM
LAETMTime of Last ChangeCATS_LAETMUZEIT
AENAMName of Person Who Changed ObjectAENAMUSNAM
APNAMName of person who approved dataCATSAPNAMUNAME
APDATDate of ApprovalCATSAPDATDATUM
WORKITEMIDWork item IDSWW_WIIDSWW_WIID
LOGSYSLogical systemLOGSYSLOGSYS
STATUSProcessing statusCATSSTATUSCATSSTATUS
REFCOUNTERReference Counter for Record to be ChangedCATSREFCOUCHAR12
REASONReason for RejectionCATSREASONCATSREASON
BELNRDocument numberCATSBELNRBELNR
EXTSYSTEMLogical system of source documentHR_AWSYSLOGSYS
EXTAPPLICATIONExternal ApplicationHR_AWTYPHR_AWTYP
EXTDOCUMENTNODocument numberHR_AWKEYAWKEY
TASKCOUNTERCATS: Task CounterCATSTASKCOUNTERBELNR
.INCLUDECATS: Include with Cell Information    
CATSHOURSHoursCATSHOURSCATSHOURS
BEGUZStart timeCATSBEGUZUZEIT
ENDUZEnd timeCATSENDUZUZEIT
VTKENPrevious Day IndicatorVTKENXFELD
ALLDFRecord is for Full DayALLDFXFELD
OFMNWRemaining workREMNWARBEIT
PEDDForecast finish date of operation from confirmationCO_PEDDDATUM
AUERUPartial/Final ConfirmationAUERU_VSAUERU_VS
LTXA1Short TextCATSSHORTTTEXT40
LONGTEXTLong TextCATSLONGTEXFELD
ERUZUIndicator: Partial confirmationERUZUXFELD
CATSAMOUNTCATS AmountCATSAMOUNTCATSAMOUNT
CATSQUANTITYTime Sheet: Number (Unit of Measure)CATSNUMBERCQUA8
.INCLUDE   
.INCLUDE   

CATSDB related tables

TableNote
CATSDBCATS: Database Table for Time Sheet
CATSCOCross-Application Time Sheet (CATS): Transfer to CO
CATSHRCross-Application Time Sheet (CATS): Transfer to HR
CATSMMCross-Application Time Sheet (CATS): Transfer to MM
CATSPMCross-Application Time Sheet (CATS): Transfer to PM/CS
CATSPSCross-Application Time Sheet (CATS): Transfer to PS
CABAREFCATS: Transfer from CATS II to PS, PM, and CO
/SAPSLL/TLEPGSMapping of FS Grouping Item Cats to Customs Doc. Item Cats
/SAPSLL/TLEPVSMapping of Feeder System Item Cats to Customs Doc. Item Cats
CATS_TEMPCATS: Database Table for Templates
CATS_BW_TIMETransfer Time Sheet into BW - Time Stamp
TABWMAsgnmt. hist. sheet (sub)groups to asset history sheet item
CATSDELTable with Deletion Time of Deleted CATS Records
MYABKBal. Sheet Valuation: Table of Database Commits Carried Out
MYCOMBal. Sheet Valuation: Table of Database Commits Carried Out
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com