P_MPE_MaterialStorageLocation

DDL: P_MPE_MATERIALSTORAGELOCATION Type: view_entity CONSUMPTION Package: ODATA_MPE_MATERIAL

Material Plant with Storage Location

P_MPE_MaterialStorageLocation is a Consumption CDS View that provides data about "Material Plant with Storage Location" in SAP S/4HANA. It reads from 3 data sources (I_ProductPlant, I_ProductPlant, I_ProductPlant) and exposes 7 fields with key fields Product, Plant, StorageLocation, Plant, StorageLocation. Part of development package ODATA_MPE_MATERIAL.

3 data source(s) 7 fields

Data Sources (3)

SourceAliasJoin Type
I_ProductPlant _Plant from
I_ProductPlant _Plant union_all
I_ProductPlant _ProductPlant inner

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Material Plant with Storage Location view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductPlant Product
KEY Plant I_ProductPlant Plant
KEY StorageLocation _StgeLoc StorageLocation
Product
KEY Plant I_ProductPlant Plant
KEY StorageLocation
StorageLocationName 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@EndUserText.label: 'Material Plant with Storage Location'
@Metadata.ignorePropagatedAnnotations: true
define view entity P_MPE_MaterialStorageLocation as select distinct from I_StorageLocation as _StgeLoc
    inner join I_ProductPlant as _ProductPlant on _ProductPlant.Plant = _StgeLoc.Plant
{
    key _ProductPlant.Product,
    key _ProductPlant.Plant,
    key _StgeLoc.StorageLocation,
    _StgeLoc.StorageLocationName
} where _StgeLoc.StorageLocation != ''

union all 

select from I_ProductPlant as _Plant 
{
    key _Plant.Product,
    key _Plant.Plant,
    key '' as StorageLocation,
    '' as StorageLocationName
} where _Plant.Product != ''

Learn More