I_ProdValnMatlLdgrCurPerdWD

@AbapCatalog.sqlViewName: 'IPRODVALNCURWD'
//@ClientDependent: true

//@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
//@VDM.viewType:#BASIC

@EndUserText.label: 'Product BO Valuation Material Ledger Current Period (Draft)'
//@Search.searchable: true

@VDM.viewType:#TRANSACTIONAL
@ObjectModel: {
  writeDraftPersistence: 'PROD_VALN_CUR',
  //draftEnabled:          true,

  semanticKey:           ['ProdCostEstNumber', 'PostingFiscalYear', 'LedgerFiscalPeriod', 'ProfitLossType', 'CurrencyConversionCalcType'],
  createEnabled:         true,
  deleteEnabled:         true,
  updateEnabled:         true,
  usageType.serviceQuality: #D,
  usageType.sizeCategory : #L,
  usageType.dataClass: #TRANSACTIONAL
}
@VDM.lifecycle.status: #DEPRECATED

define view I_ProdValnMatlLdgrCurPerdWD
  as select from ckmlcr // Zi_Prodvalnmatlldgrcurperd as MLCurPrd

  //  association [1..1] to I_ProductValuationWD as _ValuationArea on  $projection.ProdCostEstNumber  = _ValuationArea.ProdCostEstNumber

  //                                                               and $projection.PostingFiscalYear  = _ValuationArea.FiscalYearCurrentPeriod

  //                                                               and $projection.LedgerFiscalPeriod = _ValuationArea.FiscalMonthCurrentPeriod

  //                                                               and $projection.ProfitLossType     = '000'

  //association [1..1] to I_ProductWD      as _Product           on  _ValuattionArea.product               = _Product.Product

{
      //  key MLCurPrd.ProdCostEstNumber,

      //  key MLCurPrd.PostingFiscalYear,

      //  key MLCurPrd.LedgerFiscalPeriod,

      //  key MLCurPrd.ProfitLossType,

      //  key MLCurPrd.CurrencyConversionCalcType,

      //  @Search.defaultSearchElement: true

      //  MLCurPrd.LedgerCurrency,

      //  MLCurPrd.InventoryValuationProcedure,

      //  case when MLCurPrd.InventoryValuationProcedure = 'S' then MLCurPrd.StandardPrice else  MLCurPrd.MovingAveragePrice end as InventoryPrice ,

      //

      //  //MLCurPrd.StandardPrice,

      //  //MLCurPrd.MovingAveragePrice,

      //  MLCurPrd.PriceUnitQty


  key ckmlcr.kalnr  as ProdCostEstNumber,
  key ckmlcr.bdatj  as PostingFiscalYear,
  key ckmlcr.poper  as LedgerFiscalPeriod,
  key ckmlcr.untper as ProfitLossType,
  key ckmlcr.curtp  as CurrencyConversionCalcType,
      //@Search.defaultSearchElement: true

      @Semantics.currencyCode: true
      ckmlcr.waers  as LedgerCurrency, //PurReqnItemCurrency CountryCurrency

      ckmlcr.vprsv  as InventoryValuationProcedure,
      @Semantics.amount.currencyCode: 'LedgerCurrency'
      ckmlcr.stprs  as StandardPrice,
      @Semantics.amount.currencyCode: 'LedgerCurrency'
      ckmlcr.pvprs  as MovingAveragePrice,
      //Case when vprsv = 'S' then ckmlcr.stprs else  ckmlcr.pvprs end as InventoryPrice   ,



      ckmlcr.peinh  as PriceUnitQty


}