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. It is exposed through 1 OData service (EHDGM_UI_SUBSTANCETECHNAME). It is used in 1 Fiori application: Manage Technical Names for Substance.

1 data source(s) Exposed by 1 service(s) Used in 1 Fiori app(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

OData Services (1)

ServiceBindingVersionContractRelease
EHDGM_UI_SUBSTANCETECHNAME EHDGM_UI_SUBSTANCETECHNAME V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5261 Manage Technical Names for Substance Transactional An Application to manage Technical Names for substnaces that have to be shown in the Dangerous Goods Description of product classified as a Dangerous Good

Manage Technical Names for Substance

Business Role: Dangerous Goods Specialist - Product Compliance

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
}

Learn More