sdm_task_list

@AbapCatalog.sqlViewName: 'VSDMTASKLIST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #P, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@EndUserText.label: 'SDM: All Task List Tables'
define view sdm_task_list
  as select distinct from plkz as plkz
    inner join            plko as plko on  plkz.plnty = plko.plnty //PLKO

                                       and plkz.plnnr = plko.plnnr
{
      //  key concat( plko.plnty,plko.plnnr ) as SDM_Key,

  key plko.plnty                      as BillOfOperationsType,
  key plko.plnnr                      as BillOfOperationsGroup,
      case
      when plko.valid_to = '00000000' or plko.valid_to is null
      then '00'
      else '01'
      end                             as SDM_Done
}
where
     plkz.plnty = '2'
  or plkz.plnty = 'N'
  or plkz.plnty = 'Q'
union all select distinct from plkz as plkz
  inner join                   plpo as plpo on  plkz.plnty = plpo.plnty //PLPO

                                            and plkz.plnnr = plpo.plnnr
{
      //  key concat( plpo.plnty,plpo.plnnr ) as SDM_Key,

  key plpo.plnty                      as BillOfOperationsType,
  key plpo.plnnr                      as BillOfOperationsGroup,
      case
      when plpo.valid_to = '00000000' or plpo.valid_to is null
      then '00'
      else '01'
      end                             as SDM_Done
}
where
     plkz.plnty = '2'
  or plkz.plnty = 'N'
  or plkz.plnty = 'Q'
union all select distinct from plkz as plkz
  inner join                   plfl as plfl on  plkz.plnty = plfl.plnty //PLFL

                                            and plkz.plnnr = plfl.plnnr
{
      //  key concat( plfl.plnty,plfl.plnnr ) as SDM_Key,

  key plfl.plnty                      as BillOfOperationsType,
  key plfl.plnnr                      as BillOfOperationsGroup,
      case
      when plfl.valid_to = '00000000' or plfl.valid_to is null
      then '00'
      else '01'
      end                             as SDM_Done
}
where
     plkz.plnty = '2'
  or plkz.plnty = 'N'
  or plkz.plnty = 'Q'
union all select distinct from plkz as plkz
  inner join                   plas as plas on  plkz.plnty = plas.plnty //PLAS

                                            and plkz.plnnr = plas.plnnr
{
      //  key concat( plas.plnty,plas.plnnr ) as SDM_Key,

  key plas.plnty                      as BillOfOperationsType,
  key plas.plnnr                      as BillOfOperationsGroup,
      case
      when plas.valid_to = '00000000' or plas.valid_to is null
      then '00'
      else '01'
      end                             as SDM_Done
}
where
     plkz.plnty = '2'
  or plkz.plnty = 'N'
  or plkz.plnty = 'Q'
union all select distinct from plkz as plkz
  inner join                   plfh as plfh on  plkz.plnty = plfh.plnty //PLFH

                                            and plkz.plnnr = plfh.plnnr
{
       //  key concat( plfh.plnty,plfh.plnnr ) as SDM_Key,

  key  plfh.plnty                      as BillOfOperationsType,
  key  plfh.plnnr                      as BillOfOperationsGroup,
       case
       when plfh.valid_to = '00000000' or plfh.valid_to is null
       then '00'
       else '01'
       end                             as SDM_Done
}
where
     plkz.plnty = '2'
  or plkz.plnty = 'N'
  or plkz.plnty = 'Q'
union all select distinct from plkz as plkz
  inner join                   plmz as plmz on  plkz.plnty = plmz.plnty //PLMZ

                                            and plkz.plnnr = plmz.plnnr
{
      //  key concat( plmz.plnty,plmz.plnnr ) as SDM_Key,

  key plmz.plnty                      as BillOfOperationsType,
  key plmz.plnnr                      as BillOfOperationsGroup,
      case
      when plmz.valid_to = '00000000' or plmz.valid_to is null
      then '00'
      else '01'
      end                             as SDM_Done
}
where
     plkz.plnty = '2'
  or plkz.plnty = 'N'
  or plkz.plnty = 'Q'
