/SSB/CORE_DATA_ANALYZER

DDL: /SSB/CORE_DATA_ANALYZER SQL: /SSB/COSACDA Type: view
7 Fields 2 Data Sources

List of SAC Data Analyzer in S/4HANA

/SSB/CORE_DATA_ANALYZER is a CDS View that provides data about "List of SAC Data Analyzer in S/4HANA" in SAP S/4HANA. It reads from 2 data sources (/ssb/sacda_s, /SSB/SAPCLIENT) and exposes 7 fields with key field id.

Data Sources (2)

SourceAliasJoin Type
/ssb/sacda_s DataAnalyzer from
/SSB/SAPCLIENT SC inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName /SSB/COSACDA 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 List of SAC Data Analyzer in S/4HANA view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY id /ssb/sacda_s id WorklistID
service /ssb/sacda_s service Service Type
service_type /ssb/sacda_s service_type Type of Ext. Service
created_by /ssb/sacda_s created_by Version Created By
created_on /ssb/sacda_s created_on Variant created on
changed_by /ssb/sacda_s changed_by User Name
changed_on /ssb/sacda_s changed_on Variant Changed on

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/CORE_DATA_ANALYZER.
-- 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/COSACDA

CREATE VIEW /SSB/CORE_DATA_ANALYZER AS
SELECT
  DataAnalyzer.id AS id,
  DataAnalyzer.service AS service,
  DataAnalyzer.service_type AS service_type,
  DataAnalyzer.created_by AS created_by,
  DataAnalyzer.created_on AS created_on,
  DataAnalyzer.changed_by AS changed_by,
  DataAnalyzer.changed_on AS changed_on
FROM /ssb/sacda_s AS DataAnalyzer
INNER JOIN /SSB/SAPCLIENT AS SC ON /* join condition not captured in parsed metadata */
;

Learn More