I_MLInventoryPriceRawData

DDL: I_MLINVENTORYPRICERAWDATA SQL: ICKMLCR Type: view BASIC

select relevant data from CKMLCR

I_MLInventoryPriceRawData is a Basic CDS View that provides data about "select relevant data from CKMLCR" in SAP S/4HANA. It reads from 1 data source (ckmlcr) and exposes 6 fields.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
ckmlcr cr from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICKMLCR view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label select relevant data from CKMLCR view

Fields (6)

KeyFieldSource TableSource FieldDescription
CostEstimate ckmlcr kalnr
FiscalYearPeriod
MaterialPriceUnitQty
CurrencyRole curtp
Currency waers
stprs0endasInventoryPrice 
@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