I_MaterialUnrestrictedUseStock

DDL: I_MATERIALUNRESTRICTEDUSESTOCK SQL: IMATUNRUSESTOCK Type: view COMPOSITE

Material Unrestricted Use Stock

I_MaterialUnrestrictedUseStock is a Composite CDS View that provides data about "Material Unrestricted Use Stock" in SAP S/4HANA. It reads from 1 data source (I_MaterialStock_2) and exposes 9 fields with key fields Material, Plant, StorageLocation. It has 1 association to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialStock_2 I_MaterialStock_2 from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _MaterialBaseUnit $projection.MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IMATUNRUSESTOCK view
EndUserText.label Material Unrestricted Use Stock view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Material I_MaterialStock_2 Material
KEY Plant I_MaterialStock_2 Plant
KEY StorageLocation I_MaterialStock_2 StorageLocation
MaterialBaseUnit I_MaterialStock_2 MaterialBaseUnit
MatlWrhsStkQtyInMatlBaseUnit
_Material I_MaterialStock_2 _Material
_MaterialBaseUnit _MaterialBaseUnit
_Plant _Plant
_StorageLocation _StorageLocation 
@AbapCatalog.sqlViewName: 'IMATUNRUSESTOCK'
@EndUserText.label: 'Material Unrestricted Use Stock'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_MaterialUnrestrictedUseStock
  as select from I_MaterialStock_2
    association [0..1] to I_UnitOfMeasure as _MaterialBaseUnit on $projection.MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure
  {
    key I_MaterialStock_2.Material,
    key I_MaterialStock_2.Plant,
    key I_MaterialStock_2.StorageLocation,

        @Semantics.unitOfMeasure: true
        I_MaterialStock_2.MaterialBaseUnit,

        @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
        sum( I_MaterialStock_2.MatlWrhsStkQtyInMatlBaseUnit ) as MatlWrhsStkQtyInMatlBaseUnit,

        I_MaterialStock_2._Material,

        _MaterialBaseUnit,
        _Plant,
        _StorageLocation
  }
  where
        I_MaterialStock_2.InventorySpecialStockType = ''
    and I_MaterialStock_2.InventoryStockType        = '01' // Unrestricted-Use Stock

    and I_MaterialStock_2.MatlDocLatestPostgDate    <= $session.system_date
  group by
    I_MaterialStock_2.Material,
    I_MaterialStock_2.Plant,
    I_MaterialStock_2.MaterialBaseUnit,
    I_MaterialStock_2.StorageLocation
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALSTOCK_2"
],
"ASSOCIATED":
[
"I_PLANT",
"I_PRODUCT",
"I_STORAGELOCATION",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_MATERIALSTOCK_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More