I_MLINVENTORYPRICERAWDATA

CDS View

select relevant data from CKMLCR

I_MLINVENTORYPRICERAWDATA is a CDS View in S/4HANA. select relevant data from CKMLCR. It contains 2 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 2 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_InvPricesMaxFis view inner COMPOSITE
P_MLValAreaMaxPeriod view inner COMPOSITE

Fields (2)

KeyField CDS FieldsUsed in Views
Currency Currency 1
InventoryPrice InventoryPrice 1 
@AbapCatalog.sqlViewName: 'ICKMLCR'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'select relevant data from CKMLCR'

define view I_MLInventoryPriceRawData
  as select from ckmlcr as cr

{
  cr.kalnr                                            as   CostEstimate,
  concat(cr.bdatj,cr.poper)                           as   FiscalYearPeriod,
  COALESCE(cr.peinh, 1)                               as   MaterialPriceUnitQty,
  curtp                                               as   CurrencyRole,
  waers                                               as   Currency,
  case cr.vprsv
        when 'S' then COALESCE(cr.stprs, 0)
        when 'V' then COALESCE(cr.pvprs, 0)
        else COALESCE(cr.stprs, 0)
      end                                             as   InventoryPrice
}

where curtp = '10'
  and sdm_version = ' '

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CKMLCR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More