I_PriceChangeDocumentItem

DDL: I_PRICECHANGEDOCUMENTITEM SQL: IPRCHGDOCITEM Type: view COMPOSITE Package: FINS_ML_DOCUMENT
50 Fields 1 Data Sources

Material Ledger Document Item Details

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

Data Sources (1)

SourceAliasJoin Type
I_MatlLdgrDocumentItemPrice Price from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPRCHGDOCITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
EndUserText.label Material Ledger Document Item Details view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY MaterialLedgerDocument Dimension MaterialLedgerDocument
KEY MaterialLedgerDocumentYear Dimension MaterialLedgerDocumentYear
KEY DocumentItemNumber Dimension DocumentItemNumber Item
KEY Ledger I_MatlLdgrDocumentItemPrice Ledger Ledger
KEY CurrencyRole I_MatlLdgrDocumentItemPrice CurrencyRole Curr./Val. Type
KEY FiscalYear I_MatlLdgrDocumentItemPrice FiscalYear G/L Fiscal Year
KEY FiscalPeriod I_MatlLdgrDocumentItemPrice FiscalPeriod Tax period
CompanyCode Dimension CompanyCode Receiver Company Code
ValuationArea Dimension ValuationArea Valuation Area
ProdCostEstNumber Dimension ProdCostEstNumber ProdCostEst.No.
SourceDocumentItem Dimension SourceDocumentItem
Product Dimension Product Product Sold
ValuationType Dimension ValuationType Valuation Type
MaterialBaseUnit Dimension MaterialBaseUnit Valuation Unit
Division Dimension Division Internal Division ID
BusinessArea Dimension BusinessArea Business Area
ValuationAreaGroup Dimension ValuationAreaGroup
ChartOfAccounts Dimension ChartOfAccounts Node Class
PriceDeterminationControl Dimension PriceDeterminationControl Price Determ.
MaterialLedgerItemType Dimension MaterialLedgerItemType
MaterialLedgerUpdateStructure Dimension MaterialLedgerUpdateStructure
MaterialLedgerProcessType Dimension MaterialLedgerProcessType
SalesDocument Dimension SalesDocument SD Document
SalesDocumentItem Dimension SalesDocumentItem Sales Document Item
InventorySpecialStockSupplier Dimension InventorySpecialStockSupplier
InvtryValnSpecialStockType Dimension InvtryValnSpecialStockType
WBSElementInternalID Dimension WBSElementInternalID WBS Internal ID
PostingDate Quantity PostingDate Posting Date for GR
MaterialLedgerPeriodType Quantity MaterialLedgerPeriodType
PreviousInventoryQuantity Quantity PreviousInventoryQuantity
ValuationClass Quantity ValuationClass Valuation Class
InventoryPrice I_MatlLdgrDocumentItemPrice InventoryPrice Price
MovingAveragePrice I_MatlLdgrDocumentItemPrice MovingAveragePrice Per. Unit Price
StandardPrice I_MatlLdgrDocumentItemPrice StandardPrice Standard price
ProductPriceControl I_MatlLdgrDocumentItemPrice ProductPriceControl Price control
MaterialPriceUnitQty I_MatlLdgrDocumentItemPrice MaterialPriceUnitQty Price unit
PriceChangeCause I_MatlLdgrDocumentItemPrice PriceChangeCause
FiscalYearPeriod I_MatlLdgrDocumentItemPrice FiscalYearPeriod Period/Year
Currency Value Currency Valuation Crcy
PreviousProductPriceControl Value PreviousProductPriceControl
PreviousStandardPrice Value PreviousStandardPrice
PreviousMovingAveragePrice Value PreviousMovingAveragePrice
PreviousInventoryPrice Value PreviousInventoryPrice
InventoryAmountChangeAmount Value InventoryAmountChangeAmount
PrevInvtryPriceInventoryAmount Value PrevInvtryPriceInventoryAmount
MvgAvgPrInvtryAmtChangeAmount Value MvgAvgPrInvtryAmtChangeAmount
PrevMvgAvgPriceInventoryAmount Value PrevMvgAvgPriceInventoryAmount
PreviousMaterialPriceUnitQty Value PreviousMaterialPriceUnitQty
MatlLdgrPriceRevaluationAmount Revaluation MatlLdgrPriceRevaluationAmount
MatlLdgrExchRateRevalAmount Revaluation MatlLdgrExchRateRevalAmount

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_PriceChangeDocumentItem.
-- 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: IPRCHGDOCITEM

