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

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