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
SEPM_I_Address view from EPM Demo: Address
sepm_sddl_address view from

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