R_ProdMatlBsdBeforeProdnCompTP

@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Before Prodn Comp in Mat Bsd Cmpstn - TP'
@ObjectModel:
{
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #XL,
    serviceQuality: #C
  }
}
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view entity R_ProdMatlBsdBeforeProdnCompTP
  --Select data from basic view
  as select from I_MatlBasedCmpstnComponent as Component

  --Nodes/Detaildata;
  association to parent R_ProdMatlBasedCompositionTP as _Composition on $projection.ChmlCompositionUUID = _Composition.ChmlCompositionUUID

{
      --UUID of component
  key Component.MatlBsdCompUUID                                                          as 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,

      //      --Component that available before production

      //      Component.MatlBsdCompProductionType,


      --UUID of component contained in material based composition
      Component.CompChmlCmplncInfoUUID,

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


      /* Associations */
      _Composition,

      _ChmlCmplncInfo,
      _CompChmlCmplncInfo,

      _UnitOfMeasure,
      _OperatorLowerLimit,
      _OperatorUpperLimit
}
where
  Component.MatlBsdCompProductionType = 'I'