ICL_BUPA_S

8 Fields 1 CDS Views

Generated Table for View

ICL_BUPA_S is an SAP database table in S/4HANA. Generated Table for View. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SHSM_ICL_BUPA_S view from CDS View als Ersatz für ICL_BUPA_S

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY partner BU_PARTNER Busn. Partner
KEY mc_name1 BU_MCNAME1 Name 1/Last Nme
KEY mc_name2 BU_MCNAME2 Name2/First Nme
KEY mc_city1 AD_MC_CITY City
KEY mc_street AD_MC_STRT Street
KEY house_num1 AD_HSNM1 House Number
KEY rltyp BU_PARTNERROLE BP Role

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICL_BUPA_S (
    CLIENT,      -- Client [MANDT]
    PARTNER,     -- Busn. Partner [BU_PARTNER]
    MC_NAME1,    -- Name 1/Last Nme [BU_MCNAME1]
    MC_NAME2,    -- Name2/First Nme [BU_MCNAME2]
    MC_CITY1,    -- City [AD_MC_CITY]
    MC_STREET,   -- Street [AD_MC_STRT]
    HOUSE_NUM1,  -- House Number [AD_HSNM1]
    RLTYP,       -- BP Role [BU_PARTNERROLE]
    PRIMARY KEY (CLIENT, PARTNER, MC_NAME1, MC_NAME2, MC_CITY1, MC_STREET, HOUSE_NUM1, RLTYP)
);

Learn More