P_MaterialValuationTypesVH

DDL: P_MATERIALVALUATIONTYPESVH Type: view_entity COMPOSITE

P_MaterialValuationTypesVH is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_Plant, I_ProductValuationBasic) and exposes 6 fields with key fields Product, Plant, InventoryValuationType.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_Plant _Plant inner
I_ProductValuationBasic _ProductValuationBasic from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductValuationBasic Product
KEY Plant I_Plant Plant
KEY InventoryValuationType I_ProductValuationBasic ValuationType
InventoryValuationCategory I_ProductValuationBasic ValuationCategory
ValuationArea I_ProductValuationBasic ValuationArea
_Product I_ProductValuationBasic _Product 
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #COMPOSITE

//used as Value Help for Batch field while posting


define view entity P_MaterialValuationTypesVH
  as select from I_ProductValuationBasic as _ProductValuationBasic
    inner join   I_Plant                 as _Plant on _Plant.ValuationArea = _ProductValuationBasic.ValuationArea
{
        @Consumption.filter.hidden: true
  key   _ProductValuationBasic.Product,
        @Consumption.filter.hidden: true
  key   _Plant.Plant,
  key   _ProductValuationBasic.ValuationType     as InventoryValuationType,
        @Consumption.filter.hidden: true
        _ProductValuationBasic.ValuationCategory as InventoryValuationCategory,
        @Consumption.filter.hidden: true
        _ProductValuationBasic.ValuationArea,

        // Associations

        _ProductValuationBasic._Product
}
where
  _ProductValuationBasic.ValuationType <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PLANT",
"I_PRODUCTVALUATIONBASIC"
],
"ASSOCIATED":
[
"I_PRODUCT"
],
"BASE":
[
"I_PRODUCTVALUATIONBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More