I_MATERIALLEDGERPRICE

CDS View

Material Ledger Price

I_MATERIALLEDGERPRICE is a CDS View in S/4HANA. Material Ledger Price. It contains 24 fields. 27 CDS views read from this table.

CDS Views using this table (27)

ViewTypeJoinVDMDescription
C_MatlLdgrPrChangedByUserVH view_entity inner CONSUMPTION Changed By
C_MatlLdgrPrCreatedByUserVH view_entity inner CONSUMPTION Created By
I_MaterialLedgerPriceOverview view_entity from TRANSACTIONAL Material Price Change
I_MatlValnMngMrkdReldCostEst view_entity from COMPOSITE Matl Valuations Marked and Reld Cost Est
I_MLPrcWthUnivCompBreakdown view_entity from COMPOSITE Material Ledger Price with Break Down ID
P_CURRENTMATLVALNPRICE view_entity from COMPOSITE Material Valuation Prices - Current/Previous/PrevYear Period
P_CURRENTMATLVALNPRICEDEX view_entity from COMPOSITE Material Valuation Prices - Current/Previous/PrevYear Period
P_InventoryPriceByKeydate view from COMPOSITE Inventory Price by kaydate
P_InvPricesMaxFis view from COMPOSITE select the unique costestimate
P_MaterialValuation view from COMPOSITE Material Valuation
P_MaterialValuation view union_all COMPOSITE Material Valuation
P_MatlLdgrPriceByValuation view_entity from COMPOSITE Material Ledger Price by Valuation
P_MatVal_By_Period_Types view from COMPOSITE Prices and values for app Mat. Val. Manage
P_MatVal_By_Period_Types view union_all COMPOSITE Prices and values for app Mat. Val. Manage
P_MatVal_By_Periods view from COMPOSITE Prices and values for app Mat. Val. Manage
P_Matval_Manage_Ckml view_entity from COMPOSITE Base View for Mat.Val., CKML* tables
P_Matval_Manage_Ckml view_entity left_outer COMPOSITE Base View for Mat.Val., CKML* tables
P_Matval_Manage_Cost view_entity from COMPOSITE Manage Material Valuations, table of cost estimates
P_MATVAL_MANAGE_MD_FMLT view from COMPOSITE Master Data for Material Valuations
P_Matval_Manage_Val_Chart view from COMPOSITE Base View for Mat.Val., Balances
P_MlPrice_By_Periodtype view from COMPOSITE Material Ledger Prices CKMLCR/HD Max. Period
P_MlPrice_By_Periodtype view union_all COMPOSITE Material Ledger Prices CKMLCR/HD Max. Period
P_MntrMatlPrWthoutTblFunc view_entity from COMPOSITE Grouped Material Ledger Prices without table function
P_MonitorMaterialPrice view_entity from COMPOSITE Grouped Material Ledger Prices
R_InventoryPriceByKeyDate view_entity from COMPOSITE Inventory Price by key date
R_MatlPriceSpclStockValnStrgy view from COMPOSITE Mat Price Spec Stock Valuation Strategy
V_MATERIALLEDGERPRICE view from Material Ledger Price

Fields (24)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 12
KEY CostEstimate CostEstimate 14
KEY CurrencyRole CurrencyRole 9
KEY InventoryValuationType InventoryValuationType,ValuationType 6
KEY Ledger Ledger 9
KEY Material Material 9
KEY MatlPrcValdtyStartFiscalPeriod FiscalPeriod 1
KEY MatlPrcValidityStartFiscalYear FiscalYear 1
KEY ValuationArea Plant,ValuationArea 11
CurPlanProjSlsOrdValnStrategy CurPlanProjSlsOrdValnStrategy 2
Currency CompanyCodeCurrency,Currency 14
FixedPortionOfMaterialPrice FixedPortionOfPlannedPrice 2
InvtryValnSpecialStockType InvtryValnSpecialStockType 1
MaterialPrice FuturePrice,InventoryPrice,MaterialPrice,PlannedPrice 10
MaterialPriceControl MaterialPriceControl 8
MaterialPriceType MaterialPriceType 1
MaterialPriceUnitQty MaterialPriceUnitQty,MatPriceUnitInCoCodeCurrency 13
MaterialPriceValidityEndDate MaterialPriceValidityEndDate 1
MaterialPriceValidityStartDate FuturePriceValidityStartDate,MaterialPriceValidityStartDate 3
MatlPrcValdtyEndFsclYearPeriod MatlPrcValdtyEndFsclYearPeriod 2
MatlPrcValdtyStrtFsclYearPerd FiscalYearPeriod,MatlPrcValdtyStrtFsclYearPerd,MaxFiscPerCKMLPP 4
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
ValuationQuantityUnit BaseUnit,ValuationQuantityUnit 7
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@EndUserText.label: 'Material Ledger Price'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view entity I_MaterialLedgerPrice
  as select from P_MaterialLedgerPrice

  association [0..*] to I_Plant               as _Plant               on $projection.ValuationArea = _Plant.ValuationArea
  association [1..1] to I_Material            as _Material            on $projection.Material = _Material.Material
  association [1..1] to I_Product             as _Product             on $projection.Material = _Product.Product
  association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
  association [1..1] to I_CompanyCode         as _CompanyCode         on $projection.CompanyCode = _CompanyCode.CompanyCode
  association [1..1] to I_Ledger              as _Ledger              on $projection.Ledger = _Ledger.Ledger
  association [1..1] to I_CurrencyRole        as _CurrencyRole        on $projection.CurrencyRole = _CurrencyRole.CurrencyRole

{
  key  CostEstimate,
  key  Ledger,
  key  CurrencyRole,
  key  MaterialPriceType,
  key  MaterialPriceSubtype,
  key  MaterialPriceValidityStartDate,
       MaterialPriceValidityEndDate,
       MatlPrcValdtyStrtFsclYearPerd,
       MatlPrcValidityStartFiscalYear,
       MatlPrcValdtyStartFiscalPeriod,
       MatlPrcValdtyEndFsclYearPeriod,
       MatlPrcValidityEndFiscalYear,
       MatlPrcValdtyEndFiscalPeriod,
       @Semantics.amount.currencyCode: 'Currency'
       MaterialPrice,
       @Semantics.amount.currencyCode: 'Currency'
       FixedPortionOfMaterialPrice,
       Currency,
       MaterialPriceUnitQty,
       ValuationQuantityUnit,
       MaterialPriceControl,
       CurPlanProjSlsOrdValnStrategy,
       MaterialPriceCostEstimateStage,
       Material,
       ValuationArea,
       InventoryValuationType,
       CompanyCode,
       InvtryValnSpecialStockType,
       SalesOrder,
       SalesOrderItem,
       WBSElementInternalID,
       Supplier,
       StkMaterialPriceValuationType,
       MaterialPriceExtRefCategory,
       MaterialPriceExtReference,
       MaterialPriceCreatedByUser,
       MaterialPriceChangedByUser,
       MaterialPriceCreationDateTime,
       MatlPriceLastChangeDateTime,
       ComponentBreakdown,
       _Plant,
       _Material,
       _Product,
       _WBSElementBasicData,
       _CompanyCode,
       _Ledger,
       _CurrencyRole

}