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