SNWD_BPA

Transparent Table Temporary Data
13 Fields 23 CDS Views

EPM: Business Partners

SNWD_BPA is an SAP database table in S/4HANA. EPM: Business Partners. It contains 13 fields. 23 CDS views read from this table.

CDS Views using this table (23)

ViewTypeJoinVDMDescription
CdsFrwk_Partners view from Filter NULL values in WHERE clause
CdsFrwk_Sales_Orders_By_Cust view from Check GROUP BY and JOINs are unchanged
DEMO_BUSINESS_PARTNER_1 view from
DEMO_BUSINESS_PARTNER_2 view from
DEMO_BUSINESS_PARTNER_OLD view from
DEMO_BUSINESS_PARTNER_OLD1 view from
demo_corporation_sales_order view from
DEMO_SALES_ORDER_OLD1 view from
I_Sadl_Deep_Associations view left_outer Test View for path elements
I_Sadl_Voc_Businesspartner view from Vocan Core View: Business Partner
QLAST_SDDL_BPSO view from Example for business partner sales order view
SADL_V_AUnit_BuPa view from BusinessPartner for local unit tests
SADL_V_EXP_BusinessPartner view from
Sadl_V_Exp_Field_Cntr view left_outer CDS View Testing Dynamic Field Control
Sadl_V_Exp_Vocan_BuPa view from Sales Orders
sepm_bupa_address view from
sepm_cds_business_partner view from
SEPM_E_BusinessPartner view from EPM Demo: Business Partner Extension
SEPM_I_BusinessPartner view from EPM Demo: Business Partner
SEPM_I_CUSTOMER view from EPM Demo: Business Partner
SEPM_I_SUPPLIER view from EPM Demo: Business Partner
sepm_sddl_businesspartner view from
TEST_CDSRECV_1 view from

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY node_key snwd_node_key Node Key
bp_role snwd_business_partner_role Bus. Part. Role
email_address snwd_email_address Email
phone_number snwd_phone_number Phone
fax_number snwd_fax_number Fax
web_address snwd_uri URI
address_guid snwd_node_key Node Key
bp_id snwd_partner_id Business Partner ID
company_name snwd_company_name Company
legal_form snwd_legal_form Legal Form
currency_code snwd_curr_code Currency Code
approval_status snwd_bp_ap_status_code Approval Status

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 Partners
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_BPA (
    CLIENT,           -- Client [mandt]
    NODE_KEY,         -- Node Key [snwd_node_key]
    BP_ROLE,          -- Bus. Part. Role [snwd_business_partner_role]
    EMAIL_ADDRESS,    -- Email [snwd_email_address]
    PHONE_NUMBER,     -- Phone [snwd_phone_number]
    FAX_NUMBER,       -- Fax [snwd_fax_number]
    WEB_ADDRESS,      -- URI [snwd_uri]
    ADDRESS_GUID,     -- Node Key [snwd_node_key]
    BP_ID,            -- Business Partner ID [snwd_partner_id]
    COMPANY_NAME,     -- Company [snwd_company_name]
    LEGAL_FORM,       -- Legal Form [snwd_legal_form]
    CURRENCY_CODE,    -- Currency Code [snwd_curr_code]
    APPROVAL_STATUS,  -- Approval Status [snwd_bp_ap_status_code]
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More