V_WRF_STORLOC_CLASS

DDL: V_WRF_MRP_LGORT_STOCK_CLASS SQL: VWRFSTORLOCCLASS Type: view

Storage location stock classification

V_WRF_STORLOC_CLASS is a CDS View that provides data about "Storage location stock classification" in SAP S/4HANA. It reads from 2 data sources (mdlg, t438a) and exposes 4 fields with key fields matnr, werks, lgort.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
mdlg mdlg inner
t438a t438a inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName VWRFSTORLOCCLASS view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #CLIENT_DEPENDENT view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality X view
ObjectModel.usageType.sizeCategory XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Storage location stock classification view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY matnr mdma matnr
KEY werks mdlg werks
KEY lgort mdlg lgort
disvfNthenBelseAendasretail_stock_class 
@AbapCatalog.sqlViewName: 'VWRFSTORLOCCLASS'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.type: #CLIENT_DEPENDENT
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: 'X'
@ObjectModel.usageType.sizeCategory: 'XL'
@ObjectModel.usageType.dataClass: #MIXED

@EndUserText.label: 'Storage location stock classification'
define view V_WRF_STORLOC_CLASS as select from ( mdma
            inner join mdlg  
             on  mdma.berid = mdlg.berid
        )
          inner join   t438a 
            on mdma.dismm = t438a.dismm     
      {
  key mdma.matnr,
  key mdlg.werks,
  key mdlg.lgort,      
            case
        when mdma.dismm is null or mdma.loekz = 'X' then ' ' //normal stock

        when t438a.disvf = 'N' then 'B' // stock will be excluded from most retail processes

        else 'A' // other special stock - to be considered by all processes which are not replenishment

        end as retail_stock_class
        }
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MDLG",
"MDMA",
"T438A"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More