CREATE VIEW I_PriceChangeDocumentItem AS
SELECT
  Dimension.MaterialLedgerDocument AS MaterialLedgerDocument,
  Dimension.MaterialLedgerDocumentYear AS MaterialLedgerDocumentYear,
  Dimension.DocumentItemNumber AS DocumentItemNumber,
  Price.Ledger AS Ledger,
  Price.CurrencyRole AS CurrencyRole,
  Price.FiscalYear AS FiscalYear,
  Price.FiscalPeriod AS FiscalPeriod,
  Dimension.CompanyCode AS CompanyCode,
  Dimension.ValuationArea AS ValuationArea,
  Dimension.ProdCostEstNumber AS ProdCostEstNumber,
  Dimension.SourceDocumentItem AS SourceDocumentItem,
  Dimension.Product AS Product,
  Dimension.ValuationType AS ValuationType,
  Dimension.MaterialBaseUnit AS MaterialBaseUnit,
  Dimension.Division AS Division,
  Dimension.BusinessArea AS BusinessArea,
  Dimension.ValuationAreaGroup AS ValuationAreaGroup,
  Dimension.ChartOfAccounts AS ChartOfAccounts,
  Dimension.PriceDeterminationControl AS PriceDeterminationControl,
  Dimension.MaterialLedgerItemType AS MaterialLedgerItemType,
  Dimension.MaterialLedgerUpdateStructure AS MaterialLedgerUpdateStructure,
  Dimension.MaterialLedgerProcessType AS MaterialLedgerProcessType,
  Dimension.SalesDocument AS SalesDocument,
  Dimension.SalesDocumentItem AS SalesDocumentItem,
  Dimension.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  Dimension.InvtryValnSpecialStockType AS InvtryValnSpecialStockType,
  Dimension.WBSElementInternalID AS WBSElementInternalID,
  Quantity.PostingDate AS PostingDate,
  Quantity.MaterialLedgerPeriodType AS MaterialLedgerPeriodType,
  Quantity.PreviousInventoryQuantity AS PreviousInventoryQuantity,
  Quantity.ValuationClass AS ValuationClass,
  Price.InventoryPrice AS InventoryPrice,
  Price.MovingAveragePrice AS MovingAveragePrice,
  Price.StandardPrice AS StandardPrice,
  Price.ProductPriceControl AS ProductPriceControl,
  Price.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  Price.PriceChangeCause AS PriceChangeCause,
  Price.FiscalYearPeriod AS FiscalYearPeriod,
  Value.Currency AS Currency,
  Value.PreviousProductPriceControl AS PreviousProductPriceControl,
  Value.PreviousStandardPrice AS PreviousStandardPrice,
  Value.PreviousMovingAveragePrice AS PreviousMovingAveragePrice,
  Value.PreviousInventoryPrice AS PreviousInventoryPrice,
  Value.InventoryAmountChangeAmount AS InventoryAmountChangeAmount,
  Value.PrevInvtryPriceInventoryAmount AS PrevInvtryPriceInventoryAmount,
  Value.MvgAvgPrInvtryAmtChangeAmount AS MvgAvgPrInvtryAmtChangeAmount,
  Value.PrevMvgAvgPriceInventoryAmount AS PrevMvgAvgPriceInventoryAmount,
  Value.PreviousMaterialPriceUnitQty AS PreviousMaterialPriceUnitQty,
  Revaluation.MatlLdgrPriceRevaluationAmount AS MatlLdgrPriceRevaluationAmount,
  Revaluation.MatlLdgrExchRateRevalAmount AS MatlLdgrExchRateRevalAmount
FROM I_MatlLdgrDocumentItemPrice AS Price
;

Learn More