I_ExternalStoreListingTP

DDL: I_EXTERNALSTORELISTINGTP Type: view_entity TRANSACTIONAL

Product Assignment to Store by External Source

I_ExternalStoreListingTP is a Transactional CDS View that provides data about "Product Assignment to Store by External Source" in SAP S/4HANA. It reads from 4 data sources (I_ExternalAssortmentModule, I_ProductToAssortmentModule, I_Site, I_AsstmtMdlUsrToAsstmtMdl_2) and exposes 9 fields with key fields AssortmentModuleUser, Product, ValidityStartDate, ValidityEndDate.

4 data source(s) 9 fields

Data Sources (4)

SourceAliasJoin Type
I_ExternalAssortmentModule ext_module inner
I_ProductToAssortmentModule product from
I_Site site inner
I_AsstmtMdlUsrToAsstmtMdl_2 user inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Product Assignment to Store by External Source view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name ListingCondition view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleUser I_AsstmtMdlUsrToAsstmtMdl_2 AssortmentModuleUser
KEY Product I_ProductToAssortmentModule Product
KEY ValidityStartDate I_ProductToAssortmentModule ValidityStartDate
KEY ValidityEndDate I_ProductToAssortmentModule ValidityEndDate
LastChangeDate I_ExternalAssortmentModule LastChangeDate
LastChangeDateTime I_ExternalAssortmentModule LastChangeDateTime
Site I_Site Site
SalesOrganization I_Site SalesOrganization
DistributionChannel I_Site DistributionChannel 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Product Assignment to Store by External Source'
@VDM: {
  viewType: #TRANSACTIONAL,

  lifecycle: {
    contract: {
      type: #SAP_INTERNAL_API
    }
  }
}
@ObjectModel: {
    usageType: {
        serviceQuality: #C,
        sizeCategory: #XL,
        dataClass: #MASTER
   },
   sapObjectNodeType.name: 'ListingCondition'
}
define root view entity I_ExternalStoreListingTP
  as select from I_ProductToAssortmentModule as product
    inner join   I_AsstmtMdlUsrToAsstmtMdl_2 as user       on product.AssortmentModuleUUID = user.AssortmentModuleObjectUUID
    inner join   I_ExternalAssortmentModule  as ext_module on ext_module.AssortmentModuleUUID = product.AssortmentModuleUUID
    inner join   I_Site                      as site       on site.SiteCustomer = user.AssortmentModuleUser
{
  key user.AssortmentModuleUser as AssortmentModuleUser,
  key product.Product           as Product,
  key product.ValidityStartDate as ValidityStartDate,
  key product.ValidityEndDate   as ValidityEndDate,
      ext_module.LastChangeDate,
      ext_module.LastChangeDateTime,
      site.Site                 as Site,
      site.SalesOrganization    as SalesOrganization,
      site.DistributionChannel  as DistributionChannel
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ASSTMTMDLUSRTOASSTMTMDL_2",
"I_EXTERNALASSORTMENTMODULE",
"I_PRODUCTTOASSORTMENTMODULE",
"I_SITE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More