N_ProductStorageLocation

DDL: N_PRODUCTSTORAGELOCATION Type: view

Auxiliary view for Storage Location

N_ProductStorageLocation is a CDS View that provides data about "Auxiliary view for Storage Location" 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 (9)

NameValueLevelField
AbapCatalog.sqlViewName NPRDSTORLOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Auxiliary view for Storage Location view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.auxiliaryEntity.for.entity I_ProductStorageLocation view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Product mard matnr
KEY Plant mard werks
KEY StorageLocation mard lgort
_StorageLocation _StorageLocation 
@AbapCatalog:{
  sqlViewName: 'NPRDSTORLOC',
  compiler.compareFilter: true
}
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Auxiliary view for Storage Location'
@ObjectModel:{
  usageType:{
//Service category is A as this CDS view is based on a single underlying DB table

    serviceQuality: #A,
//Size category is L here as in the underlying db table the expected records is

//indicated as 67.000 to 260.000

    sizeCategory : #XL,
    dataClass: #MASTER
  }
}

@VDM:{
  auxiliaryEntity:{
    for.entity: 'I_ProductStorageLocation',
    usage.type: [#ENTERPRISE_SEARCH]
  }
}

define view N_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":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More