I_ChemicalNameText

@EndUserText.label: 'Chemical Name'
@Analytics.dataExtraction.enabled:true
@VDM.viewType: #BASIC 
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: [ 'ChemicalUUID', 'ChemicalRevisionUUID' ]
@AccessControl.authorizationCheck: #CHECK

@AbapCatalog.sqlViewName: 'ICHMNAMET'
@AbapCatalog.compiler.compareFilter: true

// Client handling by session 

@ClientHandling.algorithm: #SESSION_VARIABLE

// used for BOBF Master Data Object

@ObjectModel.usageType:{ serviceQuality: #C,        // < 15 msec   

                         sizeCategory:  #L,         // < 10.000.000

                         dataClass: #MASTER } 
                         
define view I_ChemicalNameText as select from ehfndd_chm_name as ChemicalNameText 
// begin correction 2900350

   inner join ehfndd_chm_binfo  as BasicInfo on  ChemicalNameText.parent_key = BasicInfo.db_key 
// end correction 2900350


   association [1..1] to I_ChemicalBasicInfo as _ChemicalBasicInfo on $projection.ChemicalBasicInfoUUID = _ChemicalBasicInfo.ChemicalBasicInfoUUID
   association [1..1] to I_ChemicalRoot as _ChemicalRoot on $projection.ChemicalUUID = _ChemicalRoot.ChemicalUUID
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/   
   association [1..1] to I_ChemicalRevision as _ChemicalRevision on $projection.ChemicalUUID = _ChemicalRevision.ChemicalUUID
                                                                    and $projection.ChemicalRevisionUUID = _ChemicalRevision.ChemicalRevisionUUID
   association [0..1] to I_Language as _Language on $projection.Language = _Language.Language

{
    @ObjectModel.foreignKey.association: '_ChemicalRoot' 
    @Consumption.valueHelpDefinition: [{ entity: { name: 'I_ChemicalStdVH', element: 'ChemicalUUID' }}]      
    key cast( ChemicalNameText.root_key as ehfnd_chm_uuid_ref preserving type ) as ChemicalUUID,
    _ChemicalRoot,
   
    @Semantics.businessDate.to
// begin correction 2900350

    key _ChemicalRevision.RevisionEndDate,
// end  correction 2900350


    @Semantics.language: true
    @ObjectModel.foreignKey.association: '_Language'
    key cast( ChemicalNameText.language as sylangu preserving type ) as Language,
    
// begin correction 2900350

    key BasicInfo.parent_key as ChemicalRevisionUUID,
// end  correction 2900350

    _ChemicalRevision,
    
// begin correction 2900350

//    @ObjectModel.foreignKey.association: '_ChemicalBasicInfo'

    ChemicalNameText.parent_key as ChemicalBasicInfoUUID,
// end  correction 2900350

    _ChemicalBasicInfo,

    @Semantics.businessDate.from
// begin correction 2900350

    _ChemicalRevision.RevisionStartDate,
// end correction 2900350


    @Semantics.text:true
    ChemicalNameText.text as NameOfChemical,
    
    _Language
}                                           
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHEMICALREVISION",
"EHFNDD_CHM_BINFO",
"EHFNDD_CHM_NAME"
],
"ASSOCIATED":
[
"I_CHEMICALBASICINFO",
"I_CHEMICALREVISION",
"I_CHEMICALROOT",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/