SNWD_TEXTS

Transparent Table Temporary Data
6 Fields 7 CDS Views

EPM: Text Reference Table

SNWD_TEXTS is an SAP database table in S/4HANA. EPM: Text Reference Table. It contains 6 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
SADL_V_Annotations_RT view left_outer
SADL_V_SearchAnno view left_outer
SADL_V_SearchAnnotations view left_outer
SEPM_I_ShortText view from EPM Demo: Short Text
sepm_sddl_text_data view from
SEPMRA_I_ProductText view inner Product Text
SEPMRA_I_ProductText view left_outer Product Text

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY node_key SNWD_NODE_KEY Node Key
parent_key SNWD_NODE_KEY Node Key
language SPRAS Language
text SNWD_DESC Description
_dataaging DATA_TEMPERATURE Data Aging

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.

-- EPM: Text Reference Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_TEXTS (
    CLIENT,      -- Client [MANDT]
    NODE_KEY,    -- Node Key [SNWD_NODE_KEY]
    PARENT_KEY,  -- Node Key [SNWD_NODE_KEY]
    LANGUAGE,    -- Language [SPRAS]
    TEXT,        -- Description [SNWD_DESC]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More