I_UserToExplicitAsstmtModule

DDL: I_USERTOEXPLICITASSTMTMODULE SQL: IUSRSTOASMMDL Type: view COMPOSITE Package: RFM_ASSORTMENT_VDM

Assortment User Assignment to Assortment Module

I_UserToExplicitAsstmtModule is a Composite CDS View that provides data about "Assortment User Assignment to Assortment Module" in SAP S/4HANA. It reads from 1 data source (I_ExplicitAssortmentModule) and exposes 12 fields with key fields AssortmentModuleUUID, AssortmentModuleUser, AssortmentModuleName. It has 1 association to related views. Part of development package RFM_ASSORTMENT_VDM.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_ExplicitAssortmentModule ExplicitModule inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ExclsnRatioForAsstmtMdlUser _ExclusionRatio $projection.AssortmentModuleUUID = _ExclusionRatio.AssortmentModuleUUID and $projection.AssortmentModuleUser = _ExclusionRatio.AssortmentModuleUser

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IUSRSTOASMMDL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Assortment User Assignment to Assortment Module view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleUUID I_ExplicitAssortmentModule AssortmentModuleUUID
KEY AssortmentModuleUser AssortmentModuleUser
KEY AssortmentModuleName AssortmentModuleName
ValidityStartDate AssortmentModuleUser ValidityStartDate
ValidityEndDate AssortmentModuleUser ValidityEndDate
LastChangeDate AssortmentModuleUser LastChangeDate
LastChangeDateTime AssortmentModuleUser LastChangeDateTime
LastChangedByUserName AssortmentModuleUser LastChangedByUserName
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
_Site _Site
_ExclusionRatio _ExclusionRatio 
@AbapCatalog.sqlViewName: 'IUSRSTOASMMDL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'Assortment User Assignment to Assortment Module'

@VDM: {
  viewType: #COMPOSITE,

  lifecycle: {
    contract: {
      type: #NONE
    }
  }
}
@ObjectModel: {
    usageType: {
        serviceQuality: #C,
        sizeCategory: #M,
        dataClass: #MASTER
   }
}

define view I_UserToExplicitAsstmtModule
  as select distinct from I_AsstmtMdlUsrToAsstmtMdl as AssortmentModuleUser 
    inner join            I_ExplicitAssortmentModule as ExplicitModule on ExplicitModule.AssortmentModuleUUID = AssortmentModuleUser.AssortmentModuleObjectUUID

  association [0..1] to I_ExclsnRatioForAsstmtMdlUser as _ExclusionRatio on  $projection.AssortmentModuleUUID = _ExclusionRatio.AssortmentModuleUUID
                                                                         and $projection.AssortmentModuleUser = _ExclusionRatio.AssortmentModuleUser
{
  key ExplicitModule.AssortmentModuleUUID,
  key AssortmentModuleUser,
  key AssortmentModuleName,
      AssortmentModuleUser.ValidityStartDate,
      AssortmentModuleUser.ValidityEndDate,
      AssortmentModuleUser.LastChangeDate,
      AssortmentModuleUser.LastChangeDateTime,
      AssortmentModuleUser.LastChangedByUserName,

      /*Fields for DCL*/
      SalesOrganization,
      DistributionChannel,

      _Site,
      _ExclusionRatio
}

Learn More