I_MATERIALLEDGERPRICE
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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
}