PTREQ_HEADER

Transparent Table Application Table

Request Header

PTREQ_HEADER is an SAP database table in S/4HANA. Request Header. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_HCMTimeEvtHdr view_entity from BASIC HCM Time Events Header
I_HCMTimeRequestHeader view_entity from BASIC Time Request Header

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY request_id TIM_REQ_ID Document ID
KEY version_no TIM_REQ_VERSION Doc. Version
request_type TIM_REQ_TYPE Document Categ.
status TIM_REQ_STATUS Document Status
initiator_cls OS_GUID GUID
initiator_ins OS_GUID GUID
owner_cls OS_GUID GUID
owner_ins OS_GUID GUID
next_processor_c OS_GUID GUID
next_processor_i OS_GUID GUID
responsible_cls OS_GUID GUID
responsible_ins OS_GUID GUID
item_list_id TIM_REQ_ITEM_LIST_ID ID of Item List
mod_user AS4USER Last Changed By
mod_timestamp TIMESTAMP Time Stamp
mod_timezone TIMEZONE Time Zone
workitem_id SWW_WIID Work Item ID
recurr_req_header_id TIM_REQ_ID Document 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.

-- Request Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PTREQ_HEADER (
    MANDT,                 -- Client [MANDT]
    REQUEST_ID,            -- Document ID [TIM_REQ_ID]
    VERSION_NO,            -- Doc. Version [TIM_REQ_VERSION]
    REQUEST_TYPE,          -- Document Categ. [TIM_REQ_TYPE]
    STATUS,                -- Document Status [TIM_REQ_STATUS]
    INITIATOR_CLS,         -- GUID [OS_GUID]
    INITIATOR_INS,         -- GUID [OS_GUID]
    OWNER_CLS,             -- GUID [OS_GUID]
    OWNER_INS,             -- GUID [OS_GUID]
    NEXT_PROCESSOR_C,      -- GUID [OS_GUID]
    NEXT_PROCESSOR_I,      -- GUID [OS_GUID]
    RESPONSIBLE_CLS,       -- GUID [OS_GUID]
    RESPONSIBLE_INS,       -- GUID [OS_GUID]
    ITEM_LIST_ID,          -- ID of Item List [TIM_REQ_ITEM_LIST_ID]
    MOD_USER,              -- Last Changed By [AS4USER]
    MOD_TIMESTAMP,         -- Time Stamp [TIMESTAMP]
    MOD_TIMEZONE,          -- Time Zone [TIMEZONE]
    WORKITEM_ID,           -- Work Item ID [SWW_WIID]
    RECURR_REQ_HEADER_ID,  -- Document ID [TIM_REQ_ID]
    PRIMARY KEY (MANDT, REQUEST_ID, VERSION_NO)
);