SNWD_LR_ITEM

Transparent Table Temporary Data
7 Fields 3 CDS Views

EPM: Leave Request Item data

SNWD_LR_ITEM is an SAP database table in S/4HANA. EPM: Leave Request Item data. It contains 7 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
SEPM_I_LeaveRequestItem view from EPM Demo: Leave Request Item
sepm_sddl_leave_requ_item_join view from
sepm_sddl_leave_request_item view from

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY node_key snwd_node_key Node Key
parent_key snwd_node_key Node Key
from_timestamp snwd_timestampl_from From
to_timestamp snwd_timestampl_to To
note_guid snwd_node_key Node Key
status snwd_lr_status_code Leave Request Code

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: Leave Request Item data
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_LR_ITEM (
    CLIENT,          -- Client [mandt]
    NODE_KEY,        -- Node Key [snwd_node_key]
    PARENT_KEY,      -- Node Key [snwd_node_key]
    FROM_TIMESTAMP,  -- From [snwd_timestampl_from]
    TO_TIMESTAMP,    -- To [snwd_timestampl_to]
    NOTE_GUID,       -- Node Key [snwd_node_key]
    STATUS,          -- Leave Request Code [snwd_lr_status_code]
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More