SNWD_BPA

Transparent Table Temporary Data
18 Fields 24 CDS Views

EPM: Business Partners

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

CDS Views using this table (24)

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_cds_epm_BUSINESSPARTNER view_entity from EPM Demo: Business Partner
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 (18)

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
created_by SNWD_NODE_KEY Node Key
created_at SNWD_CREATED_AT Created At
changed_by SNWD_NODE_KEY Node Key
changed_at SNWD_CHANGED_AT Changed At
currency_code SNWD_CURR_CODE Currency Code
dummy_field_bpa abap.char
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]
    CREATED_BY,       -- Node Key [SNWD_NODE_KEY]
    CREATED_AT,       -- Created At [SNWD_CREATED_AT]
    CHANGED_BY,       -- Node Key [SNWD_NODE_KEY]
    CHANGED_AT,       -- Changed At [SNWD_CHANGED_AT]
    CURRENCY_CODE,    -- Currency Code [SNWD_CURR_CODE]
    DUMMY_FIELD_BPA,  -- abap.char
    APPROVAL_STATUS,  -- Approval Status [SNWD_BP_AP_STATUS_CODE]
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More