P_MLPRICEPERSISTEDPERIOD

CDS View

P_MLPRICEPERSISTEDPERIOD is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MLPricePersistedPeriod view from COMPOSITE Periods for ML Prices per Currency 
@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