I_AsstmtMdlUserProductExclsn

DDL: I_ASSTMTMDLUSERPRODUCTEXCLSN SQL: IASMPRODUSREXCL Type: view BASIC Package: RFM_ASSORTMENT_VDM

Product Exclusion from Assortment Module for Assortment User

I_AsstmtMdlUserProductExclsn is a Basic CDS View that provides data about "Product Exclusion from Assortment Module for Assortment User" in SAP S/4HANA. It reads from 2 data sources (rfm_asm_excl, t001w) and exposes 9 fields with key fields AssortmentModuleObjectUUID, Product, AssortmentModuleUser. It has 2 associations to related views. Part of development package RFM_ASSORTMENT_VDM.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
rfm_asm_excl exclusion from
t001w site inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Customer _Customer _Customer.Customer = $projection.AssortmentModuleUser
[1..1] I_Product _Product _Product.Product = $projection.Product

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IASMPRODUSREXCL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Product Exclusion from Assortment Module for Assortment User view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleObjectUUID object_guid
KEY Product article
KEY AssortmentModuleUser t001w kunnr
SalesOrganization t001w vkorg
DistributionChannel t001w vtweg
LastChangeDateTime last_changed_at
LastChangeDate
_Customer _Customer
_Product _Product 
@AbapCatalog.sqlViewName: 'IASMPRODUSREXCL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@EndUserText.label: 'Product Exclusion from Assortment Module for Assortment User'
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM: {
  viewType: #BASIC,

  lifecycle: {
    contract: {
      type: #PUBLIC_LOCAL_API
    }
  }
}
@ObjectModel: {
    usageType: {
        serviceQuality: #B,
        sizeCategory: #M,
        dataClass: #MASTER
   }
}
define view I_AsstmtMdlUserProductExclsn
  as select from rfm_asm_excl as exclusion
    inner join   t001w        as site on  exclusion.site = site.kunnr
                                      and (
                                         site.vlfkz      = 'A'
                                         or site.vlfkz   = 'B'
                                       )
                                      and site.achvm     is initial
  association [1..1] to I_Customer as _Customer on _Customer.Customer = $projection.AssortmentModuleUser
  association [1..1] to I_Product as _Product on _Product.Product = $projection.Product

{
  key object_guid     as AssortmentModuleObjectUUID,
  key article         as Product,
  key site.kunnr      as AssortmentModuleUser,

      site.vkorg      as SalesOrganization,
      site.vtweg      as DistributionChannel,
      last_changed_at as LastChangeDateTime,
      TSTMP_TO_DATS( last_changed_at, $session.user_timezone, $session.client, 'NULL' ) as LastChangeDate,
      _Customer,
      _Product
}

Learn More