P_MonitorMaterialPrice

DDL: P_MONITORMATERIALPRICE Type: view_entity COMPOSITE

P_MonitorMaterialPrice is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_MaterialLedgerPrice) and exposes 27 fields with key fields CostEstimate, MaterialPriceType, MaterialPriceSubtype, MaterialPriceValidityStartDate. It has 1 association to related views.

1 data source(s) 27 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 (27)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate
KEY MaterialPriceType MaterialPriceType
KEY MaterialPriceSubtype MaterialPriceSubtype
KEY MaterialPriceValidityStartDate MaterialPriceValidityStartDate
MaterialPriceValidityEndDate MaterialPriceValidityEndDate
MatlPrcValdtyStrtFsclYearPerd MatlPrcValdtyStrtFsclYearPerd
MatlPrcValidityStartFiscalYear MatlPrcValidityStartFiscalYear
MatlPrcValdtyStartFiscalPeriod MatlPrcValdtyStartFiscalPeriod
MatlPrcValdtyEndFsclYearPeriod MatlPrcValdtyEndFsclYearPeriod
MatlPrcValidityEndFiscalYear MatlPrcValidityEndFiscalYear
MatlPrcValdtyEndFiscalPeriod MatlPrcValdtyEndFiscalPeriod
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 Ledger,

      //  key CurrencyRole,

  key MaterialPriceType,
  key MaterialPriceSubtype,
  key MaterialPriceValidityStartDate,
      MaterialPriceValidityEndDate,
      MatlPrcValdtyStrtFsclYearPerd,
      MatlPrcValidityStartFiscalYear,
      MatlPrcValdtyStartFiscalPeriod,
      MatlPrcValdtyEndFsclYearPeriod,
      MatlPrcValidityEndFiscalYear,
      MatlPrcValdtyEndFiscalPeriod,
      //      MaterialPrice,

      //      FixedPortionOfMaterialPrice,

      //      Currency,

      //      MaterialPriceUnitQty,

      //      ValuationQuantityUnit,

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

      //      MaterialPriceChangedByUser,

      //      MaterialPriceCreationDateTime,

      //      MatlPriceLastChangeDateTime,


      _Valuation

}

group by
  CostEstimate,
  MaterialPriceType,
  MaterialPriceSubtype,
  MaterialPriceValidityStartDate,
  MaterialPriceValidityEndDate,
  MatlPrcValdtyStrtFsclYearPerd,
  MatlPrcValidityStartFiscalYear,
  MatlPrcValdtyStartFiscalPeriod,
  MatlPrcValdtyEndFsclYearPeriod,
  MatlPrcValidityEndFiscalYear,
  MatlPrcValdtyEndFiscalPeriod,
  //  MaterialPrice,

  //  FixedPortionOfMaterialPrice,

  //  Currency,

  //  MaterialPriceUnitQty,

  //  ValuationQuantityUnit,

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

//  MaterialPriceChangedByUser,

//  MaterialPriceCreationDateTime,

//  MatlPriceLastChangeDateTime


having
      MaterialPriceType <> 'FSTDCE'
  and MaterialPriceType <> 'FUTURE'
  and CostEstimate      <> '000000000000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALLEDGERPRICE"
],
"ASSOCIATED":
[
"P_MONITORMATERIALPRICETBLFUNC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More