P_MLPricePersistedPeriod

DDL: P_MLPRICEPERSISTEDPERIOD SQL: PMLPRICEPERSPER Type: view BASIC

P_MLPricePersistedPeriod is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (ckmlcr, ckmlhd, R_MatlPriceDataMigrationStatus, t001k) and exposes 7 fields with key fields CostEstimate, ValuationArea, Material, CurrencyRole, FiscalYearPeriod.

4 data source(s) 7 fields

Data Sources (4)

SourceAliasJoin Type
ckmlcr cr from
ckmlhd hd inner
R_MatlPriceDataMigrationStatus tf inner
t001k tk inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PMLPRICEPERSPER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate ckmlcr kalnr
KEY ValuationArea t001k bwkey
KEY Material ckmlhd matnr
KEY CurrencyRole ckmlcr curtp
KEY FiscalYearPeriod
CompanyCode t001k bukrs
MatlPrcMigratedUntilFsclYrPerd 
@AbapCatalog.sqlViewName: 'PMLPRICEPERSPER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #BASIC
define view P_MLPricePersistedPeriod
  as select from ckmlcr as cr
    inner join R_MatlPriceDataMigrationStatus as tf on ( tf.MatlPriceDataMigrationStatus = 'X' ) 
                                                    or ( tf.MatlPriceDataMigrationStatus = 'R' )
    inner join   ckmlhd as hd on hd.kalnr = cr.kalnr
    inner join   t001k  as tk on tk.bwkey = hd.bwkey
{
  key  cr.kalnr                                        as CostEstimate,
  key  tk.bwkey                                        as ValuationArea,
  key  hd.matnr                                        as Material,
  key  cr.curtp                                        as CurrencyRole,
  key  concat(cr.bdatj,cr.poper)                       as FiscalYearPeriod,
       tk.bukrs                                        as CompanyCode,
       cast(hd.price_sdm_yearper as fml_yearper_nconv) as MatlPrcMigratedUntilFsclYrPerd
}
where ( hd.price_sdm_yearper = '0000000' or hd.price_sdm_yearper > concat( bdatj, poper ) ) 
  and cr.sdm_version is initial

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

Learn More