R_ProdStoreToExplctAsstmtMdlTP

DDL: R_PRODSTORETOEXPLCTASSTMTMDLTP Type: view_entity TRANSACTIONAL

Product-Store Assignment via Assortment Module

R_ProdStoreToExplctAsstmtMdlTP is a Transactional CDS View that provides data about "Product-Store Assignment via Assortment Module" in SAP S/4HANA. It has 1 association to related views.

13 fields

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_AssMdlUserToExplctAssMdlTP_2 _User $projection.AssortmentModuleUUID = _User.AssortmentModuleUUID and $projection.AssortmentModuleUser = _User.AssortmentModuleUser and $projection.AssignmentValidityStartDate = _User.ValidityStartDate

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Product-Store Assignment via Assortment Module view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name ListingCondition view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleUUID I_ProdToExplicitAsstmtModule AssortmentModuleUUID
KEY Product I_ProdToExplicitAsstmtModule Product
KEY AssortmentModuleUser _UserAssignment AssortmentModuleUser
KEY AssignmentValidityStartDate _UserAssignment ValidityStartDate
ProductIsMandatoryInAssortment I_ProdToExplicitAsstmtModule ProductIsMandatoryInAssortment
ValidityStartDate I_ProdToExplicitAsstmtModule ValidityStartDate
ValidityEndDate I_ProdToExplicitAsstmtModule ValidityEndDate
_Text I_ProdToExplicitAsstmtModule _Text
ProductIsExcludedForStore
SalesOrganization _UserAssignment SalesOrganization
DistributionChannel _UserAssignment DistributionChannel
_User _User
_Product I_ProdToExplicitAsstmtModule _Product 
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}

@EndUserText.label: 'Product-Store Assignment via Assortment Module'

@ObjectModel: {
    usageType: {
        serviceQuality: #D,
        sizeCategory: #L,
        dataClass: #MASTER
   },
   sapObjectNodeType.name: 'ListingCondition'
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle: {
    contract: {
      type: #SAP_INTERNAL_API
    }
  }
}

define root view entity R_ProdStoreToExplctAsstmtMdlTP
  as select distinct from I_ProdToExplicitAsstmtModule
    left outer to many join I_AssMdlUserToExplctAssMdlTP_2 as _UserAssignment on I_ProdToExplicitAsstmtModule.AssortmentModuleUUID = _UserAssignment.AssortmentModuleUUID
    left outer to one join  I_AsstmtMdlUsrProdExclsnTP_2  as _Exclusion      on  I_ProdToExplicitAsstmtModule.AssortmentModuleUUID = _Exclusion.AssortmentModuleUUID
                                                                              and I_ProdToExplicitAsstmtModule.Product              = _Exclusion.Product
                                                                              and _UserAssignment.AssortmentModuleUser              = _Exclusion.AssortmentModuleUser
association [1..*] to I_AssMdlUserToExplctAssMdlTP_2 as _User on $projection.AssortmentModuleUUID = _User.AssortmentModuleUUID
                                                             and $projection.AssortmentModuleUser = _User.AssortmentModuleUser
                                                             and $projection.AssignmentValidityStartDate = _User.ValidityStartDate
{
  key I_ProdToExplicitAsstmtModule.AssortmentModuleUUID,
  key I_ProdToExplicitAsstmtModule.Product,
  key _UserAssignment.AssortmentModuleUser,
  key _UserAssignment.ValidityStartDate as AssignmentValidityStartDate,
      I_ProdToExplicitAsstmtModule.ProductIsMandatoryInAssortment,
      I_ProdToExplicitAsstmtModule.ValidityStartDate,
      I_ProdToExplicitAsstmtModule.ValidityEndDate,
      I_ProdToExplicitAsstmtModule._Text,
      case when coalesce( _Exclusion.AssortmentModuleUser, ' ' ) = ' ' then ' ' else 'X' end as ProductIsExcludedForStore,
      
      _UserAssignment.SalesOrganization,
      _UserAssignment.DistributionChannel,
      
      _User,
      I_ProdToExplicitAsstmtModule._Product as _Product
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ASSMDLUSERTOEXPLCTASSMDLTP_2",
"I_ASSTMTMDLUSRPRODEXCLSNTP_2",
"I_PRODTOEXPLICITASSTMTMODULE"
],
"ASSOCIATED":
[
"I_ASSMDLUSERTOEXPLCTASSMDLTP_2",
"I_ASSORTMENTMODULETEXT",
"I_PRODUCT"
],
"BASE":
[
"I_PRODTOEXPLICITASSTMTMODULE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More