I_CmpstnCompCASNumberText

DDL: I_CMPSTNCOMPCASNUMBERTEXT Type: view BASIC
8 Fields 1 Data Sources 1 Associations

Language Dependant text for CAS Number

I_CmpstnCompCASNumberText is a Basic CDS View that provides data about "Language Dependant text for CAS Number" in SAP S/4HANA. It reads from 1 data source (dd04t) and exposes 8 fields with key fields ABAPDataElement, Language. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
dd04t dd04t from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (11)

NameValueLevelField
EndUserText.label Language Dependant text for CAS Number view
AbapCatalog.sqlViewName ICCCASNO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey ABAPDataElement view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ABAPDataElement dd04t rollname Repr. Data Elem
KEY Language dd04t ddlanguage Lang.
ABAPDataElementDescription dd04t ddtext Short text
ABAPDataElementHeading dd04t reptext Heading
ABAPShortFieldLabel dd04t scrtext_s ShortFieldLabel
ABAPMediumFieldLabel dd04t scrtext_m Medium Label
ABAPLongFieldLabel dd04t scrtext_l Long Fld Label
_Language _Language

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_CmpstnCompCASNumberText.
-- 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_CmpstnCompCASNumberText AS
SELECT
  dd04t.rollname AS ABAPDataElement,
  dd04t.ddlanguage AS Language,
  dd04t.ddtext AS ABAPDataElementDescription,
  dd04t.reptext AS ABAPDataElementHeading,
  dd04t.scrtext_s AS ABAPShortFieldLabel,
  dd04t.scrtext_m AS ABAPMediumFieldLabel,
  dd04t.scrtext_l AS ABAPLongFieldLabel
FROM dd04t
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More