CRMS4D_TEXT

Transparent Table Application Table
21 Fields 4 CDS Views

Transparent persistency for texts in Service transactions

CRMS4D_TEXT is an SAP database table in S/4HANA. Transparent persistency for texts in Service transactions. It contains 21 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
CRMS4_IU_I_IR_NOTE view_entity from Interaction Record Notes
I_ServiceDocumentLongText view_entity from BASIC Service Transaction Long Texts
I_ServiceDocumentLongText view_entity union_all BASIC Service Transaction Long Texts
I_SrvcDocHeaderLongText view_entity from BASIC ESH Long text search

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY text_uuid SYSUUID_X UUID
text_object TDOBJECT Text object
text_id TDID Text ID
language SPRAS Language
objtype_h CRMT_SUBOBJECT_CATEGORY_DB Trans. Cat.
object_id CRMT_OBJECT_ID_DB Transaction ID
number_int CRMS4_NUMBER_INT Item Number in Doc.
mimetype NTE_MIMETYPE MIME Type
text_content abap.strg
ref_text_object TDREFOBJ Reference obj.
ref_text_id TDREFID Reference ID
ref_text_name TDREFNAME Reference name
ref_objtype_h CRMT_SUBOBJECT_CATEGORY_DB Trans. Cat.
ref_object_id CRMT_OBJECT_ID_DB Transaction ID
ref_number_int CRMS4_NUMBER_INT Item Number in Doc.
log_timestamp CRMS4_LOG_TEXT_IDENTIFIER Identifier (truncated timestamp) of a log text
created_at CRMS4_TEXT_CREATED_AT Created At
created_by CRMS4_TEXT_CREATED_BY Created By
changed_at CRMS4_TEXT_CHANGED_AT Changed At
changed_by CRMS4_TEXT_CHANGED_BY Changed By

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.

-- Transparent persistency for texts in Service transactions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_TEXT (
    CLIENT,           -- Client [MANDT]
    TEXT_UUID,        -- UUID [SYSUUID_X]
    TEXT_OBJECT,      -- Text object [TDOBJECT]
    TEXT_ID,          -- Text ID [TDID]
    LANGUAGE,         -- Language [SPRAS]
    OBJTYPE_H,        -- Trans. Cat. [CRMT_SUBOBJECT_CATEGORY_DB]
    OBJECT_ID,        -- Transaction ID [CRMT_OBJECT_ID_DB]
    NUMBER_INT,       -- Item Number in Doc. [CRMS4_NUMBER_INT]
    MIMETYPE,         -- MIME Type [NTE_MIMETYPE]
    TEXT_CONTENT,     -- abap.strg
    REF_TEXT_OBJECT,  -- Reference obj. [TDREFOBJ]
    REF_TEXT_ID,      -- Reference ID [TDREFID]
    REF_TEXT_NAME,    -- Reference name [TDREFNAME]
    REF_OBJTYPE_H,    -- Trans. Cat. [CRMT_SUBOBJECT_CATEGORY_DB]
    REF_OBJECT_ID,    -- Transaction ID [CRMT_OBJECT_ID_DB]
    REF_NUMBER_INT,   -- Item Number in Doc. [CRMS4_NUMBER_INT]
    LOG_TIMESTAMP,    -- Identifier (truncated timestamp) of a log text [CRMS4_LOG_TEXT_IDENTIFIER]
    CREATED_AT,       -- Created At [CRMS4_TEXT_CREATED_AT]
    CREATED_BY,       -- Created By [CRMS4_TEXT_CREATED_BY]
    CHANGED_AT,       -- Changed At [CRMS4_TEXT_CHANGED_AT]
    CHANGED_BY,       -- Changed By [CRMS4_TEXT_CHANGED_BY]
    PRIMARY KEY (CLIENT, TEXT_UUID)
);

Learn More