/SSB/ASSO_PROP

Transparent Table Control Table (SAP+Cust)

Table for Properties of Associations in SAP Smart Bus.

/SSB/ASSO_PROP is an SAP database table in S/4HANA. Table for Properties of Associations in SAP Smart Bus.. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
/ssb/core_Assoc_Properties view union_all Core CDS View for properties of Associations

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY sap_client /SSB/SAP_CLIENT SAP Client
KEY namespace /SSB/NAMESPACE_DISCRIMINATOR Namespace
KEY source_target_hash /SSB/SHA1_DIGEST Digest
KEY is_active /SSB/IS_ACTIVE Is Active
KEY name_value_hash /SSB/SHA1_DIGEST Digest
type /SSB/ASSOC_TYPE Association Type
source_indicator /SSB/ID Identifier
target_indicator /SSB/ID Identifier
name /SSB/PROPERTY_NAME Name
value /SSB/PROPERTY_VALUE Value

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.

-- Table for Properties of Associations in SAP Smart Bus.
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SSB/ASSO_PROP (
    SAP_CLIENT,          -- SAP Client [/SSB/SAP_CLIENT]
    NAMESPACE,           -- Namespace [/SSB/NAMESPACE_DISCRIMINATOR]
    SOURCE_TARGET_HASH,  -- Digest [/SSB/SHA1_DIGEST]
    IS_ACTIVE,           -- Is Active [/SSB/IS_ACTIVE]
    NAME_VALUE_HASH,     -- Digest [/SSB/SHA1_DIGEST]
    TYPE,                -- Association Type [/SSB/ASSOC_TYPE]
    SOURCE_INDICATOR,    -- Identifier [/SSB/ID]
    TARGET_INDICATOR,    -- Identifier [/SSB/ID]
    NAME,                -- Name [/SSB/PROPERTY_NAME]
    VALUE,               -- Value [/SSB/PROPERTY_VALUE]
    PRIMARY KEY (SAP_CLIENT, NAMESPACE, SOURCE_TARGET_HASH, IS_ACTIVE, NAME_VALUE_HASH)
);