C_SubstanceTechNameSubstText

DDL: C_SUBSTANCETECHNAMESUBSTTEXT SQL: CSUBTNSTXT Type: view CONSUMPTION

Company Names for the related Substance

C_SubstanceTechNameSubstText is a Consumption CDS View that provides data about "Company Names for the related Substance" in SAP S/4HANA. It reads from 1 data source (I_SubstanceText) and exposes 5 fields with key fields SubstanceUUID, Language.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_SubstanceText text from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CSUBTNSTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Company Names for the related Substance view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey SubstanceUUID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
UI.headerInfo.typeName Substance Name view
UI.headerInfo.typeNamePlural Substance Names view
UI.headerInfo.title.label Company-Specific Names for Substance view
UI.headerInfo.title.value SubstanceName view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SubstanceUUID I_SubstanceText SubstanceUUID
KEY Language
SubstanceName I_SubstanceText SubstanceName
_Substance _Substance
_Language _Language 
@AbapCatalog.sqlViewName: 'CSUBTNSTXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Company Names for the related Substance'
@VDM.viewType: #CONSUMPTION
@Metadata: {
  allowExtensions: true,
  ignorePropagatedAnnotations: true
}

@ObjectModel: {
   dataCategory: #TEXT,
   representativeKey:                'SubstanceUUID',
   semanticKey:                      ['SubstanceUUID','Language'],
   usageType: {
     dataClass:      #MASTER,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}

@UI.headerInfo:{
  typeName: 'Substance Name',
  typeNamePlural: 'Substance Names',
  title: {
    label: 'Company-Specific Names for Substance',
    value: 'SubstanceName'
  }
}
@UI.presentationVariant: [{
  sortOrder : [{  by: 'Language',  direction: #ASC }]
}]
define view C_SubstanceTechNameSubstText
  as select from I_SubstanceText as text
{
  key   text.SubstanceUUID,

        @ObjectModel.foreignKey.association: '_Language'
        // Currenly the sorting and filtering do not work properly on the ui (because of seeing the language text but sorting/filtering the language code) but for consitency leave it enabled

        //        @ObjectModel:{

        //          filter.enabled: false,

        //          sort.enabled: false

        //        }

        @Semantics.language: true
  key   cast(text.Language as ehfnd_sub_substance_name_langu preserving type ) as Language,

        @Semantics.text: true
        text.SubstanceName,

        /* Associations */
        _Substance,
        _Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUBSTANCETEXT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_SUBSTANCE"
],
"BASE":
[
"I_SUBSTANCETEXT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More