FMLV_CKMLPRKEKO_UCT_UNION

@AbapCatalog.sqlViewName: 'FCKMLPRKEKOUCTSD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Material Ledger: Cost Component Split (Header) for Prices'

define view FMLV_CKMLPRKEKO_UCT_UNION
  as select from    ckmlprkekold        as m
    left outer join finsv_unique_cvtyps as curr on  curr.ext_curtype = m.ext_curtype
                                                and curr.rldnr       = m.rldnr
{
  key  m.kalnr                             as kalnr,
  key  m.bdatj                             as bdatj,
  key  m.poper                             as poper,
  key  m.untper                            as untper,
  key  m.prtyp                             as prtyp,
  key  curr.curtype                        as curtp,

       losgr,
       meins,
       elehk,
       elehkns,
       cast( '01' as fins_ml_sdm_version ) as sdm_version

}

union all select from ckmlprkeko               as m
  inner join          ckmllahd                 as hd       on hd.kalnr = m.kalnr
  inner join          t001w                    as w        on w.werks = hd.werks 
  inner join          t001k                    as k        on k.bwkey = w.bwkey
  left outer join     FMLV_EXTERNAL_CURTYPE_ML as curtp_ml on  curtp_ml.rbukrs      = k.bukrs
                                                           and curtp_ml.ext_curtype = m.curtp
  left outer join     finsv_unique_cvtyps      as curtp    on  curtp.ext_curtype = m.curtp
                                                           and curtp.rldnr       = curtp_ml.rldnr
{
  key  m.kalnr       as kalnr,
  key  m.bdatj       as bdatj,
  key  m.poper       as poper,
  key  m.untper      as untper,
  key  m.prtyp       as prtyp,
  key  curtp.curtype as curtp,

       losgr,
       meins,
       elehk,
       elehkns,
       sdm_version
}
where
  sdm_version < '01'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINSV_UNIQUE_CVTYPS",
"FMLV_EXTERNAL_CURTYPE_ML",
"CKMLLAHD",
"CKMLPRKEKO",
"CKMLPRKEKOLD",
"T001K",
"T001W"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/