I_SubstanceName

DDL: I_SUBSTANCENAME Type: view COMPOSITE

Substance Names with Listed Substance Names

I_SubstanceName is a Composite CDS View that provides data about "Substance Names with Listed Substance Names" in SAP S/4HANA. It reads from 1 data source (P_SubstanceNameText) and exposes 4 fields.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
P_SubstanceNameText P_SubstanceNameText from

Annotations (10)

NameValueLevelField
EndUserText.label Substance Names with Listed Substance Names view
AbapCatalog.sqlViewName ISUBNAM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey SubstanceUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (4)

KeyFieldSource TableSource FieldDescription
UUIDofsubstancekeySubstanceUUID
ResponsibleUnit ResponsibleUnit
UUIDoflistedsubstanceListedSubstanceUUID
SubstanceName SubstanceName 
@EndUserText.label: 'Substance Names with Listed Substance Names'

@AbapCatalog:
{
  sqlViewName: 'ISUBNAM',
  compiler.compareFilter: true
}

@AccessControl:
{
  authorizationCheck: #MANDATORY
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE

@ObjectModel: {
  representativeKey: 'SubstanceUUID',
  usageType:
  {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #C
  }
}

define view I_SubstanceName
  --Select data from substance
  as select from P_SubstanceNameText

{

      --UUID of substance
  key SubstanceUUID,

      ResponsibleUnit,

      --UUID of listed substance
      ListedSubstanceUUID,

      --Internal Name of substance (language-independent)
      SubstanceInternalName,

      --Specification
      Specification,

      --CAS Number
      CASNumber,

      --EC Number
      ECNumber,

      SubstanceName

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_SUBSTANCENAMETEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More