I_StorLocAssignmentToWarehouse

DDL: I_STORLOCASSIGNMENTTOWAREHOUSE Type: view_entity BASIC Package: VDM_LE_SHP_COMMON

Storage Location Assignment to Warehouse

I_StorLocAssignmentToWarehouse is a Basic CDS View that provides data about "Storage Location Assignment to Warehouse" in SAP S/4HANA. It reads from 1 data source (t320) and exposes 6 fields with key fields Plant, StorageLocation. It has 3 associations to related views. Part of development package VDM_LE_SHP_COMMON.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
t320 t320 from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..1] I_StorageLocation _StorageLocation $projection.Plant = _StorageLocation.Plant and $projection.StorageLocation = _StorageLocation.StorageLocation
[0..1] I_Warehouse _Warehouse $projection.Warehouse = _Warehouse.Warehouse

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Storage Location Assignment to Warehouse view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view
Search.searchable true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Plant werks
KEY StorageLocation lgort
Warehouse lgnum
_Plant _Plant
_StorageLocation _StorageLocation
_Warehouse _Warehouse 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Storage Location Assignment to Warehouse'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #S,
  dataClass: #CUSTOMIZING
}
@VDM:{
       viewType: #BASIC
      }
@Search.searchable: true
define view entity I_StorLocAssignmentToWarehouse
  as select from t320
  association [0..1] to I_Plant                     as _Plant                         on  $projection.Plant = _Plant.Plant
  association [0..1] to I_StorageLocation           as _StorageLocation               on  $projection.Plant = _StorageLocation.Plant and
                                                                                          $projection.StorageLocation = _StorageLocation.StorageLocation
  association [0..1] to I_Warehouse                 as _Warehouse                     on  $projection.Warehouse = _Warehouse.Warehouse
  
  
{
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_PlantStdVH', element: 'Plant' }, useAsTemplate: true } ]
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key werks as Plant,
 
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_StorageLocationStdVH', element: 'StorageLocation' }, useAsTemplate: true } ]
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key lgort as StorageLocation,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_WarehouseStdVH', element: 'Warehouse' }, useAsTemplate: true } ]
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      lgnum as Warehouse,
      
      _Plant,
      _StorageLocation,
      _Warehouse

      //  obest as Obest,

      //  lgntb as Lgntb,

      //  slgor as Slgor,

      //  obtyp as Obtyp,

      //  lgref as Lgref,

      //  censy as Censy

}

Learn More