SRT_MMASTER

Transparent Table Temporary Data

WS message (Master table)

SRT_MMASTER is an SAP database table in S/4HANA. WS message (Master table). It contains 49 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
/APE/C_PDoc_LinkedDocuments_UI view inner CONSUMPTION Linked Documents for PDoc

Fields (49)

KeyField Data ElementDescription DomainTypeLength
KEY mandt SYMANDT Client ID
KEY persist_id SRT_PERSISTENCY_PERSIST_ID Persistency ID
message_id SRT_MSGID Msg ID
location SRT_PERSISTENCY_LOCATION Location
adapter_type SRT_ADAPTER_TYPE Adapter Type
comm_type SRT_COMMUNICATION_TYPE Communication Type
operation_type SRT_OPERATION_TYPE Operation Type
parent_type SRT_PARENT_TYPE Parent Type
message_state SRT_MESSAGE_STATE Message state
created_at TIMESTAMPL Time Stamp
created_by SYUNAME User Name
changed_at TIMESTAMPL Time Stamp
changed_by SYUNAME User Name
expiry_date SYDATUM Current Date
retent_category SRT_RETENTION_CATEGORY Retention Category
retry_counter SRT_PERSISTENCY_RETRY_COUNTER Retry counter
max_retries SRT_PERSISTENCY_MAX_RETRIES Maximal Retries
error_counter SRT_PERSISTENCY_ERROR_COUNTER Error counter
sequence_id SRT_SEQUENCE_GUID GUID Part
ref_id_type SRT_ID_TYPE ID Type
ref_id_value SYSUUID_X UUID
parent_id SRT_MSGID Msg ID
last_version SRT_MESSAGE_VERSION Version Number
prod_version SRT_MESSAGE_VERSION Version Number
error_version SRT_MESSAGE_VERSION Version Number
attachments SRT_ATTACH_EXISTS_INDICATOR Message Attachments
ob_party SRT_PERSISTENCY_PARTY Party
ob_component SRT_PERSISTENCY_COMPONENT Component
ob_if_name SRT_INTERFACE_NAME Interface Name
ob_if_namespace SRT_INTERFACE_NAMESPACE Interface Namespace
ob_if_operation SRT_INTERFACE_OPERATION Interface Operation
ib_party SRT_PERSISTENCY_PARTY Party
ib_component SRT_PERSISTENCY_COMPONENT Component
ib_if_name SRT_INTERFACE_NAME Interface Name
ib_if_namespace SRT_INTERFACE_NAMESPACE Interface Namespace
ib_if_operation SRT_INTERFACE_OPERATION Interface Operation
root_context_id SRT_ROOT_CONTEXT_ID Root Context ID
transaction_id SRT_TRANSACTION_ID Transaction ID
message_data SRT_MESSAGE_DATA Message data
message_size SRT_MESSAGE_SIZE Message Size
saved_at TIMESTAMPL Time Stamp
reloaded_at TIMESTAMPL Time Stamp
http_time abap.int4
provider_time abap.int4
luw_seq_messages abap.int4
migrated SRT_PERSISTENCY_MIGRATED Migrated / Direct
is_coupled_mapping SRT_IS_COUPLED_MAPPING Coupled mapping
sender_ibc SRT_IBC_ID IBC Identifier
receiver_ibc SRT_IBC_ID IBC Identifier

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.

