FMLV_CKMLLACR_UCT_UNION

@AbapCatalog.sqlViewName: 'FCKMLLACRUCTSDM'
@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: 'ML Activity Type: Period Record/Currency Record'

define view FMLV_CKMLLACR_UCT_UNION
  as select from    ckmllacrld    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 curr.curtype                        as curtp,
      togbtr                              as togbtr,
      tofbtr                              as tofbtr,
      togbtrd                             as togbtrd,
      toe                                 as toe,
      waers                               as waers,
      togbtr_s                            as togbtr_s,
      tofbtr_s                            as tofbtr_s,
      togbtrd_s                           as togbtrd_s,
      toe_s                               as toe_s,
      waers_s                             as waers_s,
      bwstrat                             as bwstrat,
      no_settle                           as no_settle,
      saprl                               as saprl,
      cast( '01' as fins_ml_sdm_version ) as sdm_version

}

union all select from ckmllacr                 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 bdatj,
  key poper,
  key untper,
  key curtp.curtype as curtp,
      togbtr,
      tofbtr,
      togbtrd,
      toe,
      m.waers,
      togbtr_s,
      tofbtr_s,
      togbtrd_s,
      toe_s,
      waers_s,
      bwstrat,
      m.no_settle,
      saprl,
      sdm_version
}
where
  sdm_version < '01'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINSV_UNIQUE_CVTYPS",
"FMLV_EXTERNAL_CURTYPE_ML",
"CKMLLACR",
"CKMLLACRLD",
"CKMLLAHD",
"T001K",
"T001W"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/