I_SUBSTANCETEXTTP

CDS View

Substance Name

I_SUBSTANCETEXTTP is a CDS View in S/4HANA. Substance Name. It contains 4 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 4 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_SubstanceTextTP view from CONSUMPTION Substance Name

Fields (4)

KeyField CDS FieldsUsed in Views
KEY Language Language 1
KEY SubstanceUUID SubstanceUUID 1
LanguageForEdit LanguageForEdit 1
SubstanceName SubstanceName 1 
@EndUserText.label: 'Substance Name'
@VDM.viewType: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog: {
  sqlViewName:            'ISUBTTP',
  compiler.compareFilter: true
}

@ObjectModel: {
    dataCategory:                   #TEXT,
    modelCategory:                  #BUSINESS_OBJECT,
    transactionalProcessingEnabled: true,
    createEnabled:                  true,
    updateEnabled:                  true,
    deleteEnabled:                  true,
    writeActivePersistence:         'ehfndv_sub_t',
    writeDraftPersistence:          'ehfndw_sub_t',
    representativeKey:              'SubstanceUUID',
    semanticKey:                    ['SubstanceUUID'],
    usageType: {
      dataClass:      #MASTER,
      serviceQuality: #B,
      sizeCategory:   #M
    }
}

define view I_SubstanceTextTP
  as select from I_SubstanceText as text
  association [1..1] to I_SubstanceTP as _Substance       on $projection.SubstanceUUID = _Substance.SubstanceUUID
  association [0..1] to I_Language    as _LanguageForEdit on _LanguageForEdit.Language = $projection.LanguageForEdit
{
  key text.SubstanceUUID                                                     as SubstanceUUID,
      @ObjectModel.mandatory: true
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key text.Language,

      @ObjectModel.mandatory: true
      @ObjectModel.foreignKey.association: '_LanguageForEdit'
      @Semantics.language: false
      cast(text.Language as ehfnd_sub_substance_name_langu preserving type ) as LanguageForEdit,

      @Semantics.text: true
      @ObjectModel.mandatory: true
      text.SubstanceName,

      /* Associations */
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _Substance,
      _Language,
      _LanguageForEdit
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUBSTANCETEXT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_SUBSTANCETP"
],
"BASE":
[
"I_SUBSTANCETEXT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More