I_MatlLdgrDocumentItemPrice

DDL: I_MATLLDGRDOCUMENTITEMPRICE SQL: IMLDOCITMPR Type: view COMPOSITE Package: FINS_ML_DOCUMENT
15 Fields 1 Data Sources

Material Ledger Document Item Prices

I_MatlLdgrDocumentItemPrice is a Composite CDS View that provides data about "Material Ledger Document Item Prices" in SAP S/4HANA. It reads from 1 data source (R_MigrtdMatlLdgrDocItemPrice) and exposes 15 fields with key fields MaterialLedgerDocument, MaterialLedgerDocumentYear, DocumentItemNumber, FiscalYear, FiscalPeriod. Part of development package FINS_ML_DOCUMENT.

Data Sources (1)

SourceAliasJoin Type
R_MigrtdMatlLdgrDocItemPrice R_MigrtdMatlLdgrDocItemPrice from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IMLDOCITMPR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY MaterialLedgerDocument MaterialLedgerDocument SD Document
KEY MaterialLedgerDocumentYear MaterialLedgerDocumentYear Year
KEY DocumentItemNumber DocumentItemNumber Item
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY Ledger Ledger Ledger
KEY CurrencyRole CurrencyRole Curr./Val. Type
Currency Currency Valuation Crcy
InventoryPrice InventoryPrice Price
MovingAveragePrice MovingAveragePrice Per. Unit Price
StandardPrice StandardPrice Standard price
ProductPriceControl ProductPriceControl Price control
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
PriceChangeCause PriceChangeCause
FiscalYearPeriod FiscalYearPeriod Period/Year

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_MatlLdgrDocumentItemPrice.
-- 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: IMLDOCITMPR

CREATE VIEW I_MatlLdgrDocumentItemPrice AS
SELECT
  MaterialLedgerDocument,
  MaterialLedgerDocumentYear,
  DocumentItemNumber,
  FiscalYear,
  FiscalPeriod,
  Ledger,
  CurrencyRole,
  Currency,
  InventoryPrice,
  MovingAveragePrice,
  StandardPrice,
  ProductPriceControl,
  MaterialPriceUnitQty,
  PriceChangeCause,
  FiscalYearPeriod
FROM R_MigrtdMatlLdgrDocItemPrice
;

Learn More