C_ProductToAssortmentMdlVersTP

DDL: C_PRODUCTTOASSORTMENTMDLVERSTP Type: view_entity CONSUMPTION

Product Assignment to Assortment Module Version

C_ProductToAssortmentMdlVersTP is a Consumption CDS View that provides data about "Product Assignment to Assortment Module Version" in SAP S/4HANA. It reads from 1 data source (I_ProdToExplctAsstmtMdlVersTP) and exposes 14 fields with key fields AssortmentModuleUUID, Product, ValidityStartDate, ValidityEndDate.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_ProdToExplctAsstmtMdlVersTP I_ProdToExplctAsstmtMdlVersTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Product Assignment to Assortment Module Version view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
ObjectModel.representativeKey AssortmentModuleUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
Search.searchable true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleUUID AssortmentModuleUUID
KEY Product Product
KEY ValidityStartDate ValidityStartDate
KEY ValidityEndDate ValidityEndDate
ProductIsMandatoryInAssortment ProductIsMandatoryInAssortment
AssortmentModuleName AssortmentModuleName
ProductNamelocalized
LastChangeDateTime LastChangeDateTime
LastChangedByUserName LastChangedByUserName
AsstmtMdlUserExclusionPercent _ExclusionRatio AsstmtMdlUserExclusionPercent
_ExplctAssortmentMdlProduct _ExplctAssortmentMdlProduct
_ExplicitAssortmentModuleVers _ExplicitAssortmentModuleVers
_User _User
AssortmentModuleObjectUUID AssortmentModuleObjectUUID 
@EndUserText.label: 'Product Assignment to Assortment Module Version'
@AccessControl.authorizationCheck: #CHECK
@Metadata.allowExtensions: true
@ObjectModel: {
    representativeKey: 'AssortmentModuleUUID',
    semanticKey: ['Product'],
    usageType : {
      serviceQuality: #C,
      sizeCategory: #L,
      dataClass: #MASTER
    }
}
@AccessControl: {
  privilegedAssociations: ['_User']
}
@VDM.viewType: #CONSUMPTION
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@Search.searchable: true
define view entity C_ProductToAssortmentMdlVersTP
  as projection on I_ProdToExplctAsstmtMdlVersTP
{
  key AssortmentModuleUUID,

      @ObjectModel.text.element: ['ProductName']
      @Consumption.semanticObject: 'Material'
      @Consumption.valueHelpDefinition: [{entity: {name: 'C_ProdAssgblToStoreVH', element: 'Product'}}]
  key Product,

      @Semantics.dateTime: true
  key ValidityStartDate,

      @Semantics.dateTime: true
  key ValidityEndDate,

      @Semantics.booleanIndicator: true
      ProductIsMandatoryInAssortment,

      @UI.hidden: true
      AssortmentModuleName,
      _Product._Text.ProductName : localized,

      @Semantics.dateTime: true
      LastChangeDateTime,

      @Semantics.user.lastChangedBy: true
      @Semantics.user.id: true
      LastChangedByUserName,

      _ExclusionRatio.AsstmtMdlUserExclusionPercent,

      /* Associations */
      _ExplctAssortmentMdlProduct,
      _ExplicitAssortmentModuleVers,
      _User,
      AssortmentModuleObjectUUID,
      _ProdToExplicitAsstmtMdl : redirected to parent C_ProdToExplicitAsstmtMdl
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EXCLSNRATIOFORASSTMTMDLPROD",
"I_PRODTOEXPLCTASSTMTMDLVERSTP",
"I_PRODUCT",
"I_PRODUCTTEXT"
],
"ASSOCIATED":
[
"C_PRODTOEXPLICITASSTMTMDL",
"I_EXPLICITASSTMTMDLVERSIONTP",
"I_PRODASSGBLTOEXPLCTMODULETP",
"I_PRODTOEXPLICITASSTMTMDLTP",
"I_USERCONTACTCARD"
],
"BASE":
[
"I_PRODTOEXPLCTASSTMTMDLVERSTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More