C_StoreAssgblToExplctAsstmtMdl

@EndUserText.label: 'Store Assignable to Assortment Module'

@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations:true

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

@VDM: {
  viewType: #CONSUMPTION,
  usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE],

  lifecycle: {
    contract: {
      type: #PUBLIC_LOCAL_API
    }
  }
}
@ObjectModel: {
    usageType: {
        serviceQuality: #C,
        sizeCategory: #L,
        dataClass: #MASTER
   },
   sapObjectNodeType.name: 'RetailSite'
}

define root view entity C_StoreAssgblToExplctAsstmtMdl
  provider contract transactional_query
  as projection on I_StoreAssgblToExplctModuleTP
{
      @ObjectModel.text.element: ['StoreName']
      @Consumption: { semanticObject: 'Site' }
      @Consumption.valueHelpDefinition: [ {  entity: { name: 'I_StoreValueHelp' , element: 'Site'  } } ]
//      @EndUserText.quickInfo: 'Store'

  key cast ( Site as rfm_asm_store preserving type )        as Site,
      @Semantics.text: true
      SiteName                                              as StoreName,
      @Consumption.filter.hidden: true
      cast ( SiteCustomer as rfm_asm_store_customer preserving type ) as SiteCustomer,
      StoreIsAssignedToAnyModule,
      @Consumption.valueHelpDefinition: [ {  entity: { name: 'C_SalesOrganizationValueHelp' , element: 'SalesOrganization'  }} ]
      SalesOrganization,
      @Consumption.valueHelpDefinition: [ {  entity: { name: 'C_SalesOrganizationDistrChnlVH' , element: 'DistributionChannel'  },
                                             additionalBinding: [{ element: 'SalesOrganization', localElement: 'SalesOrganization' } ] } ] 
      DistributionChannel,
      PostalCode,
      @ObjectModel.text.element: ['CountryName']
      @Consumption.valueHelpDefinition: [ {  entity: { name: 'I_CountryVH' , element: 'Country'  } } ]
      cast ( Country as rfm_asm_country preserving type )   as Country,
      @Semantics.text: true
      CountryName,

      //  Foreign Key Associations

      _Customer,
      _SalesOrganization,
      _DistributionChannel,
      _UsrToExplctAsstmtMdlAssgmt : redirected to C_UserToExplicitAsstmtMdl
} where SiteCustomer is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STOREASSGBLTOEXPLCTMODULETP"
],
"ASSOCIATED":
[
"C_USERTOEXPLICITASSTMTMDL",
"I_ASSMDLUSERTOEXPLCTASSMDLTP_2",
"I_CUSTOMER",
"I_DISTRIBUTIONCHANNEL",
"I_SALESORGANIZATION"
],
"BASE":
[
"I_STOREASSGBLTOEXPLCTMODULETP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/