I_MLPrExtRefCostEstimate

@AbapCatalog.sqlViewName: 'IMLPEXTREFCE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Material Price Ext Ref for Cost Est Key'
@ObjectModel.usageType: {
  dataClass: #TRANSACTIONAL,
  serviceQuality: #B,
  sizeCategory: #M
}
@VDM.viewType: #BASIC

define view I_MLPrExtRefCostEstimate
  as select from P_MaterialLedgerPrice

{
  key CostEstimate,
  key Ledger,
  key CurrencyRole,
  key MaterialPriceType,
  key MaterialPriceSubtype,
  key MaterialPriceValidityStartDate,
      MaterialPriceValidityEndDate,
      MatlPrcValidityStartFiscalYear,
      MatlPrcValdtyStartFiscalPeriod,
      MatlPrcValdtyStrtFsclYearPerd,
      MatlPrcValidityEndFiscalYear,
      MatlPrcValdtyEndFiscalPeriod,
      @Semantics.amount.currencyCode: 'Currency'
      MaterialPrice,
      @Semantics.amount.currencyCode: 'Currency'
      FixedPortionOfMaterialPrice,
      Currency,
      MaterialPriceUnitQty,
      ValuationQuantityUnit,
      MaterialPriceCostEstimateStage,
      Material,
      ValuationArea,
      CompanyCode,
      MaterialPriceExtRefCategory,
      MaterialPriceExtReference,
      cast( substring(MaterialPriceExtReference, 1, 1) as ck_obj preserving type )     as CostingReferenceObject,
      cast( substring(MaterialPriceExtReference, 3, 12) as ck_kalnr1 )                 as ProdCostEstNumber,
      cast( substring(MaterialPriceExtReference, 16, 2) as ck_kalka  preserving type ) as CostingType,
      cast( substring(MaterialPriceExtReference, 19, 8) as ck_kadky  )                 as CostingDate,
      cast( substring(MaterialPriceExtReference, 28, 2) as ck_tvers  )                 as CostingVersion,
      cast( substring(MaterialPriceExtReference, 31, 3) as ck_bwvar preserving type )  as ValuationVariant,
      cast ( '' as ck_kkzma preserving type )                                          as CostIsEnteredManually,
      CurPlanProjSlsOrdValnStrategy

}
where
       MaterialPriceExtRefCategory =  '01'
  and

       MaterialPriceExtReference   <> ''

  and(

       MaterialPriceType           =  'FSTDCE'
    or MaterialPriceType           =  'STDCE'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_MATERIALLEDGERPRICE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/