I_MatlSampleStorageLocation

DDL: I_MATLSAMPLESTORAGELOCATION SQL: IMTLSMPLSTORLOC Type: view BASIC

Material Sample Storage Location

I_MatlSampleStorageLocation is a Basic CDS View that provides data about "Material Sample Storage Location" in SAP S/4HANA. It reads from 1 data source (tq41) and exposes 4 fields with key fields MatlSamplePlant, MaterialSampleStorageLocation. It has 2 associations to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
tq41 tq41 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Plant _Plant $projection.MatlSamplePlant = _Plant.Plant
[0..*] I_MatlSampleStorageLocationT _Text $projection.MatlSamplePlant = _Text.MatlSamplePlant and $projection.MaterialSampleStorageLocation = _Text.MaterialSampleStorageLocation

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMTLSMPLSTORLOC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Material Sample Storage Location view
ObjectModel.compositionRoot true view
VDM.viewType #BASIC view
ObjectModel.representativeKey MaterialSampleStorageLocation view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY MatlSamplePlant tq41 werks
KEY MaterialSampleStorageLocation tq41 aufbewort
_Plant _Plant
_Text _Text 
@AbapCatalog.sqlViewName: 'IMTLSMPLSTORLOC'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Material Sample Storage Location'
@ObjectModel.compositionRoot: true
@VDM.viewType:#BASIC
@ObjectModel.representativeKey: 'MaterialSampleStorageLocation'
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #S, dataClass: #CUSTOMIZING }
define view I_MatlSampleStorageLocation 
as select from tq41
   association [0..1] to I_Plant as _Plant on $projection.MatlSamplePlant = _Plant.Plant
   association [0..*] to I_MatlSampleStorageLocationT as _Text 
      on $projection.MatlSamplePlant = _Text.MatlSamplePlant and
         $projection.MaterialSampleStorageLocation = _Text.MaterialSampleStorageLocation
{
    @ObjectModel.foreignKey.association: '_Plant'
    key tq41.werks     as MatlSamplePlant,
    @ObjectModel.text.association: '_Text'
    key tq41.aufbewort as MaterialSampleStorageLocation,
    
    _Plant,
    _Text
}

Learn More