SNWD_BP_CRM

Transparent Table Temporary Data
38 Fields 1 CDS Views

EPM HANA DG: CRM Business Partner Table (non-EPM)

SNWD_BP_CRM is an SAP database table in S/4HANA. EPM HANA DG: CRM Business Partner Table (non-EPM). It contains 38 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SFPM_IDA_TEST_SEAR_SNWD_BP_CRM view from SFPM Test CDS view for SNWD_BP_CRM

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY bp_id abap.char
last_name abap.char
first_name abap.char
gender abap.char
birthday dats Date
country abap.char
country_long abap.char
zip abap.char
city abap.char
state abap.char
street abap.char
street_no abap.char
phone abap.char
fax abap.char
mobile abap.char
email abap.char
hobby abap.char
marital_status abap.char
loyality_status abap.char
children abap.int1
email_flag abap.char
phone_flag abap.char
marketing_opt_in abap.char
reg_channel abap.char
pref_channel abap.char
customer_type abap.char
customer_since dats Date
last_contact_date dats Date
currency abap.char
sales_org abap.char
distribution_channel abap.char
division abap.char
account_group abap.char
sales_volume abap.dec
last_contact abap.char
age abap.int4
customer_tenure abap.int4

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 HANA DG: CRM Business Partner Table (non-EPM)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_BP_CRM (
    CLIENT,                -- Client [mandt]
    BP_ID,                 -- abap.char
    LAST_NAME,             -- abap.char
    FIRST_NAME,            -- abap.char
    GENDER,                -- abap.char
    BIRTHDAY,              -- Date [dats]
    COUNTRY,               -- abap.char
    COUNTRY_LONG,          -- abap.char
    ZIP,                   -- abap.char
    CITY,                  -- abap.char
    STATE,                 -- abap.char
    STREET,                -- abap.char
    STREET_NO,             -- abap.char
    PHONE,                 -- abap.char
    FAX,                   -- abap.char
    MOBILE,                -- abap.char
    EMAIL,                 -- abap.char
    HOBBY,                 -- abap.char
    MARITAL_STATUS,        -- abap.char
    LOYALITY_STATUS,       -- abap.char
    CHILDREN,              -- abap.int1
    EMAIL_FLAG,            -- abap.char
    PHONE_FLAG,            -- abap.char
    MARKETING_OPT_IN,      -- abap.char
    REG_CHANNEL,           -- abap.char
    PREF_CHANNEL,          -- abap.char
    CUSTOMER_TYPE,         -- abap.char
    CUSTOMER_SINCE,        -- Date [dats]
    LAST_CONTACT_DATE,     -- Date [dats]
    CURRENCY,              -- abap.char
    SALES_ORG,             -- abap.char
    DISTRIBUTION_CHANNEL,  -- abap.char
    DIVISION,              -- abap.char
    ACCOUNT_GROUP,         -- abap.char
    SALES_VOLUME,          -- abap.dec
    LAST_CONTACT,          -- abap.char
    AGE,                   -- abap.int4
    CUSTOMER_TENURE,       -- abap.int4
    PRIMARY KEY (CLIENT, BP_ID)
);

Learn More