P_MonitorMaterialPrice

DDL: P_MONITORMATERIALPRICE Type: view_entity COMPOSITE Package: ODATA_ML_MNTRMATLPRICES

Grouped Material Ledger Prices

P_MonitorMaterialPrice is a Composite CDS View that provides data about "Grouped Material Ledger Prices" in SAP S/4HANA. It reads from 1 data source (I_MaterialLedgerPrice) and exposes 21 fields with key fields CostEstimate, MaterialPriceType, MaterialPriceSubtype, MaterialPriceValidityStartDate. It has 1 association to related views. Part of development package ODATA_ML_MNTRMATLPRICES.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialLedgerPrice I_MaterialLedgerPrice from

Associations (1)

CardinalityTargetAliasCondition
[1..1] P_MonitorMaterialPriceTblFunc _Valuation $projection.CostEstimate = _Valuation.CostEstimate and $projection.MaterialPriceType = _Valuation.MaterialPriceType and $projection.MaterialPriceSubtype = _Valuation.MaterialPriceSubtype and $projection.MaterialPriceValidityStartDate = _Valuation.MaterialPriceValidityStartDate and $projection.MaterialPriceValidityEndDate = _Valuation.MaterialPriceValidityEndDate and $projection.CompanyCode = _Valuation.CompanyCode

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate
KEY MaterialPriceType MaterialPriceType
KEY MaterialPriceSubtype MaterialPriceSubtype
KEY MaterialPriceValidityStartDate MaterialPriceValidityStartDate
MaterialPriceValidityEndDate MaterialPriceValidityEndDate
MaterialPriceControl MaterialPriceControl
CurPlanProjSlsOrdValnStrategy CurPlanProjSlsOrdValnStrategy
MaterialPriceCostEstimateStage MaterialPriceCostEstimateStage
Material Material
ValuationArea ValuationArea
InventoryValuationType InventoryValuationType
CompanyCode CompanyCode
InvtryValnSpecialStockType InvtryValnSpecialStockType
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
WBSElementInternalID WBSElementInternalID
Supplier Supplier
StkMaterialPriceValuationType StkMaterialPriceValuationType
MaterialPriceExtRefCategory MaterialPriceExtRefCategory
MaterialPriceExtReference MaterialPriceExtReference
_Valuation _Valuation 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType:{
    serviceQuality: #B,
    sizeCategory: #XXL,
    dataClass: #MIXED
}
@VDM: {
  viewType: #COMPOSITE,
  private:true
}
define view entity P_MonitorMaterialPrice
  as select from I_MaterialLedgerPrice

  association [1..1] to P_MonitorMaterialPriceTblFunc as _Valuation on  $projection.CostEstimate                   = _Valuation.CostEstimate
                                                                    and $projection.MaterialPriceType              = _Valuation.MaterialPriceType
                                                                    and $projection.MaterialPriceSubtype           = _Valuation.MaterialPriceSubtype
                                                                    and $projection.MaterialPriceValidityStartDate = _Valuation.MaterialPriceValidityStartDate
                                                                    and $projection.MaterialPriceValidityEndDate   = _Valuation.MaterialPriceValidityEndDate
                                                                    and $projection.CompanyCode                    = _Valuation.CompanyCode
{
  key CostEstimate,
  key MaterialPriceType,
  key MaterialPriceSubtype,
  key MaterialPriceValidityStartDate,
      MaterialPriceValidityEndDate,
//      MatlPrcValdtyStrtFsclYearPerd,

//      MatlPrcValidityStartFiscalYear,

//      MatlPrcValdtyStartFiscalPeriod,

//      MatlPrcValdtyEndFsclYearPeriod,

//      MatlPrcValidityEndFiscalYear,

//      MatlPrcValdtyEndFiscalPeriod,

      MaterialPriceControl,
      CurPlanProjSlsOrdValnStrategy,
      MaterialPriceCostEstimateStage,
      Material,
      ValuationArea,
      InventoryValuationType,
      CompanyCode,
      InvtryValnSpecialStockType,
      SalesOrder,
      SalesOrderItem,
      WBSElementInternalID,
      Supplier,
      StkMaterialPriceValuationType,
      MaterialPriceExtRefCategory,
      MaterialPriceExtReference,

      _Valuation

}

group by
  CostEstimate,
  MaterialPriceType,
  MaterialPriceSubtype,
  MaterialPriceValidityStartDate,
  MaterialPriceValidityEndDate,
//  MatlPrcValdtyStrtFsclYearPerd,

//  MatlPrcValidityStartFiscalYear,

//  MatlPrcValdtyStartFiscalPeriod,

//  MatlPrcValdtyEndFsclYearPeriod,

//  MatlPrcValidityEndFiscalYear,

//  MatlPrcValdtyEndFiscalPeriod,

  MaterialPriceControl,
  CurPlanProjSlsOrdValnStrategy,
  MaterialPriceCostEstimateStage,
  Material,
  ValuationArea,
  InventoryValuationType,
  CompanyCode,
  InvtryValnSpecialStockType,
  SalesOrder,
  SalesOrderItem,
  WBSElementInternalID,
  Supplier,
  StkMaterialPriceValuationType,
  MaterialPriceExtRefCategory,
  MaterialPriceExtReference

having
      MaterialPriceType <> 'FSTDCE'
  and MaterialPriceType <> 'FUTURE'
  and MaterialPriceType <> 'MAP'
  and CostEstimate      <> '000000000000'

Learn More