Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

I_ProdValnMatlLdgrCurPerdWD

DDL: I_PRODVALNMATLLDGRCURPERDWD SQL: IPRODVALNCURWD Type: view TRANSACTIONAL
10 Fields 1 Data Sources

Product BO Valuation Material Ledger Current Period (Draft)

I_ProdValnMatlLdgrCurPerdWD is a Transactional CDS View that provides data about "Product BO Valuation Material Ledger Current Period (Draft)" in SAP S/4HANA. It reads from 1 data source (ckmlcr) and exposes 10 fields with key fields ProdCostEstNumber, PostingFiscalYear, LedgerFiscalPeriod, ProfitLossType, CurrencyConversionCalcType.

Data Sources (1)

SourceAliasJoin Type
ckmlcr ckmlcr from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPRODVALNCURWD view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Product BO Valuation Material Ledger Current Period (Draft) view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence PROD_VALN_CUR view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.status #DEPRECATED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ProdCostEstNumber ckmlcr kalnr ProdCostEst.No.
KEY PostingFiscalYear ckmlcr bdatj Year
KEY LedgerFiscalPeriod ckmlcr poper Posting periods
KEY ProfitLossType ckmlcr untper Value Type
KEY CurrencyConversionCalcType ckmlcr curtp Valuation Area
LedgerCurrency ckmlcr waers Transaction Currency
InventoryValuationProcedure ckmlcr vprsv Price control
StandardPrice ckmlcr stprs Standard price
MovingAveragePrice ckmlcr pvprs Per. Unit Price
PriceUnitQty ckmlcr peinh Unit of measure

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 I_ProdValnMatlLdgrCurPerdWD.
-- 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: IPRODVALNCURWD

CREATE VIEW I_ProdValnMatlLdgrCurPerdWD AS
SELECT
  ckmlcr.kalnr AS ProdCostEstNumber,
  ckmlcr.bdatj AS PostingFiscalYear,
  ckmlcr.poper AS LedgerFiscalPeriod,
  ckmlcr.untper AS ProfitLossType,
  ckmlcr.curtp AS CurrencyConversionCalcType,
  ckmlcr.waers AS LedgerCurrency,
  ckmlcr.vprsv AS InventoryValuationProcedure,
  ckmlcr.stprs AS StandardPrice,
  ckmlcr.pvprs AS MovingAveragePrice,
  ckmlcr.peinh AS PriceUnitQty
FROM ckmlcr
;

Learn More