union all select distinct from plkz as plkz
  inner join                   mapl as mapl on  plkz.plnty = mapl.plnty //MAPL

                                            and plkz.plnnr = mapl.plnnr
{
      //  key concat( mapl.plnty,mapl.plnnr ) as SDM_Key,

  key mapl.plnty                      as BillOfOperationsType,
  key mapl.plnnr                      as BillOfOperationsGroup,
      case
      when mapl.valid_to = '00000000' or mapl.valid_to is null
      then '00'
      else '01'
      end                             as SDM_Done
}
where
     plkz.plnty = '2'
  or plkz.plnty = 'N'
  or plkz.plnty = 'Q'
union all select distinct from plkz as plkz
  inner join                   plmk as plmk on  plkz.plnty = plmk.plnty //PLMK

                                            and plkz.plnnr = plmk.plnnr
{
      //  key concat( plmk.plnty,plmk.plnnr ) as SDM_Key,

  key plmk.plnty                      as BillOfOperationsType,
  key plmk.plnnr                      as BillOfOperationsGroup,
      case
      when plmk.valid_to_on_db = '00000000' or plmk.valid_to_on_db is null
      then '00'
      else '01'
      end                             as SDM_Done
}
where
     plkz.plnty = '2'
  or plkz.plnty = 'N'
  or plkz.plnty = 'Q'
union all select distinct from plkz as plkz
  inner join                   plmw as plmw on  plkz.plnty = plmw.plnty //PLMW

                                            and plkz.plnnr = plmw.plnnr
{
      //  key concat( plmw.plnty,plmw.plnnr ) as SDM_Key,

  key plmw.plnty                      as BillOfOperationsType,
  key plmw.plnnr                      as BillOfOperationsGroup,
      case
      when plmw.valid_to_on_db = '00000000' or plmw.valid_to_on_db is null
      then '00'
      else '01'
      end                             as SDM_Done
}
where
     plkz.plnty = '2'
  or plkz.plnty = 'N'
  or plkz.plnty = 'Q'
union all select distinct from plkz as plkz
  inner join                   plab as plab on  plkz.plnty = plab.plnty //PLAB

                                            and plkz.plnnr = plab.plnnr
{
      //  key concat( plab.plnty,plab.plnnr ) as SDM_Key,

  key plab.plnty                      as BillOfOperationsType,
  key plab.plnnr                      as BillOfOperationsGroup,
      case
      when plab.valid_to = '00000000' or plab.valid_to is null
      then '00'
      else '01'
      end                             as SDM_Done
}
where
     plkz.plnty = '2'
  or plkz.plnty = 'N'
  or plkz.plnty = 'Q'
union all select distinct from plkz as plkz
  inner join                   plft as plft on  plkz.plnty = plft.plnty //PLFT

                                            and plkz.plnnr = plft.plnnr
{
      //  key concat( plft.plnty,plft.plnnr ) as SDM_Key,

  key plft.plnty                      as BillOfOperationsType,
  key plft.plnnr                      as BillOfOperationsGroup,
      case
      when plft.valid_to = '00000000' or plft.valid_to is null
      then '00'
      else '01'
      end                             as SDM_Done
}
where
     plkz.plnty = '2'
  or plkz.plnty = 'N'
  or plkz.plnty = 'Q'
union all select distinct from plkz as plkz
  inner join                   plfv as plfv on  plkz.plnty = plfv.plnty //PLFV

                                            and plkz.plnnr = plfv.plnnr
{
      //  key concat( plfv.plnty,plfv.plnnr ) as SDM_Key,

  key plfv.plnty                      as BillOfOperationsType,
  key plfv.plnnr                      as BillOfOperationsGroup,
      case
      when plfv.valid_to = '00000000' or plfv.valid_to is null
      then '00'
      else '01'
      end                             as SDM_Done
}
where
     plkz.plnty = '2'
  or plkz.plnty = 'N'
  or plkz.plnty = 'Q'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MAPL",
"PLAB",
"PLAS",
"PLFH",
"PLFL",
"PLFT",
"PLFV",
"PLKO",
"PLKZ",
"PLMK",
"PLMW",
"PLMZ",
"PLPO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/