EAMCompStorLocWithStockVH

DDL: EAMCOMPSTORLOCWITHSTOCKVH Type: view_entity Package: EAMS_UI_ORD

Component Storage Location with Stock

EAMCompStorLocWithStockVH is a CDS View that provides data about "Component Storage Location with Stock" in SAP S/4HANA. It reads from 1 data source (nsdm_e_mard) and exposes 7 fields with key fields matnr, werks, lgort. Part of development package EAMS_UI_ORD.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
nsdm_e_mard md from

Annotations (8)

NameValueLevelField
EndUserText.label Component Storage Location with Stock view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey lgort view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY matnr nsdm_e_mard matnr
KEY werks nsdm_e_mard werks
KEY lgort nsdm_e_mard lgort
lgobe sl lgobe
labst
klabs
meins mr meins 
@EndUserText.label: 'Component Storage Location with Stock'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel: {
  dataCategory: #VALUE_HELP,
  representativeKey: 'lgort',
  usageType.serviceQuality: #C,
  usageType.dataClass: #MIXED,
  usageType.sizeCategory : #XL }
define view entity EAMCompStorLocWithStockVH 
  as select from nsdm_e_mard as md 
    left outer to one join t001l as sl on md.werks = sl.werks 
                                      and md.lgort = sl.lgort
    left outer to one join mara as mr on md.matnr = mr.matnr 
{
  key md.matnr,
  key md.werks,
  key md.lgort,
  sl.lgobe,
  @Semantics.quantity.unitOfMeasure: 'meins'
  cast( md.labst as labst preserving type ) as labst,
  @Semantics.quantity.unitOfMeasure: 'meins'
  cast( md.klabs as klabs preserving type ) as klabs,
  mr.meins
}

Learn More