SSCH_CMS_CDS_DESC_FT

DDL: SSCH_CMS_CDS_DESC_FT SQL: SSCHCMSFT Type: view
23 Fields 1 Data Sources 1 Associations

SSCH_CMS_CDS_DESC_FT is a CDS View in SAP S/4HANA. It reads from 1 data source (CSN_EXPOSURE_CDS_DEFAULT_FT) and exposes 23 fields with key field EntityName. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
CSN_EXPOSURE_CDS_DEFAULT_FT CSN_EXPOSURE_CDS_DEFAULT_FT from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..*] ssch_cms_edesc _cdsdescr _cdsdescr.cdsentity = _coremodel.EntityName

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SSCHCMSFT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
UI.headerInfo.typeName CSN Entity ExFT view
UI.headerInfo.typeNamePlural CSN Entities ExFT view
Search.searchable true view
EnterpriseSearch.enabled true view
UI.headerInfo.title.value ENTITYNAME view
Metadata.allowExtensions true view
Consumption.semanticObject CDSView view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY EntityName EntityName Entity Name
EntityLabel EntityLabel Entity Label
ReleaseContract ReleaseContract Release Contract
ReleaseState ReleaseState Release State
ReleaseContractMax ReleaseContractMax
ReleaseStateMax ReleaseStateMax
ReleaseStateC0 ReleaseStateC0 Release Status
ReleaseContractC0 ReleaseContractC0 Release Contract
ReleaseStateC1 ReleaseStateC1 Release Status
ReleaseContractC1 ReleaseContractC1 Release Contract
ReleaseStateC2 ReleaseStateC2 Release Status
ReleaseContractC2 ReleaseContractC2 Release Contract
ModelingPattern ModelingPattern Modeling Pattern
ModelingPatternDescription ModelingPatternDescription Modeling Pattern Description
AnalyticsDataExtractable AnalyticsDataExtractable Data Extraction Enabled
HeaderAnnotationName HeaderAnnotationName Header Annotation Name
HeaderAnnotationValue HeaderAnnotationValue Header Annotation Value
ApplicationComponent ApplicationComponent Application Component
ApplicationComponentText ApplicationComponentText Application Component Description
Field Field Field
SoftwareComponent SoftwareComponent Software Component
ComponentText ComponentText Software Component Description
FieldDescription Field Description

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 SSCH_CMS_CDS_DESC_FT.
-- 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: SSCHCMSFT
-- Parameters: P_Language : abap.lang

CREATE VIEW SSCH_CMS_CDS_DESC_FT AS
SELECT
  EntityName,
  EntityLabel,
  ReleaseContract,
  ReleaseState,
  ReleaseContractMax,
  ReleaseStateMax,
  ReleaseStateC0,
  ReleaseContractC0,
  ReleaseStateC1,
  ReleaseContractC1,
  ReleaseStateC2,
  ReleaseContractC2,
  ModelingPattern,
  ModelingPatternDescription,
  AnalyticsDataExtractable,
  HeaderAnnotationName,
  HeaderAnnotationValue,
  ApplicationComponent,
  ApplicationComponentText,
  Field,
  SoftwareComponent,
  ComponentText,
  _cdsdescr[1:lang = $parameters.P_Language].edesc AS FieldDescription
FROM CSN_EXPOSURE_CDS_DEFAULT_FT
LEFT OUTER JOIN ssch_cms_edesc AS _cdsdescr ON _cdsdescr.cdsentity = _coremodel.EntityName  -- association [0..*]
;

Learn More