/SSB/EVALS

Transparent Table Control Table (SAP+Cust)

Evaluations of Indicators in SAP Smart Business

/SSB/EVALS is an SAP database table in S/4HANA. Evaluations of Indicators in SAP Smart Business. It contains 32 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
/SSB/CDS_VIEWS_WHERE_USED view union_all list of objects where a cds view is used
/ssb/core_Eval_Modified view union_all Evals modified time - cache invalidation
/SSB/COUNT_UNION_EVALUATIONS view union_all Union of KPIs for count
/ssb/Cust_Edited_Evals view from List of all SAP Delivered Evaluations edited by customer
/ssb/Union_Evaluations view union_all Evaluations after union of Tables

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY sap_client /ssb/sap_client SAP Client
KEY id /ssb/id Identifier
KEY is_active /ssb/is_active Is Active
indicator_id /ssb/id Identifier
scaling /ssb/scaling Scaling
odata_url /ssb/odata_url ODATA URL
odata_entityset /ssb/odata_entityset Entityset
view_name /ssb/view_name View
cds_view_name /ssb/cds_view_name CDS View
column_name /ssb/column_name Column
owner_name /ssb/owner_name Name
owner_e_mail /ssb/owner_e_mail E-Mail Addr.
owner_id /ssb/owner_id User ID
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
odata_property /ssb/odata_property Property
semantic_object /ssb/semantic_object Semantic Obj.
action /ssb/action Action
values_source /ssb/values_source Values Source
indicator_type /ssb/indicator_type Indicator T.
goal_type /ssb/goal_type Goal Type
description /ssb/text Description
additional_info /ssb/additional_info Additional Info
decimal_precision /ssb/decimal_precision Decimal Precision
ref_id /ssb/id Identifier
is_extn_reverted /ssb/is_extn_reverted Extension Reverted
annotation_model /ssb/annotation_model Annotation Model
facet_filter_pagination /ssb/facet_filter_pagination Facet-Filter
cds_annotation_name /ssb/annotation_model Annotation Model
cds_annotation_version /ssb/annotation_version Annotation Version

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.

-- Evaluations of Indicators in SAP Smart Business
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SSB/EVALS (
    SAP_CLIENT,               -- SAP Client [/ssb/sap_client]
    ID,                       -- Identifier [/ssb/id]
    IS_ACTIVE,                -- Is Active [/ssb/is_active]
    INDICATOR_ID,             -- Identifier [/ssb/id]
    SCALING,                  -- Scaling [/ssb/scaling]
    ODATA_URL,                -- ODATA URL [/ssb/odata_url]
    ODATA_ENTITYSET,          -- Entityset [/ssb/odata_entityset]
    VIEW_NAME,                -- View [/ssb/view_name]
    CDS_VIEW_NAME,            -- CDS View [/ssb/cds_view_name]
    COLUMN_NAME,              -- Column [/ssb/column_name]
    OWNER_NAME,               -- Name [/ssb/owner_name]
    OWNER_E_MAIL,             -- E-Mail Addr. [/ssb/owner_e_mail]
    OWNER_ID,                 -- User ID [/ssb/owner_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]
    ODATA_PROPERTY,           -- Property [/ssb/odata_property]
    SEMANTIC_OBJECT,          -- Semantic Obj. [/ssb/semantic_object]
    ACTION,                   -- Action [/ssb/action]
    VALUES_SOURCE,            -- Values Source [/ssb/values_source]
    INDICATOR_TYPE,           -- Indicator T. [/ssb/indicator_type]
    GOAL_TYPE,                -- Goal Type [/ssb/goal_type]
    DESCRIPTION,              -- Description [/ssb/text]
    ADDITIONAL_INFO,          -- Additional Info [/ssb/additional_info]
    DECIMAL_PRECISION,        -- Decimal Precision [/ssb/decimal_precision]
    REF_ID,                   -- Identifier [/ssb/id]
    IS_EXTN_REVERTED,         -- Extension Reverted [/ssb/is_extn_reverted]
    ANNOTATION_MODEL,         -- Annotation Model [/ssb/annotation_model]
    FACET_FILTER_PAGINATION,  -- Facet-Filter [/ssb/facet_filter_pagination]
    CDS_ANNOTATION_NAME,      -- Annotation Model [/ssb/annotation_model]
    CDS_ANNOTATION_VERSION,   -- Annotation Version [/ssb/annotation_version]
    PRIMARY KEY (SAP_CLIENT, ID, IS_ACTIVE)
);