C_SlsDocItemStorageLocationVH

DDL: C_SLSDOCITEMSTORAGELOCATIONVH Type: view CONSUMPTION

Storage Location

C_SlsDocItemStorageLocationVH is a Consumption CDS View that provides data about "Storage Location" in SAP S/4HANA. It reads from 1 data source (I_ProductStorageLocation) and exposes 4 fields with key fields Product, Plant, StorageLocation.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductStorageLocation _ProductStorageLocation from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CSLSITMSTORLOCVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Consumption.ranked true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey StorageLocation view
Consumption.valueHelpDefault.fetchValues #AUTOMATICALLY_WHEN_DISPLAYED view
EndUserText.label Storage Location view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Product
KEY Plant I_ProductStorageLocation Plant
KEY StorageLocation I_ProductStorageLocation StorageLocation
StorageLocationName 
@AbapCatalog:{
  sqlViewName: 'CSLSITMSTORLOCVH',
  compiler.compareFilter: true,
  preserveKey: true }

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION

@Search: {
  searchable: true
}

@Consumption.ranked: true

@ObjectModel:{
  usageType:{
    dataClass: #MASTER,
    serviceQuality: #A,
    sizeCategory: #L},
  dataCategory: #VALUE_HELP}

@ObjectModel.representativeKey: 'StorageLocation'
@Consumption.valueHelpDefault.fetchValues:#AUTOMATICALLY_WHEN_DISPLAYED

@EndUserText.label: 'Storage Location'
define view C_SlsDocItemStorageLocationVH
  as select from I_ProductStorageLocation as _ProductStorageLocation
{ 
      
         @UI: {
          selectionField: [{ position: 30 }],
          lineItem:[ {position:30, importance: #HIGH} ]
         }   
  key    cast(_ProductStorageLocation.Product as productnumber preserving type ) as Product,

         @UI: {
          selectionField: [{ position: 40 }],
          lineItem:[ {position:40, importance: #HIGH} ]
         } 
  key    _ProductStorageLocation.Plant,
  
         @Search: { 
           defaultSearchElement: true,
           ranking: #HIGH,
           fuzzinessThreshold: 0.8 }   
         @ObjectModel.text.element:  [ 'StorageLocationName' ]
         @UI: {
          selectionField: [{ position: 10 }],
          lineItem:[ {position:10, importance: #HIGH} ]
         }
  key    _ProductStorageLocation.StorageLocation,
  
         @Search: {
           defaultSearchElement: true,
           ranking: #LOW,
           fuzzinessThreshold: 0.8 }
         @UI: {
          selectionField: [{ position: 20 }],
          lineItem:[ {position:20, importance: #HIGH} ]
         }
        _ProductStorageLocation._StorageLocation.StorageLocationName
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTSTORAGELOCATION",
"I_STORAGELOCATION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More