P_MaterialLedgerPrice

DDL: P_MATERIALLEDGERPRICE Type: view_entity BASIC Package: FINS_ML_VDM
38 Fields 1 Data Sources

Base View for Material Valuation Prices - CKML* tables

P_MaterialLedgerPrice is a Basic CDS View that provides data about "Base View for Material Valuation Prices - CKML* tables" in SAP S/4HANA. It reads from 1 data source (fmlt_price) and exposes 38 fields with key fields CostEstimate, Ledger, CurrencyRole, MaterialPriceType, MaterialPriceSubtype. Part of development package FINS_ML_VDM.

Data Sources (1)

SourceAliasJoin Type
fmlt_price price from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate kalnr ProdCostEst.No.
KEY Ledger fmlt_price rldnr Ledger (Compat.)
KEY CurrencyRole fmlt_price ext_curtype Crcy.Type/Val.View
KEY MaterialPriceType price_type Price Type
KEY MaterialPriceSubtype price_subtype Price Sub-Type
KEY MaterialPriceValidityStartDate date_from Validity Start Date
MaterialPriceValidityEndDate date_to Validity End Date
MatlPrcValdtyStrtFsclYearPerd Fiscal Period From
MatlPrcValidityStartFiscalYear gjahr_from From Year
MatlPrcValdtyStartFiscalPeriod period_from Period Start
MatlPrcValdtyEndFsclYearPeriod Fiscal Period To
MatlPrcValidityEndFiscalYear gjahr_to To FY
MatlPrcValdtyEndFiscalPeriod period_to To Period
MaterialPrice price RVP f.PricePro.
Currency waers Transaction Currency
MaterialPriceUnitQty peinh Unit of measure
ValuationQuantityUnit valum Valuation Unit
MaterialPriceControl vprsv Price control
FixedPortionOfMaterialPrice price_fixed Price Fixed Portion
CurPlanProjSlsOrdValnStrategy lbwst Curr. Valn Strat.
MaterialPriceCostEstimateStage ce_stage Stage
Material matnr Vehicle Model
ValuationArea bwkey Valuation Area
InventoryValuationType bwtar Valuation Type
CompanyCode bukrs Value
InvtryValnSpecialStockType sobkz Special Stock
SalesOrder kdauf SD Document
SalesOrderItem kdpos Sales Ord. Item
WBSElementInternalID pspnr WBS Element
Supplier lifnr Vendor no.
StkMaterialPriceValuationType otype Type of Val.
MaterialPriceExtRefCategory origin_extref_category Orig Ext Ref Cat
MaterialPriceExtReference origin_extref_data Orig. ER Data
MaterialPriceCreatedByUser created_by_user User Name
MaterialPriceChangedByUser changed_by_user Changed By
MaterialPriceCreationDateTime created_on Variant created on
MatlPriceLastChangeDateTime changed_on Variant Changed on
ComponentBreakdown ucb_id Breakdown ID

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_MaterialLedgerPrice.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_MaterialLedgerPrice AS
SELECT
  kalnr AS CostEstimate,
  price.rldnr AS Ledger,
  price.ext_curtype AS CurrencyRole,
  price_type AS MaterialPriceType,
  price_subtype AS MaterialPriceSubtype,
  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,
  price AS MaterialPrice,
  waers AS Currency,
  peinh AS MaterialPriceUnitQty,
  valum AS ValuationQuantityUnit,
  vprsv AS MaterialPriceControl,
  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
FROM fmlt_price AS price
;

Learn More