R_ProdMatlBsdProducedSubstTP

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

  --Nodes/Detaildata;
  association to parent R_ProdMatlBasedCompositionTP 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 chemical composition
      Component.ChmlCompositionUUID,

      --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,

      --Ref of polymer cmposition
      Component.PolymerCompositionIntIDRef,

      /* Associations */
      _Composition,

      _ChmlCmplncInfo,
      _Substance,      
      _PolymerComposition,
      _ComponentType,
      _UnitOfMeasure,
      _OperatorLowerLimit,
      _OperatorUpperLimit
}