P_InvPriceManageDataFromCR

DDL: P_INVPRICEMANAGEDATAFROMCR SQL: PCRDATALINVP Type: view BASIC

P_InvPriceManageDataFromCR is a Basic CDS View 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 (4)

NameValueLevelField
AbapCatalog.sqlViewName PCRDATALINVP view
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
CostEstimate ckmlcr kalnr
FiscalYearPeriod
MaterialPriceUnitQty
curtp curtp
Currency waers
stprs0endasInventoryPrice 
@AbapCatalog.sqlViewName: 'PCRDATALINVP'
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Relevant CKMLCR Data for the Invetory Price view'

define view P_InvPriceManageDataFromCR
  as select from ckmlcr as cr

{
  cr.kalnr                                            as   CostEstimate,
  concat(cr.bdatj,cr.poper)                           as   FiscalYearPeriod,
  COALESCE(cr.peinh, 1)                               as   MaterialPriceUnitQty,
  curtp,
  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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CKMLCR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More