/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. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
/SSB/ALL_VIEWS_USED_IN_SSB view union_all Views used already in SSB
/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/RUNTIME_EVALS view union_all Evaluation data for App descriptor
/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)
);