SRMWFPTHPS

Transparent Table Application Table
24 Fields 2 CDS Views

Process Route Item for Workflow

SRMWFPTHPS is an SAP database table in S/4HANA. Process Route Item for Workflow. It contains 24 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProcessRouteTask view from BASIC Process Route Task
I_ProcessRouteTaskNote view_entity from BASIC Process Route Task Note

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY actarea SRMACTAR Activity Area
KEY pathid SRMWFPTHID Route ID
KEY posid SRMWFPOSID Item
posid_wiid SRMWFPWID Work Item ID
agent SRMWFAGENT Processor ID
activity SRMACTIV Activity
posid_led SRMWFPPLED Latest End
duedays SRMWFLDAYS Processing Time
posid_let SRMWFPPLET Latest End
creator SRMWFPPCRE Created By
creadate SRMWFPPCRD Created On
creatime SRMWFPPCRT Created at
lchgagent SRMWFPPLCA Changed by
lchgdate SRMWFPPLCD Changed on
lchgtime SRMWFPPLCT Changed at
delflag SRMWFPPDFL Deleted
actagent SRMWFPPACA Agent
enddate SRMWFPPEND Executed on
endtime SRMWFPPENT Executed at
pospast SRMWFPPAST Item in Past
posauth SRMWFPOSAU Authorization
stoppath SRMWFSTOP Can cancel
posprio SWD_STPRIO Step priority

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.

-- Process Route Item for Workflow
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SRMWFPTHPS (
    MANDT,       -- Client [MANDT]
    ACTAREA,     -- Activity Area [SRMACTAR]
    PATHID,      -- Route ID [SRMWFPTHID]
    POSID,       -- Item [SRMWFPOSID]
    POSID_WIID,  -- Work Item ID [SRMWFPWID]
    AGENT,       -- Processor ID [SRMWFAGENT]
    ACTIVITY,    -- Activity [SRMACTIV]
    POSID_LED,   -- Latest End [SRMWFPPLED]
    DUEDAYS,     -- Processing Time [SRMWFLDAYS]
    POSID_LET,   -- Latest End [SRMWFPPLET]
    CREATOR,     -- Created By [SRMWFPPCRE]
    CREADATE,    -- Created On [SRMWFPPCRD]
    CREATIME,    -- Created at [SRMWFPPCRT]
    LCHGAGENT,   -- Changed by [SRMWFPPLCA]
    LCHGDATE,    -- Changed on [SRMWFPPLCD]
    LCHGTIME,    -- Changed at [SRMWFPPLCT]
    DELFLAG,     -- Deleted [SRMWFPPDFL]
    ACTAGENT,    -- Agent [SRMWFPPACA]
    ENDDATE,     -- Executed on [SRMWFPPEND]
    ENDTIME,     -- Executed at [SRMWFPPENT]
    POSPAST,     -- Item in Past [SRMWFPPAST]
    POSAUTH,     -- Authorization [SRMWFPOSAU]
    STOPPATH,    -- Can cancel [SRMWFSTOP]
    POSPRIO,     -- Step priority [SWD_STPRIO]
    PRIMARY KEY (MANDT, ACTAREA, PATHID, POSID)
);

Learn More