FMLV_CKMLPRKEPH_UCT_UNION

@AbapCatalog.sqlViewName: 'FCKMLPRKEPHUCTSD'
@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 (Elements) for Prices'

define view FMLV_CKMLPRKEPH_UCT_UNION
  as select from    ckmlprkephld        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.keart                             as keart,
  key  m.prtyp                             as prtyp,
  key  m.kkzst                             as kkzst,
  key  m.patnr                             as patnr,
  key  m.dipa                              as dipa,
  key  curr.curtype                        as curtp,

       waers,
       kst001,
       kst002,
       kst003,
       kst004,
       kst005,
       kst006,
       kst007,
       kst008,
       kst009,
       kst010,
       kst011,
       kst012,
       kst013,
       kst014,
       kst015,
       kst016,
       kst017,
       kst018,
       kst019,
       kst020,
       kst021,
       kst022,
       kst023,
       kst024,
       kst025,
       kst026,
       kst027,
       kst028,
       kst029,
       kst030,
       kst031,
       kst032,
       kst033,
       kst034,
       kst035,
       kst036,
       kst037,
       kst038,
       kst039,
       kst040,
       kst041,
       kst042,
       kst043,
       kst044,
       kst045,
       kst046,
       kst047,
       kst048,
       kst049,
       kst050,
       kst051,
       kst052,
       kst053,
       kst054,
       kst055,
       kst056,
       kst057,
       kst058,
       kst059,
       kst060,
       kst061,
       kst062,
       kst063,
       kst064,
       kst065,
       kst066,
       kst067,
       kst068,
       kst069,
       kst070,
       kst071,
       kst072,
       kst073,
       kst074,
       kst075,
       kst076,
       kst077,
       kst078,
       kst079,
       kst080,
       kst081,
       kst082,
       kst083,
       kst084,
       kst085,
       kst086,
       kst087,
       kst088,
       kst089,
       kst090,
       kst091,
       kst092,
       kst093,
       kst094,
       kst095,
       kst096,
       kst097,
       kst098,
       kst099,
       kst100,
       kst101,
       kst102,
       kst103,
       kst104,
       kst105,
       kst106,
       kst107,
       kst108,
       kst109,
       kst110,
       kst111,
       kst112,
       kst113,
       kst114,
       kst115,
       kst116,
       kst117,
       kst118,
       kst119,
       kst120,
       cast( '01' as fins_ml_sdm_version ) as sdm_version

}
union all select from ckmlprkeph               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.keart                             as keart,
  key  m.prtyp                             as prtyp,
  key  m.kkzst                             as kkzst,
  key  m.patnr                             as patnr,
  key  m.dipa                              as dipa,
  key  curtp.curtype                       as curtp,
       m.waers,
       kst001,
       kst002,
       kst003,
       kst004,
       kst005,
       kst006,
       kst007,
       kst008,
       kst009,
       kst010,
       kst011,
       kst012,
       kst013,
       kst014,
       kst015,
       kst016,
       kst017,
       kst018,
       kst019,
       kst020,
       kst021,
       kst022,
       kst023,
       kst024,
       kst025,
       kst026,
       kst027,
       kst028,
       kst029,
       kst030,
       kst031,
       kst032,
       kst033,
       kst034,
       kst035,
       kst036,
       kst037,
       kst038,
       kst039,
       kst040,
       kst041,
       kst042,
       kst043,
       kst044,
       kst045,
       kst046,
       kst047,
       kst048,
       kst049,
       kst050,
       kst051,
       kst052,
       kst053,
       kst054,
       kst055,
       kst056,
       kst057,
       kst058,
       kst059,
       kst060,
       kst061,
       kst062,
       kst063,
       kst064,
       kst065,
       kst066,
       kst067,
       kst068,
       kst069,
       kst070,
       kst071,
       kst072,
       kst073,
       kst074,
       kst075,
       kst076,
       kst077,
       kst078,
       kst079,
       kst080,
       kst081,
       kst082,
       kst083,
       kst084,
       kst085,
       kst086,
       kst087,
       kst088,
       kst089,
       kst090,
       kst091,
       kst092,
       kst093,
       kst094,
       kst095,
       kst096,
       kst097,
       kst098,
       kst099,
       kst100,
       kst101,
       kst102,
       kst103,
       kst104,
       kst105,
       kst106,
       kst107,
       kst108,
       kst109,
       kst110,
       kst111,
       kst112,
       kst113,
       kst114,
       kst115,
       kst116,
       kst117,
       kst118,
       kst119,
       kst120,
       sdm_version
}
where
  sdm_version < '01'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINSV_UNIQUE_CVTYPS",
"FMLV_EXTERNAL_CURTYPE_ML",
"CKMLLAHD",
"CKMLPRKEPH",
"CKMLPRKEPHLD",
"T001K",
"T001W"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/