I_SMBC_CONFIGURATION_TP

DDL: I_SMBC_CONFIGURATION_TP Type: view_entity

MBC: Configuration Root View

I_SMBC_CONFIGURATION_TP is a CDS View that provides data about "MBC: Configuration Root View" in SAP S/4HANA. It reads from 1 data source (smbc_config) and exposes 8 fields with key field TechnicalID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
smbc_config smbc_config from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_SMBC_CONFIGURATION_TEXT _Text _Text.TechnicalId = $projection.TechnicalID
[0..1] P_SMBC_DATA_ELEMENT_TEXT _GroupText _GroupText.ABAPDataElement = $projection.ConfigurationGroup

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label MBC: Configuration Root View view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY TechnicalID technical_id Number
ServiceBinding service_binding Service Binding
ServiceName service_name Service Name
ServiceVersion service_version Version
RootEntity root_entity CDS view
RootEntityListReportIsSkipped skip_root_entity Skip Root Entity
_Text _Text
_GroupText _GroupText

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 I_SMBC_CONFIGURATION_TP.
-- 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.

CREATE VIEW I_SMBC_CONFIGURATION_TP AS
SELECT
  technical_id AS TechnicalID,
  service_binding AS ServiceBinding,
  service_name AS ServiceName,
  service_version AS ServiceVersion,
  root_entity AS RootEntity,
  skip_root_entity AS RootEntityListReportIsSkipped
FROM smbc_config
LEFT OUTER JOIN I_SMBC_CONFIGURATION_TEXT AS _Text ON _Text.TechnicalId = TechnicalID  -- association [0..*]
LEFT OUTER JOIN P_SMBC_DATA_ELEMENT_TEXT AS _GroupText ON _GroupText.ABAPDataElement = ConfigurationGroup  -- association [0..1]
;