What is V_MATERIALLEDGERPRICE in SAP S/4HANA?

V_MATERIALLEDGERPRICE is a cds CDS view in SAP S/4HANA. Material Ledger Price It contains 31 fields.

Which tables does V_MATERIALLEDGERPRICE read from?

V_MATERIALLEDGERPRICE reads data from: ckmlhd, ckmlhd, I_MaterialLedgerPrice, fmlv_logistic_currency, R_MatlPriceDataMigrationStatus and more.

V_MATERIALLEDGERPRICE

DDL: V_MATERIALLEDGERPRICE SQL: VMATLEDGERPRICE Type: view

31 Fields 7 Data Sources 3 Associations

Material Ledger Price

V_MATERIALLEDGERPRICE is a CDS View that provides data about "Material Ledger Price" in SAP S/4HANA. It reads from 7 data sources and exposes 31 fields with key fields CostEstimate, Material, ValuationArea, InventoryValuationType, InventorySpecialStockType. It has 3 associations to related views.

Data Sources (7)

Source	Alias	Join Type
ckmlhd	hd	inner
ckmlhd	hd	inner
I_MaterialLedgerPrice	INVPR	union_all
fmlv_logistic_currency	log	inner
R_MatlPriceDataMigrationStatus	tf	inner
R_MatlPriceDataMigrationStatus	tf	inner
V_MaterialLedgerPriceBasic2	V_MaterialLedgerPriceBasic2	from

Parameters (1)

Name	Type	Default
P_EndDate	sydate

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	I_MaterialLedgerPrice	STDPR	`STDPR.CostEstimate = INVPR.CostEstimate and STDPR.Material = INVPR.Material and STDPR.ValuationArea = INVPR.ValuationArea and STDPR.CurrencyRole = INVPR.CurrencyRole and STDPR.Ledger = INVPR.Ledger and STDPR.MaterialPriceType = 'STDPR' and STDPR.MaterialPriceSubtype = '' and STDPR.MatlPrcValdtyStrtFsclYearPerd <= INVPR.MatlPrcValdtyStrtFsclYearPerd and STDPR.MatlPrcValdtyEndFsclYearPeriod >= INVPR.MatlPrcValdtyEndFsclYearPeriod`
[0..1]	I_MaterialLedgerPrice	ACT	`ACT.CostEstimate = INVPR.CostEstimate and ACT.Material = INVPR.Material and ACT.ValuationArea = INVPR.ValuationArea and ACT.CurrencyRole = INVPR.CurrencyRole and ACT.Ledger = INVPR.Ledger and ACT.MaterialPriceType = 'ACT' and ACT.MaterialPriceSubtype = 'ACT' and ACT.MatlPrcValdtyStrtFsclYearPerd <= INVPR.MatlPrcValdtyStrtFsclYearPerd and ACT.MatlPrcValdtyEndFsclYearPeriod >= INVPR.MatlPrcValdtyEndFsclYearPeriod`
[0..1]	I_MaterialLedgerPrice	MAP	`MAP.CostEstimate = INVPR.CostEstimate and MAP.Material = INVPR.Material and MAP.ValuationArea = INVPR.ValuationArea and MAP.CurrencyRole = INVPR.CurrencyRole and MAP.Ledger = INVPR.Ledger and MAP.MaterialPriceType = 'MAP' and MAP.MaterialPriceSubtype = '' and MAP.MatlPrcValdtyStrtFsclYearPerd <= INVPR.MatlPrcValdtyStrtFsclYearPerd and MAP.MatlPrcValdtyEndFsclYearPeriod >= INVPR.MatlPrcValdtyEndFsclYearPeriod`

Annotations (8)

Name	Value	Level
AbapCatalog.sqlViewName	VMATLEDGERPRICE	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
EndUserText.label	Material Ledger Price	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ObjectModel.usageType.serviceQuality	#P	view

Fields (31)

Key	Field	Source Table	Source Field	Description
KEY	CostEstimate		CostEstimate	Cost EstimateNo
KEY	Material		Material	Vehicle Model
KEY	ValuationArea		ValuationArea	Valuation Area
KEY	InventoryValuationType		InventoryValuationType	Valuation Type
KEY	InventorySpecialStockType		InventorySpecialStockType	Special Stock
KEY	InventorySpecialStockValnType		InventorySpecialStockValnType	Valuation
KEY	IsSupplierStockValuation		IsSupplierStockValuation	Vendor stk val.
KEY	InventorySpclStkSalesDocument		InventorySpclStkSalesDocument	SD Sched. Agmt
KEY	InventorySpclStkSalesDocItm		InventorySpclStkSalesDocItm	WBS Element
KEY	InventorySpecialStockSupplier		InventorySpecialStockSupplier	Vendor no.
KEY	WBSElementInternalID		WBSElementInternalID	WBS Element
	StandardPriceInCoCodeCrcy	cr	stprs	Standard price
	MovingAveragePriceInCoCodeCrcy	cr	pvprs	Per. Unit Price
	MaterialPriceControl	cr	vprsv	Price Control
	MatPriceUnitInCoCodeCurrency	cr	peinh	Price unit
	CompanyCodeCurrency		CompanyCodeCurrency	Valuation Crcy
	kalnrasCostEstimate
