P_MatDocExtractSupplierStkVal

DDL: P_MATDOCEXTRACTSUPPLIERSTKVAL Type: view_entity BASIC Package: ODATA_MM_IM_PI_MASS_CREATE

Matdoc_Extract Supplier Stock Valuation

P_MatDocExtractSupplierStkVal is a Basic CDS View that provides data about "Matdoc_Extract Supplier Stock Valuation" in SAP S/4HANA. It reads from 1 data source (matdoc_extract) and exposes 6 fields with key fields matnr, werks, sobkz, lifnr, lbbsa. Part of development package ODATA_MM_IM_PI_MASS_CREATE.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
matdoc_extract matdoc_extract from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
VDM.private true view
VDM.viewType #BASIC view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY matnr matbf
KEY werks werks
KEY sobkz sobkz
KEY lifnr lifnr_sid
KEY lbbsa lbbsa_sid
xobew xobew 
@AccessControl.authorizationCheck: #NOT_ALLOWED
@VDM.private: true
@VDM.viewType: #BASIC
define view entity P_MatDocExtractSupplierStkVal as select from matdoc_extract {
    key matbf     as matnr, 
    key werks,
    key sobkz,
    key lifnr_sid as lifnr,
    
    key lbbsa_sid     as lbbsa,
    
    xobew
}
where stock_ind_l2 = ''
  and (sobkz = 'O'
       and (lbbsa_sid = '01' or lbbsa_sid = '02' or lbbsa_sid = '05' or lbbsa_sid = '08'))

group by matbf, werks, sobkz, lifnr_sid, lbbsa_sid, xobew

Learn More