CATSDBEXT

Transparent Table Application Table
8 Fields 2 CDS Views

RAP: Database Table for Time Sheet

CATSDBEXT is an SAP database table in S/4HANA. RAP: Database Table for Time Sheet. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_SDMCatsdbextProjectUUID view_entity inner BASIC View for SDM filling project UUID
R_TimeSheet view_entity from BASIC Time Sheet

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY timesheetrecorduuid guid GUID
timesheetrecord catscounte Counter
lastchangedatetime abp_lastchange_tstmpl Changed On
timesheetlastupdatesource cats_last_upd_src Last Updated Source
timesheetrecordlongtext cats_long_text Timesheet Long Text
timesheetlastchangedatetime cats_lastchange_tstmpl Changed On
projectuuid /s4ppm/tv_entity_guid Entity GUID

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.

-- RAP: 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 CATSDBEXT (
    MANDT,                        -- Client [mandt]
    TIMESHEETRECORDUUID,          -- GUID [guid]
    TIMESHEETRECORD,              -- Counter [catscounte]
    LASTCHANGEDATETIME,           -- Changed On [abp_lastchange_tstmpl]
    TIMESHEETLASTUPDATESOURCE,    -- Last Updated Source [cats_last_upd_src]
    TIMESHEETRECORDLONGTEXT,      -- Timesheet Long Text [cats_long_text]
    TIMESHEETLASTCHANGEDATETIME,  -- Changed On [cats_lastchange_tstmpl]
    PROJECTUUID,                  -- Entity GUID [/s4ppm/tv_entity_guid]
    PRIMARY KEY (MANDT, TIMESHEETRECORDUUID)
);

Learn More