P_Stockmaterial

DDL: P_STOCKMATERIAL SQL: PSTOCKMATERIAL Type: view COMPOSITE Package: ODATA_PP_SC

Stock Champion Material

P_Stockmaterial is a Composite CDS View that provides data about "Stock Champion Material" in SAP S/4HANA. It reads from 2 data sources (mara, marc) and exposes 3 fields with key fields Material, Plant. Part of development package ODATA_PP_SC.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
mara _Material from
marc _Plant inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PSTOCKMATERIAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Material mara matnr
KEY Plant marc werks
MaterialGroup matkl 
@AbapCatalog.sqlViewName: 'PSTOCKMATERIAL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MASTER}

define view P_Stockmaterial 
       as select from mara as _Material
           inner join marc as _Plant on _Material.matnr = _Plant.matnr
{ 
  key _Material.matnr  as Material,
  key _Plant.werks     as Plant,
      matkl            as MaterialGroup
}
where _Material.xchpf = 'X';

Learn More