-- WS message (Master table)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SRT_MMASTER (
    MANDT,               -- Client ID [SYMANDT]
    PERSIST_ID,          -- Persistency ID [SRT_PERSISTENCY_PERSIST_ID]
    MESSAGE_ID,          -- Msg ID [SRT_MSGID]
    LOCATION,            -- Location [SRT_PERSISTENCY_LOCATION]
    ADAPTER_TYPE,        -- Adapter Type [SRT_ADAPTER_TYPE]
    COMM_TYPE,           -- Communication Type [SRT_COMMUNICATION_TYPE]
    OPERATION_TYPE,      -- Operation Type [SRT_OPERATION_TYPE]
    PARENT_TYPE,         -- Parent Type [SRT_PARENT_TYPE]
    MESSAGE_STATE,       -- Message state [SRT_MESSAGE_STATE]
    CREATED_AT,          -- Time Stamp [TIMESTAMPL]
    CREATED_BY,          -- User Name [SYUNAME]
    CHANGED_AT,          -- Time Stamp [TIMESTAMPL]
    CHANGED_BY,          -- User Name [SYUNAME]
    EXPIRY_DATE,         -- Current Date [SYDATUM]
    RETENT_CATEGORY,     -- Retention Category [SRT_RETENTION_CATEGORY]
    RETRY_COUNTER,       -- Retry counter [SRT_PERSISTENCY_RETRY_COUNTER]
    MAX_RETRIES,         -- Maximal Retries [SRT_PERSISTENCY_MAX_RETRIES]
    ERROR_COUNTER,       -- Error counter [SRT_PERSISTENCY_ERROR_COUNTER]
    SEQUENCE_ID,         -- GUID Part [SRT_SEQUENCE_GUID]
    REF_ID_TYPE,         -- ID Type [SRT_ID_TYPE]
    REF_ID_VALUE,        -- UUID [SYSUUID_X]
    PARENT_ID,           -- Msg ID [SRT_MSGID]
    LAST_VERSION,        -- Version Number [SRT_MESSAGE_VERSION]
    PROD_VERSION,        -- Version Number [SRT_MESSAGE_VERSION]
    ERROR_VERSION,       -- Version Number [SRT_MESSAGE_VERSION]
    ATTACHMENTS,         -- Message Attachments [SRT_ATTACH_EXISTS_INDICATOR]
    OB_PARTY,            -- Party [SRT_PERSISTENCY_PARTY]
    OB_COMPONENT,        -- Component [SRT_PERSISTENCY_COMPONENT]
    OB_IF_NAME,          -- Interface Name [SRT_INTERFACE_NAME]
    OB_IF_NAMESPACE,     -- Interface Namespace [SRT_INTERFACE_NAMESPACE]
    OB_IF_OPERATION,     -- Interface Operation [SRT_INTERFACE_OPERATION]
    IB_PARTY,            -- Party [SRT_PERSISTENCY_PARTY]
    IB_COMPONENT,        -- Component [SRT_PERSISTENCY_COMPONENT]
    IB_IF_NAME,          -- Interface Name [SRT_INTERFACE_NAME]
    IB_IF_NAMESPACE,     -- Interface Namespace [SRT_INTERFACE_NAMESPACE]
    IB_IF_OPERATION,     -- Interface Operation [SRT_INTERFACE_OPERATION]
    ROOT_CONTEXT_ID,     -- Root Context ID [SRT_ROOT_CONTEXT_ID]
    TRANSACTION_ID,      -- Transaction ID [SRT_TRANSACTION_ID]
    MESSAGE_DATA,        -- Message data [SRT_MESSAGE_DATA]
    MESSAGE_SIZE,        -- Message Size [SRT_MESSAGE_SIZE]
    SAVED_AT,            -- Time Stamp [TIMESTAMPL]
    RELOADED_AT,         -- Time Stamp [TIMESTAMPL]
    HTTP_TIME,           -- abap.int4
    PROVIDER_TIME,       -- abap.int4
    LUW_SEQ_MESSAGES,    -- abap.int4
    MIGRATED,            -- Migrated / Direct [SRT_PERSISTENCY_MIGRATED]
    IS_COUPLED_MAPPING,  -- Coupled mapping [SRT_IS_COUPLED_MAPPING]
    SENDER_IBC,          -- IBC Identifier [SRT_IBC_ID]
    RECEIVER_IBC,        -- IBC Identifier [SRT_IBC_ID]
    PRIMARY KEY (MANDT, PERSIST_ID)
);