FMLV_MLAUFKEPHH_UCT_UNION

@AbapCatalog.sqlViewName: 'FMLAUFKEPHHUCTSD' //Name too long, use SD instead of SDM

@EndUserText.label: 'History table for summarized MLAUFKEPH data w. correct CURTP'
@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
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST,#UNION]
define view FMLV_MLAUFKEPHH_UCT_UNION
  as select from    mlaufkephldh  as mld
    left outer join finsv_unique_cvtyps as curr on  curr.ext_curtype = mld.ext_curtype
                                          and curr.rldnr       = mld.rldnr
{

  key mlvnr,
  key vgabe,
  key gjahr,
  key belnr,
  key buzei,
  key kalnr,
  key sumdno,
  key keart,
  key mlcct,
  key kkzst,
  key patnr,
  key dipa,
  key curr.curtype                            as curtp,

      storno,
      cpudt,
      cputm,
      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       mlaufkephh               as ml
  inner join      mlorderhist              as hist     on hist.mlvnr = ml.mlvnr
  inner join      aufk                     as aufk     on aufk.aufnr = hist.aufnr
  inner join      FMLV_EXTERNAL_CURTYPE_ML as curtp_ml on  curtp_ml.rbukrs      = aufk.bukrs
                                                       and curtp_ml.ext_curtype = ml.curtp
  left outer join finsv_unique_cvtyps            as curtp    on  curtp.ext_curtype = ml.curtp
                                                       and curtp.rldnr       = curtp_ml.rldnr
{

  key ml.mlvnr as mlvnr,
  key vgabe,
  key gjahr,
  key belnr,
  key buzei,
  key kalnr,
  key sumdno,
  key keart,
  key mlcct,
  key kkzst,
  key patnr,
  key dipa,
  key curtp.curtype  as curtp,

      storno,
      cpudt,
      cputm,
      ml.waers as 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",
"AUFK",
"MLAUFKEPHH",
"MLAUFKEPHLDH",
"MLORDERHIST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/