CRMS4D_GPM_NOTE

Transparent Table Application Table
15 Fields 1 CDS Views

Grantor program note

CRMS4D_GPM_NOTE is an SAP database table in S/4HANA. Grantor program note. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_GrantorProgramNote view_entity from BASIC Grantor Program Note

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY tdname tdobname Text Name
KEY text_id tdid Text ID
KEY language spras Language
program_guid crmt_gpm_program_guid Program GUID
log_timestamp crms4_log_text_identifier Identifier (truncated timestamp) of a log text
text crm_gpm_note_text Text of a program note
mime_type nte_mimetype MIME Type
ref_text_object crm_gpm_ref_text_object Reference text object
ref_text_name crm_gpm_ref_tdname Reference text name
ref_text_id crm_gpm_ref_text_id Reference text ID
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.

-- Grantor program note
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_GPM_NOTE (
    CLIENT,           -- abap.clnt
    TDNAME,           -- Text Name [tdobname]
    TEXT_ID,          -- Text ID [tdid]
    LANGUAGE,         -- Language [spras]
    PROGRAM_GUID,     -- Program GUID [crmt_gpm_program_guid]
    LOG_TIMESTAMP,    -- Identifier (truncated timestamp) of a log text [crms4_log_text_identifier]
    TEXT,             -- Text of a program note [crm_gpm_note_text]
    MIME_TYPE,        -- MIME Type [nte_mimetype]
    REF_TEXT_OBJECT,  -- Reference text object [crm_gpm_ref_text_object]
    REF_TEXT_NAME,    -- Reference text name [crm_gpm_ref_tdname]
    REF_TEXT_ID,      -- Reference text ID [crm_gpm_ref_text_id]
    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, TDNAME, TEXT_ID, LANGUAGE)
);

Learn More