/SSB/ANALYTICAL_OBJECT_COUNT

DDL: /SSB/ANALYTICAL_OBJECT_COUNT SQL: /SSB/OBJECTCOUNT Type: view Package: /SSB/CORE
7 Fields 10 Data Sources

Object count in Manage KPIs & Reports

/SSB/ANALYTICAL_OBJECT_COUNT is a CDS View that provides data about "Object count in Manage KPIs & Reports" in SAP S/4HANA. It reads from 10 data sources and exposes 7 fields. Part of development package /SSB/CORE.

Data Sources (10)

SourceAliasJoin Type
/SSB/COUNT_ALP_REPORT /SSB/COUNT_ALP_REPORT union_all
/SSB/COUNT_GENERIC_REPORTS /SSB/COUNT_GENERIC_REPORTS union_all
/SSB/count_kpis /SSB/count_kpis from
/ssb/sacda_s DataAnalyzer union_all
report_chips report_chips union_all
/ssb/sacstory_s SACStoryS union_all
/SSB/SAPCLIENT SC inner
/SSB/SAPCLIENT SC inner
/SSB/SAPCLIENT SC inner
tadir tadir inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName /SSB/OBJECTCOUNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Object count in Manage KPIs & Reports view

Fields (7)

KeyFieldSource TableSource FieldDescription
ObjectType ObjectType Type
char10asObjectType
char10asObjectType
char10asObjectType
char10asObjectType
char10asObjectType
ObjectCount

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view /SSB/ANALYTICAL_OBJECT_COUNT.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: /SSB/OBJECTCOUNT

CREATE VIEW /SSB/ANALYTICAL_OBJECT_COUNT AS
SELECT
  ObjectType,
  ObjectCount AS char10asObjectType,
  cast ( count(distinct report_chips.app_id) as abap.int2 ) AS ObjectCount
FROM /SSB/count_kpis
INNER JOIN /SSB/SAPCLIENT AS SC ON /* join condition not captured in parsed metadata */
INNER JOIN tadir ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): /SSB/COUNT_GENERIC_REPORTS, /SSB/COUNT_ALP_REPORT, /ssb/sacda_s, /ssb/sacstory_s, report_chips
;

Learn More