TCATS

Transparent Table Customizing Table
83 Fields 1 CDS Views

CATS: Data Entry Profiles

TCATS is an SAP database table in S/4HANA. CATS: Data Entry Profiles. It contains 83 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_HCMTimeShtDtaEntrPrfl view_entity from BASIC HCM Timesheet Data Entry Profile

Fields (83)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY variant CATSVARIAN Entry Profile
changable CATSPROFCH Prof.changeable
pernrlist CATSPERLIS Pers. no. list
multper CATSMULTPE Sev. pers. nos.
timeclerk CATSTIMECL Time admin.
orgobj CATSORGOBJ Org. unit
selkostl CATSSELCOS Cost center
selworkpl CATSSELWRK Work center
selcustom CATSSELCUS Cust.enhancemt
pertype CATSPERTYP Period type
catsperiod CATSPERIOD Periods
firstdayof CATSFIRSTD 1st day of week
perleft CATSPERLEF Lower limit
perright CATSPERRIG Upper limit
reldate CATSRELDAT Key date rel.
rejebright CATSBRIGHT Highlight RRs
addinfobri CATSADDINF Highlight info
daytext CATSDAYTEX Weekdays
brgru CATSPROFAG Authorization
begend CATSBEGEN_ With times
targetrow CATSTARGET Target hours
timetype CATSTIMETY Tm.type tgt hrs
subhrtimes CATSSUBHR Sub. HR hours
undertarge CATSUNDERT Downward tol.
underreact CATSUNDERR Reaction below
overtarget CATSOVERTA Upward tol.
overreact CATSOVERRE Reaction above
sumrow CATSSUMROW Totals line
calendar CATSCALE Workdays only
future CATSFUTURE Release future
worklist CATSWRKLST With worklist
assigned CATSASSIGN Resource plng
workcentre CATSWORKCT By work center
working CATSWORKNG In Process
worksince CATSSINCEP In proc. since
frompool CATSPOOL From confs pool
fromexit CATSEXITWL Cust.enhancemt
workwith WORKWITH Without hours
wf_appr CATSWFAPPR WF approval
freeatsave CATSFREEAT Rel. on saving
approval CATSAPPROV Approval reqd
defkokrsco CATSKOKRSC CO area
defcostco CATSCOSTCO Master cost ctr
defcostcc CATSCOSTCC Cost center
defactty CATSACTTY Activity type
defpuror CATSPUROR Purchase order
deflstst CATSLSTLS Service master
defatype CATSATYPE Att./abs. type
defawart AWART Att./abs. type
defwtype CATSWTYPE Wage type
deflgart LGART Wage Type
task SWW_TASK Task
kontireact CATSQUOTAR Quotas
kollireact CATSCOLLIR Collision
kolhrreact CATSCOLHRR Collision HR
maxhrreact CATSMAXHRR More than 24 H
directhr DIRECTHR Transfer to HR
catsprint CATSPRINT Print program
selreport CATSSELRP Pers. selection
hrcostasg CATSHRCO Cost acc. var.
selrep CATSSELREP Sel. report
calendar_w CATSCALE_W Workdays only
nobreakded CATSNOBRKS No Break Dedn
addovertime CATSADDOVER Add overtime
wf_auto CATSWFAUTO Auto. recipient
nochange CATSNOCHNG Read Only
skipiscr CATSSKIPISCR No init. screen
defsprznr CATSSPRZNR Send.bus.proc.
catscell_size CATSCELL_SIZE Cell lgth
t_schema RSCHE Trip Schema
template CATSTEMPLATE Templates
perlock CATSPERLOCK Period lock
exc_group CATS_EXC_GROUP Group
special_approval CATSAPPROV Approval reqd
workcpro CATSCPRO Projects
assigndb CATSASGNDB Assignment DB
checkasdb CATSCHKADB Assignments
hrenabled CATSHRE CATS with HR
datadisplay CATSDDISP Display option
cutoffdt CATSPPE Cutoff date
offsetpd CATSODD Days
publicholty CATSHABSTY Public Hol

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: Data Entry Profiles
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCATS (
    MANDT,             -- Client [MANDT]
    VARIANT,           -- Entry Profile [CATSVARIAN]
    CHANGABLE,         -- Prof.changeable [CATSPROFCH]
    PERNRLIST,         -- Pers. no. list [CATSPERLIS]
    MULTPER,           -- Sev. pers. nos. [CATSMULTPE]
    TIMECLERK,         -- Time admin. [CATSTIMECL]
    ORGOBJ,            -- Org. unit [CATSORGOBJ]
    SELKOSTL,          -- Cost center [CATSSELCOS]
    SELWORKPL,         -- Work center [CATSSELWRK]
    SELCUSTOM,         -- Cust.enhancemt [CATSSELCUS]
    PERTYPE,           -- Period type [CATSPERTYP]
    CATSPERIOD,        -- Periods [CATSPERIOD]
    FIRSTDAYOF,        -- 1st day of week [CATSFIRSTD]
    PERLEFT,           -- Lower limit [CATSPERLEF]
    PERRIGHT,          -- Upper limit [CATSPERRIG]
    RELDATE,           -- Key date rel. [CATSRELDAT]
    REJEBRIGHT,        -- Highlight RRs [CATSBRIGHT]
    ADDINFOBRI,        -- Highlight info [CATSADDINF]
    DAYTEXT,           -- Weekdays [CATSDAYTEX]
    BRGRU,             -- Authorization [CATSPROFAG]
    BEGEND,            -- With times [CATSBEGEN_]
    TARGETROW,         -- Target hours [CATSTARGET]
    TIMETYPE,          -- Tm.type tgt hrs [CATSTIMETY]
    SUBHRTIMES,        -- Sub. HR hours [CATSSUBHR]
    UNDERTARGE,        -- Downward tol. [CATSUNDERT]
    UNDERREACT,        -- Reaction below [CATSUNDERR]
    OVERTARGET,        -- Upward tol. [CATSOVERTA]
    OVERREACT,         -- Reaction above [CATSOVERRE]
    SUMROW,            -- Totals line [CATSSUMROW]
    CALENDAR,          -- Workdays only [CATSCALE]
    FUTURE,            -- Release future [CATSFUTURE]
    WORKLIST,          -- With worklist [CATSWRKLST]
    ASSIGNED,          -- Resource plng [CATSASSIGN]
    WORKCENTRE,        -- By work center [CATSWORKCT]
    WORKING,           -- In Process [CATSWORKNG]
    WORKSINCE,         -- In proc. since [CATSSINCEP]
    FROMPOOL,          -- From confs pool [CATSPOOL]
    FROMEXIT,          -- Cust.enhancemt [CATSEXITWL]
    WORKWITH,          -- Without hours [WORKWITH]
    WF_APPR,           -- WF approval [CATSWFAPPR]
    FREEATSAVE,        -- Rel. on saving [CATSFREEAT]
    APPROVAL,          -- Approval reqd [CATSAPPROV]
    DEFKOKRSCO,        -- CO area [CATSKOKRSC]
    DEFCOSTCO,         -- Master cost ctr [CATSCOSTCO]
    DEFCOSTCC,         -- Cost center [CATSCOSTCC]
    DEFACTTY,          -- Activity type [CATSACTTY]
    DEFPUROR,          -- Purchase order [CATSPUROR]
    DEFLSTST,          -- Service master [CATSLSTLS]
    DEFATYPE,          -- Att./abs. type [CATSATYPE]
    DEFAWART,          -- Att./abs. type [AWART]
    DEFWTYPE,          -- Wage type [CATSWTYPE]
    DEFLGART,          -- Wage Type [LGART]
    TASK,              -- Task [SWW_TASK]
    KONTIREACT,        -- Quotas [CATSQUOTAR]
    KOLLIREACT,        -- Collision [CATSCOLLIR]
    KOLHRREACT,        -- Collision HR [CATSCOLHRR]
    MAXHRREACT,        -- More than 24 H [CATSMAXHRR]
    DIRECTHR,          -- Transfer to HR [DIRECTHR]
    CATSPRINT,         -- Print program [CATSPRINT]
    SELREPORT,         -- Pers. selection [CATSSELRP]
    HRCOSTASG,         -- Cost acc. var. [CATSHRCO]
    SELREP,            -- Sel. report [CATSSELREP]
    CALENDAR_W,        -- Workdays only [CATSCALE_W]
    NOBREAKDED,        -- No Break Dedn [CATSNOBRKS]
    ADDOVERTIME,       -- Add overtime [CATSADDOVER]
    WF_AUTO,           -- Auto. recipient [CATSWFAUTO]
    NOCHANGE,          -- Read Only [CATSNOCHNG]
    SKIPISCR,          -- No init. screen [CATSSKIPISCR]
    DEFSPRZNR,         -- Send.bus.proc. [CATSSPRZNR]
    CATSCELL_SIZE,     -- Cell lgth [CATSCELL_SIZE]
    T_SCHEMA,          -- Trip Schema [RSCHE]
    TEMPLATE,          -- Templates [CATSTEMPLATE]
    PERLOCK,           -- Period lock [CATSPERLOCK]
    EXC_GROUP,         -- Group [CATS_EXC_GROUP]
    SPECIAL_APPROVAL,  -- Approval reqd [CATSAPPROV]
    WORKCPRO,          -- Projects [CATSCPRO]
    ASSIGNDB,          -- Assignment DB [CATSASGNDB]
    CHECKASDB,         -- Assignments [CATSCHKADB]
    HRENABLED,         -- CATS with HR [CATSHRE]
    DATADISPLAY,       -- Display option [CATSDDISP]
    CUTOFFDT,          -- Cutoff date [CATSPPE]
    OFFSETPD,          -- Days [CATSODD]
    PUBLICHOLTY,       -- Public Hol [CATSHABSTY]
    PRIMARY KEY (MANDT, VARIANT)
);

Learn More