P_MaterialValuationTypesVH

DDL: P_MATERIALVALUATIONTYPESVH Type: view_entity COMPOSITE Package: VDM_EAM_MAINTJOB_MANAGE_COMP

Valuation category by material plant

P_MaterialValuationTypesVH is a Composite CDS View that provides data about "Valuation category by material plant" in SAP S/4HANA. It reads from 2 data sources (I_Plant, I_ProductValuationBasic) and exposes 6 fields with key fields Product, Plant, InventoryValuationType. Part of development package VDM_EAM_MAINTJOB_MANAGE_COMP.

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 <> ''

Learn More