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