CRMS4D_GPM_NOTE

Transparent Table Application Table

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)
);