SNWD_BPA_CONTACT

Transparent Table Temporary Data
19 Fields 3 CDS Views

EPM: Business Partner Contacts

SNWD_BPA_CONTACT is an SAP database table in S/4HANA. EPM: Business Partner Contacts. It contains 19 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
qlast_sddl_people view from Example for Union
SEPM_I_ContactPerson view from EPM: Contact Person of a BusinessPartner
sepm_sddl_contact view from EPM: DDL view for business partner contact table

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY node_key snwd_node_key Node Key
parent_key snwd_node_key Node Key
title snwd_title Title
first_name snwd_first_name First Name
middle_name snwd_middle_name Middle Name
last_name snwd_last_name Last Name
nickname snwd_nickname Nickname
login_name syuname User Name
initials snwd_initials Initials
sex snwd_sex Gender
address_guid snwd_node_key Node Key
phone_number snwd_phone_number Phone
fax_number snwd_fax_number Fax
mobile_number snwd_mobile_number Mobile Phone Number
email_address snwd_email_address Email
language spras Language
date_of_birth snwd_date_of_birth Date of Birth
contact_id snwd_contact_id BP Contact 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: Business Partner Contacts
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_BPA_CONTACT (
    CLIENT,         -- Client [mandt]
    NODE_KEY,       -- Node Key [snwd_node_key]
    PARENT_KEY,     -- Node Key [snwd_node_key]
    TITLE,          -- Title [snwd_title]
    FIRST_NAME,     -- First Name [snwd_first_name]
    MIDDLE_NAME,    -- Middle Name [snwd_middle_name]
    LAST_NAME,      -- Last Name [snwd_last_name]
    NICKNAME,       -- Nickname [snwd_nickname]
    LOGIN_NAME,     -- User Name [syuname]
    INITIALS,       -- Initials [snwd_initials]
    SEX,            -- Gender [snwd_sex]
    ADDRESS_GUID,   -- Node Key [snwd_node_key]
    PHONE_NUMBER,   -- Phone [snwd_phone_number]
    FAX_NUMBER,     -- Fax [snwd_fax_number]
    MOBILE_NUMBER,  -- Mobile Phone Number [snwd_mobile_number]
    EMAIL_ADDRESS,  -- Email [snwd_email_address]
    LANGUAGE,       -- Language [spras]
    DATE_OF_BIRTH,  -- Date of Birth [snwd_date_of_birth]
    CONTACT_ID,     -- BP Contact ID [snwd_contact_id]
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More