C_ProdStoreToExplctAsstmtMdl

DDL: C_PRODSTORETOEXPLCTASSTMTMDL Type: view_entity CONSUMPTION

Product-Store Assignment via Assortment Module

C_ProdStoreToExplctAsstmtMdl is a Consumption CDS View that provides data about "Product-Store Assignment via Assortment Module" in SAP S/4HANA. It reads from 1 data source (R_ProdStoreToExplctAsstmtMdlTP) and exposes 10 fields with key fields AssortmentModuleUUID, Product, AssortmentModuleUser, AssignmentValidityStartDate.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
R_ProdStoreToExplctAsstmtMdlTP R_ProdStoreToExplctAsstmtMdlTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK 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 #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleUUID AssortmentModuleUUID
KEY Product
KEY AssortmentModuleUser AssortmentModuleUser
KEY AssignmentValidityStartDate AssignmentValidityStartDate
ProductIsMandatoryInAssortment ProductIsMandatoryInAssortment
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
DistributionChannel DistributionChannel
SalesOrganization SalesOrganization
ProductNamelocalized 
@AccessControl: {
  authorizationCheck: #CHECK
}

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

@ObjectModel: {
    usageType: {
        serviceQuality: #D,
        sizeCategory: #L,
        dataClass: #MASTER
   },
   sapObjectNodeType.name: 'ListingCondition'
}
@VDM: {
  viewType: #CONSUMPTION,
  usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE],
  lifecycle: {
    contract: {
      type: #PUBLIC_LOCAL_API
    }
  }
}
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations:true
define root view entity C_ProdStoreToExplctAsstmtMdl
  provider contract transactional_query
  as projection on R_ProdStoreToExplctAsstmtMdlTP
{
      @Semantics.uuid: true
  key AssortmentModuleUUID,
      @Consumption.semanticObject: 'Material'
      @ObjectModel.text.element: ['ProductName']
  key cast ( Product as productnumber preserving type ) as Product,
  key AssortmentModuleUser,
  key AssignmentValidityStartDate, 
      @Semantics.booleanIndicator: true
      ProductIsMandatoryInAssortment,
      ValidityStartDate,
      ValidityEndDate,
      @Consumption.hidden: true
      DistributionChannel,
      @Consumption.hidden: true
      SalesOrganization,
      @Semantics.text: true
      _Product._Text.ProductName  : localized,

      _User : redirected to C_UserToExplicitAsstmtMdl
}
where
  ProductIsExcludedForStore = ' ';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCT",
"I_PRODUCTTEXT",
"R_PRODSTORETOEXPLCTASSTMTMDLTP"
],
"ASSOCIATED":
[
"C_USERTOEXPLICITASSTMTMDL",
"I_ASSMDLUSERTOEXPLCTASSMDLTP_2"
],
"BASE":
[
"R_PRODSTORETOEXPLCTASSTMTMDLTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More