I_MATERIALLEDGERPRICE

CDS View
31 Fields 31 CDS Views

Material Ledger Price

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

CDS Views using this table (31)

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_MatlLdgrPrByMltplValuations view_entity from COMPOSITE Material Ledger Price by Price Type
P_MatlLdgrPriceByValuation view_entity from COMPOSITE Material Ledger Price by Valuation
P_MatVal_By_Period_Types view union_all COMPOSITE Prices and values for app Mat. Val. Manage
P_MatVal_By_Period_Types view from 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 union_all COMPOSITE Material Ledger Prices CKMLCR/HD Max. Period
P_MlPrice_By_Periodtype view from 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_InventoryPriceByKeyDate2 view_entity from COMPOSITE Inventory Price by key date
R_InventoryPriceByKeyDateWide view_entity from COMPOSITE Inventory Price by key date
R_MatlLdgrPriceByTwoValuations view_entity from COMPOSITE Price Comparison in Two Valuations
R_MatlPriceSpclStockValnStrgy view from COMPOSITE Mat Price Spec Stock Valuation Strategy
V_MATERIALLEDGERPRICE view from Material Ledger Price

Fields (31)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 15
KEY CostEstimate CostEstimate 17
KEY CurrencyRole CurrencyRole 11
KEY InventoryValuationType InventoryValuationType,ValuationType 8
KEY Ledger Ledger 11
KEY Material Material 11
KEY MaterialPriceSubtype MaterialPriceSubtype 1
KEY MaterialPriceType MaterialPriceType 2
KEY MaterialPriceValidityEndDate MaterialPriceValidityEndDate,MaterialPriceValuation1EndDate 2
KEY MaterialPriceValidityStartDate FuturePriceValidityStartDate,MaterialPriceValidityStartDate,MaterialPriceValuation1StrtDt 4
KEY MatlPrcValdtyStartFiscalPeriod FiscalPeriod 1
KEY MatlPrcValidityStartFiscalYear FiscalYear 1
KEY ValuationArea Plant,ValuationArea 13
CurPlanProjSlsOrdValnStrategy CurPlanProjSlsOrdValnStrategy 3
Currency CompanyCodeCurrency,Currency,FreeDefinedCurrency1 17
FixedPortionOfMaterialPrice FixedPortionOfPlannedPrice 2
InvtryValnSpecialStockType InvtryValnSpecialStockType 2
MaterialPrice FuturePrice,InventoryPrice,MaterialPrice,PlannedPrice 12
MaterialPriceControl MaterialPriceControl 11
MaterialPriceCostEstimateStage MaterialPriceCostEstimateStage 1
MaterialPriceExtRefCategory MaterialPriceExtRefCategory 1
MaterialPriceExtReference MaterialPriceExtReference 1
MaterialPriceUnitQty MaterialPriceUnitQty,MatPriceUnitInCoCodeCurrency 15
MatlPrcValdtyEndFsclYearPeriod MatlPrcValdtyEndFsclYearPeriod 2
MatlPrcValdtyStrtFsclYearPerd FiscalYearPeriod,MatlPrcValdtyStrtFsclYearPerd,MaxFiscPerCKMLPP 4
SalesOrder SalesOrder 3
SalesOrderItem SalesOrderItem 3
StkMaterialPriceValuationType StkMaterialPriceValuationType 1
Supplier Supplier 2
ValuationQuantityUnit AdditionalQuantity1Unit,BaseUnit,ValuationQuantityUnit 10
WBSElementInternalID WBSElementInternalID 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Material Ledger Price
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALLEDGERPRICE (
    COMPANYCODE,
    COSTESTIMATE,
    CURRENCYROLE,
    INVENTORYVALUATIONTYPE,
    LEDGER,
    MATERIAL,
    MATERIALPRICESUBTYPE,
    MATERIALPRICETYPE,
    MATERIALPRICEVALIDITYENDDATE,
    MATERIALPRICEVALIDITYSTARTDATE,
    MATLPRCVALDTYSTARTFISCALPERIOD,
    MATLPRCVALIDITYSTARTFISCALYEAR,
    VALUATIONAREA,
    CURPLANPROJSLSORDVALNSTRATEGY,
    CURRENCY,
    FIXEDPORTIONOFMATERIALPRICE,
    INVTRYVALNSPECIALSTOCKTYPE,
    MATERIALPRICE,
    MATERIALPRICECONTROL,
    MATERIALPRICECOSTESTIMATESTAGE,
    MATERIALPRICEEXTREFCATEGORY,
    MATERIALPRICEEXTREFERENCE,
    MATERIALPRICEUNITQTY,
    MATLPRCVALDTYENDFSCLYEARPERIOD,
    MATLPRCVALDTYSTRTFSCLYEARPERD,
    SALESORDER,
    SALESORDERITEM,
    STKMATERIALPRICEVALUATIONTYPE,
    SUPPLIER,
    VALUATIONQUANTITYUNIT,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (COMPANYCODE, COSTESTIMATE, CURRENCYROLE, INVENTORYVALUATIONTYPE, LEDGER, MATERIAL, MATERIALPRICESUBTYPE, MATERIALPRICETYPE, MATERIALPRICEVALIDITYENDDATE, MATERIALPRICEVALIDITYSTARTDATE, MATLPRCVALDTYSTARTFISCALPERIOD, MATLPRCVALIDITYSTARTFISCALYEAR, VALUATIONAREA)
);

Learn More