SNWD_AD

Transparent Table Temporary Data
12 Fields 9 CDS Views

EPM: Address Table

SNWD_AD is an SAP database table in S/4HANA. EPM: Address Table. It contains 12 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
ACMTEST_PFCG_API_V1 view from Entity 1 for API tests
ACMTEST_PFCG_API_V2 view from Entity 1 for API tests
DEMO_CDS_EPM_ADDRESS view_entity from EPM Demo: Address
I_Sadl_Voc_Address view from Vocan Core View: Address
SADL_V_EXP_CustomerAddress view from Address
SDSH_SEPM_DCL view from DSH: unit tests for type ahead and DCL
sepm_cds_address view from EPM CDS: Address Information
SEPM_I_Address view from EPM Demo: Address
sepm_sddl_address view from SDDL for EPM

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY node_key snwd_node_key Node Key
city snwd_city City
postal_code snwd_postal_code Postal Code
street snwd_street Street
building snwd_building Building
country snwd_country Country
address_type snwd_address_type Address Type
val_start_date snwd_validity_start_date Valid From
val_end_date snwd_validity_end_date Valid Until
latitude snwd_lat Latitude
longitude snwd_long Longitude

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: Address Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_AD (
    CLIENT,          -- Client [mandt]
    NODE_KEY,        -- Node Key [snwd_node_key]
    CITY,            -- City [snwd_city]
    POSTAL_CODE,     -- Postal Code [snwd_postal_code]
    STREET,          -- Street [snwd_street]
    BUILDING,        -- Building [snwd_building]
    COUNTRY,         -- Country [snwd_country]
    ADDRESS_TYPE,    -- Address Type [snwd_address_type]
    VAL_START_DATE,  -- Valid From [snwd_validity_start_date]
    VAL_END_DATE,    -- Valid Until [snwd_validity_end_date]
    LATITUDE,        -- Latitude [snwd_lat]
    LONGITUDE,       -- Longitude [snwd_long]
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More