R_SubstanceBasedComponentTP

@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Substance Bsd Composition Component - TP'
@ObjectModel:
{
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #XL,
    serviceQuality: #C
  }
}
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view entity R_SubstanceBasedComponentTP 
  --Select data from basic view 'Chemical Component'
  as select from I_ChmlComponent as Component

  --Nodes/Detaildata;
  association to parent R_SubstanceBasedCompositionTP as _Composition on $projection.ChmlCompositionUUID = _Composition.ChmlCompositionUUID
  
  --Link to Substance
  association [0..1] to I_Substance        as _Substance           on $projection.SubstanceUUID = _Substance.SubstanceUUID
  
{
      --UUID of component      
  key Component.ChmlCompUUID,

      --UUID of chemical compliance information as root
      Component.ChmlCmplncInfoUUID,
      --UUID of substance as root
      Component.HostSubstanceUUID,

      --UUID of chemical composition
      Component.ChmlCompositionUUID,

      --Date/Time of creation
            --Date/Time of creation
      cast( Component.CreationUTCDateTime as ehfnd_bo_crea_date_time preserving type )   as CreationUTCDateTime,

      --Created by
      cast( Component.CreatedByUser as ehfnd_bo_crea_uname preserving type )             as CreatedByUser,

      --Date/Time of change
      cast( Component.LastChangeUTCDateTime as ehfnd_bo_lchg_date_time preserving type ) as LastChangeUTCDateTime,

      --Changed by
      cast( Component.LastChangedByUser as ehfnd_bo_lchg_uname preserving type )         as LastChangedByUser,
      
      --UUID of Substance
      Component.SubstanceUUID,

      Component.ChmlCompType,

      --Concentration of component
      Component.ChmlCompQty,

      --Concentration as text (for correct formatting with decimals exactly as entered by user)
      Component.ChmlCompQtyAsText,

      --Unit of measurment of concentration
      Component.ChmlCompQtyUnit,

      --Operator for Lower limit of concentration
      Component.ChmlCompOperatorLowerLimit,

      --Lower limit of concentration
      Component.ChmlCompQtyLowerLimit,

      --Lower limit as text (for correct formatting with decimals exactly as entered by user)
      Component.ChmlCompQtyLowerLimitAsText,

      --Operator for Upper limit of concentration
      Component.ChmlCompOperatorUpperLimit,      

      --Upper limit of concentration
      Component.ChmlCompQtyUpperLimit,

      --Upper limit as text (for correct formatting with decimals exactly as entered by user)
      Component.ChmlCompQtyUpperLimitAsText,
      
      --Is a component removed
      Component.ChmlCompIsRemoved,
    
      --Ref of polymer cmposition
      Component.PolymerCompositionIntIDRef,
      
      --Trade Secret Identity Is Masked
      Component.PCTrdScrtIdentityIsMasked,
            
      /* Associations */
      _Composition,
      
      _ChmlCmplncInfo,
      _HostSubstance,
      _Substance,
      _PolymerComposition,
      _ComponentType,
      _UnitOfMeasure,
      _OperatorLowerLimit,
      _OperatorUpperLimit
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCOMPONENT"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFO",
"I_CHMLCOMPONENTOPTRLOWRLMT",
"I_CHMLCOMPONENTOPTRUPRLMT",
"I_CHMLCOMPOSITION",
"I_CHMLCOMPTYPE",
"I_SUBSTANCE",
"I_UNITOFMEASURE",
"R_SUBSTANCEBASEDCOMPOSITIONTP"
],
"BASE":
[
"I_CHMLCOMPONENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/