I_Assortment

DDL: I_ASSORTMENT SQL: IASSORTMENT Type: view BASIC Package: RFM_ASSORTMENT_MODULE_LEG_VDM

Assortment

I_Assortment is a Basic CDS View that provides data about "Assortment" in SAP S/4HANA. It reads from 1 data source (wrs1) and exposes 14 fields with key field Assortment. It has 6 associations to related views. Part of development package RFM_ASSORTMENT_MODULE_LEG_VDM.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
wrs1 wrs1 from

Associations (6)

CardinalityTargetAliasCondition
[0..*] I_AssortmentT _Text $projection.Assortment = _Text.Assortment
[0..*] I_AssortmentUser _AssortmentUser $projection.Assortment = _AssortmentUser.Assortment
[1..1] I_AssortmentCategory _AssortmentCategory $projection.AssortmentCategory = _AssortmentCategory.AssortmentCategory
[1..1] I_AssortmentStatus _AssortmentStatus $projection.AssortmentStatus = _AssortmentStatus.AssortmentStatus
[1..1] I_SalesOrganization _SalesOrganization $projection.SalesOrganization = _SalesOrganization.SalesOrganization
[1..1] I_DistributionChannel _DistributionChannel $projection.DistributionChannel = _DistributionChannel.DistributionChannel

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IASSORTMENT view
EndUserText.label Assortment view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey Assortment view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Assortment asort
AssortmentCategory sotyp
AssortmentStatus statu
LstgCndnForAsstmtIsToBeCrted
ValidityStartDate datab
ValidityEndDate datbi
SalesOrganization vkorg
DistributionChannel vtweg
_Text _Text
_AssortmentUser _AssortmentUser
_AssortmentCategory _AssortmentCategory
_AssortmentStatus _AssortmentStatus
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel 
@AbapCatalog.sqlViewName: 'IASSORTMENT'
@EndUserText.label: 'Assortment'

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true 
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC
@ObjectModel: {
    compositionRoot: true,
    representativeKey: 'Assortment',
    usageType: {
        serviceQuality: #A,
        sizeCategory: #M,
        dataClass: #MASTER
   }
}

define view I_Assortment
  as select from wrs1
  association [0..*] to I_AssortmentT         as _Text                on $projection.Assortment = _Text.Assortment
  association [0..*] to I_AssortmentUser      as _AssortmentUser      on $projection.Assortment = _AssortmentUser.Assortment
  association [1..1] to I_AssortmentCategory  as _AssortmentCategory  on $projection.AssortmentCategory = _AssortmentCategory.AssortmentCategory
  association [1..1] to I_AssortmentStatus    as _AssortmentStatus    on $projection.AssortmentStatus = _AssortmentStatus.AssortmentStatus
  association [1..1] to I_SalesOrganization   as _SalesOrganization   on $projection.SalesOrganization = _SalesOrganization.SalesOrganization
  association [1..1] to I_DistributionChannel as _DistributionChannel on $projection.DistributionChannel = _DistributionChannel.DistributionChannel
{
      @ObjectModel.text.association: '_Text'
  key asort                                                        as Assortment,

      @ObjectModel.foreignKey.association: '_AssortmentCategory'
      sotyp                                                        as AssortmentCategory,

      @ObjectModel.foreignKey.association: '_AssortmentStatus'
      statu                                                        as AssortmentStatus,

      cast(kzlik as lstgcndnforasstmtistobecrted preserving type)  as LstgCndnForAsstmtIsToBeCrted,

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

      @ObjectModel.foreignKey.association: '_SalesOrganization'
      vkorg                                                        as SalesOrganization,
      @ObjectModel.foreignKey.association: '_DistributionChannel'
      vtweg                                                        as DistributionChannel,

      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Text,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _AssortmentUser,
      _AssortmentCategory,
      _AssortmentStatus,
      _SalesOrganization,
      _DistributionChannel
}

Learn More