C_AssortmentModuleUserVH

DDL: C_ASSORTMENTMODULEUSERVH Type: view_entity CONSUMPTION

Assortment User

C_AssortmentModuleUserVH is a Consumption CDS View that provides data about "Assortment User" in SAP S/4HANA. It reads from 2 data sources (I_Site, I_SiteOpeningHours) and exposes 9 fields with key field Site.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_Site Site from
I_SiteOpeningHours SiteOpeningHours inner

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Assortment User view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Site I_Site Site
SiteCustomer I_Site SiteCustomer
SiteName I_Site SiteName
SiteCategory I_Site SiteCategory
SiteCategoryName
SalesOrganization I_Site SalesOrganization
SalesOrganizationName
DistributionChannel I_Site DistributionChannel
DistributionChannelName 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Assortment User'
@Metadata: {
  allowExtensions: true,
  ignorePropagatedAnnotations: true
}
@ObjectModel: {
  dataCategory: #VALUE_HELP,
  usageType: {
    serviceQuality: #C,
    sizeCategory: #M,
    dataClass: #MASTER
  }
}
@Search.searchable: true
@VDM.viewType: #CONSUMPTION
define view entity C_AssortmentModuleUserVH
  as select from I_Site as Site
  inner join I_SiteOpeningHours as SiteOpeningHours  on  Site.SiteCustomer = SiteOpeningHours.SiteCustomer
{
      @ObjectModel.text.element: ['SiteName']
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key Site.Site,

      @ObjectModel.text.element: ['SiteName']
      Site.SiteCustomer,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @Semantics.text:true
      Site.SiteName,

      @Consumption.valueHelpDefinition: [{entity.name: 'I_SiteCategory', entity.element: 'SiteCategory'}]
      @Consumption.filter.defaultValue: 'A' // default filter set to Site

      Site.SiteCategory,

      @Consumption.filter.hidden: true
      Site._SiteCategory._Text[1: Language=$session.system_language].SiteCategoryName,

      @Consumption.valueHelpDefinition: [{entity.name: 'I_SalesOrganization', entity.element: 'SalesOrganization'}]
      Site.SalesOrganization,

      @Consumption.filter.hidden: true
      Site._SalesOrganization._Text[1: Language=$session.system_language].SalesOrganizationName,

      @Consumption.valueHelpDefinition: [{entity.name: 'I_DistributionChannel', entity.element: 'DistributionChannel'}]
      Site.DistributionChannel,

      @Consumption.filter.hidden: true
      Site._DistributionChannel._Text[1: Language=$session.system_language].DistributionChannelName
} where Site.IsMarkedForArchiving is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DISTRIBUTIONCHANNEL",
"I_DISTRIBUTIONCHANNELTEXT",
"I_SALESORGANIZATION",
"I_SALESORGANIZATIONTEXT",
"I_SITE",
"I_SITECATEGORY",
"I_SITECATEGORYTEXT",
"I_SITEOPENINGHOURS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More