R_NonMigrtdMatlLdgrDocItmValue

DDL: R_NONMIGRTDMATLLDGRDOCITMVALUE SQL: RNMGMLDOCITMVAL Type: view BASIC
16 Fields 3 Data Sources

R_NonMigrtdMatlLdgrDocItmValue is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (fmlt_curtp_ml, mlit, mlcr) and exposes 16 fields with key fields MaterialLedgerDocument, MaterialLedgerDocumentYear, DocumentItemNumber, FiscalYear, FiscalPeriod.

Data Sources (3)

SourceAliasJoin Type
fmlt_curtp_ml c inner
mlit it inner
mlcr m from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName RNMGMLDOCITMVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MaterialLedgerDocument mlcr belnr SD Document
KEY MaterialLedgerDocumentYear mlcr kjahr Year
KEY DocumentItemNumber mlcr posnr WBS Element
KEY FiscalYear mlcr bdatj Year
KEY FiscalPeriod mlcr poper Posting periods
KEY Ledger fmlt_curtp_ml rldnr Ledger (Compat.)
KEY CurrencyRole fmlt_curtp_ml curtp Valuation Area
Currency mlcr waers Transaction Currency
PreviousProductPriceControl mlcr vprsv_old Price control
PreviousStandardPrice mlcr stprs_old Standard Price
PreviousMovingAveragePrice mlcr pvprs_old Per. Unit Price
InventoryAmountChangeAmount mlcr salk3 Total Value
PrevInvtryPriceInventoryAmount mlcr salk3_old Inventory Value
MvgAvgPrInvtryAmtChangeAmount mlcr salkv Value/MA price
PrevMvgAvgPriceInventoryAmount mlcr salkv_old Val./Per.Unit Prc
PreviousMaterialPriceUnitQty mlcr 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 R_NonMigrtdMatlLdgrDocItmValue.
-- 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: RNMGMLDOCITMVAL

CREATE VIEW R_NonMigrtdMatlLdgrDocItmValue AS
SELECT
  m.belnr AS MaterialLedgerDocument,
  m.kjahr AS MaterialLedgerDocumentYear,
  m.posnr AS DocumentItemNumber,
  m.bdatj AS FiscalYear,
  m.poper AS FiscalPeriod,
  c.rldnr AS Ledger,
  c.curtp AS CurrencyRole,
  m.waers AS Currency,
  m.vprsv_old AS PreviousProductPriceControl,
  m.stprs_old AS PreviousStandardPrice,
  m.pvprs_old AS PreviousMovingAveragePrice,
  m.salk3 AS InventoryAmountChangeAmount,
  m.salk3_old AS PrevInvtryPriceInventoryAmount,
  m.salkv AS MvgAvgPrInvtryAmtChangeAmount,
  m.salkv_old AS PrevMvgAvgPriceInventoryAmount,
  m.peinh AS PreviousMaterialPriceUnitQty
FROM mlcr AS m
INNER JOIN mlit AS it ON /* join condition not captured in parsed metadata */
INNER JOIN fmlt_curtp_ml AS c ON /* join condition not captured in parsed metadata */
;

Learn More