CATSDB

Transparent Table Application Table
113 Fields 5 CDS Views

CATS: Database Table for Time Sheet

CATSDB is an SAP database table in S/4HANA. CATS: Database Table for Time Sheet. It contains 113 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_TimeSheetRecord view from EXTENSION Extension include view for I_TimeSheetRecord
I_HCMTimeSheetRecord view from BASIC HCM Timesheet Records for Employee
I_TimeSheetRecord view from BASIC Time Recording Data
I_TimeSheetRecordLongText view from BASIC Note of a Timesheet Record - Text
P_TimesheetSDM view_entity from BASIC

Fields (113)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY counter CATSCOUNTE Counter
pernr PERNR_D Personnel No.
workdate CATSDATE Date
skostl SKOSTL Send. CCtr
lstar LSTAR Activity Type
sebeln SEBELN Sending order
sebelp SEBELP Send. PO item
sprznr SPRZNR Send.Bus.Proc.
lstnr ASNUM Activity number
rkostl EKOSTL Rec. CCtr
rproj EPROJ Rec. WBS Elem.
raufnr EAUFNR Rec. order
rnplnr NW_AUFNR Network
raufpl CO_AUFPL Plan No.f.Oper.
raplzl CO_APLZL Counter
rkdauf EKDAU Rec. sales ord.
rkdpos EKDPO RecSalOrd. item
rkstr EKSTR Cost object
rprznr EPRZNR Rec.bus.process
paobjnr RKEOBJNR Profit. segment
fund FM_EFONDS Receiver Fund
func_area EFKTBER Receiving Func. Area
grant_nbr GM_GRANT_RECEIVER Receiver Grant
s_fund FM_SFONDS Sender Fund
s_func_area SFKTBER Sender Fnc.Area
s_grant_nbr GM_GRANT_SENDER Sender Grant
budget_pd FM_EBUDGET_PERIOD Rec BudPer
sbudget_pd FM_SBUDGET_PERIOD Sender BudPer
service_doc_type FCO_SRVDOC_TYPE Service Doc. Type
service_doc_id FCO_SRVDOC_ID Service Document
service_doc_item_id FCO_SRVDOC_ITEM_ID Service Doc. Item
overtimecat CATS_OVERTIME_CATEGORY Overtime Category
work_item_id /CPD/PFP_WORKITEM_ID Work Item ID
awart AWART Att./abs. type
lgart LGART Wage Type
kapid KAPID Capacity ID
split CY_SPLIT Split number
reinr REINR Trip Number
wablnr MBLNR Material Doc.
versl VRSCH OT comp. type
wtart HRWRKAR Tax area
bwgrl CATSBWGRL Valuation basis
waers WAERS Currency
aufkz AUFKN Extra pay ID
trfgr TRFGR Pay Scale Group
trfst TRFST PS level
prakn PRAKN Premium no.
prakz PRAKZ Premium ID
otype OTYPE Object type
plans PLANS Position
kokrs KOKRS CO Area
meinh MEINH Unit of Measure
tcurr TWAER Trans. Currency
price CATSPRICE Price
arbid OBJEKTID Object ID
werks WERKS_D Plant
autyp AUFTYP Order category
hrcostasg CATSHRCO Cost acc. var.
hrkostl CATSHRKOSTL Cost center
hrlstar CATSHRLSTAR Activity type
hrfund CATSHRFUND Master Fund
hrfunc_area CATSHRFUNC_AREA MasterFunc.Area
hrgrant_nbr CATSHRGRANT_NBR Master Grant
bemot BEMOT AcctIndicator
unit MSEHI Internal UoM
statkeyfig STAGR Stat. key fig.
tasktype CATSTASKTYPE Task Type
tasklevel CATSTASKLEVEL Task level
taskcomponent CATSTASKCOMPONENT Task component
bukrs BUKRS Company Code
cpr_guid CATS_CPR_GUID Project
cpr_extid CATS_CPR_EXTID Project
cpr_objguid CATS_CPR_OBJGUID Subobject
cpr_objgextid CATS_CPR_OBJGEXTID Subobject
cpr_objtype CATS_CPR_OBJTYPE Object Type
hrbudget_pd CATSHR_BUDGET_PERIOD MasterBP
ersda CATS_ERSDA Created on
erstm CATS_CPUTM Time
ernam CATS_ERNAM Created by
laeda CATS_LAEDA Last Change
laetm CATS_LAETM Time
aenam AENAM Changed By
apnam CATSAPNAM Approved by
apdat CATSAPDAT Approval date
workitemid SWW_WIID Work Item ID
logsys LOGSYS Logical system
status CATSSTATUS Process status
refcounter CATSREFCOU Ref. counter
reason CATSREASON Rejection reas.
belnr CATSBELNR Document no.
extsystem HR_AWSYS Logical system
extapplication HR_AWTYP External appl.
extdocumentno HR_AWKEY Document no.
taskcounter CATSTASKCOUNTER Task number
catshours CATSHOURS Hours
beguz CATSBEGUZ Start time
enduz CATSENDUZ End time
vtken VTKEN Previous day
alldf ALLDF Full-day
ofmnw REMNW Remaining work
pedd CO_PEDD Forecast finish
aueru AUERU_VS Final Confirmtn
ltxa1 CATSSHORTT Short Text
longtext CATSLONGTE Long text
eruzu ERUZU Part. con.
catsamount CATSAMOUNT Amount
catsquantity CATSNUMBER Number (unit)
dummy_incl_eew_prs_cpils DUMMY Dummy function in length 1
sfsf_time_type_uuid SFSF_TIME_TYPE_UUID SFSF Time Type UUID
sfsf_time_type_ecode SFSF_TIME_TYPE_ECODE SFSF Time Type ECode
sfsf_allowance_type_uuid SFSF_ALLOWANCE_TYPE_UUID Allowance Type UUID
sfsf_allowance_type_ecode SFSF_ALLOWANCE_TYPE_ECODE Allowance Type ECode

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- CATS: Database Table for Time Sheet
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CATSDB (
    MANDT,                      -- Client [MANDT]
    COUNTER,                    -- Counter [CATSCOUNTE]
    PERNR,                      -- Personnel No. [PERNR_D]
    WORKDATE,                   -- Date [CATSDATE]
    SKOSTL,                     -- Send. CCtr [SKOSTL]
    LSTAR,                      -- Activity Type [LSTAR]
    SEBELN,                     -- Sending order [SEBELN]
    SEBELP,                     -- Send. PO item [SEBELP]
    SPRZNR,                     -- Send.Bus.Proc. [SPRZNR]
    LSTNR,                      -- Activity number [ASNUM]
    RKOSTL,                     -- Rec. CCtr [EKOSTL]
    RPROJ,                      -- Rec. WBS Elem. [EPROJ]
    RAUFNR,                     -- Rec. order [EAUFNR]
    RNPLNR,                     -- Network [NW_AUFNR]
    RAUFPL,                     -- Plan No.f.Oper. [CO_AUFPL]
    RAPLZL,                     -- Counter [CO_APLZL]
    RKDAUF,                     -- Rec. sales ord. [EKDAU]
    RKDPOS,                     -- RecSalOrd. item [EKDPO]
    RKSTR,                      -- Cost object [EKSTR]
    RPRZNR,                     -- Rec.bus.process [EPRZNR]
    PAOBJNR,                    -- Profit. segment [RKEOBJNR]
    FUND,                       -- Receiver Fund [FM_EFONDS]
    FUNC_AREA,                  -- Receiving Func. Area [EFKTBER]
    GRANT_NBR,                  -- Receiver Grant [GM_GRANT_RECEIVER]
    S_FUND,                     -- Sender Fund [FM_SFONDS]
    S_FUNC_AREA,                -- Sender Fnc.Area [SFKTBER]
    S_GRANT_NBR,                -- Sender Grant [GM_GRANT_SENDER]
    BUDGET_PD,                  -- Rec BudPer [FM_EBUDGET_PERIOD]
    SBUDGET_PD,                 -- Sender BudPer [FM_SBUDGET_PERIOD]
    SERVICE_DOC_TYPE,           -- Service Doc. Type [FCO_SRVDOC_TYPE]
    SERVICE_DOC_ID,             -- Service Document [FCO_SRVDOC_ID]
    SERVICE_DOC_ITEM_ID,        -- Service Doc. Item [FCO_SRVDOC_ITEM_ID]
    OVERTIMECAT,                -- Overtime Category [CATS_OVERTIME_CATEGORY]
    WORK_ITEM_ID,               -- Work Item ID [/CPD/PFP_WORKITEM_ID]
    AWART,                      -- Att./abs. type [AWART]
    LGART,                      -- Wage Type [LGART]
    KAPID,                      -- Capacity ID [KAPID]
    SPLIT,                      -- Split number [CY_SPLIT]
    REINR,                      -- Trip Number [REINR]
    WABLNR,                     -- Material Doc. [MBLNR]
    VERSL,                      -- OT comp. type [VRSCH]
    WTART,                      -- Tax area [HRWRKAR]
    BWGRL,                      -- Valuation basis [CATSBWGRL]
    WAERS,                      -- Currency [WAERS]
    AUFKZ,                      -- Extra pay ID [AUFKN]
    TRFGR,                      -- Pay Scale Group [TRFGR]
    TRFST,                      -- PS level [TRFST]
    PRAKN,                      -- Premium no. [PRAKN]
    PRAKZ,                      -- Premium ID [PRAKZ]
    OTYPE,                      -- Object type [OTYPE]
    PLANS,                      -- Position [PLANS]
    KOKRS,                      -- CO Area [KOKRS]
    MEINH,                      -- Unit of Measure [MEINH]
    TCURR,                      -- Trans. Currency [TWAER]
    PRICE,                      -- Price [CATSPRICE]
    ARBID,                      -- Object ID [OBJEKTID]
    WERKS,                      -- Plant [WERKS_D]
    AUTYP,                      -- Order category [AUFTYP]
    HRCOSTASG,                  -- Cost acc. var. [CATSHRCO]
    HRKOSTL,                    -- Cost center [CATSHRKOSTL]
    HRLSTAR,                    -- Activity type [CATSHRLSTAR]
    HRFUND,                     -- Master Fund [CATSHRFUND]
    HRFUNC_AREA,                -- MasterFunc.Area [CATSHRFUNC_AREA]
    HRGRANT_NBR,                -- Master Grant [CATSHRGRANT_NBR]
    BEMOT,                      -- AcctIndicator [BEMOT]
    UNIT,                       -- Internal UoM [MSEHI]
    STATKEYFIG,                 -- Stat. key fig. [STAGR]
    TASKTYPE,                   -- Task Type [CATSTASKTYPE]
    TASKLEVEL,                  -- Task level [CATSTASKLEVEL]
    TASKCOMPONENT,              -- Task component [CATSTASKCOMPONENT]
    BUKRS,                      -- Company Code [BUKRS]
    CPR_GUID,                   -- Project [CATS_CPR_GUID]
    CPR_EXTID,                  -- Project [CATS_CPR_EXTID]
    CPR_OBJGUID,                -- Subobject [CATS_CPR_OBJGUID]
    CPR_OBJGEXTID,              -- Subobject [CATS_CPR_OBJGEXTID]
    CPR_OBJTYPE,                -- Object Type [CATS_CPR_OBJTYPE]
    HRBUDGET_PD,                -- MasterBP [CATSHR_BUDGET_PERIOD]
    ERSDA,                      -- Created on [CATS_ERSDA]
    ERSTM,                      -- Time [CATS_CPUTM]
    ERNAM,                      -- Created by [CATS_ERNAM]
    LAEDA,                      -- Last Change [CATS_LAEDA]
    LAETM,                      -- Time [CATS_LAETM]
    AENAM,                      -- Changed By [AENAM]
    APNAM,                      -- Approved by [CATSAPNAM]
    APDAT,                      -- Approval date [CATSAPDAT]
    WORKITEMID,                 -- Work Item ID [SWW_WIID]
    LOGSYS,                     -- Logical system [LOGSYS]
    STATUS,                     -- Process status [CATSSTATUS]
    REFCOUNTER,                 -- Ref. counter [CATSREFCOU]
    REASON,                     -- Rejection reas. [CATSREASON]
    BELNR,                      -- Document no. [CATSBELNR]
    EXTSYSTEM,                  -- Logical system [HR_AWSYS]
    EXTAPPLICATION,             -- External appl. [HR_AWTYP]
    EXTDOCUMENTNO,              -- Document no. [HR_AWKEY]
    TASKCOUNTER,                -- Task number [CATSTASKCOUNTER]
    CATSHOURS,                  -- Hours [CATSHOURS]
    BEGUZ,                      -- Start time [CATSBEGUZ]
    ENDUZ,                      -- End time [CATSENDUZ]
    VTKEN,                      -- Previous day [VTKEN]
    ALLDF,                      -- Full-day [ALLDF]
    OFMNW,                      -- Remaining work [REMNW]
    PEDD,                       -- Forecast finish [CO_PEDD]
    AUERU,                      -- Final Confirmtn [AUERU_VS]
    LTXA1,                      -- Short Text [CATSSHORTT]
    LONGTEXT,                   -- Long text [CATSLONGTE]
    ERUZU,                      -- Part. con. [ERUZU]
    CATSAMOUNT,                 -- Amount [CATSAMOUNT]
    CATSQUANTITY,               -- Number (unit) [CATSNUMBER]
    DUMMY_INCL_EEW_PRS_CPILS,   -- Dummy function in length 1 [DUMMY]
    SFSF_TIME_TYPE_UUID,        -- SFSF Time Type UUID [SFSF_TIME_TYPE_UUID]
    SFSF_TIME_TYPE_ECODE,       -- SFSF Time Type ECode [SFSF_TIME_TYPE_ECODE]
    SFSF_ALLOWANCE_TYPE_UUID,   -- Allowance Type UUID [SFSF_ALLOWANCE_TYPE_UUID]
    SFSF_ALLOWANCE_TYPE_ECODE,  -- Allowance Type ECode [SFSF_ALLOWANCE_TYPE_ECODE]
    PRIMARY KEY (MANDT, COUNTER)
);

Learn More