CATSDBEXT_D

Transparent Table Application Table
32 Fields 1 CDS Views

Draft table for CATSDBEXT

CATSDBEXT_D is an SAP database table in S/4HANA. Draft table for CATSDBEXT. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_TimeSheetDraft view_entity from BASIC TimeSheet Draft Query View

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY timesheetrecorduuid guid GUID
timesheetrecord catscounte Counter
workassignmentexternalid wfd_assgmt_ext_id WFA Ext. ID
country2digitisocode wfd_country Country/Region
workassignment pernr_d Personnel No.
timesheetdate catsdate Date
recordedhours catshours Hours
hoursunitofmeasure meinh Unit of Measure
timesheetrecordlongtext cats_long_text Timesheet Long Text
projectuuid /s4ppm/tv_entity_guid Entity GUID
wbselementinternalid ps_s4_pspnr WBS Internal ID
activitytype lstar Activity Type
workitem /cpd/pfp_workitem_id Work Item ID
billingcontrolcategory billgctrlcat Billing Category
billablecontrol bemot AcctIndicator
timesheetstatus catsstatus Process status
timesheetrejectionreason catsreason Rejection reas.
timesheetpredecessorrecord catsrefcou Ref. counter
timesheetaccountingdocument catsbelnr Document no.
workflowtaskinternalid sww_wiid Work Item ID
createdbyuser cats_ernam Created by
lastchangedbyuser aenam Changed By
timesheetapprovedbyuser catsapnam Approved by
timesheetapproveddate catsapdat Approval date
timesheetcreationdate cats_ersda Created on
timesheetentrytime cats_cputm Time
timesheetlastchangeddate cats_laeda Last Change
timesheetlastchangedtime cats_laetm Time
lastchangedatetime abp_lastchange_tstmpl Changed On
timesheetlastchangedatetime cats_lastchange_tstmpl Changed On
timesheetoperation abap.char

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.

-- Draft table for CATSDBEXT
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CATSDBEXT_D (
    MANDT,                        -- Client [mandt]
    TIMESHEETRECORDUUID,          -- GUID [guid]
    TIMESHEETRECORD,              -- Counter [catscounte]
    WORKASSIGNMENTEXTERNALID,     -- WFA Ext. ID [wfd_assgmt_ext_id]
    COUNTRY2DIGITISOCODE,         -- Country/Region [wfd_country]
    WORKASSIGNMENT,               -- Personnel No. [pernr_d]
    TIMESHEETDATE,                -- Date [catsdate]
    RECORDEDHOURS,                -- Hours [catshours]
    HOURSUNITOFMEASURE,           -- Unit of Measure [meinh]
    TIMESHEETRECORDLONGTEXT,      -- Timesheet Long Text [cats_long_text]
    PROJECTUUID,                  -- Entity GUID [/s4ppm/tv_entity_guid]
    WBSELEMENTINTERNALID,         -- WBS Internal ID [ps_s4_pspnr]
    ACTIVITYTYPE,                 -- Activity Type [lstar]
    WORKITEM,                     -- Work Item ID [/cpd/pfp_workitem_id]
    BILLINGCONTROLCATEGORY,       -- Billing Category [billgctrlcat]
    BILLABLECONTROL,              -- AcctIndicator [bemot]
    TIMESHEETSTATUS,              -- Process status [catsstatus]
    TIMESHEETREJECTIONREASON,     -- Rejection reas. [catsreason]
    TIMESHEETPREDECESSORRECORD,   -- Ref. counter [catsrefcou]
    TIMESHEETACCOUNTINGDOCUMENT,  -- Document no. [catsbelnr]
    WORKFLOWTASKINTERNALID,       -- Work Item ID [sww_wiid]
    CREATEDBYUSER,                -- Created by [cats_ernam]
    LASTCHANGEDBYUSER,            -- Changed By [aenam]
    TIMESHEETAPPROVEDBYUSER,      -- Approved by [catsapnam]
    TIMESHEETAPPROVEDDATE,        -- Approval date [catsapdat]
    TIMESHEETCREATIONDATE,        -- Created on [cats_ersda]
    TIMESHEETENTRYTIME,           -- Time [cats_cputm]
    TIMESHEETLASTCHANGEDDATE,     -- Last Change [cats_laeda]
    TIMESHEETLASTCHANGEDTIME,     -- Time [cats_laetm]
    LASTCHANGEDATETIME,           -- Changed On [abp_lastchange_tstmpl]
    TIMESHEETLASTCHANGEDATETIME,  -- Changed On [cats_lastchange_tstmpl]
    TIMESHEETOPERATION,           -- abap.char
    PRIMARY KEY (MANDT, TIMESHEETRECORDUUID)
);

Learn More