SNWD_ITELO_DEPTS

Transparent Table Temporary Data
8 Fields 4 CDS Views

EPM: Organizational Unit Table

SNWD_ITELO_DEPTS is an SAP database table in S/4HANA. EPM: Organizational Unit Table. It contains 8 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
REPM_DepartmentV1 view from Department View
REPM_DEPTHIERARCHYV1 view from Department Hierarchy View
SEPM_I_OrganizationalUnit view from EPM Demo: Organizational Unit
sepm_sddl_depts view from

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY node_key snwd_node_key Node Key
parent_key snwd_node_key Node Key
org_unit_name snwd_org_unit_name Department
parent_org_unit snwd_node_key Node Key
manager_guid snwd_node_key Node Key
address_guid snwd_node_key Node Key
org_unit_id snwd_org_unit_id Org Unit ID

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: Organizational Unit Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_ITELO_DEPTS (
    CLIENT,           -- Client [mandt]
    NODE_KEY,         -- Node Key [snwd_node_key]
    PARENT_KEY,       -- Node Key [snwd_node_key]
    ORG_UNIT_NAME,    -- Department [snwd_org_unit_name]
    PARENT_ORG_UNIT,  -- Node Key [snwd_node_key]
    MANAGER_GUID,     -- Node Key [snwd_node_key]
    ADDRESS_GUID,     -- Node Key [snwd_node_key]
    ORG_UNIT_ID,      -- Org Unit ID [snwd_org_unit_id]
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More