P_CHMPMaterialValuation

DDL: P_CHMPMATERIALVALUATION Type: view_entity BASIC

P_CHMPMaterialValuation is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (ebew, mbew, obew, qbew) and exposes 73 fields with key field CostEstimate. It has 3 associations to related views.

4 data source(s) 73 fields

Data Sources (4)

SourceAliasJoin Type
ebew ebew union_all
mbew mbew from
obew obew union_all
qbew qbew union_all

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Purreqvaluationarea _ValuationArea $projection.ValuationArea = _ValuationArea.ValuationArea
[1..1] I_Product _Product $projection.Material = _Product.Product
[1..1] I_Material _Material $projection.Material = _Material.Material

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate kaln1
Material matnr
ValuationArea bwkey
PriceControl vprsv
PriceUnit peinh
MaterialValuationClass bklas
InventoryValuationCategory bwtty
InventoryValuationType bwtar
WBSElement
InventorySpecialStockType
SDDocument
SDDocumentItem
Supplier
PriceDeterminationControl mlast
ValuationTypeOrigin
Currency
BaseUnit _Product BaseUnit
_Product _Product
Materialkeykaln1asCostEstimate
Material matnr
ValuationArea bwkey
PriceControl vprsv
PriceUnit peinh
MaterialValuationClass bklas
InventoryValuationCategory bwtty
InventoryValuationType bwtar
WBSElement
InventorySpecialStockType sobkz
SDDocument
SDDocumentItem
Supplier lifnr
PriceDeterminationControl mlast
ValuationTypeOrigin
Currency
BaseUnit _Product BaseUnit
_Product _Product
Materialkeykaln1asCostEstimate
Material matnr
ValuationArea bwkey
PriceControl vprsv
PriceUnit peinh
MaterialValuationClass bklas
InventoryValuationCategory bwtty
InventoryValuationType bwtar
WBSElement
InventorySpecialStockType sobkz
SDDocument vbeln
SDDocumentItem posnr
Supplier
PriceDeterminationControl mlast
ValuationTypeOrigin
Currency
BaseUnit _Product BaseUnit
_Product _Product
Materialkeykaln1asCostEstimate
Material matnr
ValuationArea bwkey
PriceControl vprsv
PriceUnit peinh
MaterialValuationClass bklas
InventoryValuationCategory bwtty
InventoryValuationType bwtar
WBSElement
InventorySpecialStockType sobkz
SDDocument
SDDocumentItem
Supplier
PriceDeterminationControl mlast
ValuationTypeOrigin
Currency
BaseUnit _Product BaseUnit
_Product _Product
_Material _Material 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType:{
    serviceQuality: #B,
    sizeCategory: #XL,
    dataClass: #MIXED
}
@VDM: {
  viewType: #BASIC,
  private:true
}
@Metadata.ignorePropagatedAnnotations: true
define view entity P_CHMPMaterialValuation
  as select from mbew

  association [1..1] to I_Purreqvaluationarea as _ValuationArea on $projection.ValuationArea = _ValuationArea.ValuationArea
  association [1..1] to I_Product             as _Product       on $projection.Material = _Product.Product
  association [1..1] to I_Material            as _Material      on $projection.Material = _Material.Material
{
  key kaln1                                            as CostEstimate,
      matnr                                            as Material,
      bwkey                                            as ValuationArea,
      vprsv                                            as PriceControl,
      peinh                                            as PriceUnit,

      bklas                                            as MaterialValuationClass,
      bwtty                                            as InventoryValuationCategory,
      bwtar                                            as InventoryValuationType,
      cast('00000000' as ps_s4_pspnr preserving type ) as WBSElement,
      cast('' as sobkz)                                as InventorySpecialStockType,
      cast('' as vbeln)                                as SDDocument,
      cast('000000' as posnr)                          as SDDocumentItem,
      cast('' as lifnr)                                as Supplier,
      mlast                                            as PriceDeterminationControl,
      cast('mbew' as char4)                            as ValuationTypeOrigin,

      _ValuationArea._CompanyCode.Currency,
      _Product.BaseUnit,
      @Semantics.amount.currencyCode: 'Currency'
      case vprsv when 'V' then verpr
      else stprs end                                   as InventoryPrice,
      
      _Product,
      _Material

}
union all select from obew

