SRT_MMASTER
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /APE/C_PDoc_LinkedDocuments_UI | view | inner | CONSUMPTION | Linked Documents for PDoc |
Fields (49)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA