UKMDB_KEYBNSS0

Transparent Table Application Table
10 Fields 1 CDS Views

UKM: Key

UKMDB_KEYBNSS0 is an SAP database table in S/4HANA. UKM: Key. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDIKeyMappingBaseBP view from Business Partner Key Mapping Base

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY object_id ukm_e_object_id Object ID
KEY key_id ukm_e_key_id Key ID
agency_id ukm_e_agency_id Agency ID
scheme_id ukm_e_scheme_id Schema ID
key_value_id char32 Character field, length 32
table_suffix ukm_e_value_table_suffix Value Table Suffix
key_leading ukm_e_leading_key_boolean Leading Key
key_internal ukm_e_internal_key_boolean Internal Key
object_status ukm_e_status_code 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.

-- UKM: Key
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UKMDB_KEYBNSS0 (
    MANDT,          -- Client [mandt]
    OBJECT_ID,      -- Object ID [ukm_e_object_id]
    KEY_ID,         -- Key ID [ukm_e_key_id]
    AGENCY_ID,      -- Agency ID [ukm_e_agency_id]
    SCHEME_ID,      -- Schema ID [ukm_e_scheme_id]
    KEY_VALUE_ID,   -- Character field, length 32 [char32]
    TABLE_SUFFIX,   -- Value Table Suffix [ukm_e_value_table_suffix]
    KEY_LEADING,    -- Leading Key [ukm_e_leading_key_boolean]
    KEY_INTERNAL,   -- Internal Key [ukm_e_internal_key_boolean]
    OBJECT_STATUS,  -- Status [ukm_e_status_code]
    PRIMARY KEY (MANDT, OBJECT_ID, KEY_ID)
);

Learn More