association [1..1] to I_Purreqvaluationarea as _ValuationArea on $projection.ValuationArea = _ValuationArea.ValuationArea
association [1..1] to I_Product             as _Product       on $projection.Material = _Product.Product
association [1..1] to I_Material            as _Material      on $projection.Material = _Material.Material
{
  key kaln1                                            as CostEstimate,
      matnr                                            as Material,
      bwkey                                            as ValuationArea,
      vprsv                                            as PriceControl,
      peinh                                            as PriceUnit,

      bklas                                            as MaterialValuationClass,
      bwtty                                            as InventoryValuationCategory,
      bwtar                                            as InventoryValuationType,
      cast('00000000' as ps_s4_pspnr preserving type ) as WBSElement,
      sobkz                                            as InventorySpecialStockType,
      cast('' as vbeln)                                as SDDocument,
      cast('000000' as posnr)                          as SDDocumentItem,
      lifnr                                            as Supplier,
      mlast                                            as PriceDeterminationControl,
      cast('obew' as char4)                            as ValuationTypeOrigin,

      _ValuationArea._CompanyCode.Currency,
      _Product.BaseUnit,
      case vprsv when 'V' then verpr
      else stprs end                                   as InventoryPrice,
      
      _Product,
      _Material
}
union all select from ebew
association [1..1] to I_Purreqvaluationarea as _ValuationArea on $projection.ValuationArea = _ValuationArea.ValuationArea
association [1..1] to I_Product             as _Product       on $projection.Material = _Product.Product
association [1..1] to I_Material            as _Material      on $projection.Material = _Material.Material
{
  key kaln1                                            as CostEstimate,
      matnr                                            as Material,
      bwkey                                            as ValuationArea,

      vprsv                                            as PriceControl,
      peinh                                            as PriceUnit,

      bklas                                            as MaterialValuationClass,
      bwtty                                            as InventoryValuationCategory,
      bwtar                                            as InventoryValuationType,
      cast('00000000' as ps_s4_pspnr preserving type ) as WBSElement,
      sobkz                                            as InventorySpecialStockType,
      vbeln                                            as SDDocument,
      posnr                                            as SDDocumentItem,
      cast('' as lifnr)                                as Supplier,
      mlast                                            as PriceDeterminationControl,
      cast('ebew' as char4)                            as ValuationTypeOrigin,

      _ValuationArea._CompanyCode.Currency,
      _Product.BaseUnit,
      case vprsv when 'V' then verpr
      else stprs end                                   as InventoryPrice,
      
      _Product,
      _Material
}
union all select from qbew
association [1..1] to I_Purreqvaluationarea as _ValuationArea on $projection.ValuationArea = _ValuationArea.ValuationArea
association [1..1] to I_Product             as _Product       on $projection.Material = _Product.Product
association [1..1] to I_Material            as _Material      on $projection.Material = _Material.Material
{
  key kaln1                                       as CostEstimate,
      matnr                                       as Material,
      bwkey                                       as ValuationArea,
      vprsv                                       as PriceControl,
      peinh                                       as PriceUnit,

      bklas                                       as MaterialValuationClass,
      bwtty                                       as InventoryValuationCategory,
      bwtar                                       as InventoryValuationType,
      cast(pspnr as ps_s4_pspnr preserving type ) as WBSElement,
      sobkz                                       as InventorySpecialStockType,
      cast('' as vbeln)                           as SDDocument,
      cast('000000' as posnr)                     as SDDocumentItem,
      cast('' as lifnr)                           as Supplier,
      mlast                                       as PriceDeterminationControl,
      cast('qbew' as char4)                       as ValuationTypeOrigin,

      _ValuationArea._CompanyCode.Currency,
      _Product.BaseUnit,
      case vprsv when 'V' then verpr
      else stprs end                              as InventoryPrice,
      
      _Product,
      _Material
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_PRODUCT",
"I_PURREQVALUATIONAREA",
"EBEW",
"MBEW",
"OBEW",
"QBEW"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_PRODUCT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More