KEY	Material	ckmlhd	matnr	Vehicle Model
KEY	ValuationArea	ckmlhd	bwkey	Valuation Area
KEY	InventoryValuationType	ckmlhd	bwtar	Valuation Type
KEY	InventorySpecialStockType	ckmlhd	sobkz	Special Stock
KEY	InventorySpecialStockValnType	ckmlhd	kzbws	Valuation
KEY	IsSupplierStockValuation	ckmlhd	xobew	Vendor stk val.
KEY	InventorySpclStkSalesDocument	ckmlhd	vbeln	SD Sched. Agmt
KEY	InventorySpclStkSalesDocItm	ckmlhd	posnr	WBS Element
KEY	InventorySpecialStockSupplier	ckmlhd	lifnr	Vendor no.
KEY	WBSElementInternalID	ckmlhd	pspnr	WBS Element
	MaterialPriceControl	I_MaterialLedgerPrice	MaterialPriceControl	Price Control
	MatPriceUnitInCoCodeCurrency	I_MaterialLedgerPrice	MaterialPriceUnitQty	Price unit
	CompanyCodeCurrency	I_MaterialLedgerPrice	Currency	Valuation Crcy
	FiscalYearPeriod	I_MaterialLedgerPrice	MatlPrcValdtyStrtFsclYearPerd

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 V_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.
-- SQL view name: VMATLEDGERPRICE
-- Parameters: P_EndDate : sydate

CREATE VIEW V_MATERIALLEDGERPRICE AS
SELECT
  CostEstimate,
  Material,
  ValuationArea,
  InventoryValuationType,
  InventorySpecialStockType,
  InventorySpecialStockValnType,
  IsSupplierStockValuation,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InventorySpecialStockSupplier,
  WBSElementInternalID,
  cr.stprs AS StandardPriceInCoCodeCrcy,
  cr.pvprs AS MovingAveragePriceInCoCodeCrcy,
  cr.vprsv AS MaterialPriceControl,
  cr.peinh AS MatPriceUnitInCoCodeCurrency,
  CompanyCodeCurrency,
  FiscalYearPeriod AS kalnrasCostEstimate,
  INVPR.MatlPrcValdtyStrtFsclYearPerd AS FiscalYearPeriod
FROM V_MaterialLedgerPriceBasic2
INNER JOIN R_MatlPriceDataMigrationStatus AS tf ON /* join condition not captured in parsed metadata */
INNER JOIN ckmlhd AS hd ON /* join condition not captured in parsed metadata */
INNER JOIN fmlv_logistic_currency AS log ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialLedgerPrice AS STDPR ON STDPR.CostEstimate = INVPR.CostEstimate AND STDPR.Material = INVPR.Material AND STDPR.ValuationArea = INVPR.ValuationArea AND STDPR.CurrencyRole = INVPR.CurrencyRole AND STDPR.Ledger = INVPR.Ledger AND STDPR.MaterialPriceType = 'STDPR' AND STDPR.MaterialPriceSubtype = '' AND STDPR.MatlPrcValdtyStrtFsclYearPerd <= INVPR.MatlPrcValdtyStrtFsclYearPerd AND STDPR.MatlPrcValdtyEndFsclYearPeriod >= INVPR.MatlPrcValdtyEndFsclYearPeriod  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS ACT ON ACT.CostEstimate = INVPR.CostEstimate AND ACT.Material = INVPR.Material AND ACT.ValuationArea = INVPR.ValuationArea AND ACT.CurrencyRole = INVPR.CurrencyRole AND ACT.Ledger = INVPR.Ledger AND ACT.MaterialPriceType = 'ACT' AND ACT.MaterialPriceSubtype = 'ACT' AND ACT.MatlPrcValdtyStrtFsclYearPerd <= INVPR.MatlPrcValdtyStrtFsclYearPerd AND ACT.MatlPrcValdtyEndFsclYearPeriod >= INVPR.MatlPrcValdtyEndFsclYearPeriod  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS MAP ON MAP.CostEstimate = INVPR.CostEstimate AND MAP.Material = INVPR.Material AND MAP.ValuationArea = INVPR.ValuationArea AND MAP.CurrencyRole = INVPR.CurrencyRole AND MAP.Ledger = INVPR.Ledger AND MAP.MaterialPriceType = 'MAP' AND MAP.MaterialPriceSubtype = '' AND MAP.MatlPrcValdtyStrtFsclYearPerd <= INVPR.MatlPrcValdtyStrtFsclYearPerd AND MAP.MatlPrcValdtyEndFsclYearPeriod >= INVPR.MatlPrcValdtyEndFsclYearPeriod  -- association [0..1]
-- UNION ALL with additional select branch(es): I_MaterialLedgerPrice
;

Depth:

V_MATERIALLEDGERPRICE view