I_ProdToExplicitAsstmtMdlTP

@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}

@EndUserText.label: 'Product Assignment to Assortment Module'

@ObjectModel: {
    usageType: {
        serviceQuality: #C,
        sizeCategory: #L,
        dataClass: #MASTER
   },
   sapObjectNodeType.name: 'AssortmentModuleProductAssgmt'
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle: {
    contract: {
      type: #SAP_INTERNAL_API
    }
  }
}

define root view entity I_ProdToExplicitAsstmtMdlTP
  as select from I_ProdToExplicitAsstmtModule
  association [1..1] to I_ProdAssgblToExplctModuleTP  as _AssignableProduct on $projection.Product = _AssignableProduct.Product
  composition [1..*] of I_ProdToExplctAsstmtMdlVersTP as _ProdToExplctMdlVers 
{
  key AssortmentModuleUUID,
  key Product,
  key AssortmentModuleName,
      ProductIsMandatoryInAssortment,
      cast ( coalesce ( _ExclusionRatio.RatioOfUsersWhoExcludedProdVal, '0%' ) as rfm_asm_usr_prod_excl_percent preserving type ) as RatioOfUsersWhoExcludedProdVal,
      ValidityStartDate,
      ValidityEndDate,
      LastChangeDate,
      LastChangeDateTime,
      _ModuleVersion,
      _Text,
      _Product,
      _AssignableProduct,
      _ProdToExplctMdlVers
}