T5ASRSTEPS

Transparent Table Application Table
29 Fields 1 CDS Views

HR Administrative Services: Process Steps (Work Items)

T5ASRSTEPS is an SAP database table in S/4HANA. HR Administrative Services: Process Steps (Work Items). It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_HCMProcessStepBasic view from BASIC HCM Process Step

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY case_guid SCMG_CASE_GUID Case Key
parent_scenario SCMG_CASE_GUID Case Key
title ASR_STEP_TITLE Step Name
language SPRSL Language
processed_by ASR_PROCESSOR Agent Proc. Step
processor_role ASR_PROCESSOR_ROLE Agent Role
scenario_stage ASR_SCENARIO_STAGE Scenario Step
status ASR_STEP_STATUS Status of Step
start_date ASR_START_DATE Start Date
start_time ASR_START_TIME Start Time
start_tst ASR_UTC_TIMESTAMP_STEP_START Start Time
start_delta ASR_DELTA_TO_UTC_IN_SECONDS Time Difference
completion_date ASR_COMPLETION_DATE End Date
completion_time ASR_COMPLETION_TIME End Time
completion_tst ASR_UTC_TIMESTAMP_COMPLETION End Time Stamp
completion_delta ASR_DELTA_TO_UTC_IN_SECONDS Time Difference
latest_startdate ASR_LATEST_STEP_START_DATE Latest Start
latest_starttime ASR_LATEST_STEP_START_TIME Latest Start
latest_starttst ASR_UTC_TIMESTAMP_LATEST_START Latest Start
lateststartdelta ASR_DELTA_TO_UTC_IN_SECONDS Time Difference
latest_enddate ASR_LATEST_STEP_END_DATE Latest End Date
latest_endtime ASR_LATEST_STEP_END_TIME End of Step
latest_endtst ASR_UTC_TIMESTAMP_LATEST_END_S Step End
latest_enddelta ASR_DELTA_TO_UTC_IN_SECONDS Time Difference
forwarded_by ASR_FORWARDED_BY Forwarder
no_of_attachment ASR_NO_OF_ATTACHMENTS No. Attachments
proc_status ASR_PROCESSING_STATUS Status After Action
bstatusid ASR_BUSINESSSTATUSID Business Status ID

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.

-- HR Administrative Services: Process Steps (Work Items)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T5ASRSTEPS (
    MANDT,             -- Client [MANDT]
    CASE_GUID,         -- Case Key [SCMG_CASE_GUID]
    PARENT_SCENARIO,   -- Case Key [SCMG_CASE_GUID]
    TITLE,             -- Step Name [ASR_STEP_TITLE]
    LANGUAGE,          -- Language [SPRSL]
    PROCESSED_BY,      -- Agent Proc. Step [ASR_PROCESSOR]
    PROCESSOR_ROLE,    -- Agent Role [ASR_PROCESSOR_ROLE]
    SCENARIO_STAGE,    -- Scenario Step [ASR_SCENARIO_STAGE]
    STATUS,            -- Status of Step [ASR_STEP_STATUS]
    START_DATE,        -- Start Date [ASR_START_DATE]
    START_TIME,        -- Start Time [ASR_START_TIME]
    START_TST,         -- Start Time [ASR_UTC_TIMESTAMP_STEP_START]
    START_DELTA,       -- Time Difference [ASR_DELTA_TO_UTC_IN_SECONDS]
    COMPLETION_DATE,   -- End Date [ASR_COMPLETION_DATE]
    COMPLETION_TIME,   -- End Time [ASR_COMPLETION_TIME]
    COMPLETION_TST,    -- End Time Stamp [ASR_UTC_TIMESTAMP_COMPLETION]
    COMPLETION_DELTA,  -- Time Difference [ASR_DELTA_TO_UTC_IN_SECONDS]
    LATEST_STARTDATE,  -- Latest Start [ASR_LATEST_STEP_START_DATE]
    LATEST_STARTTIME,  -- Latest Start [ASR_LATEST_STEP_START_TIME]
    LATEST_STARTTST,   -- Latest Start [ASR_UTC_TIMESTAMP_LATEST_START]
    LATESTSTARTDELTA,  -- Time Difference [ASR_DELTA_TO_UTC_IN_SECONDS]
    LATEST_ENDDATE,    -- Latest End Date [ASR_LATEST_STEP_END_DATE]
    LATEST_ENDTIME,    -- End of Step [ASR_LATEST_STEP_END_TIME]
    LATEST_ENDTST,     -- Step End [ASR_UTC_TIMESTAMP_LATEST_END_S]
    LATEST_ENDDELTA,   -- Time Difference [ASR_DELTA_TO_UTC_IN_SECONDS]
    FORWARDED_BY,      -- Forwarder [ASR_FORWARDED_BY]
    NO_OF_ATTACHMENT,  -- No. Attachments [ASR_NO_OF_ATTACHMENTS]
    PROC_STATUS,       -- Status After Action [ASR_PROCESSING_STATUS]
    BSTATUSID,         -- Business Status ID [ASR_BUSINESSSTATUSID]
    PRIMARY KEY (MANDT, CASE_GUID)
);

Learn More