R_MATLPRICESPCLSTOCKVALNSTRGY

CDS View

Mat Price Spec Stock Valuation Strategy

R_MATLPRICESPCLSTOCKVALNSTRGY is a CDS View in S/4HANA. Mat Price Spec Stock Valuation Strategy. 5 CDS views read from this table.

Used by 5 CDS view(s)

CDS Views using this table (5)

ViewTypeJoinVDMDescription
P_EBSpecialStockValStrategy view from COMPOSITE Event-Based Special Stock Valuation Strategy
P_MfgOrderSpclStockValStrategy view inner COMPOSITE Manufacturing Order Valuation Strategy
P_PCCOrderSpclStockValStrategy view inner COMPOSITE Manufacturing Order Valuation Strategy
P_PCCTgtCstForMTOCstEst view inner CONSUMPTION Target cost for MTO order based on cost estimate
P_PCCTgtCstForMTOOnPlanCost view inner CONSUMPTION Target cost for MTO order based on order plan cost 
@AbapCatalog.sqlViewName: 'RMPSSVSTRGY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Mat Price Spec Stock Valuation Strategy'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
define view R_MatlPriceSpclStockValnStrgy
  as select from    I_MaterialLedgerPrice          as fmltp
  inner join        t001w                          as plant on plant.bwkey = fmltp.ValuationArea

{
  key fmltp.CostEstimate                                     as CostEstimate,
  key fmltp.CurrencyRole                                     as CurrencyRole,
  key fmltp.Ledger                                           as Ledger,
      fmltp.MatlPrcValdtyEndFsclYearPeriod                   as MatlPrcValdtyEndFsclYearPeriod,
      fmltp.Material                                         as Material,
      fmltp.ValuationArea                                    as ValuationArea,
      fmltp.InventoryValuationType                           as ValuationType,
      plant.werks                                            as Plant,
      fmltp.SalesOrder                                       as SalesOrder,
      fmltp.SalesOrderItem                                   as SalesOrderItem,
      cast ( fmltp.WBSElementInternalID as ps_psp_pnr_core ) as WBSElementInternalID,
      fmltp.MaterialPriceType                                as MaterialPriceType,
      fmltp.CurPlanProjSlsOrdValnStrategy                    as CurPlanProjSlsOrdValnStrategy
}
where
  (
    (
          fmltp.MaterialPriceType             =  'INVPR'
      and fmltp.MaterialPriceControl          =  'S'
    )
    or(
          fmltp.MaterialPriceType             =  'STDPR'
    )
  )
  and     fmltp.MatlPrcValidityEndFiscalYear  =  '9999'
  and     fmltp.StkMaterialPriceValuationType <> 'M'

Learn More