I_AsstmtMdlMDGenerationError_2

DDL: I_ASSTMTMDLMDGENERATIONERROR_2 Type: view_entity BASIC Package: RFM_ASSORTMENT_VDM

Error During Assortment Postprocessing

I_AsstmtMdlMDGenerationError_2 is a Basic CDS View that provides data about "Error During Assortment Postprocessing" in SAP S/4HANA. It reads from 2 data sources (I_Product, rfm_asm_error2) and exposes 16 fields with key fields AssortmentModuleUser, Product, ProductOfSuprordLstgCondition. It has 3 associations to related views. Part of development package RFM_ASSORTMENT_VDM.

Data Sources (2)

SourceAliasJoin Type
I_Product I_Product inner
rfm_asm_error2 rfm_asm_error2 from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Product _Product $projection.Product = _Product.Product
[0..1] I_Site _Site $projection.AssortmentModuleUser = _Site.SiteCustomer
[0..1] I_UserContactCard _Processor _Processor.ContactCardID = $projection.Processor

Annotations (6)

NameValueLevelField
EndUserText.label Error During Assortment Postprocessing view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleUser rfm_asm_error2 asm_user
KEY Product rfm_asm_error2 article
KEY ProductOfSuprordLstgCondition rfm_asm_error2 structured_article
SystemMessageClass rfm_asm_error2 message_id
SystemMessageNumber rfm_asm_error2 message_number
SystemMessageVariable1 rfm_asm_error2 message_var1
SystemMessageVariable2 rfm_asm_error2 message_var2
SystemMessageVariable3 rfm_asm_error2 message_var3
SystemMessageVariable4 rfm_asm_error2 message_var4
LatestMasterDataGenerationDate rfm_asm_error2 latest_md_gen_date
Processor rfm_asm_error2 processor
LastChangeDateTime rfm_asm_error2 last_changed_at
MasterDataGenerationIsRunning rfm_asm_error2 md_gen_is_running
_Product _Product
_Site _Site
_Processor _Processor
@EndUserText.label: 'Error During Assortment Postprocessing'
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType: {
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #BASIC
define view entity I_AsstmtMdlMDGenerationError_2
  as select from rfm_asm_error2
    inner join   I_Product on  I_Product.Product             = rfm_asm_error2.article
                           and I_Product.IsMarkedForDeletion is initial

  association [1..1] to I_Product         as _Product   on $projection.Product = _Product.Product
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
  association [0..1] to I_Site            as _Site      on $projection.AssortmentModuleUser = _Site.SiteCustomer
  association [0..1] to I_UserContactCard as _Processor on _Processor.ContactCardID = $projection.Processor
{
  key rfm_asm_error2.asm_user           as AssortmentModuleUser,
  key rfm_asm_error2.article            as Product,
  key rfm_asm_error2.structured_article as ProductOfSuprordLstgCondition,
      rfm_asm_error2.message_id         as SystemMessageClass,
      rfm_asm_error2.message_number     as SystemMessageNumber,
      rfm_asm_error2.message_var1       as SystemMessageVariable1,
      rfm_asm_error2.message_var2       as SystemMessageVariable2,
      rfm_asm_error2.message_var3       as SystemMessageVariable3,
      rfm_asm_error2.message_var4       as SystemMessageVariable4,
      rfm_asm_error2.latest_md_gen_date as LatestMasterDataGenerationDate,
      rfm_asm_error2.processor          as Processor,
      rfm_asm_error2.last_changed_at    as LastChangeDateTime,
      rfm_asm_error2.md_gen_is_running  as MasterDataGenerationIsRunning,
      _Product,
      _Site,
      _Processor
}