P_MATERIALLEDGERPRICE

CDS View

Base View for Material Valuation Prices - CKML* tables

P_MATERIALLEDGERPRICE is a CDS View in S/4HANA. Base View for Material Valuation Prices - CKML* tables. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MaterialLedgerPrice view_entity from BASIC Material Ledger Price
I_MLPrExtRefCostEstimate view from BASIC Material Price Ext Ref for Cost Est Key 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #BASIC
define view entity P_MaterialLedgerPrice
  as select from fmlt_price as price

{
  key kalnr                                 as CostEstimate,
  key price.rldnr                           as Ledger,
  key price.ext_curtype                     as CurrencyRole,
  key price_type                            as MaterialPriceType,
  key price_subtype                         as MaterialPriceSubtype,
  key date_from                             as MaterialPriceValidityStartDate,
      date_to                               as MaterialPriceValidityEndDate,
      cast(yrper_from as fml_yearper_nconv) as MatlPrcValdtyStrtFsclYearPerd,
      gjahr_from                            as MatlPrcValidityStartFiscalYear,
      period_from                           as MatlPrcValdtyStartFiscalPeriod,
      cast(yrper_to as fml_yearper_nconv)   as MatlPrcValdtyEndFsclYearPeriod,
      gjahr_to                              as MatlPrcValidityEndFiscalYear,
      period_to                             as MatlPrcValdtyEndFiscalPeriod,
      @Semantics.amount.currencyCode: 'Currency' 
      price                                 as MaterialPrice,
      waers                                 as Currency,
      peinh                                 as MaterialPriceUnitQty,
      valum                                 as ValuationQuantityUnit,
      vprsv                                 as MaterialPriceControl,
      @Semantics.amount.currencyCode: 'Currency' 
      price_fixed                           as FixedPortionOfMaterialPrice,
      lbwst                                 as CurPlanProjSlsOrdValnStrategy,
      ce_stage                              as MaterialPriceCostEstimateStage,
      matnr                                 as Material,
      bwkey                                 as ValuationArea,
      bwtar                                 as InventoryValuationType,
      bukrs                                 as CompanyCode,
      sobkz                                 as InvtryValnSpecialStockType,
      kdauf                                 as SalesOrder,
      kdpos                                 as SalesOrderItem,
      pspnr                                 as WBSElementInternalID,
      lifnr                                 as Supplier,
      otype                                 as StkMaterialPriceValuationType,
      origin_extref_category                as MaterialPriceExtRefCategory,
      origin_extref_data                    as MaterialPriceExtReference,
      created_by_user                       as MaterialPriceCreatedByUser,
      changed_by_user                       as MaterialPriceChangedByUser,
      created_on                            as MaterialPriceCreationDateTime,
      changed_on                            as MatlPriceLastChangeDateTime,
      ucb_id                                as ComponentBreakdown
}

Learn More