/SSB/ASSO_S

Transparent Table System Table (SAP only)

Client Independent Table for Associations between Indicators

/SSB/ASSO_S is an SAP database table in S/4HANA. Client Independent Table for Associations between Indicators. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
/ssb/union_Associations view from Union for association tables

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY namespace /SSB/NAMESPACE_DISCRIMINATOR Namespace
KEY source_target_hash /SSB/SHA1_DIGEST Digest
KEY is_active /SSB/IS_ACTIVE Is Active
type /SSB/ASSOC_TYPE Association Type
source_indicator /SSB/ID Identifier
target_indicator /SSB/ID Identifier
created_by /SSB/CREATED_BY_ID Created By
created_on /SSB/CREATED_ON Created On
changed_by /SSB/CHANGED_BY_ID Changed By
changed_on /SSB/CHANGED_ON Changed On

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.

-- Client Independent Table for Associations between Indicators
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SSB/ASSO_S (
    NAMESPACE,           -- Namespace [/SSB/NAMESPACE_DISCRIMINATOR]
    SOURCE_TARGET_HASH,  -- Digest [/SSB/SHA1_DIGEST]
    IS_ACTIVE,           -- Is Active [/SSB/IS_ACTIVE]
    TYPE,                -- Association Type [/SSB/ASSOC_TYPE]
    SOURCE_INDICATOR,    -- Identifier [/SSB/ID]
    TARGET_INDICATOR,    -- Identifier [/SSB/ID]
    CREATED_BY,          -- Created By [/SSB/CREATED_BY_ID]
    CREATED_ON,          -- Created On [/SSB/CREATED_ON]
    CHANGED_BY,          -- Changed By [/SSB/CHANGED_BY_ID]
    CHANGED_ON,          -- Changed On [/SSB/CHANGED_ON]
    PRIMARY KEY (NAMESPACE, SOURCE_TARGET_HASH, IS_ACTIVE)
);