V_WRF_STORLOC_CLASS

CDS View

Storage location stock classification

V_WRF_STORLOC_CLASS is a CDS View in S/4HANA. Storage location stock classification. 6 CDS views read from this table.

Used by 6 CDS view(s)

CDS Views using this table (6)

ViewTypeJoinVDMDescription
rrp_e_GiPo view left_outer RRP: Select Purchase Orders as Goods Issues
rrp_e_GiPr view left_outer RRP: Select Purchase Requisitions as Goods Issues
rrp_e_GrOc view left_outer RRP: Retrieve Open Order Confirmation Quantities
rrp_e_GrPo view left_outer RRP: Select Purchase Orders as Goods Receipts
rrp_e_GrPr view left_outer RRP: Select Purchase Requisitions as Goods Receipts
V_WRF_MARD_MRP view left_outer Replace MARD-DISKZ with MRP-Area 
@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