P_MatlLdgrPriceByValuation

DDL: P_MATLLDGRPRICEBYVALUATION Type: view_entity COMPOSITE Package: ODATA_ML_MNTRMATLPRICES
12 Fields 1 Data Sources

Material Ledger Price by Valuation

P_MatlLdgrPriceByValuation is a Composite CDS View that provides data about "Material Ledger Price by Valuation" in SAP S/4HANA. It reads from 1 data source (I_MaterialLedgerPrice) and exposes 12 fields with key fields CostEstimate, Ledger, CurrencyRole, MaterialPriceType, MaterialPriceSubtype. Part of development package ODATA_ML_MNTRMATLPRICES.

Data Sources (1)

SourceAliasJoin Type
I_MaterialLedgerPrice I_MaterialLedgerPrice from

Annotations (7)

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
EndUserText.label Material Ledger Price by Valuation view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate Cost EstimateNo
KEY Ledger Ledger Ledger
KEY CurrencyRole CurrencyRole Curr./Val. Type
KEY MaterialPriceType MaterialPriceType Price Type
KEY MaterialPriceSubtype MaterialPriceSubtype
KEY MaterialPriceValidityStartDate MaterialPriceValidityStartDate
KEY MaterialPriceValidityEndDate MaterialPriceValidityEndDate
KEY CompanyCode CompanyCode Receiver Company Code
MaterialPrice MaterialPrice Inventory Price
Currency Currency Valuation Crcy
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
ValuationQuantityUnit

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_MatlLdgrPriceByValuation.
-- 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_MatlLdgrPriceByValuation AS
SELECT
  CostEstimate,
  Ledger,
  CurrencyRole,
  MaterialPriceType,
  MaterialPriceSubtype,
  MaterialPriceValidityStartDate,
  MaterialPriceValidityEndDate,
  CompanyCode,
  MaterialPrice,
  Currency,
  MaterialPriceUnitQty,
  cast( ValuationQuantityUnit as fml_valuation_unit_of_measure preserving type ) AS ValuationQuantityUnit
FROM I_MaterialLedgerPrice
;

Learn More