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.string Text Content
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,     -- Text Content [abap.string]
    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