I_MaterialLedgerPrice

DDL: I_MATERIALLEDGERPRICE Type: view_entity BASIC Package: FINS_ML_VDM

Material Ledger Price

I_MaterialLedgerPrice is a Basic CDS View that provides data about "Material Ledger Price" in SAP S/4HANA. It reads from 1 data source (P_MaterialLedgerPrice) and exposes 45 fields with key fields CostEstimate, Ledger, CurrencyRole, MaterialPriceType, MaterialPriceSubtype. It has 7 associations to related views. Part of development package FINS_ML_VDM.

1 data source(s) 45 fields

Data Sources (1)

SourceAliasJoin Type
P_MaterialLedgerPrice P_MaterialLedgerPrice from

Associations (7)

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

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
EndUserText.label Material Ledger Price view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate
KEY Ledger Ledger
KEY CurrencyRole CurrencyRole
KEY MaterialPriceType MaterialPriceType
KEY MaterialPriceSubtype MaterialPriceSubtype
KEY MaterialPriceValidityStartDate MaterialPriceValidityStartDate
MaterialPriceValidityEndDate MaterialPriceValidityEndDate
MatlPrcValdtyStrtFsclYearPerd MatlPrcValdtyStrtFsclYearPerd
MatlPrcValidityStartFiscalYear MatlPrcValidityStartFiscalYear
MatlPrcValdtyStartFiscalPeriod MatlPrcValdtyStartFiscalPeriod
MatlPrcValdtyEndFsclYearPeriod MatlPrcValdtyEndFsclYearPeriod
MatlPrcValidityEndFiscalYear MatlPrcValidityEndFiscalYear
MatlPrcValdtyEndFiscalPeriod MatlPrcValdtyEndFiscalPeriod
MaterialPrice MaterialPrice
FixedPortionOfMaterialPrice FixedPortionOfMaterialPrice
Currency Currency
MaterialPriceUnitQty MaterialPriceUnitQty
ValuationQuantityUnit ValuationQuantityUnit
MaterialPriceControl MaterialPriceControl
CurPlanProjSlsOrdValnStrategy CurPlanProjSlsOrdValnStrategy
MaterialPriceCostEstimateStage MaterialPriceCostEstimateStage
Material Material
ValuationArea ValuationArea
InventoryValuationType InventoryValuationType
CompanyCode CompanyCode
InvtryValnSpecialStockType InvtryValnSpecialStockType
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
WBSElementInternalID WBSElementInternalID
Supplier Supplier
StkMaterialPriceValuationType StkMaterialPriceValuationType
MaterialPriceExtRefCategory MaterialPriceExtRefCategory
MaterialPriceExtReference MaterialPriceExtReference
MaterialPriceCreatedByUser MaterialPriceCreatedByUser
MaterialPriceChangedByUser MaterialPriceChangedByUser
MaterialPriceCreationDateTime MaterialPriceCreationDateTime
MatlPriceLastChangeDateTime MatlPriceLastChangeDateTime
ComponentBreakdown ComponentBreakdown
_Plant _Plant
_Material _Material
_Product _Product
_WBSElementBasicData _WBSElementBasicData
_CompanyCode _CompanyCode
_Ledger _Ledger
_CurrencyRole _CurrencyRole 
@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

}

Learn More