P_ProductStorageLocation

DDL: P_PRODUCTSTORAGELOCATION SQL: PPRDSTORLOC Type: view BASIC

P_ProductStorageLocation is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (mard) and exposes 4 fields with key fields Product, Plant, StorageLocation. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
mard StorageLocation from

Associations (1)

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

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PPRDSTORLOC view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Product mard matnr
KEY Plant mard werks
KEY StorageLocation mard lgort
_StorageLocation _StorageLocation 
@AbapCatalog.sqlViewName: 'PPRDSTORLOC'
@AbapCatalog.compiler.compareFilter: true
//@EndUserText.label: 'Product storage location search model'

@VDM.private: true
@AccessControl.authorizationCheck: #CHECK //is 'CHECK' required?

@VDM.viewType: #BASIC
//@ObjectModel.representativeKey: 'Product'

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
//@ClientHandling.algorithm: #SESSION_VARIABLE //Not sure if these two annotations are necessary

//@Search.searchable: true


define view P_ProductStorageLocation
  as select from mard as StorageLocation

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

{

  key StorageLocation.matnr                           as Product, //request

  key StorageLocation.werks                           as Plant, //request

  key StorageLocation.lgort                           as StorageLocation, //response



      _StorageLocation
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MARD"
],
"ASSOCIATED":
[
"I_STORAGELOCATION"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More