I_MATERIALLEDGERPRICE

@AbapCatalog.sqlViewName: 'IMLPRICE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Material Ledger Price'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view 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,
       _Plant,
       _Material,
       _Product,
       _WBSElementBasicData,
       _CompanyCode,
       _Ledger,
       _CurrencyRole

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_MATERIALLEDGERPRICE"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CURRENCYROLE",
"I_LEDGER",
"I_MATERIAL",
"I_PLANT",
"I_PRODUCT",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/