P_Productstoragelocationref

DDL: P_PRODUCTSTORAGELOCATIONREF SQL: PPRDSTORAGEREF Type: view BASIC

P_Productstoragelocationref is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (P_PlantReferences, I_ProductStorageLocationBasic) and exposes 7 fields with key fields Product, Plant, StorageLocation. It has 1 association to related views.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
P_PlantReferences Reference left_outer
I_ProductStorageLocationBasic StorageLocation from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Product _Product $projection.Product = _Product.Product

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPRDSTORAGEREF view
VDM.private true view
VDM.viewType #BASIC view
Search.searchable true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductStorageLocationBasic Product
KEY Plant I_ProductStorageLocationBasic Plant
KEY StorageLocation I_ProductStorageLocationBasic StorageLocation
PlantCategory P_PlantReferences PlantCategory
ReferenceDistributionCenter P_PlantReferences ReferenceDistributionCenter
ReferenceStore P_PlantReferences ReferenceStore
_Product _Product 
@AbapCatalog.sqlViewName: 'PPRDSTORAGEREF'
@VDM.private: true
@VDM.viewType: #BASIC
@Search.searchable: true
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Storage location for references'

@AccessControl.authorizationCheck: #CHECK
define view P_Productstoragelocationref
  as select from    I_ProductStorageLocationBasic as StorageLocation     
    left outer join P_PlantReferences        as Reference       on  StorageLocation.Plant   = Reference.Plant                                                             
  association [1..1] to I_Product as _Product on $projection.Product = _Product.Product
{

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
  key StorageLocation.Product,
  key StorageLocation.Plant,
  key StorageLocation.StorageLocation,
      Reference.PlantCategory,
      Reference.ReferenceDistributionCenter,
      Reference.ReferenceStore,
      _Product

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

Learn More