C_Productstoragelocationref

DDL: C_PRODUCTSTORAGELOCATIONREF SQL: CPRDSTORAGEREF Type: view CONSUMPTION

Storage location for references

C_Productstoragelocationref is a Consumption CDS View that provides data about "Storage location for references" in SAP S/4HANA. It reads from 1 data source (P_Productstoragelocationref) and exposes 9 fields with key fields Product, Plant, StorageLocation. It has 2 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
P_Productstoragelocationref Plant from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Plant _PlantValueHelp $projection.Plant = _PlantValueHelp.Plant
[0..1] I_StorageLocation _StorageLocation $projection.StorageLocation = _StorageLocation.StorageLocation and $projection.Plant = _StorageLocation.Plant

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CPRDSTORAGEREF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Storage location for references view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Product P_Productstoragelocationref Product
KEY Plant P_Productstoragelocationref Plant
KEY StorageLocation P_Productstoragelocationref StorageLocation
PlantCategory P_Productstoragelocationref PlantCategory
ReferenceDistributionCenter P_Productstoragelocationref ReferenceDistributionCenter
ReferenceStore P_Productstoragelocationref ReferenceStore
_PlantValueHelp _PlantValueHelp
_StorageLocation _StorageLocation
_Product _Product 
@AbapCatalog.sqlViewName: 'CPRDSTORAGEREF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Storage location for references'
@Search.searchable: true
@VDM.viewType: #CONSUMPTION

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass: #MIXED
define view C_Productstoragelocationref
  as select from P_Productstoragelocationref as Plant
  association [0..1] to I_Plant           as _PlantValueHelp  on  $projection.Plant = _PlantValueHelp.Plant


  association [0..1] to I_StorageLocation as _StorageLocation on  $projection.StorageLocation = _StorageLocation.StorageLocation
                                                              and $projection.Plant           = _StorageLocation.Plant


{

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key Plant.Product,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @ObjectModel.foreignKey.association:'_PlantValueHelp'
  key Plant.Plant,
      @ObjectModel.foreignKey.association:'_StorageLocation'
  key Plant.StorageLocation,
      Plant.PlantCategory,
      Plant.ReferenceDistributionCenter,
      Plant.ReferenceStore,
      _PlantValueHelp,
      _StorageLocation,
      _Product


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PRODUCTSTORAGELOCATIONREF"
],
"ASSOCIATED":
[
"I_PLANT",
"I_PRODUCT",
"I_STORAGELOCATION"
],
"BASE":
[
"P_PRODUCTSTORAGELOCATIONREF"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More