I_AssortmentUser

DDL: I_ASSORTMENTUSER SQL: IASSORTMENTUSER Type: view BASIC Package: RFM_ASSORTMENT_MODULE_LEG_VDM

Assortment User

I_AssortmentUser is a Basic CDS View that provides data about "Assortment User" in SAP S/4HANA. It reads from 1 data source (wrsz) and exposes 9 fields with key fields Assortment, SequenceNumber. It has 3 associations to related views. Part of development package RFM_ASSORTMENT_MODULE_LEG_VDM.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
wrsz wrsz from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Assortment _Assortment $projection.Assortment = _Assortment.Assortment
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_Site _Site $projection.SiteCustomer = _Site.SiteCustomer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IASSORTMENTUSER view
EndUserText.label Assortment User view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.representativeKey SequenceNumber view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Assortment asort
KEY SequenceNumber lfdnr
Customer kunnr
SiteCustomer locnr
ValidityStartDate datab
ValidityEndDate datbi
_Assortment _Assortment
_Customer _Customer
_Site _Site 
@AbapCatalog.sqlViewName: 'IASSORTMENTUSER'
@EndUserText.label: 'Assortment User'

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl: {
    authorizationCheck: #CHECK,
    personalData.blocking: #REQUIRED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC
@ObjectModel: {
    representativeKey: 'SequenceNumber',
    usageType: {
        serviceQuality: #A,
        sizeCategory: #L,
        dataClass: #MASTER
   }
}

define view I_AssortmentUser
  as select from wrsz
  association [1..1] to I_Assortment as _Assortment on $projection.Assortment = _Assortment.Assortment
  association [1..1] to I_Customer   as _Customer   on $projection.Customer = _Customer.Customer
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
  association [0..1] to I_Site       as _Site       on $projection.SiteCustomer = _Site.SiteCustomer
{
      @ObjectModel.foreignKey.association: '_Assortment'
  key asort   as Assortment,
  key lfdnr   as SequenceNumber,

      @ObjectModel.foreignKey.association: '_Customer'
      kunnr   as Customer,
      @ObjectModel.foreignKey.association: '_Customer'
      locnr   as SiteCustomer,

      @Semantics.businessDate.from: true
      datab   as ValidityStartDate,
      @Semantics.businessDate.to: true
      datbi   as ValidityEndDate,

      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
      _Assortment,
      _Customer,
      _Site
}

Learn More