FCML_FIND_MLDOC_WRONG_BUDAT_V

@AbapCatalog.sqlViewName: 'FCMLMLDOCWBUDA_V'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #AUTOMATED
@EndUserText.label: 'CDS View to detect wrong BUDAT in MLDOC'
define view FCML_FIND_MLDOC_WRONG_BUDAT_V 
  as select from  mldoc  as m
    inner join    ckmlhd as h
      on m.kalnr = h.kalnr
    inner join    t001k as k
      on h.bwkey = k.bwkey
    inner join    finsc_ld_cmp as fl
      on k.bukrs = fl.bukrs and
         m.rldnr = fl.rldnr
    inner join    finsc_period as fp
      on fp.fiscal_year_variant = fl.periv  and
         fp.fiscal_year_period  = m.jahrper
{
  key m.docref                   as docref,
  key m.curtp                    as curtp,
      m.rldnr                    as rldnr,
      m.kalnr                    as kalnr,
      h.matnr                    as matnr,
      h.bwkey                    as bwkey,
      '                      '   as objnr,
      m.jahrper                  as jahrper,
      m.current_per              as currernt_per,
      m.vgart                    as vgart,
      m.posart                   as posart,
      m.categ                    as categ,
      m.ptyp                     as ptyp,
      @Semantics.quantity.unitOfMeasure : 'meins'
      m.quant                    as quant,
      m.meins                    as meins,
      @Semantics.amount.currencyCode: 'waers'
      m.stval                    as stval,
      m.waers                    as waers,
      m.timestamp                as timestamp,
      m.budat                    as budat,
      k.bukrs                    as bukrs,
     fp.fiscal_year_variant      as fiscal_year_variant,    
     fp.fiscal_year_period       as FISCAL_YEAR_PERIOD,
     fp.fiscal_period_start_date as FISCAL_PERIOD_START_DATE
}
  where
        m.budat < fp.fiscal_period_start_date or
        m.budat > fp.fiscal_period_end_date

  union select distinct 
            from  mldoc  as m
    inner join    ckmllahd as l
      on m.kalnr = l.kalnr
    inner join    t001w as w
      on l.werks = w.werks  
    inner join    t001k as k
      on w.bwkey = k.bwkey
    inner join    finsc_ld_cmp as fl
      on k.bukrs = fl.bukrs and
         m.rldnr = fl.rldnr
    inner join    finsc_period as fp
      on fp.fiscal_year_variant = fl.periv  and
         fp.fiscal_year_period  = m.jahrper
{
  key m.docref                   as docref,
  key m.curtp                    as curtp,
      m.rldnr                    as rldnr,
      m.kalnr                    as kalnr,
      '                                        '  as matnr,
      k.bwkey                    as bwkey,
      l.objnr                    as objnr,
      m.jahrper                  as jahrper,
      m.current_per              as currernt_per,
      m.vgart                    as vgart,
      m.posart                   as posart,
      m.categ                    as categ,
      m.ptyp                     as ptyp,
      @Semantics.quantity.unitOfMeasure : 'meins'
      m.quant                    as quant,
      m.meins                    as meins,
      @Semantics.amount.currencyCode: 'waers'
      m.stval                    as stval,
      m.waers                    as waers,
      m.timestamp                as timestamp,
      m.budat                    as budat,
      k.bukrs                    as bukrs,
     fp.fiscal_year_variant      as fiscal_year_variant,    
     fp.fiscal_year_period       as FISCAL_YEAR_PERIOD,
     fp.fiscal_period_start_date as FISCAL_PERIOD_START_DATE
}
  where
        m.budat < fp.fiscal_period_start_date or
        m.budat > fp.fiscal_period_end_date;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CKMLHD",
"CKMLLAHD",
"FINSC_LD_CMP",
"FINSC_PERIOD",
"MLDOC",
"T001K",
"T001W"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/