C_ProdAssgblToStoreVH

DDL: C_PRODASSGBLTOSTOREVH SQL: CPRODASGBLTOSTR Type: view CONSUMPTION

Product Assignable to Store

C_ProdAssgblToStoreVH is a Consumption CDS View that provides data about "Product Assignable to Store" in SAP S/4HANA. It reads from 1 data source (I_ProductVH) and exposes 21 fields with key field Product.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductVH I_ProductVH from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CPRODASGBLTOSTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Product Assignable to Store view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey Product view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Consumption.ranked true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Product Product
_Text _Text
ProductExternalID ProductExternalID
IndustrySector IndustrySector
ProductType ProductType
_ProductType _ProductType
ProductGroup ProductGroup
_ProductGroup _ProductGroup
BaseUnit BaseUnit
_BaseUnit _BaseUnit
GrossWeight GrossWeight
NetWeight NetWeight
WeightUnit WeightUnit
_WeightUnit _WeightUnit
ManufacturerNumber ManufacturerNumber
AuthorizationGroup AuthorizationGroup
IsBatchManagementRequired IsBatchManagementRequired
ProductManufacturerNumber ProductManufacturerNumber
ArticleCategory ArticleCategory
_ProductCategory _ProductCategory
_ProductPlant _ProductPlant 
@AbapCatalog.sqlViewName: 'CPRODASGBLTOSTR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Product Assignable to Store'
@Search.searchable: true
@AccessControl.privilegedAssociations: ['_Text']
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
  representativeKey: 'Product',
  dataCategory: #VALUE_HELP,
  usageType: {
    serviceQuality: #C,
    sizeCategory : #XXL,
    dataClass: #MASTER
  }
}
@Consumption.ranked: true
define view C_ProdAssgblToStoreVH
  as select from I_ProductVH
{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @ObjectModel.text.association: '_Text'
      @Search.ranking: #HIGH
  key Product,
      @Search.ranking: #LOW
      _Text,
      @Search.defaultSearchElement: true
      @Consumption.hidden: true
      @Search.ranking: #LOW
      ProductExternalID,
      @UI.hidden: true
      @Search.ranking: #LOW
      IndustrySector as IndustrySector,
      @Search.ranking: #LOW
      ProductType,
      @Search.ranking: #LOW
      _ProductType,
      @Search.ranking: #LOW
      ProductGroup,
      @Search.ranking: #LOW
      _ProductGroup,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_BaseUnit'
      @Search.ranking: #LOW
      BaseUnit,
      _BaseUnit,

      @Semantics.quantity.unitOfMeasure: 'WeightUnit'
      @DefaultAggregation: #NONE
      @UI.hidden: true
      @Search.ranking: #LOW
      GrossWeight,

      @Semantics.quantity.unitOfMeasure: 'WeightUnit'
      @DefaultAggregation: #NONE
      @UI.hidden: true
      @Search.ranking: #LOW
      NetWeight,

      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_WeightUnit'
      @UI.hidden: true
      @Search.ranking: #LOW
      WeightUnit,
      _WeightUnit,
      @UI.hidden: true
      @Search.ranking: #LOW
      ManufacturerNumber,
      @Consumption.hidden: true
      @Search.ranking: #LOW
      AuthorizationGroup,
      @Search.ranking: #LOW
      IsBatchManagementRequired,
      @Search.ranking: #LOW
      @UI.hidden: true
      ProductManufacturerNumber,
      @Search.ranking: #LOW
      @ObjectModel.foreignKey.association: '_ProductCategory'
      ArticleCategory,
      @Search.ranking: #LOW
      @Consumption.filter.hidden: true
      _ProductCategory,
      _ProductPlant
      
}
where
     ArticleCategory = '00'
  or ArticleCategory = '02'
  or ArticleCategory = '10'
  or ArticleCategory = '11'
  or ArticleCategory = '12'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTVH"
],
"ASSOCIATED":
[
"I_PRODUCTCATEGORYVH",
"I_PRODUCTDESCRIPTION",
"I_PRODUCTGROUP",
"I_PRODUCTPLANT",
"I_PRODUCTTYPE",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_PRODUCTVH"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More